Skip to main content
Answer

Update subaccount for invoices and journals posted

  • December 17, 2021
  • 6 replies
  • 304 views
C
Freshman I

Hello,

 

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.

 

Regards,

Cherlene

Best answer by vkumar

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.

https://help-2021r2.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=7ceb94a4-5a8f-4930-a1d9-31920750580d

 

Hope this clarifies,

Regards,

6 replies

C
Semi-Pro I
Forum|alt.badge.img+8
  • ChandraM
  • Semi-Pro I
  • December 17, 2021

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

Chandra M
C
Freshman I
  • cherlene
  • Author
  • Freshman I
  • December 17, 2021

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”.

 

V
Acumatica Employee
Forum|alt.badge.img+12
  • vkumar
  • Acumatica Support Team
  • Answer
  • December 18, 2021

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.

https://help-2021r2.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=7ceb94a4-5a8f-4930-a1d9-31920750580d

 

Hope this clarifies,

Regards,

VijayKumarU
Chris Hackett
C
C
Freshman I
  • cherlene
  • Author
  • Freshman I
  • December 20, 2021

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:

 

C
Semi-Pro I
Forum|alt.badge.img+8
  • ChandraM
  • Semi-Pro I
  • December 20, 2021

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

Chandra M
C
C
Semi-Pro I
Forum|alt.badge.img+8
  • ChandraM
  • Semi-Pro I
  • December 20, 2021

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.

Chandra M
Chris Hackett
C
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