APO / S2P: Purchase Order Line amount_paid is not populated after invoice is set to Paid

[勇介野]

Hello,

I am investigating an APO / S2P issue where the invoice status becomes Paid, but the paid amount is still not populated on the Purchase Order and Purchase Order Line records.

From the documentation, my understanding is that payment details are normally ingested through the invoice payment detail inbound staging table and stored in sn_shop_invoice_payment_detail, and that payment details are used during the Pay Invoice stage / Review payments flow. 

My questions are:

1. What is the OOTB source of the paid amount field?

2. Does the UI read directly from sn_shop_invoice_payment_detail.amount_paid, or from another aggregate/calculated field?

3. If I manually set an invoice to Paid for testing, is that not enough unless payment detail records are created through the standard mechanism? 

4. Has anyone faced this issue in an environment without ERP integration?

Any advice would be appreciated.

Thank you.

[Tanushree Maiti]

Hi @勇介野 

• ServiceNow natively expects an external ERP (like SAP or Oracle) to make the actual payment, update the invoice to "Paid," and send that payload back to ServiceNow.

   Check your logs to see if the payment payload failed to update the Purchase Order (PO) and Purchase Order Line (POL) tables. Refer: How do I reflect payment information on the invoice and invoice line? 

•   Ensure your AP Specialists have properly mapped the Invoice Lines to the PO Lines. If the invoice is marked as Paid but the mapping is missing or broken, the paid amount cannot aggregate backward to the PO Line . Refer : The Full Invoice Processing Lifecycle in ServiceNow — Explained and Demoed