any way to update PO document through DTW without using "Doc Entry"
Just have a question.
I need to use DTW to update existing PO document. I realized that I have to have Doc Entry to be entered in the DTW template.
Is there any way to update PO document through DTW without using that field, "Doc Entry"?
Suda Sampath replied
A similar situation related to Bank files was resolved with one of my clients on the following way...
The file from the Vendor can be an any order or format on the Excel. Till the time it is consistant it should work fine..
We created a Job in SQL Server to read this Excel file and to use the DocNum to get the DocEntry from SAP PO and output another excel file which is exactly the template format for PO Update.
This may even not be required in your case.....
You can get this done through an Excel Macro....which will connect to the database and using the DocNum get the DocEntry and update the Excel....
This is 100% achievable and a better solution for regular use