Share via

Sales Header Table

  • Article

You can keep track of all your sales from the time a quote is created to the time the final order is shipped. You can set up invoices, and the inventory can be automatically updated in connection with the sale.

All the tables are related, and information in the fields is copied from one place in the program to another, so you need to enter information only once. In addition, you can change information on each header or line if you need to.

The sales header forms the basis for transactions involving sales and their registration. Whether you are creating a quote, an invoice, an order, a blanket order or a credit memo, you use the same sales header with the same information, although it will be displayed in different windows.

All the documents found on the Sales & Receivables menu are composed of a sales header and a number of sales lines.

The sales header contains all the relevant information about the sell-to and bill-to customers, such as name, address, document number and date. It has four FastTabs: General, Invoicing, Shipping and Foreign Trade. These FastTabs contain information about the sell-to customer, bill-to customer, shipments and currency. The program retrieves most of this information automatically from the Customer table.

Sales lines contain information (such as item number, quantity and price) about the items you have on inventory. Amounts on the sales lines are in the source currency unless the field name indicates that the amount is in LCY. The source currency is the currency that is represented by the currency code on the sales header.

To create a new sales document, fill in the sales header and then set up the lines. Any relevant information is automatically copied from the header to the sales lines.

After you have completed the sales header and associated sales lines on a quote or blanket order, you can create an order by clicking Actions, Make Order.

After you have filled in the sales header and the associated sales lines on an order, invoice or credit memo, you must post to create a shipment, invoice or credit memo.

Important

If you delete a sales header, a number will be missing from the consecutive number series. This can create problems when the accounts are audited.

List of Fields in the Table

To see the list of fields in this table, change to the Classic view. Choose the Choose View button in the upper-right corner, and then choose Classic.

