Versions Compared

Old Version 1

changes.mady.by.user Janice Dannenberg (Unlicensed)

Saved on

compared with

New Version 2

changes.mady.by.user Janice Dannenberg (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
Def - Receivable Payable Documents
Def - Receivable Payable Documents
nopaneltrue
The purpose of this page is to display all outstanding credit debit balance transactions that have not been fully applied. This page will be filtered to display transactions associated with the CustomerVendor(s) selected on the Customer Vendor Balances List View. If no Customers Vendors are selected, then this page will display all outstanding credit debit balance transactions that have not been fully applied. From here, users can select a single transaction and click the 'Apply DocumentsDocument' icon in the header toolbar to manually apply the selected transaction to one or more debit credit balance transactions. 

Software Version: 2021.04.02 09 and newer

Table of Contents
typeflat

...

This field is required and is not editable after the transaction has been posted. Def - Customer ID

Database Fields: ERPx_ARCustomer.CustomerID, ERPx_ARTransactionHeader.CustomerSK (Payment Receipt and negative Customer Sale), ERPx_SOOrderHeader.CustomerSK (Price Adjustment and Return)

 This field is required and is not editable after the transaction has been posted.

Database Fields: ERPx_ARCustomer.CustomerName, ERPx_ARTransactionHeader.CustomerSK (Payment Receipt and negative Customer Sale), ERPx_SOOrderHeader.CustomerSK (Price Adjustment and Return)

Doc Date
Toolbar IconsDescription
Apply DocumentOpens the Apply Documents Payables Document Record View. Users must select a transaction prior clicking this toolbar icon. Only one transaction can be selected at a time. If no transaction is selected, the message "Please select one item and try again." will be displayed.
Excel
Insert excerpt
Excel - LV
Excel - LV
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
Inquiry Criteria

Insert excerpt
Inquiry Criteria - Global
Inquiry Criteria - Global
nopaneltrue

  • Show balances Include transactions through: A textbox that defaults to the current date.
  • Hide fully Settled applied transactions: A Yes/No lookup that defaults to "Yes". If set to "Yes", then fully applied transactions will not be in the returned results. 
Refresh
Insert excerpt
Refresh - Global
Refresh - Global
nopaneltrue
FieldsDescription
CheckboxUsed to select one transaction to apply a document to. Customer
Insert excerpt
Customer ID - TransactionCustomer ID - Transaction
nopaneltrue
Insert excerpt
Def - Customer ID
nopaneltrue
Customer Name
Insert excerpt
Customer Name - TransactionCustomer Name - Transaction
nopaneltrue
Insert excerpt
Def - Customer NameDef - Customer Name
nopaneltrue

Insert excerpt
Doc Date
Doc Date
nopaneltrue
This field is required. It comes from the 'Invoiced' field on the 'Shipments' tab of the Sales Transaction List View for Return and Price Adjustment transactions. It comes from the 'Receipt Payment Date' field on the 'Home' tab header of the Payment Receipt Process Payments Record View for Payment Receipt payment transactions. It comes from the 'Doc Date' field on the 'Home' tab of the Quick Sale Credit Memo Record View for Credit Memo transactions. This field is not editable after the transaction has been posted.

Database Fields:   ERPx_ARTransactionHeaderAPTransactionHeader.TransactionDate (Payment Receipt and negative Customer SaleCredit Memo), ERPx_SOInvoiceHeaderMFTransactionBatch.InvoiceDate (Price Adjustment and ReturnBatchDate (Payment)

Doc No

Insert excerpt
Doc No
Doc No
nopaneltrue
This field is not required. There is no 'Doc No' associated with Return and Price Adjustment transactions. For Payment Receipt transactions, this field comes from the 'Payment #' field on the Payment Receipt the payment grid of the Process Payments Record View. For negative Customer Sale Credit Memo transactions, this field comes from the 'Doc No' field on the 'Home' tab of the Quick Sale Credit Memo Record View. This field is not editable after the transaction has been posted.

Database Field:   ERPx_ARTransactionHeaderAPTransactionHeader.DocNumber (Credit Memo), ERPx_MFTransactionBatch.TransactionID (Payment Receipt and negative Customer Sale)

GL Date

Insert excerpt
GL Date
GL Date
nopaneltrue
This field is required and is not editable after the transaction has been posted. For Payment transactions, this field field comes from the 'Payment Date' field on the header of the Process Payments Record View.

Database Field: ERPx_ARTransactionHeader.GLDate (Payment Receipt and negative Customer SaleCredit Memo), ERPx_SOInvoiceHeaderMFTransactionBatch.GLDate (Price Adjustment and ReturnBatchDate (Payment)

GL Period

Insert excerpt
GL Period
GL Period
nopaneltrue
This field is required and calculated using the 'GL Date' on the 'Properties' tab (Payment Receipt transaction) or 'Shipments' tab (Return and Price Adjustment transaction) property of the associated transaction Record View. This field is not editable.

GL Year

Insert excerpt
GL Year
GL Year
nopaneltrue
    This field is required and calculated using the 'GL Date' on the 'Properties' tab (Payment Receipt transaction) or 'Shipments' tab (Return and Price Adjustment transaction) property of the associated transaction Record View. This field is not editable.

Original Amount

Insert excerpt
Amount - Original
Amount - Original
nopaneltrue
This field is required. For Price Adjustment, Return and negative Customer Sale Payment transactions, this field comes from the is the total extended amount of all line items. For Payment Receipt the 'Amount' field in the payments grid of the Process Payments Record View. For Credit Memo transactions, this field comes from the 'Amount' field on the Payment Receipt the 'Home' tab of the Credit Memo Record View. This field is not editable after the transaction has been posted.

Database Fields:  ERPxERPx_ARTransactionHeaderAPTransactionHeader.ExtendedAmount (Payment Receipt and negative Customer SaleCredit Memo), ERPx_SOInvoiceHeaderMFCheckbookTransaction.ExtendedAmount (Price Adjustment and ReturnAmount (Payment)

Transaction

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
Clicking on this link opens the record view for the selected transaction. This is a system assigned number that comes from the 'Transaction Class' for Credit Memo transactions and the 'Next Check #' or 'Next ACH #' of the associated checkbook for Payment transactions. This field is not editable.

Insert excerpt
Def - Transaction ID
Def - Transaction ID
nopaneltrue

Database FieldsField:  ERPxERPx_ARTransactionHeaderAPTransactionHeader.TransactionID (Payment Receipt and negative Customer SaleCredit Memo), ERPx_SOInvoiceHeaderMFTransactionBatch.InvoiceNumber (Price Adjustment and ReturnTransactionID (Payment)

Transaction Type

Insert excerpt
Transaction Type
Transaction Type
nopaneltrue
This is required and comes from the Transaction Type selected when starting a new transaction. This field is not editable. The following transaction types have the ability to credit debit the Accounts Receivable Account Payable account and display on this page:

  • Invoice
  • Customer SaleCredit Memo
  • Payment Receipt
  • Price Adjustment
  • Return

Database Fields: ERPx_ARTransactionTypeAPTransactionType.TransactionName, ERPx_ARTransactionClassAPTransactionClass.TransactionTypeSK, ERPx_ARTransactionHeaderAPTransactionHeader.TransactionClassSK , ERPx_SOOrderHeader.OrderTypeSK

Unapplied Amount

Insert excerpt
Amount - Unapplied
Amount - Unapplied
nopaneltrue
This is required and updates when amounts are entered in the 'Applied Amount' field on the Apply Documents Payables Document Record View. This is calculated by subtracting previous applications from the 'Original Amount'. This value is not stored in the database.

Vendor

Insert excerpt
Vendor ID
Vendor ID
nopaneltrue
This field is required and is not editable after the transaction has been posted.

Insert excerpt
Def - Vendor ID
Def - Vendor ID
nopaneltrue

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK (Credit Memo), ERPx_MFCheckbookTransaction.EntitySK (Payment)

Vendor Name

Insert excerpt
Vendor Name
Vendor Name
nopaneltrue
 This field is required and is not editable after the transaction has been posted.

Insert excerpt
Def - Vendor Name
Def - Vendor Name
nopaneltrue

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK (Credit Memo), ERPx_MFCheckbookTransaction.EntitySK (Payment)

Related Topics

User Guide: Vendor Balances


Expand
titlePage Definitions

Page Definitions


...