Basic Item Information Setup by Depot

The system stores the depot-specific information in the Item Branch File table (F4102).

The system retrieves item information in this order:

  1. Item Branch File table.

  2. If no information exists, it retrieves item information from Item Master table (F4101).

  3. If no information exists, the system displays an error message.

When processing transactions, the system retrieves item information specific to a depot from the Item Branch File table. If none is found, the system retrieves item information from the Item Master table.

To delete an item from Item Branch/Plant Information, verify:

  • All associated balances for the item must be zero.

  • All on-hand balances, backordered quantities, and any commitments must be transferred or satisfied.

  • The Average Cost Work File table (F41051) must not contain any transactions for the item and branch.

If the requirements have been met, the system deletes the records from these tables:

  • Item Cost File (F4105) if the cost level is 2 or 3.

  • Item Location File (F41021).