How many times do you wish that there was report that would show you the link between a sub-ledger and the GL? Here is a little trick that will help you see some of this sub-ledger information through a GL Smartlist. It can especially come in handy when reconciling your Accrued Purchases account as there is not a routine to help you through this process.
Here are the steps:
Go to Microsoft Dynamics GP > Smartlist. Expand the Financial Folder and then Expand the Account Transactions folder.
Click on the default Smartlist indicated by an asterisk.
Click on the Columns button and search for the word Originating. This will bring you to fields such as Originating Master ID, Originating Master Name, Originating Document Number and so on.
These will be the originating Master Record and document information that generated each Journal Entry. The Originating Master ID will be either the Customer ID or Vendor ID depending on which module the Journal Entry originated in. When reconciling your Accrued Purchases account for instance, you can restrict the list to the Accrued Purchases GL Account and then export this data to Excel.
Then take your Credits minus your Debits to get the net changes and subtotal by Originating Master ID to get your Vendor received not invoiced totals.
This list can then be compared to the Rec’d/Not Invoiced Report subtotaled by Vendor. By doing this, you will easily be able to determine what vendor or document is causing issues and more easily resolve the discrepancy.