We need to run a daily health check to see if we have sent any duplicate POs to DMEDI for teh vendor CUTBUK.
If we have sent any duplicate POs, we need to notify David Gray with the PO numbers and have them coordinate with the vendor to not ship the PO twice.
Below are the steps:
Run the following query for CUTBUK:
select top 100 * from Attunity_RPro_Web.dbo.po where VEND_CODE='CUTBUK' order by CREATED_DATE desc
From the list, take the PO numbers that were created on the previous day
Remote in to server - 10.34.85.102
Navigate to this path - D:\Apps\RetailPro9\Scripts\SPS850Script\Sent_Files
Copy all files locally that were created on the previous day
Open notepad ++ and do a Find in files
Search for all the PO numbers noted in earlier step
Search each PO number in the copied files and see if there is any PO which appears in multiple files.
If there is any, make a note of such PO number and share with David for coordiantion with the vendor.