Link between GL & Invoice

subhadynamics

Hi All

We have customized the Sales Invoice form . So when we select the order (Customized lookup field) all the informations are copied from blanket Order to the current invoice form (replicated the existing Copy Docu Functionality). But the exchange rates are wrongly entered without checking the current invoice date . All the Amount (LCY) fields are posted with the wrong exchange rate. So i would like to correct all the wrong data with the exchange rate of current posting date . But when i correct the data in GL Entry i couldn't find out the proper link with other tables. So please help me out for the proper link between Sales Invoice Line and GL Entry to update the invoice related records in GL Entry.With out document no any other unque link is available ? or can we connect through any other tables like Cust.Ledger Entry ,Value Entry & Detailed Cust.Ledger Entry.

Thanks
Subha

srinivas.chittem

Hi Subha,

How you are correcting the data with correct exchange rate?

Use the Adjust Exchange Rate function with the specified dates then system will adjust automatically.

Batch job is available in General Ledger->Periodic Activities->Currencies

Check it out this function and let us know if you require any more inputs

ssingla

subhadynamics wrote:

Hi All

We have customized the Sales Invoice form . So when we select the order (Customized lookup field) all the informations are copied from blanket Order to the current invoice form (replicated the existing Copy Docu Functionality). But the exchange rates are wrongly entered without checking the current invoice date . All the Amount (LCY) fields are posted with the wrong exchange rate. So i would like to correct all the wrong data with the exchange rate of current posting date . But when i correct the data in GL Entry i couldn't find out the proper link with other tables. So please help me out for the proper link between Sales Invoice Line and GL Entry to update the invoice related records in GL Entry.With out document no any other unque link is available ? or can we connect through any other tables like Cust.Ledger Entry ,Value Entry & Detailed Cust.Ledger Entry.

Thanks
Subha

Are you talking of NAV or Entrepreneur Solution?

Are you seriously planning to modify the posted entries with a developer license? [-X

jglathe

Hi Subha,

subhadynamics wrote:

But the exchange rates are wrongly entered without checking the current invoice date . All the Amount (LCY) fields are posted with the wrong exchange rate. So i would like to correct all the wrong data with the exchange rate of current posting date . But when i correct the data in GL Entry i couldn't find out the proper link with other tables.

Interesting NAV that you have... normally, there is no currency information in the G/L entry. Only reporting currency. To the problem you described: modifying the amounts in posted entries is a no-go. IMO, two things need to be solved:

1. The copy from the blanket order function should make sure to take the correct exchange rate.
2. A way must be found to correct the "wrong" postings. Part of it can be done with the "Adjust Exchange Rates" batch. This will correct the customer ledger entries and the account payable. For the income and VAT accounts you need to create a function (batch) that distributes the adjustment amount from the customer entry to these accounts via a general journal. Or you do it manually, it's a one-time correction.

with best regards

Jens

Sog

Can't this be solved by using the old business logic of accounting?
1. I made a woopsie and posted it
2. I reverse the woopsie
3. I post the correct transaction

Done.