Sales Order: Sales Order Line Item Maintenance

Line Item List

All line items will be listed for the Sales Order that have not been fully dispatched. Click on a line item to show and edit the full details.

TIP: While a quotation, or before saving a sales order, and with the list sorted by line number (Line column heading is bold text), you can re-number the line items by dragging a line and dropping it on a different position in the list.

TIP: In addition, if it is a Quotation and it has already been saved, the list context menu has a Renumber from 1 function that will renumber lines starting from 1. This is needed it low line numbers have been deleted.

Lines and Weight

The number of Sales Order line items due for dispatch and the total of part item mass this represents.

Balance Total Without Tax

The total value for all outstanding items on the Sales Order, inclusive of discount but exclusive of tax.

Balance Total with Tax

The total value for all outstanding items on the Sales Order, inclusive of discount and tax.

Add

This will create a new (normally blank) record in the file. You will then be able to enter details for the record. Then confirm with an OK, or abandon the New record with a Cancel.

You will be warned if a CBD Invoice has been prepared for the SO as any changes will cause inconsistencies between what your customer expects to pay and what you will expect to receive.

When entering an order item the following rules apply:

• The line number will be automatically generated.
• The part description, UoM multiplier, sales UoM, price, sales account, discount rate and tax class are all entered automatically when a part number is entered. However they may be edited using the mouse to select the desired field.
• The part description, UoM multiplier, sales UoM and price will be brought from a Customer Part record if such a record exists for this Part and Customer. If this is the case you will not be able to edit the price, discount and UoM details unless you have security setting permission to edit the customer part record.
• Non-part items are recorded in Sales History but not in Order Preparation History or, of course, in Stock History.
• N type Non-stock parts can be entered, however no stock history or quantity adjustments will be made. You will receive a warning, but this warning message can be suppressed with the option optSONoNTypePartWarn set to 1.
• P type parts are considered “Exploded kits” when used in a Sales Order. In the SO, picking list, dispatch note and in all review listings they are shown exploded into components. Multi-level kits are permitted with no restrictions. A kit can only have a UoM multiplier of 1, and the ordered quantity must be in whole units. Once a P type part is in a Sales Order it’s BoM cannot be altered, nor can the part type be changed.
• The part’s standard and special sales texts, engineering data and associated product serial numbers are appended to the description on the Quotation, Sales Order, Dispatch Note and optionally the resulting Invoice.
• If you are adding items to a Quotation, no changes are made to the Due to Sales Orders part record value and no change is made to the customer’s On-order value.
• If you convert a Quotation to an Order, or as you add or change items on an Order, adjustments are made to the Due to Sales Orders part record value and to the customer’s On-order value. For parts, order preparation history is recorded in the Stock History file. For P type Exploded Kits, processing is carried out for components, not the kit part number.

NOTE: Prices from Customer Part records always take precedence over part master prices. If the Customer Part record is for a foreign currency, the Sales Order must be for that currency for the part to be added successfully.

NOTE: System Manager System Preferences control the recording of history, including restricting the Order Preparation History.

TIP: If at any time you believe the Customer On-order value or Part’s Due to SO quantity are out of step with Sales Orders, these values can be re-calculated automatically in the “System Manager” “Reset Data File…” function. In the case of parts you can review the source of the quantity with the “Stock History” “Processing Analysis” function.

CUSTOM CAPABILITY: oCustom1.$SolEntryPartCheck() enables you to set up a custom method for part verification. For example, you may wish to prohibit the sale of parts with particular Index Codes or from certain store locations.

CUSTOM CAPABILITY: The oCustom1.$SolptnoFinal() method enables you to carry out processing after part entry. In addition oCustom1.$AfterItemAddedToSo() enables you to set up a custom method in advance of the editing process. For example, you may wish to set up some special account code relating to the Part-Customer combination rather than the part alone.

Copy

This will create a Copy of the current record displayed on the window. You will then be able to change the details. Confirm with an OK, or abandon the new record with a Cancel.

Delete

Execute this button to permanently remove the currently selected record from the file. If you are permitted to delete the item, you will be asked for confirmation, otherwise an explanation will be given.

List Sales Price

Sales Order Line Items. Price before discount per Sales UoM. {SOLFILE.SOLPRIC number 2dp}

List Sales Value

The total value for the line item quantity, exclusive of discount and tax.

Quick Payment Amount

Quick payment discount value if applied.

Discount Rate

Sales Order Line Items. Discount % applied to the item price. {SOLFILE.SOLDISC number 2dpShortnum}

The default discount is the customer’s discount rate applying for this part’s discount class. The discount rate can then be edited within a range from 0.00 to 99.99%.

Discounted Price

The discounted sales price before tax per sales unit of measure.

Discounted Value

The discounted value for the entire Sales Order line item, exclusive of tax.

Net Price with QP Applied

The discounted sales price before tax per sales unit of measure and including quick payment discount if applied.

Net Value with QP Applied

The discounted value for the entire Sales Order line item, exclusive of tax and including quick payment discount if applied.

Sales Tax Class

Sales Order Line Items. Tax code applicable. {SOLFILE.SOLTAXC integer shortint}

