Skip to main content
Question

External Supplier Invoice Template STDSIN2

  • September 7, 2026
  • 2 replies
  • 26 views

Forum|alt.badge.img

I am using the STDSIN2 external file template to load PO invoices, where the PO matching parameter is based on the Receipt Reference.

My requirement is to load multiple PO lines with multiple receipt references under a single invoice. However, when I upload an invoice containing two different receipt references, the system considers only one receipt reference and ignores the other.

Could you please advise whether there is a way to load multiple PO receipts against the same invoice number so that each invoice line can be matched to its respective PO receipt?

Please find the example below for reference.

At the line level, all four lines have been loaded successfully. However, in the Supplier Invoice Posting Information, only one receipt reference number is populated because the system considers only a single receipt reference from the invoice header.

 

 

2 replies

Forum|alt.badge.img+20
  • Superhero (Employee)
  • September 8, 2026

Hi, 

From a quick review, the SIN2 template does not include all available attributes, and even more important, it has far more attributes than needed for most clients. 

For that reason, many people copy that template and fine tune it based on needs. 

One such attribute that is not included in the template is the receipt reference (RECEIPT_REF). Try including that column in a copy of the SIN2 type template.   

I have not tested receipt reference in many years so I can’t say 100% this will work.  You can test.  The other attribute that may / may not be needed is the multiple records allowed (or similar).   I know multiple records is required in certain situations (maybe limited to customer invoice processing), but it may be needed for multiple receipt reference. (probably not but maybe). 

 

Also, when dealing with that SIN2 or similar templated, it’s always recommended to include a header record to show the attributes, and then a skip record function in external template control so IFS does not read the header as valid data.  Just makes testing 1000% easier.    

Best regards, 

Thomas


Forum|alt.badge.img
  • Author
  • Do Gooder (Partner)
  • September 9, 2026

Thank you very much, Thomas. I have added the 'Receipt_Ref' column to the template. However, the challenge I am facing is that when I load two different receipt reference numbers for the same invoice number, the PO lines are matched only against the first receipt reference. As a result, the invoice ends up in an Unbalanced status. Please find the template along with header information.