Landing Factors - Bulk Maintenance (PO09)

The Landing Factors, Bulk Maintenance screen in the Maintain Purchasing Tables (PO09/Landing Factors) allows you to do a mass update of Landing Factor records for Suppliers in Maintain Supplier Master (PO11) and for Product Supplier records in Maintain Purchasing Info (PO13). You can change Rates, add new Landing Factor records or remove existing Landing Factor records. You can also specify a bulk change for a specific Supplier, commodity or range of Products.

The following list defines every field on the Bulk Maintenance window:

• In the Factor to Change section:
  • Factor Code - enter or select from the query a Landing Factor code. Once a Landing Factor is entered the following information from PO09/Landing Factors automatically displays:
    • Description - below the Factor Code field
    • Currency
    • Method (Calculation Method)
    • Base (Cost Base)
    • Dutiable

  • Old Rate - this field is used if you are changing the Rate of an existing Landing Factor. If you enter a Rate in this field, then the Bulk Change is limited to processing only Landing Factors with an existing Rate that matches the value entered. For example, you have a number of Supplier's Products to which you are currently charged a 3% packaging fee which must be decreased to 2%; you can narrow the criteria of the bulk change to that single Supplier code and the 'Old Rate' of 3% to select only those records for update with the 'New Rate' of 2%.

    If the 'Old Rate' is left at zero, then ALL assignments of the Landing Factor, regardless of their current Rate, are updated (provided they meet the other specified criteria).

  • New Rate - enter the new Rate for the Landing Factor. Existing Land Factors matching the specified criteria or new Landing Factor records being created are set to this rate.

    Note: If the 'New Rate' is set to zero the Bulk Change process can be used to delete Landing Factor records. Once the Start Update process is initiated, you are prompted with the following message: "New Rate is zero. Delete all applicable records? Yes/No". Select Yes to have all Landing Factor records that meet this criteria deleted from PO11 and PO13. Select No to cancel the request and close the message window.

  • Create New Records - when this check box is selected, the Landing Factor is:
    • ADDED to the specified range of Suppliers/Products in PO11 and PO13.

    • UPDATED for the specified range of Suppliers/Products in PO11 and PO13 when the 'Old Rate' matches the existing Rate on the Supplier/Product record.

    For example, you want to ensure that a Landing Factor with a Rate of 12.00 exists on the Supplier/Product records for a specific range of Products. If the Landing Factor exists on the records, then it is updated to the new Rate based on the 'Old Rate' criteria. If the Factor does not exist on the records, then it is added to the records when this check box is selected.

• In the Purchasing Master Selection section:
  • Supplier Code - enter or select from the query a Supplier code if the Bulk Change is applicable to a specific Supplier or enter ****** (6 asterisks) if the Bulk Change is applicable to ALL Suppliers.

  • Commodity - enter or select from the query a Commodity code if the Bulk Change is applicable to a specific Commodity. To restrict the Bulk Change to a Product Line (first 2 digits of the Commodity code), enter the Product Line followed by ** (2 asterisks). For example, BK** will process Products belonging to the Product Line BK.

    If the Bulk Change is applicable to ALL Commodities, enter **** (4 asterisks).

  • From Product - the Product entered in the From field indicates the first Product that the Bulk change will affect. If you enter a Product code in the From field and leave the To field blank, all Products from the Product entered in the From field to the end of the IM13 file are affected.

  • To Product - the Product entered in the To field indicates the last Product that the Bulk change will affect. If you leave the From field blank, but enter a Product in the To field, all Products from the Product entered in the To field to the beginning of the IM13 file are affected.

  Note: Recalculate Landed Cost (PO17) is used to recalculate a Product's Replacement Cost. If a global change is made, for example the exchange rate is changed in Maintain Currency Tables (CC22) or Bulk Changes are made to Landing Factors in PO09, then you should run PO17 afterwards to recalculate the affected Products' Replacement Costs.

The following table outlines the functionality of each button on the Bulk Maintenance window:

Button Label	Icon	Functionality
Start Update		Applies the Bulk Changes according to the criteria selected. Note: The Bulk Change utility can be used to delete Landing Factors. If the 'New Rate' field is set to zero, the following message displays once you click Start Update: "New Rate is zero. Delete all applicable records? Yes/No". Select Yes to have all Landing Factor records that meet the criteria deleted from PO11 and PO13. Select No to cancel the request and close the message window.
New		All fields on the 'Landing Factors, Bulk Maintenance' screen clear and you can begin adding a new Landing Factor for Bulk Change.

^{Bulk Change from Landing Factors (PO09)}