Functional Description
Purpose
This business function accepts a parameter list of fields as input. Depending on whether it finds an
existing record for the key fields (AN8,MCU,DCTO,ITM,LNTY,SRP1,SRP2,SRP3,SRP4,SRP5,FY) it either
creates or updates the Sales Summary History (F4229) file with the parameters' values.
Setup Notes and Prerequisites
At this time ACCESS can't have more than 10 key fields. SRP5 will not be a key field at this time.
Special Logic
None.
Technical Specification
2.2Related Tables
Table Table Description
F4229Sales Summary History
2.3Related Business Functions
Source NameFunction Name
2.4Processing
Verify that the Sales Summary (F4229) record exists for the key fields
(AN8,MCU,DCTO,ITM,LNTY,SRP1,SRP2,SRP3.SRP4,FY).
If NO record was found in F4229:
Retrieve the default value for the Century (CTRY) field from the Data Dictionary.
Load SSMCU with CostCenter passed in.
Load SSAN8 with AddressNumber passed in.
Load SSFY with Fiscal Year passed in.
Load SSCTRY with the default value.
Load SSDCTO with OrderType passed in.
Load SSITM with IdentifierShortItem passed in.
Load SSSRP1 - 5 with SalesReportingCodes passed in.
Load SSLITM with Identifier2ndItem passed in.
Load SSAITM with Identifier3rdItem passed in.
Load SSDLIJ with DateTransactionJulian passed in.
Move zeros to SSCI01 - SSCI14
Move zeros to SSAS01 - SSAS14
Move zeros to SSQS01 - SSQS14
Add PQOR to SSSQxx where xx is the parameter PN.
Add AEXP to SSASxx where xx is the paramter PN.
If PRFT is equal 'Y'
Add ECST to SSCIxx where xx is the parameter PN.
end
Add AEXP to SSCMS
Add AEXP to SSCYS
Add ECST to SSCMC
Add ECST to SSCYC
Write (Insert) the Sales Summary History (F4229) record.
If record exists in F4229:
Add PQOR to SSSQxx where xx is the parameter PN.
Add AEXP to SSASxx where xx is the paramter PN.
If PRFT is equal 'Y'
Add ECST to SSCIxx where xx is the parameter PN.
end
Add AEXP to SSCMS
Add AEXP to SSCYS
Add ECST to SSCMC
Add ECST to SSCYC
Update the Sales Summary History(F4229) record.
^
D4200560 - UpdateSalesSummaryHistory
Special Input Expected
MCUCostCenterKey field
AN8AddressNumberKey field
DCTOOrderTypeKey Field
ITMIdentifierShortItemKey Field
LNTYLineTypeKey Field
SRP1SalesReportingCode1Key Field
SRP2SalesReportingCode2Key Field
SRP3SalesReportingCode3Key Field
SRP4SalesReportingCode4Key Field
SRP5SalesReportingCode5
FYFiscalYear1Key Field
AEXPAmountExtendedPrice
ECSTAmountExtendedCost
LITMIdentifier2ndItem
AITMIdentifier3rdItem
TRDJDateTransactionJulian
CRYRCurrencyConverYNAR
PNPeriodNoGeneralLedge
PQORQtyShippedInPrimary
PRFTIncldSaleCogsFrGrossInclude Sales/COGS for Gross Profit
CRRCurrencyConversionRate
CRCDDomestic Currency Code
CRDCForeign Currency Code
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szCostCenter | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
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
| ||||
szOrderType | DCTO | char | NONE | 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
| ||||
mnShortItem | ITM | MATH_NUMERIC | NONE | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szLineType | LNTY | char | NONE | NONE |
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
| ||||
szSalesRptCode1 | SRP1 | char | NONE | NONE |
One of ten category codes for sales coding purposes. These codes can represent such classifications as color, material content, or use. | ||||
szSalesRptCode2 | SRP2 | char | NONE | NONE |
One of ten category codes for sales coding purposes. These codes can represent such classifications as color, material content, or
| ||||
szSalesRptCode3 | SRP3 | char | NONE | NONE |
One of ten category codes for sales coding purposes. These codes can represent such classifications as color, material content, or use. | ||||
szSalesRptCode4 | SRP4 | char | NONE | NONE |
One of ten category codes to be used for sales coding purposes. These codes can represent such classifications as color, material
| ||||
mnFiscalYear1 | 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
| ||||
szSalesRptCode5 | SRP5 | char | NONE | NONE |
One of ten category codes to be used for sales coding purposes. These codes can represent such classifications as color, material
| ||||
mnAmtExtPrice | AEXP | MATH_NUMERIC | NONE | NONE |
The number of units multiplied by the unit price. | ||||
mnAmtExtCost | ECST | MATH_NUMERIC | NONE | NONE |
For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
| ||||
sz2ndItem | LITM | char | NONE | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
sz3rdItem | AITM | char | NONE | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
jdTransDate | TRDJ | JDEDATE | NONE | NONE |
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing. | ||||
cCurrencyConv | CRYR | char | NONE | NONE |
A code that specifies whether to use multi-currency accounting, and the method of multi-currency accounting to use:
Codes are:
N Do not
| ||||
mnPeriodNoGL | 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
| ||||
mnQtyShippedInPrimary | PQOR | MATH_NUMERIC | NONE | NONE |
The quantity ordered by the customer expressed in the primary stocking unit of measure. | ||||
cIncldSaleCogsFrGross | PRFT | char | NONE | NONE |
A code that indicates that the system includes sales and cost of goods sold in gross profit calculations.
In World software, valid values are:
| ||||
cErrorCode | ERRC | char | NONE | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
szErrorMessage | DTAI | char | NONE | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
cSuppressError | EV03 | char | NONE | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
|
None |
F4229 Sales Summary History File |