PO Line Items invoiced amount

(0) Share

Report

Posted on by Hossam EL Hassan

469

Hi,

Which data entity contains the PO line item invoiced amount?

I have noticed that PurchPurchaseOrderLineV2Entity has the field PURCHASEORDERLINESTATUS = 1 as long as the PO Line item is not fully invoiced.

The table PurchLine has a field REMAINPURCHPHYSICAL which contains that PO Line Item invoiced quantity, so I guess I can multiply (PurchQuantity - REMAINPURCHPHYSICAL) * PurchAmount.

The issue is that the field REMAINPURCHPHYSICAL doesn't exist in the PurchPurchaseOrderLineV2Entity. Also there could be chances were the user just updates the invoice amount and not the quantity.

What is the best practice to acheive this.

Thanks.

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

WillWU 22,361 on at

Like (0)

Report

Hi partner,

Can the Vendor invoice journal line data entity reach your requirement?

Was this reply helpful? Yes No
Hossam EL Hassan 469 on at

Like (0)

Report

Hi,

I can see the purchase order number or po line item in this data entity.

Was this reply helpful? Yes No