Skip to main content
Solved

Automate the reclassification of journal transactions


Forum|alt.badge.img

Hello!

On the invoices form, only one sales account can be mentioned for one invoice line. And the journal transaction will get created based on that sales account. 

But we want to divide the sales amount and pass it for two sales accounts. For this we though of using the reclassification function but it needs to be automated based on the given parameters. 

Has anyone done something like this? Or are there any other options than reclassifying?

Thank you!

Amanda

Best answer by Laura02

Hello @apallawala21 ,

Consider using GL Allocations to reclassify all or part of a GL account balance. This option will work if all sales to a particular sales account, or a specific portion (predictably the same percent or amount) of sales in a particular sales account need to be moved to a different amount.

Another idea is to use Ve lixo Excel tool to calculate & book allocation entries. (Link)

 

Laura

View original
Did this topic help you find an answer to your question?

2 replies

iqraharrison
Captain II
Forum|alt.badge.img+8

@apallawala21 you could try and create a business event per the necessary conditions but that would involve having to reverse the original transaction and then replacing it with the new transaction with the two sales account.

what is the reasoning for the two sales account? Could you please elaborate on the use case? 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • Answer
  • July 8, 2024

Hello @apallawala21 ,

Consider using GL Allocations to reclassify all or part of a GL account balance. This option will work if all sales to a particular sales account, or a specific portion (predictably the same percent or amount) of sales in a particular sales account need to be moved to a different amount.

Another idea is to use Ve lixo Excel tool to calculate & book allocation entries. (Link)

 

Laura


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