Field Location
Trading Field, Sales Header Table Sales Tax
Calc. Inv. Discount (Percentage) Field, Sales Header Table Sales Tax
Transit Document Field, Sales Header Table Sales Tax
Service Tax Rounding Type Field, Sales Header Table Service Tax
State Field, Sales Header Table Sales Tax
TDS Assessee Code Field, Sales Header Table Income Tax
ST As Pure Agent Field, Sales Header Table Service Tax
VAT Exempted Field, Sales Header Table Sales Tax
Form No. Field, Sales Header Table Sales Tax
Free Supply Field, Sales Header Table Sales Tax
Form Code Field, Sales Header Table Sales Tax
TDS Certificate Receivable Field, Sales Header Table Income Tax
WHT Business Posting Group Field, Sales Header Table New Zealand Local Functionality
Service Tax Rounding Precision Field, Sales Header Table Service Tax
Nature of Service Field, Sales Header Table Service Tax
Tax Document Marked Field, Sales Header Table New Zealand Local Functionality
Tax Document Type Field, Sales Header Table New Zealand Local Functionality
Printed Tax Document Field, Sales Header Table New Zealand Local Functionality
Sale Return Type Field, Sales Header Table Excise
Price Inclusive Of Taxes Field, Sales Header Table Excise
Adjustment Field, Sales Header Table New Zealand Local Functionality
Export or Deemed Export Field, Sales Header Table Excise
Excise Bus. Posting Group Field, Sales Header Table Excise
Adjustment Applies-to Field, Sales Header Table New Zealand Local Functionality
Prepmt. Include Tax Field, Sales Header Table United States Local Functionality
Tax Exemption No. Field, Sales Header Table United States Local Functionality
Posting from Whse. Ref. Field, Sales Header Table Inventory
STE Transaction ID Field, Sales Header Table United States Local Functionality
Posted Tax Document Field, Sales Header Table New Zealand Local Functionality
Ship-to UPS Zone Field, Sales Header Table United States Local Functionality
Type of Supply Code Field, Sales Header Table United Kingdom Local Functionality
BAS Adjustment Field, Sales Header Table New Zealand Local Functionality
Location Filter Field, Sales Header Table Inventory
Deactivate recurrence Field, Sales Header Table Norway Local Functionality
Structure Field, Sales Header Table India Local Functionality
Source Inv. Total Field, Sales Header Table Sweden Local Functionality
Source Inv. VAT Field, Sales Header Table Sweden Local Functionality
Bill to Customer State Field, Sales Header Table India Local Functionality
Source Inv. No. Field, Sales Header Table Sweden Local Functionality
GLN No. Field, Sales Header Table Norway Local Functionality
Account Code Field, Sales Header Table Norway Local Functionality
PoT Field, Sales Header Table India Local Functionality
Return Re-Dispatch Rcpt. No. Field, Sales Header Table India Local Functionality
Recurring Group Code Field, Sales Header Table Norway Local Functionality
E-Invoice Field, Sales Header Table Norway Local Functionality
Vehicle No. Field, Sales Header Table India Local Functionality
LR/RR Date Field, Sales Header Table India Local Functionality
Transaction No. Serv. Tax Field, Sales Header Table India Local Functionality
Mode of Transport Field, Sales Header Table India Local Functionality
Re-Dispatch Field, Sales Header Table India Local Functionality
LC No. Field, Sales Header Table India Local Functionality
Time of Removal Field, Sales Header Table India Local Functionality
LR/RR No. Field, Sales Header Table India Local Functionality
Amount to Customer Field, Sales Header Table India Local Functionality
Outstanding Amount ($) Field, Sales Header Table Mexico Local Functionality
Job Queue Status Field, Sales Header Table Using Microsoft Dynamics NAV
Job Queue Entry ID Field, Sales Header Table Using Microsoft Dynamics NAV
Prepayment No. Series Field, Sales Header Table Sales and Receivables
Correction Field, Sales Header Table Sales and Receivables
Late Order Shipping Field, Sales Header Table Sales and Receivables
External Document No. Field, Sales Header Table Sales and Receivables
Quote No. Field, Sales Header Table Sales and Receivables
Posting No. Field, Sales Header Table Sales and Receivables
Posting Date Field, Sales Header Table Sales and Receivables
No. Field, Sales Header Table Sales and Receivables
Completely Shipped Field, Sales Header Table Sales and Receivables
Applies-to Bill No. Field, Sales Header Table Spain Local Functionality
Corrected Invoice No. Field, Sales Header Table Spain Local Functionality
Sell-to Customer No. Field, Sales Header Table Sales and Receivables
Sell-to Contact No. Field, Sales Header Table Sales and Receivables
Receive Field, Sales Header Table Sales and Receivables
Reason Code Field, Sales Header Table Sales and Receivables
Direct Debit Mandate ID Field, Sales Header Table Sales and Receivables
Bill-to IC Partner Code Field, Sales Header Table Sales and Receivables
Promised Delivery Date Field, Sales Header Table Sales and Receivables
Ship-to Address 2 Field, Sales Header Table Sales and Receivables
Comment Field, Sales Header Table Sales and Receivables
Shipping Time Field, Sales Header Table Sales and Receivables
Sell-to Customer Name Field, Sales Header Table Sales and Receivables
Send IC Document Field, Sales Header Table Sales and Receivables
Payment Method Code Field, Sales Header Table Sales and Receivables
On Hold Field, Sales Header Table Sales and Receivables
Your Reference Field, Sales Header Table Sales and Receivables
Date Filter Field, Sales Header Table Sales and Receivables
Bill-to Address 2 Field, Sales Header Table Sales and Receivables
Sell-to County Field, Sales Header Table Sales and Receivables
Shipping Agent Code Field, Sales Header Table Sales and Receivables
Ship-to Name 2 Field, Sales Header Table Sales and Receivables
Sell-to Customer Template Code Field, Sales Header Table Sales and Receivables
Due Date Modified Field, Sales Header Table Spain Local Functionality
Document Date Field, Sales Header Table Sales and Receivables
Prepmt. Payment Discount % Field, Sales Header Table Sales and Receivables
Pay-at Code Field, Sales Header Table Spain Local Functionality
Cust. Bank Acc. Code Field, Sales Header Table Spain Local Functionality
Posting No. Series Field, Sales Header Table Sales and Receivables
Due Date Field, Sales Header Table Sales and Receivables
Invoice Discount Value Field, Sales Header Table Sales and Receivables
Ship-to City Field, Sales Header Table Sales and Receivables
Combine Shipments Field, Sales Header Table Sales and Receivables
Sell-to Country/Region Code Field, Sales Header Table Sales and Receivables
No. Series Field, Sales Header Table Sales and Receivables
Ship-to County Field, Sales Header Table Sales and Receivables
Bill-to Name Field, Sales Header Table Sales and Receivables
Exit Point Field, Sales Header Table Sales and Receivables
Requested Delivery Date Field, Sales Header Table Sales and Receivables
Bill-to Customer No. Field, Sales Header Table Sales and Receivables
Shipping No. Series Field, Sales Header Table Sales and Receivables
Bill-to Post Code Field, Sales Header Table Sales and Receivables
Get Shipment Used Field, Sales Header Table Sales and Receivables
Incoming Document Entry No. Field, Sales Header Table General Ledger
Sell-to City Field, Sales Header Table Sales and Receivables
Allow Line Disc. Field, Sales Header Table Sales and Receivables
Ship-to Name Field, Sales Header Table Sales and Receivables
Salesperson Code Field, Sales Header Table Sales and Receivables
Opportunity No. Field, Sales Header Table Sales and Receivables
Status Field, Sales Header Table Sales and Receivables
Shortcut Dimension 2 Code Field, Sales Header Table Sales and Receivables
Applies-to ID Field, Sales Header Table Sales and Receivables
Shipment Date Field, Sales Header Table Sales and Receivables
Bill-to Country/Region Code Field, Sales Header Table Sales and Receivables
Amount Including VAT Field, Sales Header Table Sales and Receivables
Ship-to Country/Region Code Field, Sales Header Table Sales and Receivables
Shipment Method Code Field, Sales Header Table Sales and Receivables
Sell-to Address Field, Sales Header Table Sales and Receivables
Customer Disc. Group Field, Sales Header Table Sales and Receivables
Return Receipt No. Field, Sales Header Table Sales and Receivables
Shipped Not Invoiced Field, Sales Header Table Sales and Receivables
Last Return Receipt No. Field, Sales Header Table Sales and Receivables
EU 3-Party Trade Field, Sales Header Table Sales and Receivables
No. Printed Field, Sales Header Table Sales and Receivables
Campaign No. Field, Sales Header Table Sales and Receivables
Shipping Agent Service Code Field, Sales Header Table Sales and Receivables
Tax Area Code Field, Sales Header Table Sales and Receivables
Last Prepmt. Cr. Memo No. Field, Sales Header Table Sales and Receivables
Sell-to Post Code Field, Sales Header Table Sales and Receivables
IC Status Field, Sales Header Table Sales and Receivables
Credit Card No. Field, Sales Header Table Sales and Receivables
Ship-to Post Code Field, Sales Header Table Sales and Receivables
Location Code Field, Sales Header Table Sales and Receivables
Authorization Required Field, Sales Header Table Sales and Receivables
Ship-to Contact Field, Sales Header Table Sales and Receivables
Outbound Whse. Handling Time Field, Sales Header Table Sales and Receivables
Pmt. Discount Date Field, Sales Header Table Sales and Receivables
Ship-to Address Field, Sales Header Table Sales and Receivables
Bill-to Customer Template Code Field, Sales Header Table Sales and Receivables
Currency Code Field, Sales Header Table Sales and Receivables
Assigned User ID Field, Sales Header Table Sales and Receivables
Responsibility Center Field, Sales Header Table Sales and Receivables
Doc. No. Occurrence Field, Sales Header Table Sales and Receivables
Transport Method Field, Sales Header Table Sales and Receivables
Prepmt. Cr. Memo No. Series Field, Sales Header Table Sales and Receivables
VAT Country/Region Code Field, Sales Header Table Sales and Receivables
Reserve Field, Sales Header Table Sales and Receivables
Prepmt. Cr. Memo No. Field, Sales Header Table Sales and Receivables
Customer Posting Group Field, Sales Header Table Sales and Receivables
Bill-to Address Field, Sales Header Table Sales and Receivables
Shortcut Dimension 1 Code Field, Sales Header Table Sales and Receivables
Bill-to Contact No. Field, Sales Header Table Sales and Receivables
Language Code Field, Sales Header Table Sales and Receivables
Transaction Specification Field, Sales Header Table Sales and Receivables
Customer Price Group Field, Sales Header Table Sales and Receivables
Applies-to Doc. No. Field, Sales Header Table Sales and Receivables
Shipping No. Field, Sales Header Table Sales and Receivables
VAT Bus. Posting Group Field, Sales Header Table Sales and Receivables
Compress Prepayment Field, Sales Header Table Sales and Receivables
Prepayment Due Date Field, Sales Header Table Sales and Receivables
VAT Registration No. Field, Sales Header Table Sales and Receivables
Prepayment No. Field, Sales Header Table Sales and Receivables
Return Receipt No. Series Field, Sales Header Table Sales and Receivables
No. of Archived Versions Field, Sales Header Table Sales and Receivables
Order Class Field, Sales Header Table Sales and Receivables
Bill-to Contact Field, Sales Header Table Sales and Receivables
Prepmt. Posting Description Field, Sales Header Table Sales and Receivables
Invoice Disc. Code Field, Sales Header Table Sales and Receivables
Prepayment % Field, Sales Header Table Sales and Receivables
Posting Description Field, Sales Header Table Sales and Receivables
Order Date Field, Sales Header Table Sales and Receivables
Area Field, Sales Header Table Sales and Receivables
VAT Base Discount % Field, Sales Header Table Sales and Receivables
Bill-to City Field, Sales Header Table Sales and Receivables
Applies-to Doc. Type Field, Sales Header Table Sales and Receivables
Transaction Type Field, Sales Header Table Sales and Receivables
Ship Field, Sales Header Table Sales and Receivables
Sell-to IC Partner Code Field, Sales Header Table Sales and Receivables
Sell-to Customer Name 2 Field, Sales Header Table Sales and Receivables
Bal. Account Type Field, Sales Header Table Sales and Receivables
Last Shipping No. Field, Sales Header Table Sales and Receivables
Payment Discount % Field, Sales Header Table Sales and Receivables
Gen. Bus. Posting Group Field, Sales Header Table Sales and Receivables
Ship-to Code Field, Sales Header Table Sales and Receivables
Currency Factor Field, Sales Header Table Sales and Receivables
Last Prepayment No. Field, Sales Header Table Sales and Receivables
Sell-to Contact Field, Sales Header Table Sales and Receivables
Invoice Field, Sales Header Table Sales and Receivables
Bill-to County Field, Sales Header Table Sales and Receivables
Prices Including VAT Field, Sales Header Table Sales and Receivables
Print Posted Documents Field, Sales Header Table Sales and Receivables
Sell-to Address 2 Field, Sales Header Table Sales and Receivables
Shipping Advice Field, Sales Header Table Sales and Receivables
Invoice Discount Amount Field, Sales Header Table Sales and Receivables
Last Posting No. Field, Sales Header Table Sales and Receivables
IC Direction Field, Sales Header Table Sales and Receivables
Prepmt. Payment Terms Code Field, Sales Header Table Sales and Receivables
Bill-to Name 2 Field, Sales Header Table Sales and Receivables
Bal. Account No. Field, Sales Header Table Sales and Receivables
Package Tracking No. Field, Sales Header Table Sales and Receivables
Tax Liable Field, Sales Header Table Sales and Receivables
Payment Terms Code Field, Sales Header Table Sales and Receivables
Amount Field, Sales Header Table Sales and Receivables
Prepmt. Pmt. Discount Date Field, Sales Header Table Sales and Receivables
Document Type Field, Sales Header Table Sales and Receivables
Invoice Discount Calculation Field, Sales Header Table Sales and Receivables
Dimension Set ID Field, Sales Header Table General Ledger
Sell-to Contact Role Field, Sales Header Table Denmark Local Functionality
Sell-to Contact Phone No. Field, Sales Header Table Denmark Local Functionality
Account Code Field, Sales Header Table Denmark Local Functionality
Sell-to Contact Fax No. Field, Sales Header Table Denmark Local Functionality
Sell-to Contact E-Mail Field, Sales Header Table Denmark Local Functionality
EAN No. Field, Sales Header Table Denmark Local Functionality
Payment Channel Field, Sales Header Table Denmark Local Functionality
OIOUBL Profile Code Field, Sales Header Table Denmark Local Functionality
Probability % Field, Sales Header Table Switzerland Local Functionality
Additional Information Field, Sales Header Table Italy Local Functionality
Tax Representative Type Field, Sales Header Table Italy Local Functionality
Competitor Price Field, Sales Header Table Switzerland Local Functionality
Decision Date Field, Sales Header Table Switzerland Local Functionality
Applies-to Occurrence No. Field, Sales Header Table Italy Local Functionality
Competition Field, Sales Header Table Switzerland Local Functionality
3rd Party Loader Type Field, Sales Header Table Italy Local Functionality
Expected Order Inflow Field, Sales Header Table Switzerland Local Functionality
Refers to Period Field, Sales Header Table Italy Local Functionality
TDD Prepared By Field, Sales Header Table Italy Local Functionality
Last Name Field, Sales Header Table Italy Local Functionality
Transaction Mode Code Field, Sales Header Table Netherlands Local Functionality
Quote valid until Field, Sales Header Table Switzerland Local Functionality
Followup Date Field, Sales Header Table Switzerland Local Functionality
Fiscal Code Field, Sales Header Table Italy Local Functionality
Bank Account Code Field, Sales Header Table Netherlands Local Functionality
Filed User ID Field, Sales Header Table Switzerland Local Functionality
Place of Birth Field, Sales Header Table Italy Local Functionality
Filed Date Field, Sales Header Table Switzerland Local Functionality
Prepmt. CM Refers to Period Field, Sales Header Table Italy Local Functionality
Additional Instructions Field, Sales Header Table Italy Local Functionality
Individual Person Field, Sales Header Table Italy Local Functionality
Activity Code Field, Sales Header Table Italy Local Functionality
Service Tariff No. Field, Sales Header Table Italy Local Functionality
First Name Field, Sales Header Table Italy Local Functionality
Operation Type Field, Sales Header Table Italy Local Functionality
Payment % Field, Sales Header Table Italy Local Functionality
Additional Notes Field, Sales Header Table Italy Local Functionality
Tax Representative No. Field, Sales Header Table Italy Local Functionality
Resident Field, Sales Header Table Italy Local Functionality
Operation Occurred Date Field, Sales Header Table Italy Local Functionality
Cumulative Bank Receipts Field, Sales Header Table Italy Local Functionality
Bank Account Field, Sales Header Table Italy Local Functionality
3rd Party Loader No. Field, Sales Header Table Italy Local Functionality
Date of Birth Field, Sales Header Table Italy Local Functionality

See Also

Reference

Sales Order
Sales Invoice
Sales Quote
Blanket Sales Order
Sales Line
Sales Journal

Other Resources

Sell Goods
About Posting Sales