The purpose of this page is to show Broker Program (Brokerage, Rebate and Off Book) and Company 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 drill down to the individual transactions that make up the balance.Insert excerpt Def - Broker Program Balances Def - Broker Program Balances nopanel true
Software Version: 20212022.xx.xx and newer
| Table of Contents | ||
|---|---|---|
|
Page Header
| Toolbar Icons | Description | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Column Filter Show/Hide |
| ||||||||||||||
| Excel |
| ||||||||||||||
| Favorites |
| ||||||||||||||
| Grid LayoutGroup By Show/Hide |
| ||||||||||||||
| Help |
| ||||||||||||||
| More Actions |
| ||||||||||||||
| Process Settlements to For | Displays a drop down menu of options including: | Activity | Displays the 'Activity' link. Clicking on the link opens the Broker Activity Inquiry
| ||||||||||||
| Fields | Description | ||||||||||||||
| |||||||||||||||
| Quick Column Filter |
| ||||||||||||||
| Saved Layouts |
| ||||||||||||||
| Fields | Description | ||||||||||||||
| Company Balance | Displays the current open Program balance in the Company currency. This is required and is not editable. This field is not stored in the database. | Broker Balance | Displays the current open Broker balance, in the Broker currency. This is required and is not editable amount is calculated from the 'Program Balance' amount using the associated currency exchange rate. It is not stored in the database.
Database Field: ERPx_SPProgramSettlementHeader.ComputedAmount | ||||||||||||
| Broker Currency ID | Displays the ID of the currency assigned to the Settle to Entity. This is required and is not editable.
Database Fields: MFCurrency.CurrencyID, ERPx_APVendor.CurrencySK | ||||||||||||||
| Payee ID | |||||||||||||||
| Payee Name | Displays the customer/vendor name assigned to the Sales Program. Database Field: ERPx_SPProgramSettlementHeader.SettleToEntityName | ||||||||||||||
| Program | |||||||||||||||
| Program Balance | Displays the current open Broker Program balance, in the Company Customer/Vendor's 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.
| Settle As | Database Field: | ERPxERPx_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.ComputedAmount | ||||||||||||||
| Program Class | |||||||||||||||
| Program Type | |||||||||||||||
| Settle To | Displays Database Field: | ERPxERPx_SPProgramSettlementHeader. | SettleToEntityNameSettleToEntityID |
Related Topics
| Expand | ||
|---|---|---|
| ||
Page Definitions |
| Expand | ||
|---|---|---|
| ||
Technical Details |