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 use a bind parameter in Supplier address DFF?

in Supplier Management 1 comment

Summary:

We have a requirement to populate a DFF at Supplier address level with consecutive numbers increasing by 1 everytime a new address is created. For eg for Supplier A, if it has 10 addresses, the DFF value will be 1 to 10. If Supplier B has 5 addresses, it will be 1 to 5. Next address for Supplier A will have value 11 and Supplier B will be 6. However for that in query we will need to compare the data for each of the supplier.


However I am unable to use a bind parameter for Supplier in that case. Here's the query I am trying to build:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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