Sales Invoice Line to be stored same in G/L table

iqbalmad

hi,

in Sales Invoices, when i input sales lines with with different currencies, on post navision converts them in Amount LCY and store it in G/L Table.

I would like to change this. I would like to store the same currency amount as in the Sales line with the same currency code.

can anybody give me a hint hw the above can be done in Codeunit 80.

is there any impact if i do this change??

thanks

Phenno

iqbalmad wrote:

hi,

in Sales Invoices, when i input sales lines with with different currencies, on post navision converts them in Amount LCY and store it in G/L Table.

I would like to change this. I would like to store the same currency amount as in the Sales line with the same currency code.

can anybody give me a hint hw the above can be done in Codeunit 80.

is there any impact if i do this change??

thanks

Is there a particular reason for this? You do have an option for "Additional currency for postin" where you will see both LCY and ACY (Additional currency) values...

As far as I know, all postings must be in LCY by law. Everything else is for reporting uses.

Marije_Brummel

You don't want to change that. What you can do is add a new field with the currency amount.

Normaly one additional currency is allowed but this can only be one currency, not different ones.

Why do you want it? Can't you do something with the Customer entries?

If you want to build it you need to change the Invoicing buffer and the Gen. Journal routine.

ssingla

Dear iqbalmad,

Mark is right but as per my view if you do something like this then currency code and the original currency amount needs to be saved in the G/L entry table. Also the fields needs to be added in the Analysis View entry table for proper analysis. Further I fail to understand what is the need to have such customization.
If it is for reporting only then Cust. Ledger entry or the Posted Sales Invoice line can be used.

Can u please clarify.

iqbalmad

in fact me 2 am not that keen to do this..

but i will be getting info from external sources which will be in their respective currencies.. n will have to reconcile these..

zats y i need to change that..

i tried changing the InvPostingBuffer.. but when i do a sales post.. system gives me an error like " Posting these lines will make G/L table Inconsistent".

what shud i do in these cases??

thankx

Marije_Brummel

In that case you are messing up the amount field instead of adding your own field.

Leave the current fields and values intact and add your currency amount field as a new value.

In CU12 the concisency is checked of both the GL Amount field and the Add-currency amount.

iqbalmad

Am going to reconcile figures with my G/L Table.. these can be from sales or purchases or any journals..
so i can't create a new field ( e.g currency amount ) which i will reconcile sales n purchases while entries which were input through journals will be matched using the standard Amount field in G/L table.

zats y i need to change the process of sales post and purchase post..

help pls!!

ssingla

Dear iqbalmad,

Can u clarify what is the exact requirement of reconcilling the sales and purchase module figures with the GL figures.

To my understanding, the reports peratining to specific modules should be generated from that module only and not by populating/inserting the values in other modules.

Further there is a standard report of AR/AP reconciliation available in Navision and you can probably customize a report for sale and purchase rather than modifying the functionality/GL table.