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.Insert excerpt Def - Program Balances Def - Program Balances nopanel true
Software Version: 2022.xx.xx and newer
| Table of Contents | ||
|---|---|---|
|
Page Header
| Toolbar Icons | Description | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Column Filter Show/Hide |
| |||||||||
| Excel |
| |||||||||
| Favorites |
| |||||||||
| Group By Show/Hide |
| |||||||||
| Help |
| |||||||||
| More Actions |
| Inquiry for the selected record. - This should have been re-named.IQ: Balance Details: Opens the Balance Details
| ||||||||
| Process Settlements For | Displays a drop-down menu of options including:
| |||||||||
| 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 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:
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:
Database Fields: ERPx_SPProgramHeader.SettlementMethodSK |
...