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
| Toolbar Icons | Description |
|---|
| Column Filter Show/Hide | | Insert excerpt |
|---|
| Column Filter Show/Hide - Global |
|---|
| Column Filter Show/Hide - Global |
|---|
| nopanel | true |
|---|
|
|
| Group By Show/Hide | | Insert excerpt |
|---|
| Group By Show/Hide - Global |
|---|
| Group By Show/Hide - Global |
|---|
| nopanel | true |
|---|
|
|
| Help | | Insert excerpt |
|---|
| Help - Global |
|---|
| Help - Global |
|---|
| nopanel | true |
|---|
|
|
| Quick Column Filter | | Insert excerpt |
|---|
| Quick Column Filter |
|---|
| Quick Column Filter |
|---|
| nopanel | true |
|---|
|
|
Save | | Insert excerpt |
|---|
| Save - RV Header 3.0 |
|---|
| Save - RV Header 3.0 |
|---|
| nopanel | true |
|---|
|
|
| Save & Close | | Insert excerpt |
|---|
| Save & Close - RV Header 3.0 |
|---|
| Save & Close - RV Header 3.0 |
|---|
| nopanel | true |
|---|
|
|
| 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 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 | | Insert excerpt |
|---|
| Item ID & Item Description |
|---|
| Item ID & Item Description |
|---|
| nopanel | true |
|---|
|
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. | | Insert excerpt |
|---|
| SP - Open Item Program Amount |
|---|
| SP - Open Item Program Amount |
|---|
| nopanel | true |
|---|
|
|
| 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. | | Insert excerpt |
|---|
| GL Account - SP Write Off |
|---|
| GL Account - SP Write Off |
|---|
| nopanel | true |
|---|
|
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. | | Insert excerpt |
|---|
| SP - Write Off Program Amount |
|---|
| SP - Write Off Program Amount |
|---|
| nopanel | true |
|---|
|
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 | | Insert excerpt |
|---|
| Reason Code |
|---|
| Reason Code |
|---|
| nopanel | true |
|---|
|
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 |
Related Topics
...