Versions Compared

Old Version 9

changes.mady.by.user Emma Greenwood

Saved on

compared with

New Version 10

changes.mady.by.user Tom Williams

Saved on

Key

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

Insert excerpt
Def - Program Balances
Def - Program Balances
nopaneltrue
The purpose of this page is to show 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 review program balances by Program. From here, users can also create program Settlements and drill down to the individual transactions that make up the balancebalances.

Software Version: 2022.xx.xx and newer

Table of Contents
typeflat

Page Header

Currency Currency IDafter the Program has been saved.

Database Fields: MFCurrency ERPx_SPProgramHeader.CurrencyIDProgramEntitySK, ERPx_APVendor.CurrencySK

Payee ID

VendorID, ERPx_APCustomer.CustomerID

Database Field: ERPx_SPProgramSettlementHeader.ComputedAmount

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
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
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. - This should have been re-named.
  • IQ: Balance Details: Opens the Balance Details Inquiry for the selected record
Process Settlements For 

Displays a drop down menu -down menu of options including:

  • Brokerage: Opens the the Process Settlements page to create Brokerage Settlements
  • Off Book: Opens the Process Settlements page to create Off Book Settlements
  • Rebates: Opens the 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
Company Balance

Displays the current open Program balance, in the Company currency. This is required and is not editable. This

amount

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.

Insert excerpt
Def - Program BalancesDef - Program Balances
nopaneltrue

Displays the ID of the currency assigned 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 currency assigned to the Settle to EntityCustomer or Vendor that is assigned as the 'Payee' on the Sales Program. This is required and is not editable .

Insert excerpt
Def - CurrencyDef - Currency
nopaneltrue
Payee Name

Displays the customer/vendor name assigned to the Sales Program.

Database Field: ERPx_SPProgramSettlementHeader.SettleToEntityName

ProgramProgram

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

Displays the Program as [Program ID]: [Program Description]  ← This is missing the ID

Database Fields: ERPx_SPProgramHeader.ProgramID, ERPx_SPProgramHeader.Description

Program Balance

Displays the current open Program balance, in the Customer/Vendor's 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.

Insert excerpt
Def - Program BalancesDef - Program Balances
nopaneltrue
Program ClassProgram TypeSettle To 

Displays 

Database Field: ERPx_SPProgramSettlementHeader.SettleToEntityID

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.
  • Rebates: A Program that calculates amounts that will either pay an AP Vendor or credit an AR Customer but do not post to the General Ledger until the program is settled.

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


...