How to change Control Account in SAP Business One During Outgoing Payment based on AP Invoices

[salah35]

Dears,

Wish all have a good day

Please, help in this case

I was posted AP Invoices with Old Control Account on BP Master Data

After this i was changed Control Account to new control account in BP Master Data and make this old control account inactive

Issue is when make outgoing payment based on Old AP Invoices with old control account

i can't because old control account is inactive and if i converted old control account to active

Transactions of outgoing payment go to old control account and i want transactions go to new control account

Please, advice or workaround

Many Thanks

[Felipe_Lima]

Hi @salah35 ,

1. Balance Offset with JE - Post a JE choosing the BP account you're offsetting as both Debit and Credit. In this case, I'm moving a customer balance from 123010 to 123000. Obviously, you'll need to consider Debit and Credit differently when it comes to a Supplier:
   
   
   
   
2. Internal Reconciliation - Reconcile the original invoice with the newly created JE:
   
   
   
3. Post the payment to the new account - Now that you've reconciled the original invoice with the JE, the latter will be available for clearance. Preview the JE first and check if the control account is now the desired one.
   

This is just an example, do not forget to set dates and other parameters according to your accounting needs and principles, but that should do the job.

*** If this answer resolves your question, kindly consider marking it as accepted. This helps our community by highlighting useful solutions. Thank you! ***

BR,
Felipe

[Felipe_Lima]

Hi @salah35 ,

Once an invoice is posted, you cannot change the control account assigned to it under the Accounting document's tab.

As a workaround, you can offset this open balance with the new control account via Journal Entry and perform an Internal Reconciliation so that the new G/L will hold the balance, from where you can finally post the payment.

BR,
Felipe

[salah35]

Dear Felipe,

Thanks for your answer

Please, screen shot from steps if this available and payment will be based on JE or payment on account

Many thanks