Question

Opening balance currency issue

  • 13 January 2022
  • 3 replies
  • 103 views

Userlevel 5
Badge +9

 Initially supplier opening balance was recorded in a wrong currency. After correcting that by mixed payment, the opening balance has been transferred to an incorrect account. Need a transfer the balance to the correct account

 

Raised on behalf of LCS Case ID G2308997


This topic has been closed for comments

3 replies

Userlevel 7
Badge +18

Hi, 

A manual posting could affect the manual posting side - that would be easy just a manual voucher. But assuming this is the IP1 side (AR TRADE). A Q type voucher could fix GL for IP1,  but when the invoices are paid they would go back to the old account, and next month another voucher would be required to move old to new. The IP1 side is stored in the IFS tables for a given invoice.  Assuming posting control is updated / supplier set up is corrected, the repost ledger items function will move the IP1 side from account X to account Y in the invoice tables, and create the voucher to correct the accounting. 

It would be good to know if this was the IP1 side or if this was the “manual” posting side that hit the wrong account.  Then we know what to fix / how. 

Best regards, 

Thomas

Badge +2

Manual postings are not allowed for this account ? 

Userlevel 7
Badge +18

Hi, 

Assuming this was the IP1 side going to the wrong account, you can update the supplier / posting control (the reason why IP1 was the wrong account) and then use the function to “Repost Ledger Item”.    This will fix the IP1 side or IP2 side if we use this for customer invoices. 

 

If the manual posting side of the invoice hit the wrong account, then need more information. Like what’s the wrong account / is this side connected to anything, etc.  If we hit the wrong expense account (no connections to other things in IFS) you can do a manual voucher to correct. 

 

You can highlight many invoices or just the problem invoice and run the process. The process is safe and only creates postings for the invoices that are actually changed (posted to a different IP1 account). 

Best regards, 

Thomas