| # Synchronization between purchase order line and purchase order line detail A purchase order line can have purchase order line details linked to it. A purchase order line detail can be of the following Order Line Type: Detail. Back Order. For each line detail ( Detail line, or Back Order line), you can also have (a) linked Back Order line(s). A purchase order line with several line details is also referred to as a Total line. To have the correct information on the order line, the Detail lines and the Back Order lines are synchronized with the Total line and vice versa, when they are updated. To update line details from the total line If you change the following fields on the Total line in the Purchase Order Lines (tdpur4101m000) session, the change is copied to the linked line detail(s) in the Purchase Order Line Details (tdpur4101m200) session: Price fields: Price. Price Matrix Definition. Price Matrix Sequence. Discount fields: Discount %. Discount Amount. Discount Matrix Definition. Discount Matrix Sequence. Discount Method. Discount Type. Discount Code. Determining. Eligible. Contract fields: Contract. Contract. Contract Purchase Office. Order Confirmation Date. Lot Selection. Lot. Note A change to a field on the Total line is not always directly visible on the line detail. The reason for this is that commercial data, such as prices, discounts, amounts, and so on, are only visible on the Total line. Only logistic data, such as time and place of receipt, place of shipment, and so on, are visible on the line detail. As a result, the Total line holds the commercial information of the linked line details, which is divided over the line details, but which is not visible on the line details because these lines only display logistic data. However, if you release a line detail to ERP LN Financials, ERP LN uses the invisible commercial data of the line details, because a Total line cannot be invoiced. To update price and discounts after receipt After an order line or a line detail is received, you cannot update the price or discount for the Total line in the Purchase Order Lines (tdpur4101m000) session. For a Total line or a detail line with at least one receipt, you can update the price in the Change Price and Discounts after Receipt (tdpur4122m000) session. As a result, ERP LN copies the new prices and discounts to all linked line details that are not yet processed and/or matched/approved in ERP LN Financials. To update price and discounts after consumption For consumed order lines, you can update prices or discounts in the Change Price and Discounts after Receipt (tdpur4122m000) session and the Change Price and Discounts of Purchase Payable Receipts (tdpur4132m000) session. For more information, refer to To change prices or discounts after receipt or consumption. Example
﻿Sequence | Order Line Type | Order Quantity | Price | Order Amount | Received | Processed
0 | Total | 30 | 8 | 240 | - | -
1 | Detail | 10 | 8 | 80 | Yes | No
2 | Detail | 10 | 8 | 80 | Yes | Yes
3 | Detail | 10 | 8 | 80 | No | No
4 | Back Order | 3 | 8 | 24 | No | No
Now the price on the Total line is changed from 8 to 10:
﻿Sequence | Order Line Type | Order Quantity | Price | Order Amount | Received | Processed
0 | Total | 30 | 10 | 280 | - | -
1 | Detail | 10 | 10 | 100 | Yes | No
2 | Detail | 10 | 8 | 80 | Yes | Yes
3 | Detail | 10 | 10 | 100 | No | No
4 | Back order | 3 | 10 | 30 | No | No
The new price of the Total line is copied to all linked sequences that are not yet matched in ERP LN Financials, or processed. The order amount on the Total line is the sum of the order amounts of the Detail lines. To prevent double counting, the order amount of the Back Order lines is excluded. Note When the order line is created, the price is determined based upon the Purchase Price Date Type parameter in the Pricing Parameters (tdpcg0100m000) session. This field determines whether the order date, system date, or delivery date must be used to calculate the price. When you change the Receipt Date for Pricing, or the Order Date in the Purchase Order Lines (tdpur4101m000) session, the new dates are not synchronized with the linked line details in the Purchase Order Line Details (tdpur4101m200) session. To update the total line from the line details ERP LN updates the quantity and amount fields on the Total line when these fields are modified on a linked line detail, when you add, update, cancel, or delete a line detail in the Purchase Order Line Details (tdpur4101m200) session. The quantity or amount fields on the Total line hold the sum of the quantities/amounts of the linked line details. The quantity and amount fields that are synchronized are: Ordered Quantity. Received Quantity. Packing Slip Quantity. Approved Quantity. Rejected Quantity. Back Order Quantity. Order Amount. Receipt Amount. Total Order Line Discount Amount. Order Discount Amount. Note The quantities/amounts are present on the purchase order line detail, but most of them are not visible in the Purchase Order Line Details (tdpur4101m200) session. However, you can view these quantities and amounts in the Purchase Receipts (tdpur4106m000) session and the Purchase Orders - Receipt Overview (tdpur4531m000) session. When you modify the Ordered Quantity of a Back Order line in the Purchase Order Line Details (tdpur4101m200) session, ERP LN does not update the Ordered Quantity of the Total line in the Purchase Order Lines (tdpur4101m000) session, but updates the Back Order Quantity of the Total line. When you modify the order quantity, ERP LN recalculates prices and discounts automatically. ERP LN only recalculates the price and discounts when you did not manually enter the existing price and discounts. When a new price and/or discount is retrieved for the Total line, ERP LN: Copies the new price/discount to the linked Detail lines and Back Order lines as long as these lines are not invoiced or processed. Recalculates the order line amounts for each Detail line/ Back Order line. The order line amount fields on the Total line are updated with the sum of the order line amounts of the linked Detail lines. The order amount of the Back Order lines is not taken into account for the order amount of the Total line. For the other quantities and amounts, such as Received Quantity and Receipt Amount, the values of the Back Order lines are taken into account for the sum on the Total line. Example
﻿Sequence | Order Line Type | Order Quantity | Price | Order Amount | Received | Processed
--- | --- | --- | --- | --- | --- | ---
0 | Total | 30 | 8 | 240 | - | -
1 | Detail | 10 | 8 | 80 | Yes | No
2 | Detail | 10 | 8 | 80 | Yes | Yes
3 | Detail | 10 | 8 | 80 | No | No
4 | Back Order | 3 | 8 | 24 | No | No
Now the order quantity on one of the Detail lines is changed from 10 to 12, and the price is changed from 8 to 10:
﻿Sequence | Order Line Type | Order Quantity | Price | Order Amount | Received | Processed
--- | --- | --- | --- | --- | --- | ---
0 | Total | 32 | 10 | 300 | - | -
1 | Detail | 10 | 10 | 100 | Yes | No
2 | Detail | 10 | 8 | 80 | Yes | Yes
3 | Detail | 12 | 10 | 120 | No | No
4 | Back Order | 3 | 10 | 30 | No | No
For the Detail line that has a new order quantity, the order amount is recalculated. The order quantity on the Total line is the sum of the order quantities of the Detail lines. Because the price and discounts were not entered manually, the price and discounts on the Total line are recalculated following the price and the new total order quantity. The new prices and discounts are copied to the linked sequences. For each Detail line/ Back Order line, the order amount is recalculated and the Total line is updated with the sum of the order amounts of the Detail lines. To update back order lines from the original line For a Total line, a Detail line, or a Back Order line, you can change the price and discounts (after receipt). When a line has already one or more linked Back Order lines, ERP LN copies the new price and discounts to these lines. Example
﻿Sequence | Order Line Type | Order Quantity | Price | Parent Sequence | Received | Processed
--- | --- | --- | --- | --- | --- | ---
0 | Detail | 50 | 8 | - | Yes | No
1 | Back Order | 10 | 8 | 0 | Yes | No
2 | Back Order | 2 | 8 | 0 | Yes | Yes
3 | Back Order | 5 | 8 | 1 | Yes | No
4 | Back Order | 1 | 8 | 1 | No | No
5 | Back Order | 2 | 8 | 3 | No | No
Now the price on the Detail line is changed from 8 to 10:
﻿Sequence | Order Line Type | Order Quantity | Price | Parent Sequence | Received | Processed
--- | --- | --- | --- | --- | --- | ---
0 | Detail | 50 | 10 | - | Yes | No
1 | Back Order | 10 | 10 | 0 | Yes | No
2 | Back Order | 2 | 8 | 0 | Yes | Yes
3 | Back Order | 5 | 10 | 1 | Yes | No
4 | Back Order | 1 | 10 | 1 | No | No
5 | Back Order | 2 | 10 | 3 | No | No
The new price also applies to all linked sequences that can be modified. Now, instead of the price on the Detail line, the price for sequence number 1 is changed:
﻿Sequence | Order Line Type | Order Quantity | Price | Parent Sequence | Received | Processed
--- | --- | --- | --- | --- | --- | ---
0 | Detail | 50 | 8 | - | Yes | No
1 | Back Order | 10 | 10 | 0 | Yes | No
2 | Back Order | 2 | 8 | 0 | Yes | Yes
3 | Back Order | 5 | 10 | 1 | Yes | No
4 | Back Order | 1 | 10 | 1 | No | No
5 | Back Order | 2 | 10 | 3 | No | No
The new price applies to all sequences that are linked to sequence 1 (the sequences with parent sequence 1 and its children). ERP LN does not change the parent line of sequence 1. |