DEFINTION HERE. 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: 20212022.xx06.xx 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 |
PayPayee Name | | Settle | | Insert excerpt |
|---|
| SP - Amount to Settle - Item |
|---|
| SP - Amount to Settle - Item |
|---|
| 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. | | Insert excerpt |
|---|
| SP - Item Program Amount |
|---|
| SP - Item Program Amount |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_SPProgramSettlementItem.OrderItemAmount |
Open Amt. | SPProgramSettlementHeader.SettleToEntityNameProgram Amt. | Database Field: ERPx_SPProgramSettlementItem.ComputedAmount
QuantitySPProgramSettlementItem.ComputedAmount |
| Item Program Calc. On | Identifies the values used for determining Sales Program Amounts. It can be set to one of the following values: - $/UOM: The program amount is calculated by multiplying the Item Set's 'Rate' by the transaction item's quantity (Unit or Weight quantity converted to the Item Set's Rate UOM).
- % Gross Amt: The program amount is calculated by multiplying the Item Set's 'Rate' by the transaction item's 'Gross Amt.' (extended amount).
- % (Gross - Freight): The program amount is calculated by multiplying the Item Set's 'Rate' by the transaction item's ([Gross Amt.] - [Freight Amt.]).
This defaults from the 'Calculated On' field on the 'Item Sets' tab of the Sales Program Record View. The 'Calculated On' is only editable from the Sales Program Record View, it is not editable from here. |
| Item Program Rate | | Insert excerpt |
|---|
| Rate - SP |
|---|
| Rate - SP |
|---|
| nopanel | true |
|---|
|
|
| Item Program Remaining Amt. | | Insert excerpt |
|---|
| SP - Item Program Remaining Amount |
|---|
| SP - Item Program Remaining Amount |
|---|
| nopanel | true |
|---|
|
|
| Item Program Qty | | Insert excerpt |
|---|
| SP - Item Program Qty |
|---|
| SP - Item Program Qty |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_SPProgramSettlementItem.ConvOrderUnits |
Remaining Amt. | UOM |
| Item Program UOM | | Insert excerpt |
|---|
| SP - Item Program UOM |
|---|
| SP - Item Program UOM |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_IMUOM.UOMID , ERPx_SPProgramSettlementItem.ProgramCalcUOMSK |
Write Off Amt.| 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_ |
SPProgramSettlementBatchPaymentSPProgramSettlementHeader. |
WriteoffAmountSettleToEntityName |
| 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 Item Program Amount |
|---|
| SP - Write Off Item 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
...