Versions Compared

Old Version 6

changes.mady.by.user Janice Dannenberg (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Tom Williams

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
Def - Broker Program Balances
Def - Broker Program Balances
nopaneltrue
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

Table of Contents
typeflat

Page Header

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid Layout
Group By Show/Hide
Insert excerpt
Grid Layout
Group By Show/Hide - Global
Grid Layout
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
More Actions

Insert excerpt
More Actions - Global 3.0
More Actions - Global 3.0
nopaneltrue

  • IQ: Broker Activity: Opens the Broker Activity Inquiry for the selected record
Process Settlements
to 
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.
  • 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
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
Activity
Company Balance

Displays

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 Entity

as 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

.CurrencySKCompany

.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

Insert excerpt
Program ID & Description
Program ID & Description
nopaneltrue
 

Database Fields: ERPx_SPProgramHeader.ProgramID, ERPx_SPProgramHeader.Description

Program Balance

Displays the current open

Broker Balance

Program balance, in the

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.SettleToEntityName

Program 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:

  1. AP Invoice - Paid in Full Orders
  2. AP Invoice - All Orders
  3. AR Credit Memo

Database Fields: ERPx_SPProgramHeader.SettlementMethodSK 

Related Topics



Expand
titlePage Definitions

Page Definitions



Expand
titleTechnical Details

Technical Details