Skip to main content
Solved

Reclassing Sales

  • December 23, 2020
  • 4 replies
  • 124 views
Michaelh
Semi-Pro III
Forum|alt.badge.img+2

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!

Best answer by vkumar

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,

View original
Permanent Newb, don't let the posts fool you.
Did this topic help you find an answer to your question?

4 replies

V
Acumatica Employee
Forum|alt.badge.img+12
  • vkumar
  • Acumatica Support Team
  • 871 replies
  • Answer
  • December 23, 2020

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
Semi-Pro III
Forum|alt.badge.img+2
  • Michaelh
  • Author
  • Semi-Pro III
  • 187 replies
  • December 23, 2020

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
Acumatica Employee
Forum|alt.badge.img+12
  • vkumar
  • Acumatica Support Team
  • 871 replies
  • December 24, 2020

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
Semi-Pro III
Forum|alt.badge.img+2
  • Michaelh
  • Author
  • Semi-Pro III
  • 187 replies
  • December 24, 2020

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.
V
1 person likes this
  • V
    vkumar

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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