Missing master data in Infor M3 Supplier Rebate


Agreement validation compares the masterdata of PO details (e.g., item, supplier) against the agreement criteria, which are often fields from the masterdata table. If the necessary masterdata is not replicated in Infor M3 Supplier Rebate database, there will be no basis for this comparison and the expected accrual will not be created.

If the PO number is known, query the record in Purchase Order Line Query. This form shows you the details of the purchase order, including the supplier and item.

  1. Open the Item Master Query.
  2. Specify the item number from the PO in the Item Number field under Primary Criteria.
  3. Click Apply.
    This action shows the details of the item.
  4. If the accruing agreement number is known, verify that the PO details matches the agreement criteria.
  5. Optionally, If no record is retrieved in Item Master Query, check the masterdata in M3BE.
    The field 'User-defined field 3 - item' (CFI3) in 'Item. Open' (MMS001/G) is used for tagging an item as rebatable or not. Non-rebatable items are filtered out in ION.
  6. To make a PO line rebatable, change the rebatable flag of the item and republish the PurchaseOrder BOD.