Skip to main content

Printing Accounts Receivable Aging Report in Dynamics GP

The way to print Aging Report for Payables and Receivable is the same in Dynamics GP. Process below illustrate how Receivable Aging is printed.

Payable Aging Path: 
Reports > Purchasing > Trial Balance

Receivable Aging Path:
Reports > Sales > Trial Balance


1.   Always select "Historical Aged Trial Balance" to print, as this allow users to print aging at any target date and even back date. The other aging reports only gives result as at current print date. This applies to Payable Aging too. Select [New] to proceed.




2.   Enter a name in the [Option].
3.  Select the "Enter Date" as the [Print/Age as of] option. This option allows user to change any date that they want to print.
4.  Select [In Detail] if user need to print aging in detail. Detail will include document numbers and document amounts.

     Tip for printing aging:-
        a.  Unmarked the "Credit Balance" if user need to print outstanding balance as at set date, which is the normal aging.
        b.  Unmarked the "Credit Balance"+"Fully Paid Documents"+"Zero Balance" if user need to include outstanding documents with fully paid documents.
          c. Unmarked "Multicurrency Info" if user need to view functional currency together with originating currency.

5.  User can generate aging based on Customer ID, Name, or even Class ID. To filter by these options, after select the range to print, select [Insert >>] to add the requirement to the Restrictions area.

6.   Next, select [Destination] to set how the report should be printed.
7.   Select [Screen] to show the report in the GP screen. Select [File] to have the report export to Excel format. 

8.   Select [Print] to generate the report.

To learn how to export report to Excel, you may refer to the link below:-
Export Microsoft Dynamics report to Excel.


Labels:

Comments

Post a Comment

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 > Sal...
Post a Comment
Read more

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...
1 comment
Read more

Fixed Asset Retirement, Write-off, Disposal in Dynamics GP

User able to perform Fixed Asset Retirement, write-off or even disposal using "Retirement Maintenance". Path: Transaction > Fixed Assets > Retire 1.   Select the Asset that need to retire. 2.   The date of retire. 3.   Select "Like-Kind Exchange". The double entry for this will be Accounting entries for write-off:       Dr. Non-Recognized gain/loss (FA written-off)       Dr. Accumulated Depreciation                  Cr. Asset Cost User may select "Sale" in Retirement Type and "Disposal" in Retirement Code for disposal of asset. 4.   Select Retirement Code "WRITEOFF". If the code is not present, user can create it by going to Retirement Setup.  Path:  MSDGP > Tools > Setup > Fixed Assets > Retirement 5.  There are 3 ways how the asset can be retired. Quantity, Cost, or Percentage. In...
Post a Comment
Read more