Sales program amounts are calculated for each sales line item. When an amount to settle and/or a write off is needed, for a specific sales invoice, the edits must be made to the individual line-item(s). The purpose of this page is to edit the amount to settle or write off amount(s) for individual sales line-items.
Software Version: 2022.06.16 and newer
Page Header
| Toolbar Icons | Description |
|---|---|
| Column Filter Show/Hide |  Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column. |
| Group By Show/Hide |  Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. |
| Help | Opens the online WIKI help page for the current page.
|
| Quick Column Filter |  Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text. |
Save |  Saves the changes made to the record. |
| Save & Close |  Saves your changes and closes the page. |
| Saved Layouts |  Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected. Please note that existing saved grid layouts will display the Filter Row as hidden by default. |
| Fields | Description |
| Amt. to Settle | Error rendering macro 'excerpt-include' : No link could be created for 'Amount to Settle'. This is an editable textbox that defaults to 0.00 and is not required. If entered it must be >= 0.00 and <= 'Item Program Remaining Amt.'.Database Field: ERPx_SPProgramSettlementBatchPayment.AmountToPay |
| Item | Identifies the Item, displayed as Item ID: Item Description. This is not editable. Database Field: ERPx_SPProgramSettlementItem.ItemID: ERPx_SPProgramSettlementItem.ItemDescription |
| Item Program Amt. | Database Field: ERPx_SPProgramSettlementItem.OrderItemAmount Database Field: ERPx_SPProgramSettlementItem.ComputedAmount |
| Item Program Calc. On | |
| Item Program Rate | |
| Item Program Remaining Amt. | |
| Item Program Qty | Database Field: ERPx_SPProgramSettlementItem.ConvOrderUnits |
| Item Program UOM | Database Field: ERPx_IMUOM.UOMID , ERPx_SPProgramSettlementItem.ProgramCalcUOMSK |
| Open Item Program Amt. | Error rendering macro 'excerpt-include' : No link could be created for 'Open Item Program Amount'. |
| Payee Name | Identifies the Name of the Customer or Vendor that will be paid for the Program. Database Field: ERPx_SPProgramSettlementHeader.SettleToEntityName |
| Write Off GL Acct. | Identifies the account number and description of the GL Account used for a Brokerage or Rebate Program write off. This is a single select lookup that is required for every line item where the 'Write Off Program Amt.' <> 0. This defaults from the Sales Program but can be overwritten. The lookup contains a blank value, the current assigned value, and list of all 'Active GL Accounts' displayed as [GL Account] - [Account Description]. Database Field: ERPx_GLAccount.AccountNumber -AccountDescription, ERPx_SPProgramSettlementBatchPayment.WriteOffAccountSK, ERPx_IMItem.BrokerageWriteOffActSK |
| Write Off Program Amt. | Error rendering macro 'excerpt-include' : No link could be created for 'Write Off Program Amount'. This is an editable textbox that defaults to 0.00 and is not required. If entered it must be >= 0.00 and <= 'Item Program Remaining Amt.'.Database Field: ERPx_SPProgramSettlementBatchPayment.WriteoffAmount |
| Write Off Reason Code | Identifies the reason the balances are being adjusted. This is a single select lookup that defaults to the 'Write Off Reason Code' saved in the Sales Program 'Reason Code for Write Offs' Preference or blank. This is required if the 'Write Off Program Amt.' <> 0.00. Database Field: ERPx_MFNoteTypeReasonCode.ReasonCode, ERPx_SPProgramSettlementBatchPayment.WriteoffReasonCode |
This icon is only visible on pages that are documented in the online help.