DIB ERP Merge SKUs with Different Costs

(ID# 3249) This Telecommunications option in Options Configuration allows Do it Best members to have better control over their ERP posting. When a member orders an item from Do it Best, if the quantity ordered meets certain price-break levels, two invoice records with different costs are returned for the one PO detail record. ERP posts the first invoice record against the PO detail record, and that PO detail record is short-shipped for the price break items. The second invoice record is appended to the PO if the ERP Append to Target PO = Y. (if Append to Target PO is N, the second invoice record is reported but not processed.) If the second invoice record is posted, the values already posted from the first invoice record are averaged with the values from the second invoice record, and those averaged values are put into the PO detail. The fields which are averaged are Stk Unit Cost, Pur Unit Cost, and Unit Retail. The Qty Being Received is the sum of the quantities from the first and second invoice records. All other fields in the PO detail set by the processing of the first invoice record are left as-is. If the PO is ship/cancel (backorder is N), the short-shipped PO detail is processed and removed from the PO when it is finalized with RRP. If the PO is backorder, the short-shipped PO detail is processed and remains on the PO when RRP option F is run. That PO detail won’t be processed again because all the invoice records for that PO detail were already transmitted.