How to update BPA line interface Agreement Quantity column to Blank(NULL) using FBDI?
Summary:
We are implementing the 22B Feature: PREVENT PURCHASE ORDER RELEASES WHEN AMOUNTS OR QUANTITIES EXCEED THE LIMITS ON THE REFERENCED BLANKET AGREEMENT LINE. Our business has decided that they do not want to restrict the Agreement Quantity at the line level. We have over 300 BPAs which have lines where the Agreement Quantity is 0. We need to clean up these agreement lines prior to turning on the 22B feature to prevent self-service procurement users from having incomplete purchase orders.
Content (please ensure you mask any confidential information):
We are using the 24B_POImportBlanketPurchaseAgreementTemplate.xslm
When we update the Agreement Quantity column on the PO_LINES_INTERFACE tab of the template from 0 to another positive number greater than 0, the file successfully loads and updates the Agreement Quantity as expected.