Broker 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 |
|---|
|
|
| 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 |
to down menu -down menu of options including: |
Accounts Payable Process Settlement - AP Record View to build a payment batch.Accounts Receivable: Opens the Process Settlement - AR Record View to build a payment batch.- Process 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 |
Activity a hyperlink, which opens a Broker Activity list view. Broker Balance | Displays the current open Broker Balance in the broker currency.
Broker 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. It is not stored in the database. |
| Currency ID | Displays the ID of the currency assigned |
to the Settle to Entityas the 'Program Rate Currency'. This is required and is not editable after 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 |
.CurrencySKCompany .VendorName, ERPx_APCustomer.CustomerName |
| Program | | Insert excerpt |
|---|
| Program ID & Description |
|---|
| Program ID & Description |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_SPProgramHeader.ProgramID, ERPx_SPProgramHeader.Description |
| Program Balance | Displays the current open |
Broker Balance company currency.| 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.SettleToEntityNameProgram currency. This is required and is not editable. 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