Content Comparison

A non-editable text box to display the calculated discount amount that the sales transaction is still eligible for. This is calculated for all sales invoices that were posted with a Payment Term that contained a discount (e.g., 2%10 Net 30). If the 'Trans. Date' of the document being applied falls within the discount days of the sales invoice date then an amount will be shown, otherwise it will be 0.00. This value in this field is informational only, a user is still able to override the actual 'Discount Amount'.

This is a calculated amount and not linked to a Database Field.

Database Fields AR Transactions: ERPx_ARCustomer.CustomerName, ERPx_ARTransactionHeader.CustomerSK

Database Fields for SO Transactions: ERPx_ARCustomer.CustomerName, ERPx_SOOrderHeader.CustomerSK

A date field to display the last day the Payment Terms discount is applicable. This is displayed for all Sales transactions that were posted with a Payment Term that contains a discount (e.g., 2%10 Net 30) and is calculated by adding the number of discount days to the invoice date for sales Invoices and to the Doc Date for Quick Sales. This field will be blank for all Sales Invoices, Price Adjustments, Returns, and Quick Sales that were posted with a Payment Terms that did not include a discount. 

A non-editable text box to display the header comment/description of a Quick Sale or Payment Receipt transaction. This will always be blank for Sales Invoices, Returns, and Price Adjustment transactions. 

Database Field for AR Transactions:

ERPx_ARTransactionHeader.

Description

Database

Fields for SO

Transactions: N/A

A date field to display the date the payment is due. This is displayed for all transactions in the grid and is calculated by adding the number of due days to the invoice date for sales Invoices and to the Doc Date for Quick Sales. 

This is a calculated field based on the payment terms assigned to the order and not linked to a Database Field.

A textbox to identify the date that the transaction was fully settled. This will only display a date if the 'Fully Settled' field = "Yes". 

A textbox to identify if the transaction has been fully settled. If "Yes", the transaction has been fully settled. If blank, there is still a remaining balance on the transaction.

This is a calculated amount and not linked to a Database Field.  

A non-editable text box to display the sales transaction amount. 

Database Fields AR Transactions: ERPx_ARTransactionHeader.ExtendedAmount

Database Fields for SO Transactions: ERPx_SOOrderHeader.ExtendedAmount

A non-editable text box to display the discount amount the transaction was eligible for when it was posted. This is calculated for all Sales transactions posted with a Payment Term that contained a discount (e.g., 2%10 Net 30). If the transaction contained a Payment Term with a discount, an amount will be shown, otherwise it will be 0.00. This is calculated by multiplying the Payment Terms Discount Amount by the Invoice Amount. This will be blank for Payment Receipts.Payment Receipts.

This is a calculated amount and not linked to a Database Field.  

A non-editable text box to display the open amount of the transaction. This is calculated by subtracting all previous Applied Amounts, Discount Amounts, and Write Off Amounts from the transactions 'Orig. Amount'. 

This is a calculated amount and not linked to a Database Field.  

A non-editable text box to display the open amount of Payment Term ID of the Payment Term the transaction . This is calculated by subtracting all previous Applied Amounts, Discount Amounts, and Write Off Amounts from the transactions 'Orig. Amount'. 

This is a calculated amount and not linked to a Database Field. 

A nonwas posted with. This defaults from the Customer but can be changed on the transaction prior to posting.

Database Fields AR Transactions: ERPx_MFPaymentTerms.PaymentTermName, ERPx_ARTransactionHeader.PaymentTermSK

Database Fields for SO Transactions: ERPx_MFPaymentTerms.PaymentTermName, ERPx_SOOrderHeader.PaymentTermSK

A non-editable text box to display the Payment Term ID of the Payment Term the transaction was posted with. This defaults from the Customer but can be changed on the transaction prior to posting.Database Fields AR Transactions: ERPx_MFPaymentTerms.PaymentTermName, ERPx_ARTransactionHeader.PaymentTermSKthe the Purchase Order number (PO number) of a Sales Invoice, Return, and Price Adjustment transaction. This will always be blank for Quick Sales and Payment Receipt transactions.

Database Field AR Transactions: N/A

Database Fields for SO Transactions: ERPx_MFPaymentTerms.PaymentTermName,Transactions: ERPx_SOOrderHeader.PaymentTermSKPurchaseOrder