Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to update BPA line interface Agreement Quantity column to Blank(NULL) using FBDI?

edited Jul 25, 2024 12:44PM in Purchasing 1 comment

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!