1.1Purpose
The purpose of this business function event rule is to update the Invoice Summary Access file (F48520). The file is a cumulative summary file that stores
invoice amounts by invoice G/L date, employee/supplier number, business unit, object account, subsidiary, contract information, component code and
currency codes, and is used for reporting purposes. The cumulative amounts are kept by the Invoice G/L date of the invoice (WDIDGJ). So, if there are
records existing for 01/10/99, 01/30/99 and 02/28/99 and a record needs to be added for 01/15/99. The amounts from 01/10/99 need to be used as the starting
point for the amounts to be updated for 01/15/99. Also, the amounts from 01/15/99 need to be added to the 01/30/99 and 02/28/99 amounts. If the 01/15/99
record already existed, the 01/15/99, 01/30/99 and 02/28/99 records need to be updated with additional amounts passed in. The function also handles
subtracting amounts from the F48520 records when an invoice is voided. If all the amounts become zero, then the F48520 record is deleted.
Updates/Adds
Access file (F48520).
SUB, CCOD, CRCD, CRCF, IDGL
Only the IDGL (invoice G/L date) would change for each record. All other key values would be the same for all records selected.
$100$250$350$450
SUB, CCOD, CRCD, CRCF, IDGL
Only the IDGL (invoice G/L date) would change for each record. All other key values would be the same for all records selected
01/10/9901/15/9901/30/9902/28/99
$100$150$350$450
Voids
SUB, CCOD, CRCD, CRCF, IDGL
Only the IDGL (invoice G/L date) would change for each record. All other key values would be the same for all records selected
Send in Key info and amounts. Update record and subsequent records by subtracting void amount.
SUB, CCOD, CRCD, CRCF, IDGL
Only the IDGL (invoice G/L date) would change for each record. All other key values would be the same for all records selected
Example: Using current records with the amounts shown starting on 01/10/99 through 02/28/99 for the following dates below
$100$100$200
1.2Setup Notes and Prerequisites
The NER will be called from the Invoice History Review (N48S0410) only if the Billing Constants are set to update the Invoice Summary Access file
(WZISAC = 1).
This function should only be called when the eligibility code for the records is a '1' or a '0'.
1.3Special Logic
D48S0660 - F48520 Update
2.1Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
AN8 Employee/Supplier No IY
MCU Business Unit IY
OBJ Object Account IY
SUB Subsidiary IY
DOCO Contract No IY
DCTO Contract Document Type IY
KCOO Contract Key Co IY
COCH Contract Change Order IY
LNID Contract Line No IY
CCOD Component Code IY
CRCD Base Currency IY
CRCF Foreign Currency IY
ITOL Invoice Total Amount I Y
ITXA Invoice Taxable Amount I Y
ITAM Invoice Tax Amount IY
IDSC Invoice Discount Amount IY
CITL Foreign Invoice Total Amount IY
CITA Foreign Invoice Taxable Amount IY
CITX Foreign Invoice Tax Amount IY
CIDS Foreign Invoice Discount Amount IY
U Units IY
AA Cost Amount IY
IDGJ Invoice Journal Date IY
EV01 Update Or Void flag IY
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
EmpSuppNo | 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
| ||||
BusinessUnit | MCU | char | REQ | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
ObjectAcct | OBJ | char | REQ | NONE |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
Subsidiary | SUB | char | REQ | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
ContractNo | DOCO | MATH_NUMERIC | REQ | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
ContractDocTy | DCTO | char | REQ | NONE |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
ContractKeyCo | KCOO | char | REQ | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
ContractChgOrder | COCH | char | REQ | NONE |
The change number of the contract. The change order number of the base contract is always initialized to 000. Each time you enter a
| ||||
ContractLineNo | LNID | MATH_NUMERIC | REQ | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
CompCode | CCOD | char | REQ | NONE |
A component code identifies a provisional burden that is accounted for at the billing detail transaction level. | ||||
BaseCurrency | CRCD | char | REQ | NONE |
A code that identifies the currency of a transaction. | ||||
ForeignCurrency | CRCF | char | REQ | NONE |
The currency code of the insured amount. | ||||
InvTotalAmt | ITOL | MATH_NUMERIC | REQ | NONE |
The invoice amount for a billing detail transaction. | ||||
InvTaxableAmt | ITXA | MATH_NUMERIC | REQ | NONE |
The portion of the invoice amount that is subject to tax. | ||||
InvTaxAmt | ITAM | MATH_NUMERIC | REQ | NONE |
The tax amount in the invoice. This can be either the sales, use or VAT tax. | ||||
InvDiscountAmt | IDSC | MATH_NUMERIC | REQ | NONE |
The amount of the discount available, as opposed to the amount of the discount actually taken. The discount calculated is based on the
| ||||
ForInvTotalAmt | CITL | MATH_NUMERIC | REQ | NONE |
The total amount of the invoice in foreign currency. | ||||
ForInvTaxableAmt | CITA | MATH_NUMERIC | REQ | NONE |
The portion of the foreign invoice amount that is subject to tax. | ||||
ForInvTaxAmt | CITX | MATH_NUMERIC | REQ | NONE |
The tax amount on the invoice in foreign currency. This can be either the sales, use or VAT tax. | ||||
ForInvDiscountAmt | CIDS | MATH_NUMERIC | REQ | NONE |
The foreign currency amount of the discount available, as opposed to the amount of the discount actually taken. The discount calculated is
| ||||
Units | U | MATH_NUMERIC | REQ | NONE |
The quantity of something that is identified by a unit of measure. For example, it can be the number of barrels, boxes, cubic yards, gallons,
| ||||
CostAmount | AA | MATH_NUMERIC | REQ | NONE |
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a
| ||||
InvJrnlDate | IDGJ | JDEDATE | REQ | NONE |
Special Input Expected
| ||||
UpdateOrVoid | EV01 | char | REQ | NONE |
An option that specifies the type of processing for an event. |
None |
None |