Skip to main content

How to create new Smartlist reports in Microsoft Dynamics GP

Many times, Microsoft Dynamics GP users has miss out how useful Smartlist can help them on data analysis. Users able to customised their own report based on their preference. The most common listing my customers ask for is the financial transaction listing which includes detail from sub-ledger like Accounts Payable or Accounts Receivable. I'm going to include the guide on how to create financial transaction listing in Smartlist.


   1.     To create a new Smartlist to pull financial data and sub-ledger detail, you can pull through Financial Folder. As the default reports are widely available, but you still able to include additional field in the report. To add, select [Columns].

   2.     In the Change Column Display, it shows the current fields showing in the report. To continue, select [Add].
   3.     In the [Columns], you may select the additional field which helps the user in data analysis. In this example, I'm going to add "Originating Control Number", "Originating Document Number" and "Originating Master ID". User able to select multiple columns by holding [CTRL] button on your keyboard. Select [OK] to proceed on the selection.

   4.     Once return to the Change Column Display, the selected field will appear in the table. You can move the sequence of the column by select the button to move up or move down at the right side. Select [OK] to save the current selection.

   5.     Next, user may save the current listing as Favourites. Select [Favourites] to name the listing, and also the availability of the reports, whether the listing is visible to everyone by selecting "System", or the listing only for your own-self by selecting "User ID". Select [Add] to save the listing.


Take note that Smartlist only pulls data available in Dynamics GP, it doesn't allow any formula calculation. However, you can input the formula calculation after you export the data to Excel.


















Comments

Popular posts from this blog

Reprinting GP Posting Journal after Posting in Dynamics GP

As there is no shortcut to reprint the posting journal from one screen, you need to know the original screen location. Financial and Bank 1. To reprint General Journal entries.      Path: Reports > Financial > Cross-Reference > Select "Journal Entries"             Take note that the document printed from here will include transaction posted from other source too like Payables, Receivables, and Fixed Assets and etc. 2. To reprint Bank Posting Journal/ Bank Recon Reports      Path: Reports > Financial > Bank Posting Journal Sales Order Processing and Receivables 3. To reprint Sales Transaction Entry      Path: Reports > Sales > Posting Journal > Select "Sales Posting Journal" 4. To reprint Receivables Entry      Path: Reports > Sales > Posting Journal > Select "Receivable Posting Journal" 5. To reprint Cash Receipt Entry      Path: Reports > Sales > Posting Journal > Select "Cash Receipt Posting Journal" Pu

GP How to Reconcile Payable/ Receivable Ledger to General Ledger Control Account using "Reconcile to GL"

The “Reconcile to GL” tool helps you find differences between Payables Management (and GL) and Receivables Management (and GL) automatically by coming out a report. The Rule of Thumb, GL balance for the AP Control Account should match up with the total on the Payable Ledger report and the GL balance for the AR Control Account should match the total on the Receivables Ledger report.  "Reconcile to GL" will match each transaction between GL and Sub-ledger based on the setup account and posting date.  Any transactions that don’t match and users have to start digging through detailed transactions to see what went wrong, “Reconcile to GL” can be helpful in this scenario. To perform Payable/Receivable Reconciliation Path: Microsoft Dynamics GP > Tools > Routines > Financial > Reconcile to GL     1.       Type in your date range.     2.       Select “Module”, either Payable Management or Receivable Management.     3.       Put in all your A/P or A/R account number.     

How to Create Recurring Transaction in Dynamics GP

If you have a handful of journal entries to be created in regular basis, whether for  numerous accruals and reversals,  allocation, or reclassification entries, setting up Recurring Transaction in Dynamics GP will be helpful and speed up your month end process. Step 1 - Setup Recurring Batch Path: Transaction > Financial > Batches  i.    After entering the " Batch ID " and " Comment ", setting up the " Frequency " is the most important part for recurring transaction. " Single Use " is the one we use all the time for single posting, once posted, the batch will remove from Batch ID. But if you set the Frequency to " Monthly ", which means the batch automatically becomes a recurring batch, the batch will be there forever for multiple posting. ii.    There is another useful option here, " Clear Recurring Amounts ", which will clear the amounts in journal entries after the posting. You can then later enter the amount in the j