PO related invoice file upload
We have a situation where we send the purchase orders to the suppliers, as a PDF output and we get the invoices in a CSV file.
The issue we are facing at the moment is when we get the file the suppliers dont specify which PO lines the particular invoice lines is related to.
Therefore its creating problems and putting the invoice lines on hold.
Please let me know what the best practice is in these type of situations (the details we get from the suppliers) . Upto what level of details should we request from the suppliers ? It will definitely work if we request the suppliers to send the PO line number against the invoice. However is it practical ?