| Insert excerpt |
|---|
| Def - Broker Program Balances |
|---|
| Def - Broker Program Balances |
|---|
| nopanel | true |
|---|
|
The purpose of this page is to show Broker and Company review program balances by Customer/Vendor. Users will have the ability to process settlements to both Accounts Payable and Accounts Receivable. From this List View, users may also Program. From here, users can also create program Settlements and drill down to the individual transactions that make up the balancebalances.
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 |
|---|
|
|
| Excel | | Insert excerpt |
|---|
| Excel - LV 3.0 |
|---|
| Excel - LV 3.0 |
|---|
| nopanel | true |
|---|
|
|
| Favorites | | Insert excerpt |
|---|
| Favorites Add/Remove - Global |
|---|
| Favorites Add/Remove - Global |
|---|
| nopanel | true |
|---|
|
|
Grid LayoutGrid Layout | Group By Show/Hide - Global |
|---|
|
|
Grid Layout | Group By Show/Hide - Global |
|---|
| nopanel | true |
|---|
|
|
| Help | | Insert excerpt |
|---|
| Help - Global |
|---|
| Help - Global |
|---|
| nopanel | true |
|---|
|
|
Process Settlements to | More Actions | | Insert excerpt |
|---|
| More Actions - Global 3.0 |
|---|
| More Actions - Global 3.0 |
|---|
| nopanel | true |
|---|
|
- IQ: Broker Activity: Opens the Broker Activity Inquiry for the selected record
|
| Process Settlements For | Displays a drop |
down menu -down menu of options including: |
Accounts Payable- Brokerage: Opens the Process
|
Settlement - AP Record View to build a payment batch.Accounts Receivable: Opens the Process Settlement - AR Record View to build a payment batch.| Fields | Description |
Activity | Displays the 'Activity' link. Clicking on the link opens the Broker Activity Inquiry- Settlements page to create Brokerage Settlements
- Off Book: Opens the Process Settlements page to create Off Book Settlements
- Rebates: Opens the Process Settlements page to create Rebate Settlements
|
| Quick Column Filter | | Insert excerpt |
|---|
| Quick Column Filter |
|---|
| Quick Column Filter |
|---|
| nopanel | true |
|---|
|
|
| Saved Layouts | | Insert excerpt |
|---|
| Column Layouts for Framework 3.0 - Global |
|---|
| Column Layouts for Framework 3.0 - Global |
|---|
| nopanel | true |
|---|
|
|
| Fields | Description |
| Company Balance | Displays the current open Program balance, in the Company currency. This is required and is not editable. This is a calculated field that is not stored in the database. It is calculated from the 'Program Balance' amount using the associated currency exchange rate. |
Broker BalanceIt is not stored in the database. |
| Currency ID | |
current open Broker balance, in the Broker currencyID of the currency assigned as the 'Program Rate Currency'. This is required and is not editable |
.| Insert excerpt |
|---|
Def - Broker Balances | Def - Broker Balances | | nopanel | true |
|---|
Database Field: ERPx_SPProgramSettlementHeader.ComputedAmount
Broker Currency ID | Displays the ID of the currency assigned to the Settle to EntityDef - Currencyafter the Program has been saved. Database Fields: ERPx_SPProgramHeader.CurrencySK, ERPx_MFCurrency.CurrencyID |
| Payee ID | Displays the ID of the Customer or Vendor that is assigned as the 'Payee' on the Sales Program. This is required and is not editable after the Program has been saved. Database Fields: ERPx_SPProgramHeader.ProgramEntitySK, ERPx_APVendor.VendorID, ERPx_APCustomer.CustomerID |
| Payee Name | Displays the name of the Customer or Vendor that is assigned as the 'Payee' on the Sales Program. This is required and is not editable after the Program has been saved. Database Fields: ERPx_SPProgramHeader.ProgramEntitySK, ERPx_APVendor.VendorName, ERPx_APCustomer.CustomerName |
| Program | |
Def - Currency | | Program ID & Description | | Program ID & Description |
|---|
| nopanel | true |
|---|
|
Database Fields: |
MFCurrencyCurrencyID ERPxAPVendorCurrencySKCompany | Program Balance | Displays the current open |
Broker Company Program currency. This is required and is not editable |
. This amount is calculated from the 'Broker Balance' amount using the associated currency exchange rate. It is not stored in the database.| Insert excerpt |
|---|
Def - Broker Balances | Def - Broker Balances | | nopanel | true |
|---|
| Settle As | Displays the settlement method AP Invoice or AR Credit as defined on the sales program record. Database Field: ERPx_SPProgramSettlementHeader.SettlementMethodName |
| Settle To ID | Displays the customer/vendor ID of the Sales Program. Database Field: ERPx_SPProgramSettlementHeader.SettleToEntityID |
Settle To Name | Displays the customer/vendor name assigned to the Sales Program.
Database Field: ERPx_SPProgramSettlementHeader.SettleToEntityName. Database Field: ERPx_SPProgramSettlementHeader.ComputedAmount, ERPx_SPProgramSettlementHeader.SettledAmount, ERPx_SPProgramSettlementHeader.WriteoffAmount |
| Program Class | Displays the Program Class assigned to the Program. This is required and is not editable after the Program has been saved. Database Fields: ERPx_SPProgramHeader.ProgramClassSK, ERPx_SPProgramClass.ClassName |
| Program Type | Displays the Type of Sales Program. The potential 'Program Types' include: - Brokerage: A Program that pays an AP Vendor.
- Off Book: A Program that can either pay an AP Vendor or credit an AR Customer but does not post to the General Ledger until the program is settled.
- Rebates: A Program that calculates amounts that will either pay an AP Vendor or credit an AR Customer.
Database Fields: ERPx_SPProgramHeader.ProgramClassSK, ERPx_SPProgramClass.ProgramTypeSK |
| Settle To | Displays how the Program is settled. This is required and is not editable after the Program has been saved. The Settle To options include: - AP Invoice - Paid in Full Orders
- AP Invoice - All Orders
- AR Credit Memo
Database Fields: ERPx_SPProgramHeader.SettlementMethodSK |
Related Topics