Skip to main content

Hello!

 

I am trying to figure out how the PO Line matching works and my scenario is as follows:

  • Supplier Master - PO Matching is set to PO Line, and the Validation is set to PO Reference and Receipt Reference.
  • The PO has 10 Inventory part lines, and all 10 are received via ‘Receipt’, and ‘Receipt’ is in the ‘Received’ Status.
  • Assume that the first PO Line is for 110 quantities, unit priced at $0.98 = $107.86
  • I receive an Invoice from the Supplier, which has only one Invoice line, accounting for $107.86. 
  • This invoice is loaded into IFS (Apps 10) as an external invoice file, and the file is also processed successfully. However, no matching is conducted at the Posting Proposal. 

I even changed the Supplier’s PO matching level to PO Header and PO Receipt, which simply matches all 10-part lines received, which is not what I expected. I would want only the Invoice line to match against the specific PO Line received.

I kindly request your assistance and guidance in resolving this issue and understanding how PO Line matching can be successfully implemented.

Your valuable insights and advice on this matter are greatly appreciated!

Thank you!

 

Hi,

 

For line level matching you need to have PO reference, line number, Part Number and qty in the invoice line. Try sending that as well in external invoice.

 

Hope this helps.

 

Best Regards,

Shehan Almeida.

Thank you very much, @Shehan Almeida !

Could you please explain a little more about the items below:

  • Should the Part Number be the IFS-registered Part Number?  For instance, in the invoice line description, the part number is AGIHCPL-2212-000E, but if this is registered in IFS as 909053, should the external invoice file have 909053 as the Part number?
  • Should these four pieces of information be mentioned at the Line Level of the external invoice file? Would that be enough since the PO Reference is specified at the header level?
  • We use the XML files after the invoices are analysed by an OCR tool (Pagero, to be exact), so there are certain cases where the Supplier does not particularly mention the PO Line number against which the invoice is being raised. So, we would only have the PO Number, Part Number (assuming the IFS Part Number), and the Quantity. Would this still allow IFS to do the PO line matching correctly?
  • Lastly, it would be greatly helpful if you happen to have any sample invoice XML with the line-level details available.

Thank you! Your valuable insights on these items are greatly appreciated.

 

Hi @WiaPasanD 

Supplier part number and is available in external file template as a field and it can be used for ext supplier invoices..

I believe in this case you can manage automatic matching with PO Ref, Supplier Part Number and QTY.

I'm afraid that I do not have any sample XMLs.

 

Shehan Almeida.

Thank you very much @Shehan Almeida! much appreciated.

Reply


Terms & ConditionsCookie settings