Receiving Calculations: Landing Fields

The table in this topic reflects the fields in the Estimated Landing Information section of the PO Receive Items window that use calculations to obtain the presented information.

Landing Field | Calculation Used |
---|---|

Landed Purchase Discount | If a Percent discount, then the Land Ext. Discount sum for all discountable line items with Land Item checked shows in this field If a Dollar discount, then one of these three outcomes occurs: • If B is less than or equal to zero, then the Landed Purchase Discount is zero • If A is less than B, then the Landed Purchase Discount equal A • If A is greater than B, then the Landed Purchase Discount equals B A = (Extended Receive sum for all discountable line items with Land Item checked) / (Sum for all discountable line items with Land Item checked ((Quantity Received/Returned + Quantity Remaining + Quantity already posted) * (Estimated Actual or Actual Cost))) * (Discount Amt field from the original purchase order) B = (Discount Amt field from the original purchase order) - Total Landed Purchase Discount already posted for the purchase order) |

Landed Tax | (Extended Receive sum for all Taxable line items with Land Item checked) - (Extended Discount sum for all Discountable line items with Discount checked) * (Sale Tax% from original purchase order) |

Landed Freight | Depending on the amount, one of these three outcomes occurs: • If B is less than or equal to zero, then the Landed Freight is zero • If A is less than B, then the Landed Freight equal A • If A is greater than B, then the Landed Freight equals B A = (Extended Receive sum for all discountable line items with Land Item checked) / (Sum for all discountable line items with Land Item checked ((Quantity Received/Returned + Quantity Remaining + Quantity already posted) * (Estimated Actual or Actual Cost))) * (Freight Amt field from the original purchase order) B = (Freight Amt field from the original purchase order) - (Total Landed Freight already posted for the purchase order) |

Published date: 06/04/2021