B03B0080
Update Open Summary Parent
Functional Description
Purpose
This business function writes and updates parent records (PART = P) in the A/R Open Summary file
(F03B15). This business function should be called whenever a child record is being written to the F03B15.
Setup Notes and Prerequisites
Special Logic
Technical Specifications
Parameters
ItemDescriptionI/OReq?Notes
AN8Customer NumberIYes
PA8Parent NumberI Yes
AN8Address Number ChildI Yes
COCompany NumberIYes
DAGAs Of DateINo
AAPOpen AmountINo
OINVNumber of Open Inv Pay ItemsINo
OCBOpen Chargeback AmountINo
NOCBNumber of Open ChargebacksINo
ADSADiscount AvailableINo
EDSCDiscount EarnableINo
PDAAmount Past DueINo
PDINNumber of Past Due InvoicesINo
OCBPOpen Chargebacks Past DueINo
DSCPDiscount Available Past DueINo
FTRFuture Amount DueINo
CURRCurrent AmountINo
CUINNumber of Current InvoicesINo
OCBCCurrent Chargeback AmountINo
CUDSCurrent Discount AvailableI No
CUEDCurrent Discount EarnableI No
AG1Aging Amount 1I No
AG2Aging Amount 2I No
AG3Aging Amount 3I No
AG4Aging Amount 4I No
AG5Aging Amount 5I No
AG6Aging Amount 6I No
AG7Aging Amount 7I No
AOCLAmount Over Credit LimitINo
UAAUnapplied AmountI No
NURNumber Unapplied AmountI No
CREEOpen CreditsI No
CRENNumber Open CreditsI No
ODAMOutstanding DraftsI No
NODNumber Outstanding DraftsI No
CRCDCurrency Code FromI No
AGEMAging MethodI No
CRDYAging Days AR CurrentI No
AGR1Aging Days AR001I No
AGR2Aging Days AR002I No
AGR3Aging Days AR003I No
AGR4Aging Days AR004I No
AGR5Aging Days AR005I No
AGR6 Aging Days AR006I No
AGR7 Aging Days AR007I No
AGEBase Aging DateI No
DDOAClaim Amount OpenI No
DDNBNumber of Open ClaimsI No
CLMGCollection ManagerI No
CMGRCredit ManagerI No
WKFLAccount Worked FlagI No
For the items that are not required, if their values are not blank or zero, they should be passed
into this function.
Related Tables
F03B15Credit and Cash Management
F03B31Customer Activity Log
F0150Address Organization Structure Master File - OSTP, PA8, AN8
Related Business Functions
B0100042Customer Master - MBF
B0000033Get Exchange Rate
B9800100Get Audit Information
B0000027CurrencyConvForAndDom
Processing
Call I_B03B0080_Process_Parent_Record
While bRecordRead = True
I_B03B0080_Process_Parent_Record (internal function)
Fetch F03B15
Run Get Audit Info
Otherwise, the record will be inserted)
and the internal function I_B03B0080 to convert the amounts
Update F03B15
If Company is 00000 and customer currency code is not the same as Currency Code From
Fetch F0150 to get the Parent Number
Fetch F03B31 to see if the promise (activity type 30) exists
If the promise exists, set the Account Worked Flag (WKFL) to a 1. If not, set it to a 0
Insert the parent record to F03B15
^
D03B0080 - Update Open Summary Parent
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnCustomerNumber | AN8 | MATH_NUMERIC | REQ | 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
| ||||
jdAsOfDate | DAG | JDEDATE | NONE | NONE |
A date that the system uses to determine the aging category to which to assign an invoice. The system compares the aging date to the
| ||||
mnOpenAmount | AAP | MATH_NUMERIC | NONE | NONE |
The amount of an invoice or voucher pay item that is unpaid. | ||||
mnNumberOpenInvoices | OINV | MATH_NUMERIC | NONE | NONE |
The number of invoice pay items that had an open amount at the time the Credit Analysis Refresh program (R03B525) was run. | ||||
mnOpenChargebackAmount | OCB | MATH_NUMERIC | NONE | NONE |
The total open amount of chargebacks for the customer. | ||||
mnNumberOpenChargebacks | NOCB | MATH_NUMERIC | NONE | NONE |
The total number of open chargeback pay items. | ||||
mnDiscountAvailable | ADSA | MATH_NUMERIC | NONE | NONE |
The amount by which an invoice or voucher is reduced if paid by a specific date. The discount taken does not have to be the same as the
| ||||
mnDiscountEarnable | EDSC | MATH_NUMERIC | NONE | NONE |
The amount of the discount that is taken on or before the discount due date. | ||||
mnAmountPastDue | PDA | MATH_NUMERIC | NONE | NONE |
Total amount of all invoice pay items that are past due. | ||||
mnNumberPastDueInvoices | PDIN | MATH_NUMERIC | NONE | NONE |
The number of invoice pay items with a due date prior to the aging date specified when the Credit Analysis Refresh program (R03B525)
| ||||
mnOpenChargebacksPastDue | OCBP | MATH_NUMERIC | NONE | NONE |
Total amount of all open chargebacks that are past due. | ||||
mnDiscountAvailablePastDue | DSCP | MATH_NUMERIC | NONE | NONE |
Total discount available amount for all open invoice pay items that are past due. | ||||
mnAmountFuture | FTR | MATH_NUMERIC | NONE | NONE |
The total amount of the invoices that is due prior to the first aging category defined when the Credit Analysis Refresh program (R03B525)
| ||||
mnCurrentAmount | CURR | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the current aging category as defined in either the Accounts Receivable constants or the
| ||||
mnNumberCurrentInvoices | CUIN | MATH_NUMERIC | NONE | NONE |
The total number of invoice pay items that are due in the current period, as specified by the Age as of Date field on the form. | ||||
mnCurrentChargebackAmount | OCBC | MATH_NUMERIC | NONE | NONE |
Total amount of all chargebacks that are due in the current period. | ||||
mnCurrentDiscountAvailable | CUDS | MATH_NUMERIC | NONE | NONE |
Total discount available amount for all open invoices due in the current period. | ||||
mnCurrentDiscountEarnable | CUED | MATH_NUMERIC | NONE | NONE |
Total discount amount for all open invoices due in the current period and contain a discount due date greater than or equal to the current
| ||||
mnAgingAmount1 | AG1 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the first category as defined in either the Accounts Receivable constants or the processing options
| ||||
mnAgingAmount2 | AG2 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the second category as defined in either the Accounts Receivable constants or the processing
| ||||
mnAgingAmount3 | AG3 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the third category as defined in either the Accounts Receivable constants or the processing options
| ||||
mnAgingAmount4 | AG4 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the fourth category as defined in either the Accounts Receivable constants or the processing
| ||||
mnAgingAmount5 | AG5 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the fifth category as defined in either the Accounts Receivable constants or the processing options
| ||||
mnAgingAmount6 | AG6 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the sixth category as defined in either the Accounts Receivable constants or the processing options
| ||||
mnAgingAmount7 | AG7 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the seventh category as defined in either the Accounts Receivable constants or the processing
| ||||
mnAmountOverCreditLimit | AOCL | MATH_NUMERIC | NONE | NONE |
The portion of a customer's total amount due that exceeds his available credit limit. | ||||
mnUnappliedAmount | UAA | MATH_NUMERIC | NONE | NONE |
The total payment amount received from a customer that was not applied to invoices. | ||||
mnNumberUnappliedAmount | NUR | MATH_NUMERIC | NONE | NONE |
The number of unapplied receipts records (RU) in the Customer Ledger table (F03B11) that have a pay status not equal to P. | ||||
mnOpenCredits | 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
| ||||
mnNumberOpenCredits | CREN | MATH_NUMERIC | NONE | NONE |
The total number of open credit pay items. The system updates this field when you run the Credit Analysis Refresh program (R03B525). | ||||
mnOutstandingDrafts | ODAM | MATH_NUMERIC | NONE | NONE |
The total value of the open draft amounts. Outstanding drafts are considered all drafts in Italy and only drafts not yet due in France. | ||||
mnNumberOutstandingDrafts | NOD | MATH_NUMERIC | NONE | NONE |
The number of draft records (R1) in the Customer Ledger table (F03B11) that have a pay status not equal to P. | ||||
szCurrencyCodeFrom | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
cAgingMethod | AGEM | char | NONE | NONE |
A code that designates which aging categories the system uses to assign invoices. The system uses the date specified in the Age as of
| ||||
mnAgingDaysARCurrent | CRDY | MATH_NUMERIC | NONE | NONE |
A value used in conjunction with the value of AGR1 to define the number of days in the current aging category. | ||||
mnAgingDaysAR001 | AGR1 | MATH_NUMERIC | NONE | NONE |
A value used in conjunction with CRDY and AGR2 to define the current and first aging categories. | ||||
mnAgingDaysAR002 | AGR2 | MATH_NUMERIC | NONE | NONE |
A value used in conjunction with AGR1 and AGR3 to define the first and second aging categories. | ||||
mnAgingDaysAR003 | AGR3 | MATH_NUMERIC | NONE | NONE |
A value used in conjunction with AGR2 and AGR4 to define the second and third aging categories. | ||||
mnAgingDaysAR004 | AGR4 | MATH_NUMERIC | NONE | NONE |
A value used in conjunction with AGR3 and AGR5 to define the third and fourth aging categories. | ||||
mnAgingDaysAR005 | AGR5 | MATH_NUMERIC | NONE | NONE |
A value used in conjunction with AGR4 and AGR6 to define the fourth and fifth aging categories. | ||||
mnAgingDaysAR006 | AGR6 | MATH_NUMERIC | NONE | NONE |
A value used in conjunction with AGR5 and AGR7 to define the fifth and sixth aging categories. | ||||
mnAgingDaysAR007 | AGR7 | MATH_NUMERIC | NONE | NONE |
A value used in conjunction with AGR6 to define the sixth aging category. | ||||
cBaseAgingDate | AGE | char | NONE | NONE |
A code that specifies which date on the invoice record to use to calculate aging. The system compares the date specified on the invoice
| ||||
mnClaimAmountOpen | DDOA | MATH_NUMERIC | NONE | NONE |
The unresolved domestic amount of the deduction. The currency associated with this amount appears in the Base Currency Code field
| ||||
mnNumberOfOpenClaims | DDNB | MATH_NUMERIC | NONE | NONE |
Future use. | ||||
mnAddressNumberParent | PA8 | MATH_NUMERIC | OPT | NONE |
The address book number of the parent company. The system uses this number to associate a particular address with a parent company
| ||||
szCollectionManager | CLMG | char | OPT | NONE |
The name of the collection manager responsible for managing this customer's account. You must set up the collection manager in the
| ||||
szCreditManager | CMGR | char | OPT | NONE |
The name of the credit manager responsible for approving changes to the credit limit. You must set up the credit manager in the address
| ||||
cAccountWorkedFlag | WKFL | char | OPT | NONE |
An option that specifies whether to limit the display of accounts to those for which you have entered a promise message (Worked) or those
| ||||
mnAddressNumberChild | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
|
B0000027 CurrencyConvForAndDom | ||||
B0000033 Get Exchange Rate | ||||
B9800100 Get Audit Information | ||||
N0100042 Customer Master -MBF |
F0150 Address Organization Structure Master | ||||
F03B15 Credit and Cash Management | ||||
F03B31 Customer Activity Log |