This content has been marked as final. Show 4 replies
Based on my previous experience in this scenario, it will create single PR, as Vendor grouping goes by Vendor name only and does not look into the sites.
Is there any way by which separate requisitions can be created based on Supplier Site?
There is no standard way of doing this.
In our project, we grouped lines in the REQ INTERFACE using the BATCH_ID column by populating this field with a sequence value through a custom script and then calling the "Requisition Import" program populating the "Import Batch ID" parameter with the corresponding value and "Group By" as "All".
So all the lines for a supplier-site combination will have same batch_id and we need to run Req Import as many times as the number of supplier-sites combination.
This seems complex but we wrote a nice script using Do..While and all which did the job for us with ease.
A quick way would be to write a before-insert db trigger on the req interface table.
In the trigger, populate group_code = vendor_site_id
That will group all reqs by the vendor site.
Hope this helps,