Skip to main content

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

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


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

 


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,


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:

 


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


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.


Reply