Excel

Favorites

Grid Layout

Help

Inquiry Criteria

• Customer

• Data From

• Date To

• Posted Status

• GL Period

• GL Year 

Journal Details

Opens the Journal Details page for the selected record(s).

Refresh

Void

Opens the Void Transaction page for the selected record. Only Quick Sales and Payment Receipts can be voided or corrected from here. Sales Orders, Price Adjustments, and Returns must be voided from the Transaction History Inquiry.

Checkbox

Avail. Disc. Amt.

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.

Currency

Database Fields AR Transactions: ERPx_MFCurrency.CurrencyID, ERPx_ARTransactionHeader.CurrencySK 

Database Fields for SO Transactions: ERPx_MFCurrency.CurrencyID,  ERPx_SOOrderHeader.CurrencySK 

Customer

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

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

Customer Name

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

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

Discount Date

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. 

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

Doc Date

A date field to show the date of the transaction. For Sales Invoice, Returns, and Price Adjustments this will be the Invoice Date and for Quick Sales this is the Doc Date. 

Database Field AR Transactions: ERPx_ARTransactionHeader.TransactionDate

Database Field for SO Transactions: ERPx_SOOrderHeader.OrderDate

Doc Description

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

Doc No

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

Database Field AR Transactions: ERPx_ARTransactionHeader.DocNumber

Database Fields for SO Transactions: N/A

Due Date

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.

Fully Applied Date

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

Fully Applied Days

A textbox to identify how many days it took to fully settle the transaction. This field is used in the Average Days to pay calculation.

Fully Settled

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.  

GL Date

Database Field AR Transactions: ERPx_ARTransactionHeader.GLDate

Database Fields for SO Transactions: ERPx_SOInvoiceHeader.GLDate

GL Period

GL Year

Orig. Amt.

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

Orig. Terms Disc. Amt.

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.

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

Open Amt.

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. 

Payment Terms

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.PaymentTermSK

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

PO

A non-editable text box to display the 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_SOOrderHeader.PurchaseOrder

Posted Status

Database Fields AR Transactions: ERPx_APTransactionStatus.StatusName, ERPx_ARTransactionHeader.TransactionStatusSK

Database Fields for SO Transactions: ERPx_APTransactionStatus.StatusName, ERPx_SOOrderHeader.OrderStatusSK

Transaction

Database Fields AR Transactions: ERPx_ARTransactionHeader.TransactionID

Database Fields for SO Transactions: ERPx_SOOrderHeader.OrderID

Transaction Type

• Customer Sale

• Invoice

• Payment Receipt

• Price Adjustment

• Return

Database Fields AR Transactions: ERPx_ARTransactionType.TransactionName, ERPx_ARTransactionClass.TransactionTypeSK, ERPx_ARTransactionHeader.TransactionClassSK

Database Fields for SO Transactions: ERPx_ARTransactionType.TransactionName, ERPx_SOOrderHeader.OrderTypeSK