Solved

Reclassing Sales

  • 23 December 2020
  • 4 replies
  • 91 views
Michaelh
Rank
Userlevel 5
Badge

I have a set of sales that I wish to isolate and reclass to a different account. Has anyone done this before? I’m not sure how to handle the shuffling out of one account into another, the finance segments in ACK have always been a weak-spot for me. Any help is greatly appreciated.

Longer explanation: We started up a new division, but we didn’t know it would be it’s own full division until it grew. So now I need to take the sales for those items and put them to a new class to show a new profit center on our P&L. I can find the old/new accounts and sub accounts easily enough, but actually deducting from the old account and attaching everything to the new account without wrecking my system has me a bit nervous.

 

Thanks in advance for your help!

icon

Best answer by vkumar 23 December 2020, 19:46

View original
Permanent Newb, don't let the posts fool you.

4 replies

V
Rank
Userlevel 7
Badge +11

Hi @Michael Hansen

You can create a GL Journal Transaction to move the amount to different GL account/ sub account. Else, if the amounts are spread across several financial periods, then you can use GL allocation functionality. Here is the documentation link.

https://help-2020r2.acumatica.com/(W(3))/Help?ScreenId=ShowWiki&pageid=3a030bc1-dec7-4c97-bcd2-59b1dfe83bff

Hope this helps.

Regards,

VijayKumarU
Michaelh
Rank
Userlevel 5
Badge

That help doc is awesome, thank you!

Forgive my ignorance of accounting, but wouldn’t this just move the numbers and not the actual transactions? I’m worried I wouldn’t be able to trace which transactions were shifted from Account 1 to Account 2.

I was hoping to show that specific sales order/invoice lines who pointed to Account 1 now point to Account 2, but if that isn’t feasible, I understand and will push ahead with the aforementioned method.

Permanent Newb, don't let the posts fool you.
V
Rank
Userlevel 7
Badge +11

Hi @Michael Hansen 

Its not possible to move the transactions from one branch to another branch once they have been released. Lets say you have a set of Sales Invoices which are released, you cant change the branch on those transactions.  You can only move the accounting entry related to the revenue and COGs from one branch to another branch by following the process I have mentioned on my previous post. Let us know what exact document branch were you trying to change and what is the document status at present.

Hope this clarifies,

Regards.

VijayKumarU
Michaelh
Rank
Userlevel 5
Badge

These are old and throughout the year. Your answer is precisely what I’m looking for. I was hoping to re-attach all the invoices to the correct account, but it looks like I can only move the money. Thanks for your prompt and accurate replies!

Permanent Newb, don't let the posts fool you.

Reply


Terms & ConditionsCookie settings
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