InvoiceMatchingReceiptQuantityTransactions
Retrieves matching quantities for accounts payable invoice lines based on specified transaction IDs, aiding in reconciliation and validation.
Columns
| Name | Type | Description |
| TransactionId [KEY] | Long | The unique identifier for the invoice matching receipt quantity transaction. This identifier is used to track purchase order (PO) quantities and invoice-related transactions within the procurement process. |
| TransactionType | String | The type of transaction being recorded, such as a receipt, return, or correction. This field categorizes inventory movements related to invoicing and procurement. |
| QuantityAvailableToInvoice | Decimal | The quantity of received items that are available for invoicing. This field ensures that only eligible quantities are matched to invoices, preventing discrepancies. |
| OrderedPOQuantity | Decimal | The total quantity of items ordered in the purchase order. This field helps in tracking procurement commitments and comparing with received quantities. |
| CancelledPOQuantity | Decimal | The total quantity of items in the purchase order that was canceled before receipt. This field ensures accurate reporting of procurement changes. |
| ReceivedPOQuantity | Decimal | The total quantity of items received against the purchase order. This field tracks goods that have physically arrived at the receiving location. |
| CorrectedPOQuantity | Decimal | The total quantity of items in the purchase order that has been adjusted due to corrections, such as updates to receipt errors or quality issues. |
| DeliveredPOQuantity | Decimal | The total quantity of items delivered to the designated location from the purchase order receipts. This field ensures accurate inventory updates. |
| RTVPOQuantity | Decimal | The total quantity of items returned to the vendor (RTV) from the purchase order receipts. This field tracks rejected or defective goods sent back to the supplier. |
| BilledPOQuantity | Decimal | The total quantity of items that have been invoiced from the purchase order receipts. This ensures accurate invoice-to-receipt matching. |
| AcceptedPOQuantity | Decimal | The total quantity of items that have been inspected and accepted from the purchase order receipts. This field is used to validate invoices against received goods. |
| RejectedPOQuantity | Decimal | The total quantity of items that have been inspected and rejected from the purchase order receipts. This field ensures that invoices are not processed for defective or non-compliant goods. |
| OrderedTransactionQuantity | Decimal | The total quantity of items ordered in the transaction. This field tracks procurement quantities at the transaction level. |
| CancelledTransactionQuantity | Decimal | The total quantity of items in the transaction that was canceled before processing. This field ensures accurate reporting of procurement changes. |
| ReceivedTransactionQuantity | Decimal | The total quantity of items received in the transaction. This field is used to track the actual receipt of goods. |
| CorrectedTransactionQuantity | Decimal | The total quantity of items in the transaction that has been adjusted due to corrections. This field ensures that receipt errors are properly accounted for. |
| DeliveredTransactionQuantity | Decimal | The total quantity of items delivered to the designated location in the transaction. This field ensures accurate inventory tracking. |
| RTVTransactionQuantity | Decimal | The total quantity of items returned to the vendor (RTV) in the transaction. This field tracks rejected or defective goods sent back to the supplier. |
| BilledTransactionQuantity | Decimal | The total quantity of items that have been invoiced in the transaction. This field ensures that invoices are correctly matched to received quantities. |
| AcceptedTransactionQuantity | Decimal | The total quantity of items that have been accepted in the transaction. This field ensures accurate reporting of received goods that meet quality standards. |
| RejectedTransactionQuantity | Decimal | The total quantity of items that have been rejected in the transaction. This field ensures that incorrect or defective goods are excluded from invoicing. |
| TransactionUOMCode | String | The unit of measure (UOM) code used for the transaction quantities. This ensures standardization in quantity tracking across procurement and invoicing. |
| IsPricedInSecondaryFlag | Bool | Indicates whether the transaction is priced in a secondary UOM. Possible values include 'true' (priced in secondary UOM) or 'false' (not priced in secondary UOM). This flag ensures accurate cost calculations. |
| Finder | String | A reference attribute used for searching and retrieving specific invoice matching receipt quantity transaction records. This attribute enhances system usability by allowing users to locate records efficiently. |