Skip to main content
Solved

How do I reconciling Accounts Payable to General Ledger, in Acumatica?

  • 8 December 2022
  • 8 replies
  • 670 views

ChrisWeidner
Varsity I
Forum|alt.badge.img

How would I run a report to show me the open AP documents for a specific period? Currently the reports are not tying because the AP bills were paid in a future period, so they seem to be omitted from AP Open Documents by Vendor. Our AP Aging report won’t work because it doesn’t seem to handle retainage documents.

Any ideas on how to accomplish this? Is it a feature out of the box?

Best answer by YasasWithanage76

@ChrisWeidner 

Please try the "AP Balance by GL Account (AP632000)" report. This report shows the AP account balances for the selected period. Documents are grouped by account, subaccount, and vendor.

 

View original
Did this topic help you find an answer to your question?

8 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • December 8, 2022

Hello,

I can’t answer your question but want to draw previously posted idea to your attention so you may vote :

https://community.acumatica.com/ideas/need-better-ap-aging-reports-with-retainage-6357

 

 


meganfriesen37
Captain II
Forum|alt.badge.img+11

Have you looked at the AP Aged Period Sensitive Report?  This will allow you to run as of a historical point in time and include documents that were open then and are closed now.  I’m not sure how it handles retainage but that’s the one to use for Month End Reconciliations.  The other ones are “Aged as of Date” but are only looking for items that are currently open.


ChrisWeidner
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 27 replies
  • December 9, 2022

AP AGED Period Sensitive won’t work for auditors. They need to see the retainage broken out.

I am not sure how to accomplish this. When I view the AP Open Documents by vendor it matches exactly to current period. But when I look at a period sensitive report there is a discrepancy.. I assume Acumatica is still trying to figure out how to handle retainage in reporting


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • December 9, 2022

Hi @ChrisWeidner 

Not sure how good you are with report writer but you could make a copy of the AP Open Documents by Vendor and just make it by period instead. 

If you click Edit Report, you can make a new version.

Change the Vendor to the Financial Period and save the report to the server:

 

 


ChrisWeidner
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 27 replies
  • December 9, 2022

@kandybeatty49  I have tried this but I do not get the intended result. I know the report is only displaying Open documents, but if some documents were paid in a future period then it would fall off the report. 

 

I tried to add filters to the build schema: 

Open documents ( Post Period = 12-2022 or earlier)

Closed documents (w/ post period 12-2022 or earlier, but only ones closed in 01-2023)

 

I may just need to make period specific & then manually add documents that were closed in the future period. Not ideal at all


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • December 9, 2022
ChrisWeidner wrote:

@kandybeatty49  I have tried this but I do not get the intended result. I know the report is only displaying Open documents, but if some documents were paid in a future period then it would fall off the report. 

 

I tried to add filters to the build schema: 

Open documents ( Post Period = 12-2022 or earlier)

Closed documents (w/ post period 12-2022 or earlier, but only ones closed in 01-2023)

 

I may just need to make period specific & then manually add documents that were closed in the future period. Not ideal at all

It’s not very ideal unfortunately. You could possibly submit it as an idea for a future release for Acumatica to create the report. 


YasasWithanage76
Acumatica Employee
Forum|alt.badge.img+3
  • Acumatica Employee
  • 52 replies
  • Answer
  • December 13, 2022

@ChrisWeidner 

Please try the "AP Balance by GL Account (AP632000)" report. This report shows the AP account balances for the selected period. Documents are grouped by account, subaccount, and vendor.

 


ChrisWeidner
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 27 replies
  • December 13, 2022

@YasasWithanage76  , Yes that will work but leads to manipulation for the end user. Thank you. 

It doesn’t show retainage on the documents unfortunately. I may have to work to customize this or just manually add that column.

It would be very nice to have an (out of box) AP retainage report that shows original retainage


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings