Orders

It is the product reference for which a document line is recorded.

You can directly enter a product reference or a Product/Customer reference. The existence of this reference is controlled in the Product/Sales and Product/Customer records. If you enter a Product/Customerreference, the system returns the internal product reference. A blocking message is displayed when entering a product:

• if price lists of the prohibitedtype have been set up for some customers (see Price list setup),
• if this product if of the Kit parent product type and cannot be delivered.

You can also use the Actions icon to do the following:

• select a product from the file of sold products,
• select a product from the list of customer products,
• create, according to the user's access rights, a product in the file,
• view the price lists for the product,
• inquire the stock for the product at the shipment site,
• inquire the available stock at the shipment site,
• select the replacement product if it has already been recorded. This function is only accessible if the original product is not available. A screen is then displayed that specifies the stock information linked to the availability of the replacement product. It is possible to accept or decline the product replacement. During line entry for an order, the Alternate product option is available from the action icon for the Ordered qty. field in the grid. It is not available if the line has been allocated or partially delivered, billed, or prepared.

The entry of the product is used to initialize the Description and Sales unit fields, which can be modified. The sales unit can be modified on the condition that it is chosen from the list proposed that contains the sales and packing units from the product and product-customer records.

At this stage, a warning message can appear that to inform the user of the replacement of the entered product by the substitute product. This automatic substitution only takes place when the following two conditions are met:

• the Substitute product field of the product record has been entered,
• the document date is greater than or equal to the substitution date.

Once the line is entered, it is no longer be possible to modify the product code. It is necessary to delete the line and recreate it to modify the code.

This is the product description translated into the customer language. It is this description that will be printed on the document. If the translation does not exist in the customer language, the un-translated product description will be used. This description is also copied to the next document.

• There is the possibility to access the product record using a tunnel from this field.

Inter-company specificities: In the event of an inter-company or inter-site order generated from a purchase order, the translated description will be initialized by the standard description of the purchase order (description translated into the connexion language, in other words, the language of the user who has created the purchase order.)

This is the description entered in the product record. This description is transferred to the deliveries or invoices (case of direct invoicing orders) along with any modification made in the order.

When the order comes from a quote, the standard description is inherited from the quote line.

It is possible to access the product record by tunnel.

Special features linked to the inter-company option: In the case of an inter-company or inter-site order generated from a purchase order, the standard description is initialized by the translated description of the purchase order, and so, the translated description in the supplier's language (sales site).

Enable the predictive or automatic entry by setting the AUTOSEL – Automatic selection parameter (SUP chapter, INT group) to Yes.
Start by entering a few characters contained in the reference or description (or other), and press Tab.
A window displays a list of results. Select the value you require.

  AUTOSEL – Automatic selection parameter (SUP chapter, INT group) for the conditions for implementing the automatic search.

This field displays the major version of the product.

The major version number can only be accessed if the tracking of major versions is active at the level of the product setup (in the Management tab of the Product function, the Stock version field is set to 'Major').

If the preloading of versions is active at the product/customer level (in the Customers tab of the Product function, the Version preloading box is checked), or by default, at the product/sales level (in the Sales tab of the Product function, the Version preloading box is checked), then the last active major version is preloaded automatically. Otherwise, the last major version with the 'Stopped' status will be preloaded.

When the line is partially allocated, prepared, delivered or invoiced, you can no longer change the version number.

When the order is converted into another document, the following actions are carried out:

• Activation of the Preparation button and Delivery button, along with the transfer and control of version numbers on the picking ticket or delivery note.
• Activation of the Invoice button, along with the transfer and control of the version numbers on the invoice.
• Quotes picking with transfer and control of versions on the order.

The Major version field display depends on the setup of the entry transaction (hidden, displayed, entered).

This field displays the minor version of the product.

The minor version number can only be accessed if the tracking of major and minor versions is active at the level of the product setup (in the Management tab of the Product function, the Stock version field is set to 'Major and minor').

If the preloading of versions is active at the product/customer level (in the Customers tab of the Product function, the Version preloading box is checked), or by default, at the product/sales level (in the Sales tab of the Product function, the Version preloading box is checked), then the last active minor version is preloaded automatically.

When the line is partially allocated, prepared, delivered or invoiced, you can no longer change the version number.

When the order is converted into another document, the following actions are carried out:

• Activation of the Preparation button and Delivery button, along with the transfer and control of version numbers on the picking ticket or delivery note.
• Activation of the Invoice button, along with the transfer and control of the version numbers on the invoice.
• Quotes picking with transfer and control of versions on the order.

The Minor version field display depends on the setup of the entry transaction (hidden, displayed, entered).

It is the storage site from where the goods are shipped to deliver the order line. The shipping site is initialized by the shipping site entered in the order header. It can be modified provided that the selected shipping site belongs to the same legal company as the sales site and the order line has not been allocated. In the case of orders with Complete delivery, the shipping site is neither modifiable on the order lines.

It is possible to:

• select a storage site,
• inquire the stock for the product at the shipping site,
• access by tunnel the Product-site record if the user's authorization allow it.

Special features linked to the inter-company option: In the case of an inter-company or inter-site order generated from a purchase order, the shipment site is initialized by the shipment site entered in the purchase order line. It can be modified to manage any changes in the shipments. This modification does not lead to the update of the original purchase order.

The sales unit is initialized by the sales unit defined in the Product-customer record, or by the sales unit of the product. It is possible to enter another unit using a selection window. The suggested units are the packing units of the product and the packing units defined in the Product-customer record. If the user has the appropriate authorizations, it is possible to access the unit table.

Once the line is entered, it is no longer possible to modify the sales unit. It is necessary to delete the line and to recreate it to modify the unit.

Inter-company specificities upon sales order entry: if the order has been generated from inter-company or inter-site purchase order, this information will be initialized with the unit entered in the purchase order and will be inaccessible. Only by modifying the original purchase contract order is it possible to modify this information.

Quantity ordered by the customer. It is expressed in a sales unit.

Click the Actions icon to:

• jump to the Product-site record,
• view the Stock by site,
• Access the Allocation filters Use this option to specify the information used by the detailed allocation or at the time of shipment if the line has Global allocation. Two exclusive filters can be entered: the lot and a combination of statuses (the combination of statuses entered must be included in the Issue rule of the corresponding shipment type). A preferred filter can be assigned to a location that is used to orientate the allocation. It is possible to enter wild cards "*,? " for these data in order to extend filters. These filters can also be accessed from the Quantity to allocate field,
• inquire the Allocation detail. This function is only accessible if there are quantities already allocated on the order. This function is used to view the stock lines that have been reserved. See the Allocation detail accessed from the Actions icon on the line,
• inquire the Available stock,
• inquire the Projected stock,
• select the replacement product. This function is only accessible if the original product is not available. A screen is then displayed that specifies the stock information linked to the availability of the replacement product. It is possible to accept or decline the product replacement.

The ordered quantity must be entered. A warning message is displayed if:

• the quantity entered is less than the minimum quantity defined in the product record,
• the quantity entered is greater than the maximum quantity defined in the product record. These messages can be blocking ones according to the value of the user parameter SDACLOCK - Price, margin, qty non-blocking ctrl (VEN chapter, AUZ group).

The product availability is displayed in the Available stock section under the table, if the option Product availability is selected in the Order entry transaction.
If the product is not available, the message: ’XXX: Not available in stock' is displayed, followed by the possible first date of availability and quantity in stock unit and sales unit.
As for the document valuation, the display of the product availability is conditioned by the value of parameter SOHVALLIG - Order valuation on line (VEN chapter, MIS group).

When the ordered quantity is entered a price list search process is automatically carried out. The objective of this search is to recover:

• the gross price and the associated reason,
• the charges and discounts in percentages or in amounts to be applied to the line level and the associated reasons,
• any free product(s).

The price list search process can be triggered in different ways depending on the product type entered:

• if the product entered is of the type Normal, the search processing is automatically triggered.
• if the product entered is of type Kit component or BOM component, an initial price list search is triggered for the component, then a read of the BOM file is carried out in order to display the different BOM codes of the Commercial type if multiple ones exist. If the product has only a single BOM code, it will be taken into account automatically.

After choosing the BOM code, different cases can occur according to the construction of the product BOM:

• each component of type Normal is automatically selected,
  
  It is automatically replaced by the substitute product if it was entered at the level of the Product record if the document date is greater than or equal to the substitution date.
  For the other types of components mentioned below, when a substitute product is used, the original product description is displayed at the level of the components selection window.
• For each component of the type Normal (with formula), a window is displayed with all the products returned by the selection formula. If a component of the type Normal has been recorded in the same sequence, this component appears in the list. By default, it is automatically selected but it is possible to clear this selection. Its quantity cannot be modified.
  It is possible to select one or several other components of the selection. The Include all and Exclude all buttons are available for this purpose. Therefore, if no component is selected, the Criteria button becomes available so as to narrow the selection when the number of lines in the table is too large (the number of lines presented depends on the number of lines that still can be inserted in the document).
• For each component of type Variant, a window opens displaying the set of variants listed at the same BOM level or coming from a selection. It is compulsory to choose one.
• For each component with the Option type, the option is suggested and the user can accept or reject it. When several options are possible for a same BOM level or when a selection formula is defined, a window opens for the user to select one or more options or to refuse all of them.
• For each component with the Multiple option type, a window is displayed with the set of components listed at the same BOM level or coming from a selection formula. You can select several components or refuse them all. The buttons [Include all] and [Exclude all] are available for this purpose. If no component is selected, the button [Criteria] becomes available in order to narrow the selection when the number of table lines is too important.

The lines corresponding to the different BOM components are generated:

• If the product has the Kit component type, all the component lines are automatically generated. These lines become completely dependent on the parent product. They appear on the screen but are not accessible. The component quantity is automatically calculated from that of the parent product. If the parent product quantity is modified, the quantities of all the components are automatically recalculated. If the parent product is deleted, all the components are automatically deleted.
• If the product has the BOM parent product type, all the component lines are submitted and they can be modified (except the sales unit). They become independent from the parent product. If the parent product is modified or deleted, it is possible to transfer the modification or deletion to the components.

In both cases, a price list search for the component type is automatically triggered and for each order line generated, a value is assigned to the type of line:

• Kit option or BOM option for a component of type Option,
• Kit Variant or BOM Variant for a Variant type component,
• Kit component or BOM component for a component of Normal type.

Some price list controls are carried out on exiting this price list processing:

• if the price is defined with tax included, the price without tax is calculated,
• control on the calculated net price: if the calculated net price is less than the threshold price stored in the product, a warning message is displayed,
• control on the profit margin: if the percentage margin is less than the minimum margin percentage (or margin rate) stored in the product record, a warning message is displayed.

These various messages can be blocking ones according to the value of the user parameter SDACLOCK - Price, margin, qty non-blocking ctrl.(VEN chapter, AUZ group).

Order lines applying to sold and non-deliverable products of the Generic or Service category:

These products are subject to invoicing using an invoicing schedule. As long as the order line has not been invoiced completely, you can modify the quantity of the line. In that case, only the open items that are not invoiced yet and that are associated with the line can be modified. The percentage is recalculated for all the lines. The total amount of the order line can be different from the schedule total.

When products are linked to a progress billing project:

• The ordered quantity on the line can be modified and it impacts the scheduled invoice lines that have not been billed or validated.
• The order line cannot be below the total quantity, including the quantity of billed scheduled invoices and total quantity of scheduled invoices with a validated progress status.
• For a bill of materials including one or multiple components linked to a progress billing project, if the parent product quantity is modified the components are only updated if this quantity is greater than or equal to the quantity of the validated or billed progress status. Otherwise, the modification is only applied to the components which are not linked to a progress billing project.
• You cannot modify the quantity when all scheduled invoices are linked to a validated progress status.
• The modification is also blocked when a price list structure (discounts/charges) is set to trigger a price change when the scheduled invoice has a validated progress status.

This is the conversion factor between the sales unit and the stock unit. This coefficient can be modified. It will be modifiable if the sales unit of the product or the packing unit have been checked as 'modifiable' (see the Product record). It cannot be modified if the unit used is a unit defined for the customer. If for the units used, the factor is modifiable, it is necessary to define only prices expressed in stock unit.

Once the line entered, it is no longer possible to modify the conversion factor. It is necessary to delete the line and recreate it to modify this factor.

Specificities linked to the inter-company: if the order has been generated from inter-company or inter-site sales order, this information is initialized with the factor calculated between the purchase quantity and the stock unit and it cannot be accessed. Only a modification of the original purchase order can modify this information.

This is the stock unit for the product. This unit cannot be modified.

This is the quantity, expressed in sales unit, already allocated in the order. This allocation can be global or detailed.

This is the shortage quantity in the order expressed in the sales unit. During the last allocation made in the order line, if part of the stock is unavailable then it is expressed in this column (if the GENSHT - Generation of the shortage quantities parameter (STO chapter/MIS group) is set to Yes).

This is the quantity allocated to the order line.

When the transaction authorizes it, it is possible to enter the quantity that is to be allocated on the order line.
It is always equal to the quantity already allocated in the order line (Allocated Quantity + Shortage Quantity). To increase or decrease the quantity to be allocated, this quantity must be increased or decreased.
If the INIALLORD - Initialization of quantity to be allocated in the order parameter is set to 'Yes', the quantity to be allocated is initialized by the total quantity that must be allocated on the order line (if the ordered quantity for the order must be modified, the quantity to be allocated would then be recalculated).
If the order is not Fully signed though the approval circuit is managed and the SOHAPPALL - Non-signed order allocation parameter is set to 'No', the quantity to be allocated cannot be entered and is not initialized with respect to the ordered quantity. The same behavior is applied if this SOHAPPALL - Allocation order not approved parameter is set to 'Yes' but that the WIP generation for the products managed in stock is forbidden for the orders that have not been approved (SOHAPPORD parameter set to No). The allocation of an order without WIP is not unauthorized.

The quantity entered can be greater than the ordered quantity. A warning message will signal this. The allocation is carried out on saving of the order.

If customer reservations exist for this product and if the USERERBPC - Consumption of customer reservations parameter is set to the value 'Yes', the reservations carried out by the customer are consumed during the allocation.

If the customer credit is blocked, this field cannot be accessed.
If the customer has exceeded their credit, a warning message requires the entry confirmation if the SCDTUNL - Authorization to unlock order user parameter allows it, otherwise the information cannot be accessed.

If the order status is Prepayment not settled, a warning message asks for the entry confirmation.

When entering the quantity to be allocated:

• A warning message is displayed if shortage quantities already exist in other documents for the product currently being processed.
• If the Product availability option is selected in the order entry transaction, the information is mentioned in the Available stock section under the table. When the total quantity to be allocated is not available, the quantity remaining to be allocated is mentioned. It is expressed in stock unit and sales unit.
  As for the document valuation, the display of the product availability is conditioned by the value of parameter SOHVALLIG - Order valuation on line (VEN chapter, MIS group).

In the specific case of order lines generated by back-to-back order on receipt or back-to-back production order.

When the order line is associated with this type of back-to-back order, the automatic allocation processes do not allow the allocation of this type of line. The order line is allocated at the time of the associated purchase order receipt or at the moment of the production reporting for the associated production order.
To manage certain occurrences (production delay or supplier shipment...) it is possible to manually allocate (or de-allocate) these lines if the stock is available.
During the production reporting or at the time of the purchase order receipt, if the quantity remaining to be allocated in the order is less than the quantity booked into stock, only the part remaining to be allocated is allocated. The rest of the goods is entered in stock and is available for other orders.

It is not possible to allocate an order line managed with direct orders.

The available actions are:

• Allocations filter. Use this action to specify the information used by the detailed allocation or at the time of shipment if the line has Global allocation. Exclusive filters can be entered: the lot and a combination of statuses (the combination of statuses entered must be included in the Issue rule of the corresponding shipment type). A preferential filter can be assigned to a location that is used to orientate the allocation. It is possible to enter wild cards "*,? " for these data in order to extend filters.

The allocation type for an order line has as its default value the allocation type defined in the order header. It is possible to modify the allocation type (Global/Detailed) on a line, provided that the selected order transaction allows it. A global allocation is carried out depending on the available stock total. A detailed allocation reserved the stock objects (Lot - Serial number - Status - Location).

When the order line is allocated, this information is no longer accessible.

When the ordered product is not managed in stock, you can specify the quantity to be shipped or invoiced (for direct invoicing orders) for this product. If nothing is specified, the whole line is shipped.

When the product is not deliverable for a normal order, this field is not available: the quantity to invoice is defined on the invoicing schedule.

This is the unit gross price (in sales unit) of the product expressed tax-excluding or tax-including (depending on the price type). It comes from a price list search, or from the base price of the sales product if the price list search did not return any result.

If the sales unit is different to that of the price list line:

- the price list amount is converted if the Unit conversion is set to 'Yes' in the Price list setup. This conversion is based on the table of unit conversion factors. If no conversion is set up for these units, the price list amounts are considered by applying a conversion rate of 1.

- The price list is not used if the Unit conversion is set to 'No' in the Price list setup. The gross price is set to '0'.

Click the Actions icon to:

• View the reasons associated with the price as well as the different discounts and charges fields;
• View the list of the last 10 order prices;
• View the price lists;
• Get an explanation on how the net price was obtained from the gross price and the different discounts.

If the entered price is null, a message is displayed to request confirmation.

This message is displayed neither for the components of a BOM nor for free items.

Free item processing

A processing for free items is triggered at the end of the document line. This processing generates all the free product lines (Gross price and discounts set to 0). If the parameter FOCPRI - Free product valuation (chapter VEN, group PRI) has the value Yes, a price list search is triggered for the free item so as to assign it a gross price. The assigned price is compensated for, either by a line discount in percentage or a line discount in amount (according to the order of discounts) to obtain a zero net price.
The original line number of the free item is mentioned in each free item line generated in the quote line file (information not displayed on the screen). The Origin information is displayed on the line from which the free items originated in the Free field. For the free item line, this information is set to Yes. All free item lines are accessible in modification mode (except the price and discounts fields). It should be noted that the management of free items is not taken into account for components.

When creating the document, if the setup manages grouped price lists (GRPPRI - Management of grouped price lists), a question is asked about whether to carry out a new price list search (for the grouped type) that is used to determine the specific conditions linked to the whole quote. At the end of this process, you may get the following, on some product lines:

• A new gross price or new discounts or new charges for the line;
• Free products that are not associated with a specific line.

Order lines applying to sold and non-deliverable products of the generic or service category.

These products are subject to invoicing using an invoicing schedule. As long as the order line has not been invoiced in full, you can modify the price of the line. In that case, only open items not yet invoiced and linked to the line can be modified. The quantity and percentage of open items are not impacted. The total amount of the order line can be different from the schedule total.

For products linked to a project with progress billing, you cannot update the price if the progress status linked to a scheduled invoice is validated. The price becomes available for modification again once the scheduled invoice is billed and the other scheduled invoices have not yet been linked to a validated progress status.

Discounts and charges columns are displayed. They depend on the setup of the Price list structure code (see the Price list structure documentation). They can be initialized by the use of the price lists (see the Price list parameters and Price list entry documentations). Access to these columns can depend on the parameters of the reasons associated with the price lists as well as the value of the reason given to the UPDPRISAL parameter for Sales and to the UPDPRIPUR parameter for Purchase.

These discounts or charges are defined in amount or in percentage and they are applied in total or as a cascade to the gross price to determine le net price of the document line.

From this information using the contextual button there is the possibility to view the reasons associated with the price as well as the different discounts and charges field.

This is the unitary net price for the receipt line calculated from the gross price affected by any discounts and charges. This information cannot be accessed.
From this field, use the Actions icon to:

• View the reasons associated with the price as well as the different discounts and charges fields
• View the list of the last 10 order prices
• View the price lists
• Have a detailed explanation available describing how the net price is obtained

If the entered price is null, a message appears to request confirmation. However, this message is not displayed for the components of a BOM, for free items and for deliveries not to be invoiced.

A process for the Free items is triggered at the end of the delivery line. This processing generates all the free product lines (Gross price and discounts set to 0). If the value of the FOCPRI - Free product valuation parameter (VEN chapter, PRI group) is ‘Yes’, a price list search is triggered for the free item to assign it a gross price. The assigned price is compensated for, either by a line discount in percentage or a line discount in amount (according to the order of discounts) to obtain a zero net price.

When you click Create to save the delivery, and based on the value of the GRPPRI - Grouped price lists parameter, a message can be displayed, suggesting that a new price list search is run to determine the specificities globally linked to the delivery. At the end of the processing, the following can be generated on some product lines:

• a new gross price or new discounts or new charges for the line,
• free products that are not associated with a specific line.

The 'cost price' is populated by default with the valuation of the product chosen for the margin calculation (see the valuation methods defined for the Product-Site record) at the time of the creation of the document line and is expressed in sales unit. The various possible choices for the cost price valuation are: Standard price, Revised standard price, Last price, Weighed average price, FIFO price, Lot average price and LIFO price. If the valuation method happened to return a zero value, a default value is used by specifying another valuation method contained in the list previously described. This value is stored in the "document" line.

It is possible to preload this information according to the document transaction used. Still, during the following events, the entered value is systematically replaced by the value originating from the setup of the valuation method for the product, except if this setup determines a null value (in which case the change is saved):

• Turning a quote into an order
• Delivering an order 
• Validating a delivery
• Invoicing an order The cost price is fixed when invoicing a delivery

In quote management, the 'lot average price' always returns a null value. A default value is used. During the delivery validation, the 'Lot average price' is used to recalculate the margin and obtain a real margin depending on the shipped lot(s).

This field displays the margin in sales unit, calculated based on the difference between the net price and the cost price.

During the gross margin calculation, a control can be carried out to verify that this margin is not below the minimum threshold defined in the Sales tab in the Product record. This control can be blocked according to the value attributed to the user parameter SDACLOK - Non block. control price, prof, qty (VEN chapter, AUZ group). The calculation carried out to control the margin rate is the following:

(Ex-tax price - Cost price) / Total ex-tax price) *100 >= percentage of the minimum margin.

No control is carried out on nonbillable deliveries.

This field indicates the tax level applied to the selected product.

The tax level, when crossed with the document tax rule, is used to determine the tax rate to be applied on the document line.

There are three tax levels for a document line.

The first level is compulsory and it corresponds to the VAT.

The other two levels concern additional and special taxes that can be submitted to the VAT or not, and be applied to the ex-tax basis or any other evaluated formula.

The tax levels for the document line will be loaded by default with the values associated with the product record (Accounting tab). These values can be modified depending on the transaction. You can also, if the user's authorizations permit it, access the tax level management.

The parameter CTLTAX - Tax codes control (VEN chapter, VAT group) is used to control that the tax codes linked to the tax level are consistent. Using this control, the system checks that the tax level:

• is specified,
• is activated,
• has a legislation and company group consistent with the ones of the document.

The presence of this field depends on the entry transaction used.
An invoicing term can be used to determine the invoicing schedule of the order line. This invoicing term must be entered when the order line applies to a product of the Sold but not Deliverable type. Otherwise, it cannot be entered.
The field is initialized based on the invoicing term entered on the order header, or else, based on the condition specified for the product.

In the case of Free items, the invoicing term is initialized by order of priority, as follows:

• invoicing term entered at the level of parameter INVCNDFREE - Free items invoicing term (VEN chapter, ORD group),
• invoicing term entered in the order header,
• invoicing term entered on the product,
• invoicing term of the free items source line, when free items are linked to an order line and are created at the end of the price list search for this line.
  When free items are generated from grouped price lists after the order entry, their invoicing term is initialized based on the rules defined above. If the invoicing term is not specified, the free item lines are not generated.

In the case of BOM parent products, which are not deliverable, the invoicing term is initialized based on the invoicing term entered on the order header, at the Invoicing tab level. By default, the term is initialized on each line (component and parent) based on the invoicing term specified on the line product. It can be accessed and modified on each line separately. If the invoicing term is not specified, the scheduled invoices are not generated. If the invoicing term is modified on the header, a dialog box opens suggesting to transfer the modification to the document lines, as for normal products (see the notes below about products).
If the invoicing term is modified on the parent product, a dialog box opens and suggests that the modification is transferred to all component lines. If you answer Yes, the modification is applied to all component lines that have not been closed, subject to an invoice, or linked to a billing plan. On order modification, a message is displayed when modifying the selected schedule to inform you that the schedule of the relevant lines is to be modified.

Notes applying to all products:

When the invoicing term is modified on the document header, a dialog box opens and proposes to apply the modification to all document lines, based on the following options:

• Yes: The invoicing term is applied to all lines including free item lines but excluding lines linked to a billing plan.
• No: The invoicing term is not applied to the lines.
• Same value: The invoicing term is only applied to the lines on which the former invoicing term was used.

Only the lines that have not been closed or subject to invoicing are concerned.

The selected invoicing term can only be modified once the order line is invoiced partially or totally. On order creation, when this choice is modified on an order line, the schedule is immediately revaluated based on this new invoicing term. On order modification, a message is displayed when modifying the selected schedule to inform you that the schedule of the relevant lines is to be modified.

You can access the invoicing terms management in view mode from the Actions icon. In this function, use the Simulation action to simulate the scheduling of expected invoicing open items.

To display the invoicing schedule of an order line, click Schedule form the Actions icon displayed at the beginning of a line.

Enter the code to use in order to override the default SST tax code from the product or invoice element. This tax code is recognized by Sage Sales Tax and is used to identify line types for tax purposes. This field is available only if the LTA - Local taxing activity code is activated, and the USATAX - Tax system user parameter is set to Yes.

For invoicing elements designated as the SST document discount for a company, you cannot remove the SST tax code value on the document.

The project code in document line is initialized by the one entered in the header or, in the case of a document transformation, by the one of the selected document lines (in picking or in mass processing, if the project code on a document line is inactive, the line cannot be selected).

• The PJTSNGDOC - one project per document parameter (TC chapter, MIS group) is set to No,
• The entry of this field is authorized by the entry transaction being used.

In modification mode, the project code management depends on the value of the CTLOPPCOD - Mandatory project control parameter.

• When the value is No, it may be a code selected freely.
• When its value is Yes, an existence check is systematically applies to the entered project code.

When the entry is controlled, depending on the context, a project or one of its entities can be picked (a budget batch or task), using its posting code:

• Yes: The project code is applied to all lines, excluding lines linked to a billing plan and lines with an incompatible milestone.
• No: The project code is not transferred to the lines.
• Same value: The project code is only transferred to the lines associated to the previous project code.

Sales documents: Quotes, orders, deliveries and invoices:

• For a quote: The item line is not ordered and is not free.
• For an order: The item line is not closed, not delivered, not invoiced nor free.
• For a delivery: The item line is direct and not free.
• For an invoice or a direct credit: the document is not validated, the item line is direct and not free. For direct credits, the quantity is different from 0.

• If multi-project management of documents is enabled (PJTSNGDOC - One project per document parameter set to No), the delivery can include direct delivery lines and product lines linked to tasks. The header project code is used as the default value on direct delivery lines only. Product lines linked to tasks keep their project code, which cannot be modified. If the header project code is modified, the application of this code to the lines is suggested, as described above. This only applies to direct delivery lines.
• If multi-project management of documents prohibited (PJTSNGDOC - One project per document parameter set to Yes), the delivery cannot include both direct delivery lines and product lines linked to tasks.

• When the delivery is for direct delivery lines, you cannot enter a project code in the header that is already used on tasks.
• When the delivery is for product lines linked to tasks, you can only enter product lines linked to the same task. The header project code can then be used to filter tasks in the selection panel.

Specific case of free items generated by the price list search after updating the header project code: The free item displays the project code of its source product but only if this code is not used on a task.

The sales reps on the document line are initialized by the sales reps entered in the document header. If the latter are not entered, the sales reps in the line are initialized by the sales reps for the customer, by those for the ship-to customer if there are no sales reps in the customer record.

If the parameter LINREP - Sales rep on detail allows it (chapter VEN, group MIS), the sales reps can be modified on the document line. It is possible, based on the user's authorizations, to access the sales representative record.

The commission rate for the sales representative is initialized on the line based on the commission category for the customer and the commission rate for the sales representative by category. This commission rate can be weighted by a modifiable weighting factor that can be initialized by the price list setup. This information comes from the invoice header in the case of a direct invoice or the original document.

This coefficient is used to weight the commissioning rate of the sales representatives for this document line upon commision calculation.
This information is initialized using the price list search: some price lists are used to define a weighing coefficient for the commissioning rate of the sales representatives.

This is the delivery date requested by the customer. This date is initially by the requested delivery date entered in the order header. The modification of this date will trigger the recalculation of the shipment date (Shipment date = Requested delivery date - Delivery lead-time) and will recalculate the planned delivery date (Planned delivery date = Shipment date + Delivery lead-time).

During the modification of this date, the system controls that this date does not correspond to a non-working day or an unavailable day for the delivery date. If this is a non-working day, the date is postponed, otherwise a warning message is displayed.
The system also checks that the entered date remains lower than or equal to the Maximum delivery date entered on each order line. If it is not the case, a message is displayed suggesting to also replace the Maximum delivery date with the entered date.

Inter-company specificities: In the case of an inter-company or inter-site order generated from a purchase order, the requested delivery date will be initialized by the planned receipt date entered in the purchase order line.

This is the delivery lead-time in number of days for the ship-to customer. This lead-time is initialized by the lead-time determined in the order header. It is used to calculate the planned delivery date from the shipment date. If the delivery address is modified on the order line, the delivery lead-time will be re-initialized with the lead-time entered in the new delivery address which will also lead to the recalculation of the planned delivery date.

The shipment date is initialized by the shipment date entered in the order header. It is used to calculate the planned delivery date. It is calculated from the requested delivery date to the delivery lead-time is attached. If the shipment date is modified, the planned delivery date will then be recalculated by adding the lead-time to the shipment date entered.

During the modification of the shipment date, the system controls that:

• the date is included in the working days of the shipment site. If this is not the case, the shipment date is moved to an earlier date. 
• the date is not included in the unavailability days of the site. If this is the case a blocking message signals it.
• the date is not inferior to the date of the order. Otherwise, a blocking message signals it.

This is the delivery date calculated by the system taking into account the shipment date and delivery lead-time.  If the planned delivery date is modified, the system will suggest that the user modifies the shipment date as a function of the delivery lead-time.

During the modification of this date, the system controls that this date does not correspond to a non-working day or an unavailable day for the shipment date. If this is a non-working day, the date is postponed, otherwise a warning message is displayed.

The delivery address can be personalized in each order line if the general parameter (LINBPD - Ship-to Customer on Detail) allows it and if the shipment method for the order is not Complete order, in which case this information will not be modifiable on the order line.
The contextual button is used to select a delivery address for the customer and to access by tunnel this delivery address.

The modification of the delivery address of an order line has the following consequences:
- the delivery lead-time will be re-initialized by the delivery lead-time in the new delivery address. The shipment date will be recalculated taking into account the lead-time and the requested delivery address. The planned delivery date will also be calculated from the new shipment date and the delivery lead-time.
- if necessary, a message indicating that the product is prohibited for this new address, is displayed. If the user has no blocking control on prices (SDACLOK - Non block ctrl price, profit,qt user parameter), he may carry on regardless of the warning message.
- A dialog box opens and suggests that prices and discounts be re-calculated. The answer 'Yes' triggers a price list search according to the new delivery address.

Special features linked to the inter-company option: IIn the case of an inter-company order generated automatically from a purchase order, the delivery address corresponds to the ship-to customer associated with the receiving site entered in the purchase order. This information cannot be modified in the sales order. Only a modification of the original purchase order can update this information provided the order line is neither allocated nor shipped.

This is the name of the contact associated with the delivery address. If the delivery address corresponds to the delivery address in the document header, the contact suggested by default on the line is the contact entered for the delivery address displayed on the header.

If the delivery address does not match the delivery address mentioned on the document header, then the contact suggested by default is the business partner default contact if it corresponds to this delivery address. Otherwise, the system suggests the first contact of this address by alphabetical order on the contact code.

The quote lines applying to non-deliverable products are not impacted by this information.

This information is used to indicate the place of consumption or to define an addition to the address. For example: Dock x.

Special features linked to the inter-company option: In the case of an inter-company or inter-site order generated from a purchase order, the place of consumption will be initialized by the place of consumption entered in the purchase order line.

This information (initialized by the delivery priorities in the Delivery tab) is used to specify the priority of each line. This information is used to prioritize the preparation of certain order lines. It is used in the automatic allocation processing of orders. It is possible to allocate orders by priority level (e.g. to supply all orders when the stock is insufficient).

 If the delivery method for the order is Complete order, this information is not accessible at the order line level.

This code, which is controlled by a local menu, is used to generate the delivery notes according to the route code defining for example, a geographic zone. This information is defined by the customer delivery address.

This delivery method is used to define the information related to the transport and delivery.  It describes the manner in which the goods will be sent to the customer (this information is used notably in the Intrastat exchange of goods declaration). It is managed in the Delivery methods table. This information is initialized with the delivery method entered in the order header but it can be modified on the line if the order delivery method is not set to the value Ship order complete. If the delivery address is modified on the order line, the delivery method will then be reassigned by the value mentioned on the delivery address.

This is the carrier used to transport the goods to the customer delivery address. It is managed in the Carriers table. This information is initialized with the carried entered in the order header but it can be modified on the line if the order delivery mode is not set to the value Ship order complete. If the delivery address is modified on the order line, the carrier is reassigned by the value mentioned on the delivery address.

The carrier is used later on the delivery note in order to calculate freight in accordance with the delivery weight and volume.

This field includes the preparation code. You can select this code from the Actions icon or enter it if it has not been set up.

This code is controlled in the packaging table. It specifies the number of products, expressed in sales units, that the packaging can contain. It is initialized once the product has been entered, based on the sales unit used and the shipping site:

• If the sales unit of the order is initialized to the sales unit of the customer product, the packaging is initialized to that of the customer product
• If the sales unit does not exist for the customer product, the sales unit of the order is initialized to the sales unit of the product. In this case, the packaging is initialized to that of the product-site, or, if there is none, to that of the product category.
• If you modify the shipping site of the line and it is different from the shipping site on the order header, the packaging is once again initialized to that of the customer product, or, if there is none, to that of the product-site.

This information can be modified.
Once the line has been entered and validated, the packaging is not reinitialized if you modify the shipping site of the line. You must enter it manually.

This information and the packaging capacity are used upon preparation or shipment to carry out the packaging.
During the declared packing, this packaging code is entered if it is displayed in the Deliveries or Picking tickets original documents.

If you are granted the proper authorizations, you can access the packaging record.

This field is subject to the EDIX3 activity code.
You use it to enter the final price of the product for the consumer.
On automatically generated BOM and free item lines, this amount is set to: 0

In the case of orders received by EDI, the BOM and free item lines are not generated automatically. The final price of the product may be provided by the sender on each line. The lines are therefore imported one by one, based on the provided values.

The two fields Exp. delivery time and Max delivery time are initialized to the Exp. delivery time entered in the header.
The Max delivery time field is subject to the EDIX3 activity code.
As a general rule, these fields can be modified: you use them to define a delivery time slot.
In the following cases however, this information is automatically loaded and cannot be modified:

• on the automatically generated BOM lines where the values are identical to the ones on the component line,
• on the 'free item' lines where the values are identical to the ones of the product from which the free item originated.

This field is subject to the EDIX3 activity code.
It is initialized based on the Requested delivery date and is available for modification. The date entered must be later than or equal to the Requested delivery date.
This information is loaded automatically and cannot be modified:

• on the automatically generated BOM lines where the values are identical to the ones on the component line,
• on the 'free item' lines where the values are identical to the ones of the product from which the free item originated.

In the case of orders received by EDI, the BOM and 'free item' lines are not generated automatically. Lines are imported individually. However, if a modification is applied to the component or source product of the 'free item', this modification will be also applied to the component and free item lines.

The two fields Exp. delivery time and Max delivery time are initialized to the Exp. delivery time entered in the header.
The Max delivery time field is subject to the EDIX3 activity code.
As a general rule, these fields can be modified: you use them to define a delivery time slot.
In the following cases however, this information is automatically loaded and cannot be modified:

• on the automatically generated BOM lines where the values are identical to the ones on the component line,
• on the 'free item' lines where the values are identical to the ones of the product from which the free item originated.

This field is subject to the EDIX3 activity code.
If the product is managed in stock and the expiry date is also managed, this field is initialized as follows: Maximum delivery date (MAXDLVDAT) + Shelf life (SHL). The date is calculated based on the criteria of the calculation method set up in the Management field (EXYMGTCOD) at product level.
This date can be modified. This date must be greater than or equal to the Maximum delivery date.
If the expiry date is not managed, the field is blank by default.

The analytical dimensions are initialized according to the setup of Default dimensions, associated with the management of order lines. Depending on the setup, they remain available for modification.
When an analytical dimension is used for project management tracking, any modification of the project code on the document line leads to the dimension code being reset based on the Default dimensions setup.

This flag is used to define the status of the order line which can be Firm or Planned. The Planned status is used to anticipate the firm orders to come because this information is used for requirement purposes in the MRP calculation. This flag is no longer modifiable if the order line has been allocated, delivered or invoiced. It cannot be modified if the line is managed with direct orders.

• If the order line has the status Firm (default value), it remains possible to allocate and deliver it.
• If the order line has the status Planned, it can neither be allocated nor delivered (its status needs to be modified manually to switch it to Firm).

Use this field to choose how to cover the requirement expressed by the order line: in a normal way, using a receipt back-to-back order, a direct back-to-back order or a production back-to-back order.

Based on the product category and the setup of the product record (Sales tab), this field is initialized in the following way:

• If the product belongs to the Service , Non deliverable category, the product origin is Normal.
• If the product is not managed in a back-to-back order mode, the product origin is Normal : it is possible to deliver the order line from the available stock.

• If the product is managed in a back-to-back order mode, the default back-to-back order is dependent on the product category.

• If a product belongs to the Bought category, but not to the Manufactured category, the default back-to-back order is a receipt back-to-back order, except if the Direct quantity (Sales tab in the Product record) is populated. In that case, the default back-to-back order type is a direct back-to-back order if the ordered quantity is greater than or equal to the direct quantity.
  This type of back-to-back order (direct) cannot be used in an intercompany context.
  
• If a product belongs to the Manufactured category, but not to the Bought category, the default back-to-back order is a work order.
• If the product belongs to the Service category and its flow type is Bought, the only possible choices are Normal and Direct order.

This is the purchase order number or the works order number when a back-to-back has been generated for an order line. This document is accessible from the Position function.

This is the unitary net ex-tax price for the line multiplied by the document quantity.

This is the unitary ex-tax price for the line to which the different taxes entered have been applied, multiplied by the quantity of the document line.

This is the unitary margin multiplied by the quantity on the document line.

This is the quote number at the origin of the order line. To access the quote, click Quote from the Actions icon available on the order line.

This field cannot be entered. It only applies to non-deliverable Service products linked to a project with progress billing. This field displays the number of the billing plan linked to the project, which you generate from the Project management (GESPJM) function after entering the project code on the order line.

This information characterizes the line type by distinguishing a classic product from a kit or a BOM product.
It can take the following values:

• Normal,
• Fixed kit,
• Kit Component,
• Kit Option, Kit Variant,
• Flex kit,
• BOM component,
• BOM Option,
• BOM Variant.

This information specifies whether the line concerns a free item or if the line is the origin of the generation of one or more free items.

This information specifies whether the order line is closed or still active. A line can be closed if it has been totally delivered (or totally invoiced in the case of direct invoicing orders or scheduled invoices) or if it has been manually closed.

A closed line is no longer available for modification. If the order is not completely closed, an order line can be un-closed if associated with a service contract.

This is the closing reason for the order line when this has been closed manually. The closing reason is loaded if the CCLRENORD - Enter order closing reason parameter is active. This reason can correspond to the order closure reason (if the order has been globally closed) or corresponds to the closing reason assigned during the closing of this reason. During the order closing this information can be entered in a list of predetermined values (see miscellaneous table Closing reason)

This is the date on which the closing of the order was manually carried out.

The display of information related to stock availability depends on the setup of the Order entry transaction.
As for the document valuation, the display of the product availability is conditioned by the value of parameter SOHVALLIG - Order valuation on line (VEN chapter, MIS group).

If the product is not available, the message: ’XXX: Not available in stock' is displayed, followed by the possible first date of availability and quantity in stock unit and sales unit.

The display of information related to stock availability depends on the setup of the Order entry transaction.

As for the document valuation, the display of the product availability is conditioned by the value of parameter SOHVALLIG - Order valuation on line (VEN chapter, MIS group).

When the total quantity to be allocated is not available, the quantity remaining to be allocated is mentioned. It is expressed in stock unit and sales unit.

This field displays the ex-tax amount remaining to be delivered, calculated from the order lines which are either not delivered or only partially delivered.

On standard orders, this amount is only calculated from lines that relate to deliverable products.

On direct invoicing orders, this amount is loaded based on all the lines. It always corresponds to the ex-tax amount to be invoiced.

Indicates the total margin of the order calculated based on the margin of the order lines.

This is the aggregated tax excl. total for the lines. It is calculated by adding the quote lines. If the report DEVICLIENT is printed (Quote printed Ex-tax), the Ex-tax amount printed corresponds to the total Ex-tax amount.

This field indicates the ex-tax result including the various invoicing elements entered in the order.

This information is displayed when printing the report ARCTTC2.

The calculation detail is stored in tables SVCRVAT and SVCRFOOT.

This field indicates the tax incl. total, which includes:

• the various invoicing elements entered in the order,
• the tax calculation by tax basis.

This information appears when the ARCTTC2 report is printed.

The detail of the tax incl. calculation is obtained by right click on the total amount. The detail of the calculation is stored in the SVCRVAT and SVCRFOOT tables.

In order to access the 'Incl. tax Valuation' screen, click on the incl. tax field.