The tax rate and amount applicable for this part is automatically calculated from the System Manager control value assigned to the tax class. The tax class can be 0 through 6. A zero class is always zero tax. The default class is drawn from the part’s master record or set to 1 if a non-part item. The default is always zero if there is an Additional Address for the order which has the Zero tax rate default option checked, or where there is no additional address and the Customer has the Zero tax rate default option checked. The tax percent rate is saved with the line item record but can not be edited. It remains in force until invoicing when it is updated to reflect any changes in the “System Manager” settings. This provides for tax rate changes that are always applicable at the date of dispatch and invoice.

WARNING: Line item tax class defaults using the rules above at the time it is created. After changing the Additional Address to one with a different option setting you may find that the default tax class will change. If you do change the status of any of the defaults, existing line items are NOT reset.

Sales Tax Rate

Sales Order Line Items. Tax % applied. {SOLFILE.SOLTAX number 2dp}

Discounted Taxed Price

The sales price per sales unit of measure, inclusive of discount and tax.

Discounted Taxed Value

The total value for the Sales Order line item, inclusive of discount and tax.

Discounted Taxed Price with QP Applied

The sales price per sales unit of measure, inclusive of discount and tax and including quick payment discount if applied.

Discounted Taxed Value with QP Applied

The total value for the Sales Order line item, inclusive of discount and tax and including quick payment discount if applied.

Tax regime and class

Sales Order Line Items. Tax regime code applicable. {SOLFILE.SOLTAMC char 6} and Tax class applicable. {SOLFILE.SOLTAXC char 1} See the Tax Maintenance window for full details of the tax handling system.

The default regime is provided from the customer or the additional dispatch addresses, if applied. The default class comes from the part or default sales non-part setting in the company details.

Stock Unit of Measure

Parts Master. Standard stock unit of measure. {PTMFILE.PTMSTUM char 6}

Sales Unit of Measure

Sales Order Line Items. Sales UoM for the item. {SOLFILE.SOLSAUM char 6}

By default this is obtained from the part’s master record. It can be optionally changed but if the Stock UoM and Sales UoM texts are syntactically the same the multiplier will default to 1.0000.

Multiplier

Sales Order Line Items. Multiplier of Stock UoM to get Sales UoM. {SOLFILE.SOLMULT number 4dp}

By default this is obtained from the part’s master record. It can be optionally changed.

Sales Account

Sales Order Line Items. G/L sales posting account code. {SOLFILE.SOLACCO char 10}

This field is of particular interest when your program license includes the Ledgers option. It provides for a selection of a sales type General Ledger account for the posting of the sale item at the time of dispatch and invoicing. It defaults to the account for the part or the default account for non-part sales. If no account is entered the default part account will be used. If you hold the shift key down when passing out of the account code box, the system will accept a non-Sales type G/L account, otherwise only a ‘S’ type account will be permitted. If you don’t have ledgers, this field can be used for any extra coding needs you may have.

Delivery Terms for Quotation

Sales Order Line Items. Quotation delivery terms. {SOLFILE.SOLDELI char 300}

NOTE: Normally the Delivery Terms can only be modified while the document is a quotation. If you set option optSOEditDeli to ‘1’, this field will remain editable after the quotation has been confirmed into a Sales Order.

Balance due

Sales Order Line Items. Balance quantity due in Sales UoM. {SOLFILE.SOLBAL number 3dp}

This quantity field is automatically maintained to accommodate multiple dispatches. If you change the order quantity, this value will also change.

Weight

The mass of the balance due quantity of the selected part item.

Bonded Quantity

Sales Order Line Items. Bonded quantity in Sales UoM. {SOLFILE.SOLBOND number 3dp}

This is a calculated value that shows the quantity of the item placed in bond pending dispatch to the customer. Bonded items are removed from inventory (physical) but not as yet dispatched, and therefore invoiced, to the customer.

Shipping Load

Sales Order Line Items. Shipping load reference (from MCNLOAD sequence). {SOLFILE.SOLLOAD char 6}

This identifies whether the line item has been assigned to a Shipping Load. If blank, it is not assigned. For more details on the Shipping Load system see the Sales Order Shipping Load Assignment window.

Last Dispatch Date

Sales Order Line Items. Last dispatch date for split deliveries. {SOLFILE.SOLLASD date date1980}

This date field is automatically updated when an incomplete dispatch occurs.

Ignore as MRP demand

Sales Order Line Items. Ignore as MRP demand. {SOLFILE.SOLMRP boolean}

A part can be have the Default SO items to be ignored in MRP demand attribute set. This will pass to this SO item attribute when a part is loaded. This characteristic can then the changed in Sales Order line item maintenance. You can use this attribute to eliminate certain products or product groups from control by Materials Requirement Planning. However, you should bear in mind that if the part is an assembly, MRP will not schedule any requirements for it. The consequences of this must be understood in advance as they could be somewhat damaging to your supply situation.

Marketing project code

Sales Order Line Items. Marketing project code, default from SOHMKTP (IDXID = con(‘0’,SOLMKTP)). {SOLFILE.SOLMKTP char 4 Idx} See the Marketing Data Maintenance window help for more details of Marketing Project codes and their use.

Marketing project description

Index and Other Codes. Index code, scrap reason, QA test or Incoterm description. {IDXFILE.IDXDESC char 255}

Show

Lists the available marketing codes set up the File — System Manager — Index Codes. Double-click on a listed code to enter that value.

Current Quantities

For details see the Parts Current Quantity subwindow.

Period Usage

See the Parts Usage subwindow for details.

• Sales Order Maintenance
• Parts Usage
• Parts Current Quantity