Functional Description
Purpose
This function is used to load all open invoices that match the specified statement number to an
invoice selection cache.
Setup Notes and Prerequisites
The Invoice Selection Create Cache (B03B0172) function must be called first to create the temporary
cache used to hold any invoice pay items found. Call the Receipts Entry Read Cache (B03B0142) function
in a loop to retrieve each pay item from the temporary cache. Once completed, call the Invoice
Selection Destroy Cache (B03B0172) function to free the memory used by the cache. Other functions in the
B03B0172 family may be used to add, delete, and check for records in the cache.
Special Logic
None.
Technical Specification
Parameters
Item DescriptionI/OReq?Notes
CTLszStatementNumberIYAll open invoices for the given statement number will
be loaded to the cache.
COszCompanyIYRequired if currency is on.
CRRMcCurrencyModeIYRequired if currency is on.
CRCDszTransactionCurrencyIYRequired if currency is on and the mode is foreign.
EV01cEditPayApprovedInvoicesIYIf this parameter is a '1', only invoices at a pay
status of 'A' will be added to the cache.
MATH01mnRecordsSelectedO Total number of invoices that were added to the
cache.
BCRCszCurrencyCodeBase I Y Required if currency is on.
Related Tables
F03B11Customer Ledger File
Related Functions
B03B0158Maintain Receipts Entry Cache
Processing
Retrieve currency constant.
Validate required parameters.
Open F03B11 table.
Set F03B11 selection using specified criteria.
While a record is found,
Call the Receipts Entry Check Cache (B03B0158) function.
If the invoice is already in the Receipts Entry cache,
Skip record.
Else,
Add record to the Invoice Selection cache.
Increment mnRecordsSelected by one.
Repeat until no more records are found.
Close F03B11 table.
^
D03B0152 - F03B11 Load By Statement Number
Parameters
Item DescriptionI/OReq?Notes
CTLszStatementNumberIYAll open invoices for the given statement number will
be loaded to the cache.
COszCompanyIYRequired if currency is on.
CRRMcCurrencyModeIYRequired if currency is on.
CRCDszTransactionCurrencyIYRequired if currency is on and the mode is foreign.
EV01cEditPayApprovedInvoicesIYIf this parameter is a '1', only invoices at a pay
status of 'A' will be added to the cache.
MATH01mnRecordsSelectedO Total number of invoices that were added to the
cache.
BCRCszCurrencyCodeBase I Y Required if currency is on.
^
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| szStatementNumber | CTL | char | NONE | NONE |
Accounts Payable - A code the system uses to determine the order in which A/P payments are printed. The value of the field differs
| ||||
| szCompany | CO | char | NONE | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
| cCurrencyMode | CRRM | char | NONE | NONE |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
| szTransactionCurrency | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
| cEditPayApprovedInvoices | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| mnRecordsSelected | MATH01 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance Low Value. | ||||
| szCurrencyCodeBase | BCRC | char | OPT | NONE |
A code that represents the currency of the company for a transaction. For a foreign currency transaction, this is the currency code of the
| ||||
| None |
| F03B11 Customer Ledger |