Skip to main content
Solved

Purchase Accrual GL account and "Allow AP Bill before Receipt"

  • December 28, 2023
  • 2 replies
  • 234 views

Forum|alt.badge.img

We’ve found that for companies that have the “Allow AP Bill before Receipt” option enabled for their vendors, the Purchase Accrual GL account and the Purchase Accrual Summary report in the Purchases module don’t match. This is because the Purchase Accrual Summary report is based upon PO Receipts. Companies that allow AP Bill before receipt cannot then easily reconcile their Purchase Accrual account.

 

We can create a different GI or report for this, but before we do, I thought I’d ask -- has anyone else run across this and if so, how did you resolve?

Best answer by rhelton37

Thanks for your reply @Laura02 !  Since my original post, I found that the Purchase Accrual Balance by Period inquiry that was added in 2022 R1 DOES include AP Bills that have been posted against POs prior to the PO Receipts, and can be accurately reconciled against the GL balance. It can also be used to reconcile prior periods, unlike the Purchase Accrual Summary & Detail reports. We were able to successfully use the GI to help a client reconcile their PO Accrual account over a period of 14 months.

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

2 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • December 28, 2023

Hello @rhelton37 ,

I think it’s an oversight if the standard report is out of balance with the GL because a certain Vendor checkbox/feature has not been considered in the design of the standard report. Have you opened a support ticket?

This post linked below, answered by Tiffany Seeland, contains at the bottom, an invitation to meet with Dana M. of Acumatica to discuss possible improvements to PO Accruals for future versions of Acumatica. In addition to opening a ticket, you may consider sending a Private Message to Dana containing your support ticket # to see whether your improvement suggestion should be on the list.

I like SArmstrong51’s idea to offer flexibility to use PO Accrual accounts for different situations: Normal versus Drop-Ship, and (maybe) it would improve your situation too, if Acumatica offered a different PO account or a different way to identify/track Bills before Receipts separately. Here is SArmstrong51’s post, though I do not see it as an idea we can vote for.

HTH,

 Laura


Forum|alt.badge.img
  • Author
  • Freshman II
  • 31 replies
  • Answer
  • December 29, 2023

Thanks for your reply @Laura02 !  Since my original post, I found that the Purchase Accrual Balance by Period inquiry that was added in 2022 R1 DOES include AP Bills that have been posted against POs prior to the PO Receipts, and can be accurately reconciled against the GL balance. It can also be used to reconcile prior periods, unlike the Purchase Accrual Summary & Detail reports. We were able to successfully use the GI to help a client reconcile their PO Accrual account over a period of 14 months.


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