| Toolbar Icons | Description |
|---|
Auto Fill Amounts | This button displays options to: - Fully Pay - Filtered: Updates the 'Amt. to Settle' value for all the records in the grid to [Open Program Amt.] - [Write Off Program Amt.]
- Fully Pay - Selected: Updates the 'Amt. to Settle' value for all the tagged/selected records in the grid to [Open Program Amt.] - [Write Off Program Amt.]
- Write Off - Filtered: Updates the 'Write Off Program Amt.' value for all the records in the grid to [Open Program Amt.] - [Amt. to Settle].
- Write Off - Selected: Updates the 'Write Off Program Amt.' value for all the tagged/selected records in the grid to [Open Program Amt.] - [Amt. to Settle].
 If using this feature to Write Off balances, you must either have a Write Off code saved in the Sales Program 'Reason Code for Write Offs' Preference or you must manually assign the Write Off Code to each transaction by selecting the record, clicking the 'Edit Amounts' icon, and manually assigning the Write Off Code to each transaction item.
|
| Column Filter Show/Hide | | Insert excerpt |
|---|
| Column Filter Show/Hide - Global |
|---|
| Column Filter Show/Hide - Global |
|---|
| nopanel | true |
|---|
|
|
| Edit Amounts | Opens the 'Edit Amounts' List View, filtered for the transaction that was selected, to allow edit of the 'Amt. To Settle' and/or 'Write Off Program Amt.' for the individual Sales Transactions Iines. This can only be opened for one Transaction at a time else the message "Please select one row and try again." will be displayed. |
| Excel | | Insert excerpt |
|---|
| Excel - RV Grid |
|---|
| Excel - RV Grid |
|---|
| nopanel | true |
|---|
|
|
| Group By Show/Hide | | Insert excerpt |
|---|
| Group By Show/Hide - Global |
|---|
| Group By Show/Hide - Global |
|---|
| nopanel | true |
|---|
|
|
| Quick Column Filter | | Insert excerpt |
|---|
| Quick Column Filter |
|---|
| Quick Column Filter |
|---|
| nopanel | true |
|---|
|
|
| Remove Payment | Removes the amounts in both the 'Amt. to Settle' and 'Write Off Program Amt.' columns for all the tagged/selected records. |
| Saved Layouts | | Insert excerpt |
|---|
| Column Layouts for Framework 3.0 - Global |
|---|
| Column Layouts for Framework 3.0 - Global |
|---|
| nopanel | true |
|---|
|
|
| Fields | Description |
| Amt. to Settle | | Insert excerpt |
|---|
| SP - Amount to Settle |
|---|
| SP - Amount to Settle |
|---|
| nopanel | true |
|---|
|
This is a non-editable textbox that defaults to 0.00 and displays the sum of the 'Amt. to Settle' for each transaction item. This can only be edited by selecting a record and clicking the 'Edit Amounts' icon to open the Sales Program: Edit Amounts List View or by clicking the 'Auto Fill Amounts' icon and selecting one of the Fully Pay options. Database Field: ERPx_SPProgramSettlementHeader. |
| Closed Date | | Insert excerpt |
|---|
| Date - Closed SP |
|---|
| Date - Closed SP |
|---|
| nopanel | true |
|---|
|
This is not editable. Database Field: ERPx_SPProgramSettlementHeader.OrderPaidOffDate |
| Customer ID | | Insert excerpt |
|---|
| Customer ID |
|---|
| Customer ID |
|---|
| nopanel | true |
|---|
|
This is not editable. Database Field: ERPx_SPProgramSettlementHeader.CustomerID |
| Customer Name | | Insert excerpt |
|---|
| Customer Name |
|---|
| Customer Name |
|---|
| nopanel | true |
|---|
|
This is not editable. Database Field: ERPx_SPProgramSettlementHeader.CustomerName |
| OK To Pay | A Yes/No value that indicates whether a transaction on a sales program is okay to pay/settle. - Programs with a 'Settle To' of either "AR Credit Memo" or "AP Invoice - All Orders", this is always "Yes".
- Programs with a 'Settle To' of "AP Invoice - Paid In Full Orders" this is set based on whether or not the sales transaction has an open balance. If the sales transaction has been fully paid or written off this will be "Yes", otherwise it will be "No".
This is used for auto-selecting transactions to settle and for informational purposes only. Program transactions can still be settled no matter what this value is. This is a calculated field that is not stored in the database. |
| Open Program Amt. | | Insert excerpt |
|---|
| SP - Open Program Amount |
|---|
| SP - Open Program Amount |
|---|
| nopanel | true |
|---|
|
This is a calculated field that is not stored in the database. |
| Payee ID | Identifies the ID of the Customer or Vendor that will be paid for the Program. This is not editable. Database Field: ERPx_SPProgramHeader.ProgramEntitySK, ERPx_SPProgramSettlementHeader.SettleToEntityID |
| Payee Name | Identifies the Name of the Customer or Vendor that will be paid for the Program. This is not editable. Database Fields: ERPx_APVendor.VendorName, ERPx_ARCustomer.CustomerName, ERPx_SPProgramHeader.ProgramEntitySK, ERPx_SPProgramSettlementHeader.SettleToEntityName |
| PO | | Insert excerpt |
|---|
| Purchase Order |
|---|
| Purchase Order |
|---|
| nopanel | true |
|---|
|
This comes from the 'Purchase Order' field on the 'Home' tab of the Sales Transaction Record View. This is not editable. Database Field: ERPx_SPProgramSettlementHeader.PONumber |
| Program | | Insert excerpt |
|---|
| Program ID & Description |
|---|
| Program ID & Description |
|---|
| nopanel | true |
|---|
|
This is not editableDatabase Fields: ERPx_SPProgramHeader.Description, ERPx_SPProgramSettlementHeader.ProgramHeaderSK |
| Program Amt. | Database Field: ERPx_SPProgramSettlementHeader.ComputedAmount
Remaining Amt. | Settle To | | | Insert excerpt |
|---|
| SP - Program Amount |
|---|
| SP - Program Amount |
|---|
| nopanel | true |
|---|
|
This is not editable.Database Field: ERPx_SPProgramSettlementHeader. | SettlementMethodName | Settled
| Remaining Program Amt. | Database Field| Insert excerpt |
|---|
| SP - Remaining Program Amount |
|---|
| SP - Remaining Program Amount |
|---|
| nopanel | true |
|---|
|
This is a calculated field that can only be edited by changing either the 'Amt. to Settle' or the 'Write Off Program Amt.'This value is not stored in the database. |
| Settle To | Identifies how the Program will be settled (paid). This defaults from the Sales Program and is not editable. The available options include: - AP Invoice - Paid In Full Orders
- AP Invoice - All Orders
- AR Credit Memo: Only available for Rebate and Off Book Programs
Database Field: ERPx_SPProgramSettlementHeader.SettlementMethodName |
| Settled Program Amt. | | Insert excerpt |
|---|
| SP - Settled Program Amount |
|---|
| SP - Settled Program Amount |
|---|
| nopanel | true |
|---|
|
This is only editable by settling and/or writing off a Program Amount.Database Field: ERPx_SPProgramSettlementHeader.SettledAmount |
| Trans Amt. | Identifies the 'Invoice' amount of the Sales transaction. This is not editable. Database Field: ERPx_SPProgramSettlementHeader.TotalOrderAmount |
| Trans Class | | Insert excerpt |
|---|
| Transaction Class |
|---|
| Transaction Class |
|---|
| nopanel | true |
|---|
|
This comes from the 'Transaction Class' value selected by the user when the transaction was created. This is not editable. | Insert excerpt |
|---|
| Def - Transaction Class - General |
|---|
| Def - Transaction Class - General |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_SOOrderHeader.DocumentID |
| Trans Curr. | Identifies the Currency ID that the transaction was entered in. This comes from the Customer and is not editable. Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_SOOrderHeader.CurrencySK |
| Trans Date | | Insert excerpt |
|---|
| Doc Date |
|---|
| Doc Date |
|---|
| nopanel | true |
|---|
|
It is formatted from the users 'Date Format' preference. This comes from the '
Invoiced Date' field on the ' Shipments' tab of the Sales Transaction Record View and is not editable. Database Field: ERPx_SPProgramSettlementHeader.InvoiceDate |
| Tran Trans Open Amt. | Identifies the open/unpaid amount of the sales transaction. This value is updated when is only editable by applying Payment Receipts, Credits, or Returns This is not editableto the transaction. Not sure where this comes from or if it is calculated, how it is calculated. |
| Trans Type | | Insert excerpt |
|---|
| Transaction Type |
|---|
| Transaction Type |
|---|
| nopanel | true |
|---|
|
This is a system assigned value and is not editable. The applicable transaction types are: Order, Return and Price Adjustment. | Insert excerpt |
|---|
| Def - Transaction Types |
|---|
| Def - Transaction Types |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_ARTransactionType.TransactionName, ERPx_SOOrderHeader.OrderTypeSK |
| Transaction | | Insert excerpt |
|---|
| Transaction ID |
|---|
| Transaction ID |
|---|
| nopanel | true |
|---|
|
This is a system assigned value and is not editable.
| Insert excerpt |
|---|
| Def - Transaction ID - Sales |
|---|
| Def - Transaction ID - Sales |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_SPProgramSettlementHeader.InvoiceNumber |
| Write Off Program Amt. | | Insert excerpt |
|---|
| SP - Write Off Program Amount |
|---|
| SP - Write Off Program Amount |
|---|
| nopanel | true |
|---|
|
This is a non-editable textbox that defaults to 0.00 and displays the sum of the 'Write Off Program Amt.' for each transaction item. This can only be edited by selecting a record and clicking the 'Edit Amounts' icon to open the Sales Program: Edit Amounts List View or by clicking the 'Auto Fill Amounts' icon and selecting one of the Write Off options. Database Field: ERPx_SPProgramSettlementHeader.WriteOffAmount |