Field descriptions: Sales order
Field | Description |
---|---|
Number |
The sales order number. If sequence number rules have been defined for the sales orders on the Sequence number page, the sales order number populates automatically when you save the order for the first time. |
Order date | The date the customer placed the order. It defaults to the date you create the sales order. You can edit it. |
Sales site |
The site that manages the sales. You can select one from a list of sites defined as sales sites on the Site page. |
Sold-to customer |
The customer who places the order. You can select from a list of active customer records. When you select the customer, the customer's primary address, and phone number associated to it, are displayed. You can edit the address, or replace it by selecting another one. You can select from a list of customer's active addresses. |
Lines tab
Field | Description |
---|---|
Allocation request status |
The allocation request status for the line when you launch the automatic stock allocation.
After the allocation is completed for all lines and there's no error, the Allocation request status column does not display anymore. In case of stock shortage, stock is not allocated or is partially allocated, but the automatic allocation is considered as complete. |
Allocation status |
Status of the stock allocation for the order line.
|
Item name |
The ordered item. You can select from a list of active and sold items. The active items are those whose records have the Active switch set to ON and the Sold checkbox selected. The item has to be available on the stock site defined on the Information tab of the line panel. If not, a warning message is displayed. |
Net price | The item net price. It's the result of the gross price minus the discount plus the charge percentages. |
Order assigned | When a work order or a purchase order line has been created from the sales order line, an icon displays in this column to inform you there is a supply order linked to this line. |
Origin |
The origin is Direct because you create the sales order line manually and not from a sales quote. The ability to create sales order lines from sales quotes has not been implemented yet.
|
Quantity in sales unit | The ordered quantity. |
Sales unit | The sales unit. |
Status |
The sales order line status.
|
Total excluding tax | The total amount for the order line without tax. It's the quantity multiplied by the net price. |
Total including tax | The total including tax amount for the order line. It's the sum of the total excluding tax and the total tax amount. |
Total tax | The total tax amount in the order currency. |
Detail panel of a line
Field | Description |
---|---|
Status |
The sales order line status.
|
Information tab
Field | Description |
---|---|
Item description |
The item description defaults to the item description on the item record. If there's no description on the item record, it defaults to the item name. You can edit it if necessary. |
Item name |
The ordered item. |
Origin |
The origin is Direct when you create the sales order line manually and not from a sales quote. The creation of order lines from sales quotes has not been implemented yet.
|
Stock site |
The site the item is shipped from. When you create or edit the line, a warning message is displayed if the item is not available on this site. |
Sales block
Field | Description |
---|---|
Quantity in sales unit |
The quantity ordered by the customer in the sales unit. Example
The sales unit is a case of 24 bottles and the quantity in sales unit is 10. It means the customer orders 10 cases containing 24 bottles each. |
Sales unit |
The sales unit.
|
Stock block
Field | Description |
---|---|
Quantity in stock unit |
The quantity ordered by the customer in the stock unit. It is displayed for information. Example
The stock unit is each, the sales unit is a case of 24 bottles, and the quantity in sales unit is 10. It means the customer has ordered 240 bottles. |
Stock unit |
The item stock unit. |
Stock unit conversion factor |
The sales to stock unit conversion factor. The sales to stock conversion factor is managed on the Units tab of the item record. |
Price tab
Field | Description |
---|---|
Charge | The percentage of the item's gross price added as a charge. Charges can be added to cover things that vary with the value of the goods such as insurance. |
Discount | The percentage of a special discount applied to the item gross price. |
Gross price | The item price before applying the charge or discount percentages. |
Net price | The net price is the result of the gross price minus the discount plus the charge percentages. |
Price origin |
The value displayed is automatically selected from 3 possible values:
|
Price reason |
When the price calculation process identifies a valid price list for the combination of values in the Sales site, Stock site, Sold-to customer, Item, Order date, Quantity in sales unit, Sales unit, and Currency fields:
Customer price reasons are managed on the Customer price reason page. |
Totals block
Field | Description |
---|---|
Gross profit amount | The gross profit for the line in the order currency. It's the total excluding tax amount minus the stock cost amount. |
Stock cost amount | The stock cost for the line in the order currency. It's the line quantity multiplied by the item unit cost. |
Total excluding tax | The total amount for the order line without tax. It's the quantity multiplied by the net price. |
Total excluding tax company currency |
The total excluding tax amount converted to the sales site company currency. It displays only when the company currency differs from the transaction currency. |
Total including tax | The total including tax amount for the order line. It's the sum of the total excluding tax and the total tax amount. |
Total including tax company currency | The total including tax amount converted to the sales site company currency. It displays only when the company currency differs from the transaction currency. |
Total tax | The total tax amount in the order currency. |
Stock tab
Field | Description |
---|---|
Allocated quantity |
The quantity allocated on the line already. |
Allocation request status |
The allocation request status for the line when you launch the automatic stock allocation.
After the allocation is completed for all lines and there's no error, the allocation request status does not display anymore. In case of stock shortage, stock is not allocated or is partially allocated, but the automatic allocation is considered as complete. |
Allocation status |
The status of the stock allocation on the line.
|
Quantity to allocate |
The quantity ordered on the line. |
Remaining quantity | The quantity that still needs to be allocated on the line. |
Stock available | The quantity available in stock in the stock unit. |
Stock on hand | The total quantity in stock for all statuses (Accepted, Quality control, and Rejected) on the stock site. |
Stock shortage | The quantity that is missing in stock. It is displayed when the quantity ordered is greater than the quantity in stock. In this case, the Stock shortage status is also displayed. |
Stock shortage status |
This status is displayed only for stock managed items .
Example
The order quantity is 10. The Available field displays 3 and the Stock shortage field displays 7: it means only 3 items are available in stock, and 7 items are out of stock. |
Address
Field | Description |
---|---|
Ship-to-address | The name of the address the customer wants the order delivered to. It defaults to the ship-to address defined on the Shipping tab. You can edit it or select another one. |
Ship-to address
Field | Description |
---|---|
Address line 1 and 2 | The address details. |
City | The city or town where the address is located. |
Country | The country where the address is located. |
Name |
The company or person at this address. |
Phone number | The contact phone number. |
State County Region Division Department |
The field label and formatting change according to the selected country. |
ZIP code Postal code |
The postal code or ZIP code according to the selected country. |
Delivery tab
The fields on this tab populate with the sales order shipping data. You can edit them for a particular line if needed.
Field | Description |
---|---|
Do-not-ship- before date Do-not-ship- after date |
The date before or after which you should not ship the items, because the customer asked for the items not to be delivered before or after a particular date. Examples The earliest date the customer can receive their items is April 4. The delivery lead time is 3 days. You should not ship the item before April 1 to make sure the customer does not receive the items before April 4.
Or, the latest date the customer can receive their items is April 29. The delivery lead time is 3 days. You should not ship the items after April 26. To make sure the items are delivered on time before April 29, you can even enter a prior date such as April 24. |
Shipping date | The date you plan to ship the items from your stock site. |
Shipping status |
The shipping status of the sales order line.
|
Delivery block
Field | Description |
---|---|
Delivery lead time | The average delivery lead time in days. |
Delivery mode | Defaults to the delivery mode defined on the Shipping tab. You can select a different one. |
Entity use code | The entity use code only applies if you are using the Avalara tax calculation. It is related to the customer address and provides information about the type of customer they are, and whether they are exempt from tax. |
Expected delivery date | The estimated delivery date at the customer site. It is calculated using the shipping date plus the delivery lead time. |
Requested delivery date | The date the customer wants the delivery. It defaults to the sales order date. If you edit it, the shipping date and expected delivery date are updated consequently. |
Progress tab
On this tab, you can track the shipping and invoicing processes for the sales order line.
Shipment block
Field | Description |
---|---|
Shipped | The number of shipped items. |
Quantity in progress |
After the sales shipment is confirmed, items that need to be shipped are prepared on the stock site. This is the quantity of items that are being prepared. When the operator validates the sales shipment, the quantity moves from the Quantity in progress field to the Shipped field. |
Quantity in sales unit | The number of ordered items that need to be shipped. |
Remaining | The number of remaining items that require shipment. |
Shipment lines |
Quantities on one sales order line can be split into several shipment lines. The information related to the shipment lines is displayed in a grid. There are as many lines as shipment lines. Each line contains:
|
Shipping status |
The shipping status of the sales order line.
|
Invoicing block
The invoicing information is displayed only when one of the shipment lines is invoiced.
Field | Description |
---|---|
Invoice lines |
Because there is one invoice line per shipment line, and because a sales order line can be split into several shipment lines, there can be several invoice lines for one sales order line. Information related to the sales invoice lines is displayed in a grid. There are as many lines as invoice lines. Each lines contains:
|
Invoice status |
The invoice status of the sales order line.
|
Invoiced | The number of items invoiced. |
Quantity in progress | The number of items to be invoiced. |
Line notes tab
The notes you enter on this tab relate to the sales order line. If you want to add notes at document level, go to the Notes tab of the sales order.
Field | Description |
---|---|
Add notes to customer document |
The switch to make the customer notes text box available. If you keep this switch on, the customer notes print under the corresponding line on the sales order quote or sales order confirmation. |
Customer notes | If the Add notes to customer document switch is on, these notes print under the corresponding line on the sales order quote or sales order confirmation. |
Internal line notes |
The text box where you can add notes you want to share with your colleagues about the sales order line. Those notes are only for internal purposes. Customers cannot see them. |
Taxes window
Field | Description |
---|---|
Amount | The amount that is charged on the order line after applying the tax rate to the taxable base. |
Category |
The tax category. For example, Value added tax. It is determined by the legislation linked to the sales site company. Tax categories are managed on the Tax category page. |
Tax |
The tax is determined by the following elements:
You can change the tax. For example, Normal rate collected on debits was selected but you can change it to Intermediate rate collected on debits.
Taxes and tax rates are managed on the Tax page. |
Tax rate |
The tax rate associated with the tax. It is used to calculate the tax amount to be charged on the line. Taxes and tax rates are managed on the Tax page. |
Taxable base | The amount for the order line without the charge. |
Total excluding tax | The total amount for the order line without tax. |
Total including tax |
The total including tax amount for the order line. |
Total tax |
The total tax amount to be charged on the order line, in the order currency. |
New work order panel
You can create a work order from a confirmed sales order. Refer to Create a work order from a sales order for more information.
Field | Description |
---|---|
Category |
The category that defines whether the routing and/or bill of material need to be added to the work order when it's created. The default work order category is displayed but you can change it. The list of work order categories includes those delivered by Sage and work order categories created by your organization that identify with your production processes. The following work order categories are delivered by Sage: Assembly: Create an assembly order. Only add the default list of components to assemble or to process the released item at the specified site to the work order. Do not add production operations to the work order. Normal: Create an assembly line order. Add the default sequence of shop floor processes and list of components to build or maintain the released item at the specified site to the work order. Rework: Create a production line order. Only add the default sequence of shop floor processes to rebuild or maintain the released item at the specified site to the work order. Do not add components to the work order. |
End date |
The end or required completion date. The default value is the shipping date on the sales order line. |
Name |
The name of the item to build or maintain. The default is the released item name. You can enter a different item name. |
Quantity |
The planned quantity. The quantity is expressed in the stock unit defined for the item. The default value is the remaining quantity to ship on the sales order in the stock unit. |
Released item |
The name of the item to build or to maintain. The released item is defined as a bill of material. |
Requested start date |
The planned production start date. The default is today's date. You can select a different date. |
Site | The production site. |
Type |
The initial work order status. Planned: This is the default value. You cannot track planned work orders. You can select Firm instead. Firm: You can track production of, and component consumption for firm work orders. |
Work order number |
The work order reference. You can enter your own alphanumeric reference for the work order or you can leave the field blank to generate the next sequential work order number. If you are using sequential work order numbers, the components that make up the structure of the generated work order number are determined by the assigned sequence number. You can view the individual components, length, and any constants in the number on the Sequence number page. |
New purchase order panel
You can create a purchase order from a confirmed sales order. Refer to Create a purchase order from a sales order for more information.
Field | Description |
---|---|
Expected receipt date |
A theoretical expected receipt date is automatically calculated from the order date and the purchase lead time defined in the following pages:
|
Gross price |
The item price. |
Item |
The item on the sales order line. |
Order date |
By default, today's date. You can change it but only to an earlier date. |
Purchase quantity |
The item quantity you want to purchase. |
Purchase unit |
The item purchase unit. |
Site | The purchasing site.
|
Stock quantity |
The quantity in the stock unit. |
Stock site | The site the items are received at. It defaults to the sales order line stock site. |
Stock unit |
The item stock unit. |
Supplier | The default supplier of the item. You can select another supplier. |
Assigned orders window
When a work order or purchase order line is created from a sales order line, you can assign a quantity from this supply order to the sales order line. You can also delete a link between a sales order line and a supply order.
All quantities are in the stock unit.
General block
Field | Description |
---|---|
Assigned quantity | The sum of supply order quantities assigned to the sales order line. |
Remaining quantity | The required quantity minus the assigned quantity. |
Remaining quantity to ship |
The sales order line remaining quantity to ship. |
Required quantity |
The sales order line quantity. |
Assigned orders block
Field | Description |
---|---|
Assigned quantity |
The supply order quantity assigned to the sales order line. This quantity cannot be greater than the supply order quantity or sales order line quantity. |
Order | The work order or purchase order number, and a link to it. |
Order assigned |
The supply order created from the sales order line. It can be a work order, or a purchase order line. |
Quantity not assigned |
The supply order quantity minus the assigned quantity. |
Quantity on order | The supply order quantity. |
Detailed stock allocation window
You can allocate stock on lines that have stock managed items. You can select the Allocate stock action from the More actions icon on a line when the sales order is confirmed or partially shipped.
General block
Field | Description |
---|---|
Item | The ordered item. |
Remaining quantity | The remaining quantity that needs to be allocated. |
Required quantity |
The quantity that still needs to be shipped. |
Selected quantity | The quantity allocated already. |
Stock site |
The stock site. It defaults to the stock site defined on the Shipping tab. |
Stock unit | The stock unit. |
Stock allocation grid
The grid displays all stock lines that match the item you want to ship. There are as many lines as lots, locations, and A* stock statuses.
Field | Description |
---|---|
Available quantity | The available quantity in stock at the location. |
Location | The stock location on the site, for location managed sites. |
Lot | The lot number, for items managed by lots. |
Quality control |
The stock status. Only items with stock status A* (Accepted) are considered as available in stock. |
Quantity to allocate |
The quantity you want to allocate on this stock line. |
Serial number |
The serial number status.
|
Serial numbers grid
Field | Description |
---|---|
From serial number | The first serial number in the serial number range. |
Quantity |
The quantity of items in the serial number range. |
To serial number | The last serial number in the serial number range. |
Manage allocations window
Field | Description |
---|---|
Allocated quantity | The quantity allocated on the sales order line. |
Item |
The ordered item. |
Required quantity | The quantity on the sales order line. |
Stock available | The quantity in stock on the stock site when the status is Accepted. |
Stock on hand | The total quantity in stock for all statuses (Accepted, Quality control, and Rejected) on the stock site. |
Stock site | The sales order stock site. |
Field | Description |
---|---|
Allocation request status |
The sales order stock allocation request status. There are no stock allocation request statuses on sales shipments.
|
Allocation status | The sales order or shipment stock allocation status. |
Assigned order | If the sales order has a work order or a purchase order assigned to it, this checkbox is selected. |
Customer |
The sales order or shipment customer. |
Document |
A link to the sales order or shipment where stock was allocated. The documents that show in this grid are the orders that are allocated but not shipped, and the shipments that are ready to process |
Document amount | The sales order or shipment total amount excluding tax. |
Document profit | The sales order or shipment total gross profit amount. |
Quantity allocated | The total quantity allocated on the sales order or shipment. |
Shipping date | The sales order or shipment shipping date. |
Shortage | The shortage quantity on the sales order or shipment when the order or shipment is partially allocated or not allocated. |
Information tab
Field | Description |
---|---|
Allocation request status |
The allocation request status for the sales order.
After the allocation is completed for all lines and there's no error, the allocation request status for the sales order does not display anymore. In case of stock shortage, stock is not allocated or is partially allocated for the concerned line or lines, but the automatic allocation is considered as complete. |
Customer order reference | The purchase order number used by the customer when they placed the order. |
Printed |
This checkbox is only selected when you print a confirmed sales order. There's no indication for a sales quote being printed. |
Sent |
This checkbox is only selected when you send the order to a recipient through the automatic email sending system. There's no indication if you send a printed order by email, or by mail. |
Stock allocation status |
Stock can be allocated on sales order lines. This status indicates if order lines are fully allocated, partially allocated, not allocated, or not stock managed.
|
Transaction currency | The sold-to customer currency. You can edit it if needed. |
Sold-to address
Field | Description |
---|---|
Address line 1 and 2 | The address details. |
City | The city or town where the address is located. |
Country | The country where the address is located. |
Name |
The company or person at this address. |
Phone number | The contact phone number. |
State County Region Division Department |
The field label and formatting change according to the selected country. |
ZIP code Postal code |
The postal code or ZIP code according to the selected country. |
Shipping tab
Field | Description |
---|---|
Delivery date | The estimated delivery date at the customer's site. It's the shipping date plus the delivery lead time. |
Delivery lead time | Defaults to the lead time on the ship-to address. When you update the number of days, the system asks if you want to update the shipping date and the delivery date, or not. |
Delivery mode |
If a delivery mode is associated to the ship-to address, it populates by default. You can edit it if needed. Delivery modes are managed on the Delivery mode page. |
Do-not-ship-before date Do-not-ship-after date |
The date before or after which you should not ship the items, because the customer asked for the items not to be delivered before or after a particular date. Examples
The earliest date the customer can receive their items is April 4. The delivery lead time is 3 days. You should not ship the item before April 1 to make sure the customer does not receive the items before April 4.
Or, the latest date the customer can receive their items is April 29. The delivery lead time is 3 days. You should not ship the items after April 26. To make sure the items are delivered on time before April 29, you can even enter a prior date such as April 24. |
Entity use code | The entity use code only applies if you are using the Avalara tax calculation. It relates to the customer address and provides information about the type of customer they are, and whether they are exempt from tax. |
Incoterms® rule |
If an Incoterms® rule is associated with the ship-to address, this rule populates by default. You can edit it if needed. Otherwise, select the required Incoterms® rule. |
Requested delivery date | Defaults to the sales order date. If the customer requires a delivery on another date, enter this date. The shipping date and delivery date update consequently. |
Ship-to customer |
Defaults to the sold-to customer. The Ship-to address panel displays the customer's primary ship-to address and the phone number associated to this address by default. You can edit the address, or replace it by selecting another one. You can select from a list of active ship-to-addresses set on the customer record. |
Shipping date | The date you plan to ship the items from your stock site. |
Stock site |
The site the items are shipped from.
|
Ship-to address
Field | Description |
---|---|
Address line 1 and 2 | The address details. |
City | The city or town where the address is located. |
Country | The country where the address is located. |
Name |
The company or person at this address. |
Phone number | The contact phone number. |
State County Region Division Department |
The field label and formatting change according to the selected country. |
ZIP code Postal code |
The postal code or ZIP code according to the selected country. |
Financial tab
Field | Description |
---|---|
Bill-to customer |
Defaults to the sold-to customer. The Bill-to address panel displays the primary bill-to address of this customer, and the phone number associated to this address by default. You can edit the address, or replace it by selecting another one. You can select from a list of customer's active addresses set on the customer record. |
Invoice status |
The invoicing status for sales order.
|
Payment term |
The payment term defaults to the bill-to customer payment term defined on the Financial tab of the customer's record. You can edit it if needed. |
Bill-to address
Field | Description |
---|---|
Address line 1 and 2 | The address details. |
City | The city or town where the address is located. |
Country | The country where the address is located. |
Name |
The company or person at this address. |
Phone number | The contact phone number. |
State County Region Division Department |
The field label and formatting change according to the selected country. |
ZIP code Postal code |
The postal code or ZIP code according to the selected country. |
Totals tab
This tab displays the tax related information. The tax details are updated when you add or edit a sales order line.
Field | Description |
---|---|
Excluding tax | The total excluding tax amount of all the lines, in the order currency. |
Tax | The total tax amount of all lines, in the order currency. |
Including tax | The total including tax amount of all the lines, in the order currency. |
Gross profit | The gross profit for the sales order in the order currency. It's the sum of the gross profit amounts of all the lines. |
Summary by tax block
This grid displays the total taxable base and amount, per tax, and per rate.
Field | Description |
---|---|
Amount | The total tax amount for the order lines matching the tax. |
Category |
The tax category. Tax categories are managed on the Tax category page. |
Rate |
The tax rate associated with the tax. Taxes and tax rates are managed on the Tax page. |
Tax |
The tax. Taxes and tax rates are managed on the Tax page. |
Taxable base | The total excluding tax amount accumulated for the order lines using the same tax. |
Amounts in company currency
Field | Description |
---|---|
Excluding tax |
The total excluding tax amount of all the order lines, in the company currency. The company is the company of the sales site. |
Including tax |
The total including tax amount of all the order lines, in the company currency. The company is the company of the sales site. |
Notes tab
The notes you enter on this tab print on the sales order quote or sales order confirmation, at the bottom of the page, or at the bottom of the last page if there are several pages. If you want to add notes for a particular line, go to the Line notes tab of the line panel.
Field | Description |
---|---|
Add notes to customer document |
The switch to make the customer notes text box available. If you keep this switch on, the customer notes print on the sales order quote or sales order confirmation. |
Customer notes |
If the Add notes to customer document switch is on, these notes print on the last page of the sales order quote or sales order confirmation. |
Internal notes |
The text box where you can add notes you want to share with your colleagues about the sales order. Those notes are only for internal purposes. Customers cannot see them. |
Repeat all the line notes on new documents. |
If it's switched on, the lines notes are repeated on the corresponding shipment lines. The same applies if you create the shipments by using the Ship button, using the Mass shipment creation page, or manually creating shipments and selecting order lines. |
Repeat the document notes on new documents. |
If it's switched on, the notes at document level are repeated on the sales shipment if the sales shipment is created by selecting Ship or using the Mass shipment creation page. If you manually create a shipment and select order lines, the order notes are repeated on the shipment only if all lines come from the same order. |
Proforma invoices tab
Field | Description |
---|---|
Created by |
The person who creates the proforma invoice. |
Expiration date |
The date the proforma invoice expires. |
Issue date |
The date the proforma invoice is generated. |
Link |
The link to download the proforma invoice. |
Link expiration date |
The date the link to download the proforma invoice expires. It's available for 10 days. If a new version is generated, the link becomes outdated even if the expiration date has not been reached.
|
Version |
The version of the proforma invoice. |