Dynamics Blogger

I updated the Historical Inventory Trial Balance Smart list Builder report to version 1.1. In this version, the following changes are made to the earlier version 1.0 . Added Excel Report Builder Report in addition to SLB Report. So, You can easily explore the results in Excel directly instead of exporting to excel every time. Added GL Balance as a calculated field which is a Net Balance field of Debit and Credit amounts on GL side of the report so as to easily compare against Extended cost field on Inventory side Added Account Description field to the Inventory and Inventory offset accounts. In Excel Report Builder for GP 10, we can arrange the fields using columns option so I have arranged the fields in Excel report but for smart list, I suggest to arrange fields globally by going to smart list options in System setup. This is not an issue in GP 11 though as we have options in GP 11 for the same. Separate Report is provided for...

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...