Page 1 of 1

FOREIGN prefix on variables

Posted: 27 Aug 2014, 15:43
by zonkolooney
Hi there.
Can anyone explain to me the difference between, for example,

Invoice_Item.Foreign_Net_Amount and Invoice_Item.Net_Amount.

I am trying to create a template for an email Invoice/Credit Note and I have to say this confuses me.

Thanks in advance.
Peter

Re: FOREIGN prefix on variables

Posted: 28 Aug 2014, 13:07
by brucedenney
The difference is that one of them is in the currency of the customer/supplier and the other is in your base currency.

In general

When reporting to customers/suppliers we want this to be in foreign (even if they are UK based as then the layout works for all customers) so we use INVOICE_ITEM.FOREIGN_NET_AMOUNT on invoices/sales orders and customer/supplier facing documents
When reporting internally we want to use the base currency so we use INVOICE_ITEM.NET_AMOUNT when we do things like report on sales volumes by customer for the sales director

Re: FOREIGN prefix on variables

Posted: 28 Aug 2014, 14:25
by zonkolooney
Thanks Bruce - much appreciated!
Peter