Purchase Transaction Matching

In \Automation\ Pending\, Prelude Desktop will scan for CSV files named
“YYYYMMDDHHMMSSMMM-CC-TTT.CSV” where:
CC – Company Number – the franchisor company two-alphanumeric code
TTT – “PTM” – Purchase Transaction Matching
YYYYMMDDHHMMSSMMM – Date/Time – date/time stamp
CODE – Char(8) – Supplier Account code in Prelude Desktop (validated)
REF – Char(16) – For YSP, Job-FranchiseeNr-OrderNr or “STKnnnn”
MATCH_DATE – Date – Date matching is to be processed (validated)
CODE – will identify the Purchase Ledger account in Prelude Desktop
REF – will identify the invoice and receipt(s) to be matched

Reject the CSV file if any of the following apply:
There is no invoice in PLTRAN with this REF for this Supplier
Move to Quarantine folder with the error message in the log file and email
“Order REF for Supplier CODE has not been invoiced”
If not rejected, process as follows
Update MDATE with MATCH_DATE for all records in PLTRAN with Open # 0.00 with this REF for this Supplier
Move CSV file to Purchase Transaction Matching folder with a success message in the log file