/
Apply Documents Record View

Apply Documents Record View

The purpose of the Apply Documents record view is to apply open Receipts, Returns, and negative Invoices to open sales transactions. The page header shows information pertaining to the Receipts, Returns, or negative Invoice and the page detail shows all the open sales transactions for the receipt customer, that are in the same currency as the Receipts, Returns, or negative Invoice, and that have an 'Open Amount' greater than 0.00. From here, users can apply the receipt to one or more open transactions, enter a Discount Taken, or record a Write Off Amt. When the application is saved, the Customer Balances and Customer Aging are updated. Applications that have an amount in either the 'Discount Amount'  or 'Write Off Amount' will generate a journal entry. Applications where the Receipt is not in the 'Home Currency' have the potential to make a currency gain / loss journal entry.

Software Version: 2020.01.13 and newer

Page Header

Toolbar Icons

Description
Grid Layout

Opens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).

(lightbulb) The bolded view is the default view, which will determine the view will automatically display in when opened. 

Journal Details

Opens the Journal Details window showing the Journal Entry for this transaction. 

(lightbulb) Until the transaction Approved or Posted, this is a temporary journal entry so no Journal ID will be assigned. 

The Journal Details Window for this transaction will include:

  • The Cash Receipt Journal Entry (in both the Receipt Currency Amounts and Home Currency Amounts)
    • Debit to the Checkbooks Cash Account 
    • Credit to the Customer A/R Account 
  • All the associated application Journal Entries - even though they may have happened on different dates
  • All the associated Currency Gain/Loss Journal Entries - even though they may have happened on different dates
Save & Close / Save

Either saves your changes and closes the page or saves your changes and leaves you on the page.

(lightbulb) The Save button is only activated when a change is detected on the page. When the Save button is active, a ‘ + ‘ character is displayed in the page border. Saving reloads the page.

On save, any potential journal entries are created.

FieldsDescription
Applied Amt.A non-editable text box to identify how much of the receipt, sales return, negative price adjustment, negative sales invoice, or negative quick sale has been applied. This defaults to 0.00 but will re-calculate as the receipt is applied. Receipts can be posted without applying, but if they have been applied, this amount will be >0.00. This is a calculated field. This field is not linked to a Database Field. 
Customer

A non-editable text box to identify the Customer associated with the receipt, return, negative price adjustment, negative sales invoice, or negative quick sale, displayed as Customer Name (Customer ID). This is a looked-up value.

Linked Database Field for Receipts: ERPx_ARTransactionHeader.CustomerSK

Linked Database Field for SO Transactions: ERPx_SOOrderHeader.CustomerSK

Linked Database Field for AR Transactions: ERPx_ARTransactionHeader.CustomerSK

Orig. Amt.

A non-editable text box to identify the amount of the receipt, sales return, negative price adjustment, negative sales invoice, or negative quick sale. If the transaction was not in the 'Home Currency', then the currency ID of the source transaction will also be shown as a label. This amount does not change and is only used for information. This is a looked-up value that is not editable on this page.

Linked Database Field for Receipts: ERPx_ARTransactionHeader.ExtendedAmount

Linked Database Field for SO Transactions: ERPx_SOOrderHeader.ExtendedAmount

Linked Database Field for AR Transactions: ERPx_ARTransactionHeader.ExtendedAmount

Payment #

A non-editable text box to identify the Check# / Payment# of the payment you received. If the document being applied is a sales return, negative price adjustment, or negative sales invoice then this will be blank. This is a looked-up value that is not editable on this page.

Linked Database Field: ERPx_ARTransactionHeader.DocNumber

Receipt Type

A non-editable text box to identify the type of the Receipt.  If the document being applied is a sales return, negative price adjustment, negative sales invoice, or negative quick sale then this will be blank. This is a looked-up value that is not editable on this page.

Linked Database Field: ERPx_ARTransactionHeader.CashReceiptTypeEN

Transaction

A non-editable text box to identify the Transaction ID that is the source for the applications. If applying from a 'Payment Receipt' it will be the Transaction ID of the receipt and if applying from a sales return, negative price adjustment, negative sales invoice, or negative quick sale it will be the Transaction ID of the source document. This is a looked-up value. 

Linked Database Field for Receipts: ERPx_ARTransactionHeader.TransactionID

Linked Database Field for SO Transactions: ERPx_SOOrderHeader.OrderID

Linked Database Field for AR Transactions: ERPx_ARTransactionHeader.TransactionID

Trans. Date

A date field to show the date of the source transaction. This is a looked-up value that is not editable on this page.

Linked Database Field for Receipts: ERPx_ARTransactionHeader.TransactionDate

Linked Database Field for SO Transactions: ERPx_SOOrderHeader.OrderDate

Linked Database Field for AR Transactions: ERPx_ARTransactionHeader.TransactionDate

Unapplied Amt.A non-editable text box to identify how much of the receipt, sales return, negative price adjustment, negative sales invoice, or negative quick sale still needs to be applied. This defaults from 'Amount' entered but will re-calculate as the transaction is applied. Receipts can be posted without applying, but if they have been applied, this amount will be >0.00 and < 'Amount'. This is a calculated field. This field is not linked to a Database Field. 

Page Detail

Open Transactions Grid

The purpose of the Open Transactions grid is to show all the sales transactions that have not been applied to the current receipt, as well as all the other sales transactions with an open balance. The sales transactions included are sales invoices, price adjustments with a positive extended amount, and quick sale transactions with a positive extended amount that belong to the receipt customer, the receipt currency, and that are posted. The fields sorted at the bottom of this section, prefixed with "MC:" are only visible on multi-currency transactions.

Toolbar Icons

Description
Excel