B03B0085
F03B16S - Update Stat Summary Parent
Functional Description
Purpose
This function summarize the records on the F03B16S for a Parent/Child relationship. When a Customer
Number and Company Number are passed into the function, the function will read the F0150 to determine
if the Customer is part of a Parent/Child relationship. If the Customer has a parent, the function
will add the current Customer's, a child, amounts the parent's totals. These amounts are rolled up to
the top of the Parent/Child tree. Additionally, if currency processing is "ON", the amounts are
converted into the parent's currency before they are accumulate.
Setup Notes and Preqeruisites
Special Logic
Technical Specifications
Data Structure Parameters
Data ItemData Structure DescriptionI/ORequiredNotes
AN8mnCustomerNumberI
CO szCompanyI
AHB mnHighBalanceAmountI
DHBJ jdDateHighBalanceJulianI
ACLH mnHighCreditLimitAmountI
AG mnInvoicedAmountI
NINV mnNumberInvoicesI
SAG mnSalesAmountI
CREE mnCreditsEnteredI
ADSC mnDiscountsAvailableI
DFEE mnDelinquencyFeesAmountI
ECBA mnChargebackAmountsI
NCB mnNumberChargebacksI
DFIJ jdDateFirstInvoiceJulianI
DLIJ jdDateLastInvoiceJulianI
DT1J jdDateLastStatementJulianI
ASTY mnAmountInvoicedThisYearI
SPYE mnAmountInvoicedPriorYearI
PAAP mnPaymntAmountI
UDSC mnDiscountsUnearnedI
EDSC mnDiscountsEarnedI
AIPL mnInvoiceAmountPaidLateI
NIPL mnNumberInvoicesPaidLateI
DDCA mnAmountDeductionsI
DDCN mnNumberDeductionsI
MWO mnAmountMinorWriteOffI
BDBT mnAmountBadDebtI
ANSF mnNSFAmountI
NNSF mnNumberNSFsI
DLP jdDateLastPaidI
ALP mnAmountLastPaidI
CRCD szCurrencyCodeFromI
CHGA mnAmountChangedI
AVDL mnAverageDaysLateI
NBR1 mnNoSentReminders1I
DLQJ jdDateLastDunningLetterJulI
NINP mnNumberOfInvoicesPaidI
NXPD jdThruDateI
NUMDAY mnNumberDaysLateI
AVDL mnChildPrevAVDLI
PAAP mnChildPrevPaymntAmtI
PAAP mnChildCurrPaymntAmtI
AVDL mnChildCurrAVDLI
Related Tables
F03B16SA/R Statistical Summary
F0150Address Organization Structure Master File - OSTP, PA8, AN8
Related Business Functions
N0100042Customer Master -MBF
B1100006Decimal Trigger Get By Currency
B0000027CurrencyConvForAndDom
B0000033Get Exchange Rate
B9800100Get Audit Information
JDEAPPApplications Global Definitions - include file only
Processing
^
D03B0085 - Update Stat Summary Parent
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
| ||||
mnHighBalanceAmount | 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
| ||||
jdDateHighBalanceJulian | DHBJ | JDEDATE | NONE | NONE |
The invoice date of the record that has the highest gross amount from either the A/R Statistical History (F03B16) or A/R Statistical Summary
| ||||
mnHighCreditLimitAmount | ACLH | MATH_NUMERIC | NONE | NONE |
The highest credit limit that has been extended to the customer. | ||||
mnInvoicedAmount | 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
| ||||
mnNumberInvoices | 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)
| ||||
mnSalesAmount | 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
| ||||
mnDiscountsAvailable | 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
| ||||
mnDelinquencyFeesAmount | 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. | ||||
mnNumberChargebacks | 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. | ||||
jdDateLastStatementJulian | 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). | ||||
mnAmountInvoicedThisYear | 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
| ||||
mnAmountInvoicedPriorYear | 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
| ||||
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
| ||||
mnDiscountsUnearned | 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
| ||||
mnDiscountsEarned | EDSC | MATH_NUMERIC | NONE | NONE |
The amount of the discount that is taken on or before the discount due date. | ||||
mnInvoiceAmountPaidLate | 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
| ||||
mnNumberInvoicesPaidLate | 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
| ||||
mnAmountDeductions | DDCA | MATH_NUMERIC | NONE | NONE |
The total amount of the deduction records from the Receipts Detail table (F03B14) for the specified period. | ||||
mnNumberDeductions | DDCN | MATH_NUMERIC | NONE | NONE |
The total number of deductions that have been applied to an account. | ||||
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
| ||||
mnNSFAmount | 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
| ||||
mnNumberNSFs | 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. | ||||
mnAmountChanged | CHGA | MATH_NUMERIC | NONE | NONE |
The net change amount. | ||||
mnAverageDaysLate | AVDL | MATH_NUMERIC | NONE | NONE |
The average length of time, in days, that it took the customer to pay an invoice. | ||||
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
| ||||
mnNumberOfInvoicesPaid | NINP | MATH_NUMERIC | NONE | NONE |
The number of invoices that were paid in the period specified at the time the Statistics History Update program (R03B16) was run. | ||||
jdThruDate | 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
| ||||
mnNumberDaysLate | NUMDAY | MATH_NUMERIC | NONE | NONE |
The number of days back from the calculate balance date that will be used to calculate the Statistical History Balance. For example, if the
| ||||
mnChildPrevAVDL | AVDL | MATH_NUMERIC | NONE | NONE |
The average length of time, in days, that it took the customer to pay an invoice. | ||||
mnChildPrevPaymntAmt | 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
| ||||
mnChildCurrPaymntAmt | 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
| ||||
mnChildCurrAVDL | AVDL | MATH_NUMERIC | NONE | NONE |
The average length of time, in days, that it took the customer to pay an invoice. |
B0000027 CurrencyConvForAndDom | ||||
B0000033 Get Exchange Rate | ||||
B1100006 Decimal Trigger Get By Currency | ||||
B9800100 Get Audit Information | ||||
N0100042 Customer Master -MBF |
F0150 Address Organization Structure Master | ||||
F03B16S A/R Statistical Summary |