Dynamics Blogger

Historical Inventory Trial Balance is available in Inventory  > Reports > Activity > Historical IV Trial Balance Report. This report will run into several hundred pages most times based on the size of Inventory. To have this report in excel is always a good choice and easy to work on the report for reconciliation purposes if you have it nice formatted excel worksheet. Smartlist by making use of smartlist builder makes it an easy task. All you have to do is build a custom smartlist builder report using SEE30303 Table (Termed as Inventory Transaction History Detail Table in GP). I am providing a link to download the smartlist that gives the Inventory Historical Trial balance. Please note that I’ve used Item Master table also along with Inventory Transaction History Detail table in order to pull Item description from the former because Item description is not stored in the latter. Download the smartlist and import it into Smartlist Builder using smartlist builder Import fu...

While we all know that Smart list doesn’t support displaying totals, We now have a workaround to beat this limitation in Dynamics GP 2010. Though I’m yet to test this functionality, I thought to quickly share this cool feature. In Excel Report builder, Select the report and go to options and mark “ Display totals at the end of each list ”. This feature would then ensure all the numeric fields in the reports sum up when the report is published. We can duplicate all our existing smart list builder reports to Excel report builder using Duplicate option in Smart list Builder to copy them to Excel Report Builder.

Earlier, I reported in my post Couple of Known issues in Dynamics GP10 SP4 , some bugs that were discovered post SP4 release by Microsoft. Now, an updated smartlist dictionary must fix these issues, according to a blog post published on Developing for Dynamics GP. For more details on this Fix, Please follow the link here .

We get to see this message when Dynamics GP is installed and launched for the first time on a machine. “ To us the Smartlist capability in this product, the Smartlist table must be built. This is a one-time initialization process and may take a few minutes. Do you want to proceed with the initialization now? ”   Mostly during upgrades from previous versions, sometimes this initialization would result into errors that result in display of empty data in smartlists while returning different types of errors pertaining to smartlist tables. Not necessarily during upgrades, sometimes for various other reasons as well, we get to see the following errors. “A get/change first operation on table ‘ASI_MSTR_Explorer_Favorites_OrderBy” cannot find table” “A get/change first operation on table ‘ASI_Explorer_Export_Favorites’ cannot find the table”   Whenever I get to see these types of errors either during the upgrades where the initialization doesn’t happen properly...

A Forum member posted a query in Dynamics GP partner Forums today that when she is trying to use Field Comparison in Search Criteria for a smartlist built using Smartlist Builder throws an invalid value in the value field. I was quick to test the scenario on my system. I’m able to exactly recreate her scenario. Here in the below image, the value field is shown as “Are you sure you want to delete this order ID?”. However this was not the value that I gave in the field. My criteria was to search for records where Current Transaction amount is not equal to Original Transaction Amount. Once I save the search as a favorite, then go back to this favorite, it replaced this Original Transaction amount with the above field. Then I extended my testing on other smartlists that were built using Smartlist Builder. Strange that this is happening across all smartlists built using Smartlist Builder. Interesting thing is that the results are absolutely correct and no issues on that front except th...

In Dynamics GP10, When we uninstall Analytical Accounting feature in Add/Remove programs, we might get the following error while trying to open default Smart lists like Accounts, Customers, Vendors,Items. The same error will be displayed in the smart list lookups in the Cards windows for Accounts, Customers and Vendors. “ This Favorite Contains a column from a product(3180) not installed on this workstation. The following columns will not be displayed:Node ” Resolution : To avoid this message, Go to Administration => Setup => System Setup => Smart list Options, Select Accounts in Category drop down, Unmark the Node column. Continue the same for Customers,Vendors, Items categories if the same error is popping up in smart list lookups or smart list views. Note: This error was replicated on Dynamics GP V10 SP3 (10.00.1193)

Smartlist Builder is one of various tools available for extensive reporting inside Dynamics GP. One of the features in Smartlist Builder is the functionality to build custom Go To's. In the Go To's we can make use of Advanced Go To's that just need to be added to the custom smartlist. They doesn't need any tasks to be performed for displaying the Go To's. However, Advanced Go To's are limited. Available default Advanced Go To's are 1. Payables Transaction Inquiry 2. Purchase Order Inquiry 3. Receivables Transaction Inquiry 4. Sales Inquiry So, If we need to build any other Go To on any custom Smartlist, We need to build it ourselves making use of the Go To Functionality. I'll try to explain how we can build a Go To Check Book Register Inquiry using this functionality in this example. For my example, I've built a custom smartlist making using of CM Transaction Table. Once the CM Transaction Table is added, I'd add checkbook Register Inquiry Go To....