SageForum for UK versions of Sage 50- Help and support.

Hi, if I get the sales order data through the ODBC link what value is the best one to use for the total net value of the sales order before tax? I have always used ITEMS_NET in the past but this does not always match the actual Sage order value. Sage support suggested that I use the FOREIGN_ITEMS_NET even if no foreign currency is involved.

Thanks,

Vince

Sage splits the sales order into several elements, the items, the separate carriage charge, the whole invoice/order and (now) discounts.

Sage fortunately, has used a consistent naming convention for each of the parts in the past*.

Each of the variable relating to the values on a sales order is made up of 3 parts.

At the beginning blank (nothing) or FOREIGN to give you the value in either the base currency or the value in the currency associated with the customer account (these are the same if the customer uses your base currency, so in layouts we tend to use the "Foreign" value even if it is base currency)

At the end NETT, TAX or GROSS to give you either the nett amount, the VAT amount or the gross amount

In the Middle you get the section ITEMS, CARR or INVOICE to give you the value of the items on the invoice, the shipping costs or the invoice total.

So I think the field you want to use is INVOICE_NETT this is the nett value of the whole sales order (they call it an invoice even though it is a sales order) in base currency including discounts.


(*Of course it would have been sensible to maintain the naming convention for the recently introduced discounts value by having FOREIGN_DISC_NETT and DISC_NETT but Sage decided to break the convention and have NET_VALUE_DISCOUNT_NET and NET_VALUE_DISCOUNT_BASE)

Many thanks Bruce.

Much appreciated.

Vince