Update subaccount for invoices and journals posted

  • 17 December 2021
  • 6 replies

Userlevel 1



I just added subaccount for some of the inventory IDs. 

Is there a way to mass update historical invoices (linked to inventory) created and journals posted with the new subaccount?

Thank you so much.





Best answer by vkumar 18 December 2021, 02:55

View original

6 replies

Userlevel 7
Badge +9

Hi @cherlene Did you try reclassifying option? Please advise with some screenshots with more details.

Userlevel 1

Hi @ChandrasekharM the inventory ID are updated with the subaccount. I am thinking of a way to update invoices already posted with the new subaccount instead of “0”.


Userlevel 7
Badge +11

Hi @cherlene 

There is no option available to automatically update the Invoice ( and linked transactions ), on updating GL account /sub account in Inventory item profile. As indicated by @ChandrasekharM , you can use ‘Reclassifying transaction’ feature to move transactions from on GL account/ sub account to another GL account/ Sub account. It will be at General Ledger transaction level and not based on Inventory. There is no option to set a filter or list transactions based on Inventory item used on source document. 

Here is the documentation link for Reclassifying transactions.


Hope this clarifies,


Userlevel 1

Hi @vkumar and @ChandrasekharM, I have tried to reclass one transation. The Tran type for that transaction has changed from AR module to GL module.

is there any way that the tran type can stay as AR module?


After reclass:


Userlevel 7
Badge +9

Hi @cherlene The reclassification is performed in the GL Batch level, and hence the reclassification will show GL module.

Userlevel 7
Badge +9

Hi @cherlene The other way to achieve this would be Reverse the Invoices with a credit memo. The original and reverse entries will be seen both in AR and GL. And the receivable Account would match.


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