Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

FOREIGN prefix on variables

Sage 50 general help forum - Free help and support for all general issues
Post Reply
zonkolooney
User
User
Posts: 31
Joined: 05 Dec 2012, 17:01
Sage Version: v2009 15 UK/Europe/Africa

FOREIGN prefix on variables

Post by zonkolooney » 27 Aug 2014, 15:43

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
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: FOREIGN prefix on variables

Post by brucedenney » 28 Aug 2014, 13:07

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
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
zonkolooney
User
User
Posts: 31
Joined: 05 Dec 2012, 17:01
Sage Version: v2009 15 UK/Europe/Africa

Re: FOREIGN prefix on variables

Post by zonkolooney » 28 Aug 2014, 14:25

Thanks Bruce - much appreciated!
Peter
Top
Post Reply

Return to “Sage 50 UK version General Help”

Who is online

Users browsing this forum: No registered users and 2 guests