Check Item Data by Warehouse (whwmd2210m000)

Use this session to check if the item data by warehouse must be cleared.

This session helps you to check if:

  • The business partners for line supply are still valid and the supply type is Supplier. These business partners are, for each warehouse/item combination, specified in the Item Data by Warehouse (whwmd2110s000) session.
  • The inventory of an item/warehouse combination is zero and planned inventory transactions are available for an item/warehouse combination

LN only checks item data by warehouses with item/warehouse status Active.

If the Check Validness of Business Partners check box is selected, LN carries out the following checks:

  1. The buy-from business partner must exist in the Buy-from Business Partners (tccom4520m000) session.
  2. The business-partner status of the buy-from business partner must be Active. You can change the buy-from business partner's status in the Buy-from Business Partner (tccom4120s000) session.
  3. The ship-from business partner must exist in the Ship-from Business Partners (tccom4521m000) session.
  4. The business-partner status of the ship-from business partner must be active. You can change the ship-from business partner's status in the Ship-from Business Partner (tccom4121s000) session.
  5. The buy-from business partner and the ship-from busines partner must be related. LN checks if the following relations exist:
  6. A business partner has the business-partner roles buy-from business partner and ship-from business partner.
  7. The ship-from business partner and the buy-from business partner have the same parent business partner.
  8. The buy-from business partner is the parent of the ship-from business partner. The business partner can deal with electronic data interchange (EDI) 866 messages. You can specify if a ship-from business partner can deal with EDI messages in the Communication Channel field of the Items - Purchase Business Partner (tdipu0110m000) session.

You can specify parent business partners in the Business Partner (tccom4100s000) session.

If a business partner does not exist any longer or is not active or if the business partners are not related, LN prints a list of alternative business partners on the report. The alternative business partners are determined based on data in the Items - Purchase Business Partner (tdipu0110m000) session. LN first searches on item level for an alternative business partner. If no alternative business partner can be found on item level, LN secondly searches on item group level. If again no alternative business partner can be found, no alternative business partner is printed on the report. LN searches on both the item level and the item-group level as follows:

  1. Is a business partner the Single Source for the item or item group? If yes, see 2. If no, see 3.
  2. Is the Single Source business partner for the item or item group approved and effective? If yes, this business partner is printed on the report as alternative business partner. If no, see 3.
  3. Are business partners Preferred for the item or item group? If yes, see 4. If no, no alternative business partner is printed on the report.
  4. Are there any Preferred business partners for the item or item group approved and effective? If yes, see 5. If no, no alternative business partner is printed on the report.
  5. LN sorts the found alternative business partners for the item or item group based on the assigned priorities and prints the alternative business partners on the report.

LN checks, for each item warehouse combination, if the Check Inventory check box is selected, and:

  • The inventory on hand, the allocated inventory, the inventory on order and the historical inventory balance are zero. You can view these values in the Warehouse - Item Inventory (whwmd2115s000) session. If all these values are zero and the Remove Data with Zero Inventory check box is selected, the item data by warehouse is deleted. If the Remove Data with Zero Inventory check box is cleared, the item/warehouse combination is printed on the report.
  • Planned inventory transactions are present in the specified time fence. You can specify the time fence in the Up to Date field. If no planned inventory transactions are present for an item/warehouse combination, this combination is printed on the report. You can view the planned inventory transactions in the Planned Inventory Transactions (whinp1500m000) session.

Field Information

Check Validness of Business Partners

If this check box is selected, LN performs the following checks:

  1. The buy-from business partner must exist in the Buy-from Business Partners (tccom4520m000) session.
  2. The business-partner status of the buy-from business partner must be Active. You can change the buy-from business partner's status in the Buy-from Business Partner (tccom4120s000) session.
  3. The ship-from business partner must exist in the Ship-from Business Partners (tccom4521m000) session.
  4. The business-partner status of the ship-from business partner must be active. You can change the ship-from business partner's status in the Ship-from Business Partner (tccom4121s000) session.
  5. The buy-from business partner and the ship-from business partner must be related. LN checks if the following relations exist:
  6. A business partner has the business-partner roles buy-from business partner and ship-from business partner.
  7. The ship-from business partner and the buy-from business partner have the same parent business partner.
  8. The buy-from business partner is the parent of the ship-from business partner. The business partner can deal with electronic data interchange (EDI) 866 messages. You can specify if a ship-from business partner can deal with EDI messages in the Communication Channel field of the Items - Purchase Business Partner (tdipu0110m000) session.

You can specify parent business partners in the Business Partner (tccom4100s000) session.

If a business partner does not exist any longer or is not active or if the business partners are not related, LN prints a list of alternative business partners on the report. This alternative business partners are determined, based on data in the Items - Purchase Business Partner (tdipu0110m000) session. LN first searches on item level for an alternative business partner. If no alternative business partner can be found on item level, LN secondly searches on item group level. If again no alternative business partner can be found, no alternative business partner is printed on the report. LN searches on both the item level and the item-group level as follows:

  1. Is a business partner the Single Source for the item or item group? If yes, see 2. If no, see 3.
  2. Is the Single Source business partner for the item or item group approved and effective? If yes, this business partner is printed on the report as alternative business partner. If no, see 3.
  3. Are business partners Preferred for the item or item group? If yes, see 4. If no, no alternative business partner is printed on the report.
  4. Are there any Preferred business partners for the item or item group approved and effective? If yes, see 5. If no, no alternative business partner is printed on the report.
  5. LN sorts the found alternative business partners for the item or item group based on the assigned priorities and prints the alternative business partners on the report.

Check Inventory

If this check box is selected, LN checks, for each item/warehouse combination, if:

  • The inventory on hand, the allocated inventory, the inventory on order and the historical inventory balance are zero. You can view these values in the Warehouse - Item Inventory (whwmd2115s000) session. If all these values are zero and the Remove Data with Zero Inventory check box is selected, the item data by warehouse is deleted. If the Remove Data with Zero Inventory check box is cleared, the item/warehouse combination is printed on the report.
  • Planned inventory transactions are present in the specified time fence. You can specify the time fence in the Up to Date field. If no planned inventory transactions are present for an item/warehouse combination, this combination is printed on the report. You can view the planned inventory transactions in the Planned Inventory Transactions (whinp1500m000) session.
Up to Date

The date upto which LN checks if planned inventory transactions are available for each item/warehouse combination. If no planned inventory transactions are available, the item/warehouse combination is printed on the report.

Remove Data with Zero Inventory

If this check box is selected, and the inventory on hand, the allocated inventory, the inventory on order, and the historical inventory balance of an item/warehouse combination are zero, the item data by warehouse combination is deleted.

You can view these values in the Warehouse - Item Inventory (whwmd2115s000) session.

If this check box is cleared, and the inventory on hand, the allocated inventory, the inventory on order, and the historical inventory balance of an item/warehouse combination are zero, the item/warehouse combination is printed on the report.

You can view these values in the Warehouse - Item Inventory (whwmd2115s000) session.