B03B0090
F03B16S - Update Statistic Summary
Functional Description
Purpose
This function updates the Account Statistic Summary (F03B16S) table. This function will try to fetch
a F03B16S record based Customer Number and Company if a record is found the function will add the
amounts passed to the existing record and then update the F03B16S record. If a record does not exist,
the function will insert the record into the F03B16S.
Setup Notes and Prerequisites
Special Logic
Technical Specifications
Parameters
Data ItemData Structure DescriptionI/ORequiredNotes
AN8Address NumberIYes
PARTParent/Child RelationshipIYes
COCompanyIYes
ENBLEnding BalanceIYes
AHBAmountHigh BalanceINo
AGAmount InvoicedINo
NINVNumber of InvoicesINo
SAGSales AmountINo
CREECredits EnteredINo
ADSCDiscount AvailableINo
DFEEAmt Delinquency FeesINo
ECBAChargeback AmountINo
NCBNumber of ChargebacksINo
DFIJDate First InvoiceINo
DLIJDate Last InvoiceINo
PAAPPayment AmountsINo
EDSCDiscount EarnableINo
UDSCDiscount UnearnableINo
AIPLAmount Paid LateINo
NIPLNumber of Invoice Paid LateINo
MWOAmount Minor Write-offINo
BDBTAmount Bad DebtINo
ANSFAmount NSFINo
NNSFNumber of NSFINo
DLPDate Last PaidINo
ALPAmount Last PaymentINo
CRCDCurrency CodeINo
ASTYAmount Invoiced This YrINo
SPYEAmount Invoiced Prior YrINo
AVDLAverage Days LateINo
Related Tables
F03B16SAccount Statistic Summary
Related Business Functions
N0100042Customer Master -MBF
B0100056F03012 - Update A/R Data on Customer Master
B9800100Get Audit Information
B03B0085Update Stat Summary Parent
Processing
^
D03B0090 - F03B16 - Update Statistic Summary
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnAddressNumber | 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
| ||||
cParentChildRelationshi | PART | char | NONE | NONE |
An option that specifies whether the system displays parent records or child records. If you turn on this option, the system displays parent
| ||||
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
| ||||
mnEndingBalance | ENBL | MATH_NUMERIC | NONE | NONE |
The total open amount of invoices. The system displays this information from either the A/R Statistical Summary table (F03B16S) or the A/R
| ||||
mnAmountHighBalance | AHB | MATH_NUMERIC | NONE | NONE |
The invoice record with the highest gross amount from the A/R Statistical Summary table (F03B16S) or the A/R Statistical History table
| ||||
mnAmountInvoiced | AG | MATH_NUMERIC | NONE | NONE |
A value that specifies the total amount of the invoice or voucher pay item. The gross amount might include the tax amount, depending on
| ||||
mnNumberOfInvoices | NINV | MATH_NUMERIC | NONE | NONE |
Depending on the form, the number of posted invoices entered for the customer at the time the Statistics History Update program (R03B16)
| ||||
mnAmountSales | SAG | MATH_NUMERIC | NONE | NONE |
The total amount of sales orders from the A/R Statistical Summary table (F03B16S) or the A/R Statistical History table (F03B16), depending
| ||||
mnCreditsEntered | CREE | MATH_NUMERIC | NONE | NONE |
A value that indicates the total amount of invoices with a gross amount less than zero, excluding invoices with document types R1, R5, and
| ||||
mnAmtDiscountAvailable | ADSC | MATH_NUMERIC | NONE | NONE |
The amount of the invoice or voucher pay item that is eligible to be subtracted from the gross amount when the transaction is paid. The
| ||||
mnAmountDelinquencyFees | DFEE | MATH_NUMERIC | NONE | NONE |
The total amount of the delinquency fee invoice records (RF). The system displays this information from either the A/R Statistical Summary
| ||||
mnChargebackAmounts | ECBA | MATH_NUMERIC | NONE | NONE |
An unpaid invoice amount for which you want to create a new invoice record so that you can charge the customer. | ||||
mnNumberOfChargebacks | NCB | MATH_NUMERIC | NONE | NONE |
The total number of chargeback invoices (document type RB) from either the A/R Statistical Summary table (F03B16S) or the A/R Statistical
| ||||
jdDateFirstInvoiceJulian | DFIJ | JDEDATE | NONE | NONE |
The G/L date of the first invoice generated. | ||||
jdDateLastInvoiceJulian | DLIJ | JDEDATE | NONE | NONE |
The G/L date of the last invoice generated for the customer. | ||||
mnPaymntAmount | PAAP | MATH_NUMERIC | NONE | NONE |
In the Accounts Payable system, the amount of the payment.
In the Accounts Receivable system, the amount of the receipt. This amount
| ||||
mnDiscountEarnable | EDSC | MATH_NUMERIC | NONE | NONE |
The amount of the discount that is taken on or before the discount due date. | ||||
mnDiscountUnearned | UDSC | MATH_NUMERIC | NONE | NONE |
The total amount of the discounts taken after the discount due date. The system displays this amount from either the A/R Statistical
| ||||
mnAmountPaidLate | AIPL | MATH_NUMERIC | NONE | NONE |
The total amount of invoices that have been paid late from the A/R Statistical Summary table (F03B16S) or the A/R Statistical History table
| ||||
mnNumberOfInvoicesPaidLate | NIPL | MATH_NUMERIC | NONE | NONE |
The total number of invoices that were paid after the due date. The system displays this number from either the A/R Statistical Summary
| ||||
mnAmountMinorWriteoff | MWO | MATH_NUMERIC | NONE | NONE |
The total write-off amount accumulated from the Receipts Detail table (F03B14) for all reason codes in UDC 03B/RC that have 1 in the
| ||||
mnAmountBadDebt | BDBT | MATH_NUMERIC | NONE | NONE |
The total write-off amount accumulated from the Receipts Detail table (F03B14) for all reason codes in UDC 03B/RC that have no value in
| ||||
mnAmountNSF | ANSF | MATH_NUMERIC | NONE | NONE |
The total amount of the receipts that were returned for insufficient funds (document type RV). The system displays this information from
| ||||
mnNumberOfNSFs | NNSF | MATH_NUMERIC | NONE | NONE |
The total number of receipts returned for non-sufficient funds (document type RV) from the A/R Statistical Summary table (F03B16S) or the
| ||||
jdDateLastPaid | DLP | JDEDATE | NONE | NONE |
The date of the last premium payment. | ||||
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
| ||||
szCurrencyCodeFrom | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
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
| ||||
mnAverageDaysLate | AVDL | MATH_NUMERIC | NONE | NONE |
The average length of time, in days, that it took the customer to pay an invoice. | ||||
jdDateLastStatementDate | DT1J | JDEDATE | NONE | NONE |
The date that the last statement was processed. The system displays this information from the A/R Statistical Summary table (F03B16S). | ||||
mnNoSentReminders1 | NBR1 | MATH_NUMERIC | NONE | NONE |
The total number of delinquency notices that were sent to a customer. | ||||
jdDateLastDunningLetterJul | DLQJ | JDEDATE | NONE | NONE |
The date of the last deliquency notice that was sent to the customer. The system displays this information from either the A/R Statistical
| ||||
cRollingBalanceFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. |
B03B0085 Update Stat Summary Parent | ||||
B9800100 Get Audit Information | ||||
N0100042 Customer Master -MBF |
F03B16S A/R Statistical Summary |