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

Sales order true value

Sage 50 general help forum - Free help and support for all general issues
Post Reply
runfineline
User
User
Posts: 2
Joined: 12 Jan 2009, 20:23

Sales order true value

Post by runfineline » 12 Jan 2009, 20:28

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

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 14 Jan 2009, 12:57

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)
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.

runfineline
User
User
Posts: 2
Joined: 12 Jan 2009, 20:23

Post by runfineline » 14 Jan 2009, 13:57

Many thanks Bruce.

Much appreciated.

Vince

Post Reply

Who is online

Users browsing this forum: Amazon [Bot], Semrush [Bot] and 15 guests