Versions Compared

Old Version 14

changes.mady.by.user Emma Greenwood

Saved on

compared with

New Version 15

changes.mady.by.user Emma Greenwood

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 review program balances by Program. From here, users can also create program Settlements and drill down to the individual transactions that make up the balances.

Software Version: 2022.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
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
Process Settlements For 

Displays a drop-down menu of options including:

  • Brokerage: Opens the 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
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. It is not stored in the database.

Currency ID

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

Displays the Program as [Program ID]: [Program Description]  

Database Fields: ERPx_SPProgramHeader.ProgramID, ERPx_SPProgramHeader.Description

Program Balance

Displays the current open Program balance, in the 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 

...