B03B0131
F03B16 - Calculate Statistical Summary
Functional Description
Purpose
This function is called from the B03B0124 (Read Statistical History Cache). For every record in the
cache, this function is called. Based upon company, customer, end date, and beginning date, this
function will select F03B16 records and total these to be either updated or inserted into the F03B16S as
child records. It will update F03B16S Child records if a record is found, or else it will insert child
records into the F03B16S if no record is found.
This function also compares statistical history information such as Date of First Invoice to
information stored for a customer, company combination in the F03012. If conditions are met, this function
will load the D0100056 and call the B0100056 to update the F03012 with these fields.
Setup Notes and Prerequisites
Special Logic
Technical Specifications
Parameters
Data ItemDescriptionI/OReqNotes
AN8CustomerNumberIY
COCompanyIY
DTBGBeginningDateIY
DTENEndDateCCIY
DFIJDateFirstInvoiceIY
DLIJDateLastInvoiceIY
ALPAmountLastPaidIY
DLPDateLastPaidIY
CTRYCenturyIN
FYFiscalYearIN
PNPeriodNumberIN
DAYPPeriodDaysIN
NXPDNextPeriodToProcessIY
EV01DSOMethodIY
MATH01DSOPeriodsIY
MATH01TotalNumberDaysLateIY
ASTYAmtInvoicedThisYrIY
SPYEAmtInvoicedPriorYrIY
Related Tables
F03B16SAccount Statistic Summary
F03B16A/R Statistical History
F03012Customer Master by Line of Business
F03B20A/R Notification History
Related Business Functions
N0100042Customer Master -MBF
B03B0085Update Stat Summary Parent
B9800100Get Audit Information
B0100056F03012 - Update A/R Data on Customer Master
Processing
^
D03B0131 - F03B16 - Calculate Statistical Summary
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnCustomerNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
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
| ||||
jdBeginningDate | DTBG | JDEDATE | NONE | NONE |
The date on which the credit/collection date pattern begins for the year specified. The system uses credit/collection date patterns for
| ||||
jdEndDateCC | DTEN | JDEDATE | NONE | NONE |
The date on which a credit/collection period ends for the date pattern specified. The system uses credit/collection date patterns for
| ||||
jdDateFirstInvoice | DFIJ | JDEDATE | NONE | NONE |
The G/L date of the first invoice generated. | ||||
jdDateLastInvoice | DLIJ | JDEDATE | NONE | NONE |
The G/L date of the last invoice generated for the customer. | ||||
mnAmountLastPaid | ALP | MATH_NUMERIC | NONE | NONE |
The amount of the last payment applied to invoices based on the G/L date of the Receipt Detail record (F03B14). The system displays this
| ||||
jdDateLastPaid | DLP | JDEDATE | NONE | NONE |
The date of the last premium payment. | ||||
mnCentury | CTRY | MATH_NUMERIC | NONE | NONE |
The calendar century associated with the year. Enter is the first two digits of
the year. For example, 19 indicates any year beginning with 19
| ||||
mnFiscalYear | FY | MATH_NUMERIC | NONE | NONE |
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal
| ||||
mnPeriodNumber | PN | MATH_NUMERIC | NONE | NONE |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
| ||||
cDSOMethod | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
mnDSOPeriods | MATH01 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance Low Value. | ||||
mnPeriodDays | DAYP | MATH_NUMERIC | NONE | NONE |
The number of days within an accounting period. | ||||
jdNextPeriodToProcess | NXPD | JDEDATE | NONE | NONE |
The date that was entered for the Thru Date processing option on the Summary Record tab when the Statistics History Update program
| ||||
mnTotalNumberDaysLate | MATH01 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance Low Value. | ||||
mnAmtInvoicedThisYr | ASTY | MATH_NUMERIC | NONE | NONE |
The amount invoiced for the year. The system uses the gross amount of the invoice record (F03B11) regardless of whether taxes are
| ||||
mnAmtInvoicedPriorYr | SPYE | MATH_NUMERIC | NONE | NONE |
The gross amount invoiced for the previous year. The system updates this field only when you run the Statistics Annual Close program
|
B03B0075 F03b16BalanceStatsHist | ||||
B03B0085 Update Stat Summary Parent | ||||
B9800100 Get Audit Information | ||||
N0100042 Customer Master -MBF |
F03B16 A/R Statistical History | ||||
F03B16S A/R Statistical Summary | ||||
F03B20 A/R Notification History |