Skip to main content
Answer

Consolidating "Purchase Accrual" and "Accounts Payable" on balance sheet.

  • August 21, 2025
  • 2 replies
  • 63 views
R
Captain II
Forum|alt.badge.img+6

       Currently, in the liability section of our balance sheet, "Purchase Accrual" and "Accounts Payable" are displayed separately. Our company’s accountant has requested that the values of these two items be combined and shown as a single line item on the balance sheet.

After checking, I noticed that it seems I could simply change the account class of "Purchase Accrual" from "othcurliab" to "AP" to achieve this.
 

However, would this cause any issues? Is this the most recommended approach? Are there any better alternative solutions?

Best answer by jhouser

​@ray20 That actually wouldn't help in this case. Would have to see the Row Set for this report, but I'm guessing there is one Row where the data source is set to include all these accounts and expand so they are all displayed. 

If above is true, you need to add a Row before existing one with the two account and set it to not expand. Then use the existing Row for the other accounts and set it to expand. 

Either way, what you want is two rows, one with two accounts set to not expand, another with remaining accounts set to expand. Hope this helps, let me know if you would like help accomplishing this. 

2 replies

jhouser
Captain II
Forum|alt.badge.img+6
  • jhouser
  • Captain II
  • Answer
  • August 22, 2025

​@ray20 That actually wouldn't help in this case. Would have to see the Row Set for this report, but I'm guessing there is one Row where the data source is set to include all these accounts and expand so they are all displayed. 

If above is true, you need to add a Row before existing one with the two account and set it to not expand. Then use the existing Row for the other accounts and set it to expand. 

Either way, what you want is two rows, one with two accounts set to not expand, another with remaining accounts set to expand. Hope this helps, let me know if you would like help accomplishing this. 

Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/
R
Chris Hackett
R
Captain II
Forum|alt.badge.img+6
  • ray20
  • Author
  • Captain II
  • August 22, 2025

Yes, I set all account# under “AP” account class not expand.  So the only thing I have to do is to move “Purchase accrual”  from “otherliabitly” account class to AP account class.
I already did it, and seems no issue then.

jhouser
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved