Calculating Unit Price for Inter-Entity Transfer Orders

For transfer order lines where the Inter-Site Parameters record's Posting Method for transfers between the two sites is set to Inter-Entity, the unit price is calculated as follows:

  1. A price code for the transfer order may be specified in the From site's Inter-Site Parameters form, or in the From site's Item Pricing form for the item being transferred. If a price code is found in only one of these two areas (or if no price code is found), the system skips to step 3.
  2. If two valid price codes exist, then:
    • A search is performed for a Price Matrix record for this combination of codes.
    • If a Price Matrix record is found, the corresponding price formula is found and the quantity price breaks are checked, as defined on the Price Formula form:
      • If the transfer line quantity exceeds one or more of the break quantities listed at the bottom of the form, the system uses the best valid quantity break to determine the unit price.
      • If the transfer line quantity does not exceed any break quantity or if all break quantities are zero, the formula in the upper right corner of the Price Formula form is used to determine the unit price.
  3. If fewer than two price codes exist (one or none), and a current Item Pricing record is found for the item (based on the item pricing's effectivity date), then:
    • If any quantity price breaks have been established for the item on the Item Pricing form, and if the quantity price breaks apply, these quantity price breaks are used to determine the default unit price.
    • If no other pricing has been established, the default unit price is the value entered in the Unit Price 1 field on the Item Pricing record.
  4. If no price code exists, and no current Item Pricing record exists, the Unit Price is set to the Unit Cost.
Related topics