Confirming selected Purchase Orders for FTR upload file

[Former Member]

Hi,

Scenario is we will send every day Purchase Order Due for confirmation  using download profile to supplier.Assume there are 20 Purchase orders which needs to be confirmed.But as of now supplier can confirm only 10 Purchase orders.Is there any way from the same excel supplier can confirm  selected Purchase orders.

Thanks and Regards

Raghavendra Pai

[former_member1013 · Accepted solution]

Hi Raghavendra,

One of the possible solution is -

If you don't want to send all the PO's to Supplier which are due for confirmation you can filter it on the Delivery date in "Specify Selection Criteria" and send only those.

Hope this reply will help you.

Thanks,

Sanjay Patil

[Former Member · Accepted solution]

Hi Sanjay,

We want to send all PO which are due for confirmation.It is upto supplier to decide whether he wants to confirm all or selcted Purchase Orders.

One way just delete the Purchase orders from the excel which they do not want to confirm.

Regards

Raghavendra Pai

[former_member1013 · Accepted solution]

Hi Raghavendra,

I don't know if you are using the standard setting only for upload/download center.

In one of the way you can achieve your requirement by cutomizing, use following steps.

1. Get the “Z” status in PO Item line, that has to show if PO item is confirmed or not. E.g. if PO item is not confirmed the status will be New PO and if the PO is confirmed then that status will be Confirmed.
2. Get this Status in the downloaded file also, so that supplier easily knows the PO item is confirmed or not please see the attached screen shot.
3. One more field you have to add to the downloaded Excel as “Status”.
4. Make modification in code so that the Status column will fetch the PO Item data from your new Z status i.e. PO is conf or not.
5. Make the code modifications in such a way that the column TO_BE_CONF should come as blank, Column Requested come as cross marked for PO line where supplier has to conf and Column “Status” will show the actual status of the PO line as New PO or Confirmed etc.
6. Make modification in code such that if supplier entered “Y” in TO_BE_CONF column then only system has to conf the PO line and if kept blank then system has to ignore this PO line has go for next entry.
7. In this way supplier can go for confirmation for selected PO line items.

Please check the attached screen shot.

Check if this works.

Thanks,

Sanjay Patil