Functional Description
Purpose
This business function is used by the Manufacturing Journal Entries UBE (R31802A). It is called by the Work Order Processing (B3104170)
business function. Its purpose is to calculate Planned and Actual production costs and to create F0911 journal entries for unaccounted hours and quantities.
Setup Notes and Prerequisites
There are no special prerequisites or setup notes for this function.
Technical Specifications
For each Work Order Routing (F3112) record (for the work order passed into the function)
If the Branch has changed
Retrieve the Mfg. Constants
If the Work Center has changed
Retrieve Work Center Master Data
Get Work Center Rates
If Overhead values are stored as percents
Convert the overhead values
If a Restated Quantity exists
Calculate Run Labor and Machine Labor for the Restated Quantity
Calculate Planned and Actual Amounts for B1 - C4
If the Routing step is an outside operation
If an F3102 record exists for the Cost Type
Retrieve the F3102 record
If no F3102 record exists for the Cost Type
Add a F3012 record
Retrieve the outside operation unit cost
Calculate Planned and Actual Amounts for the outside operation
Update the F3102 Variance Cache with the new amounts
If the Actual Amount is not equal to zero
Create journal entries for the Actual Amount
Retrieve the next F3112 Routing record
If the Work Center value has changed
For Cost Types B1-C4
Update F3102 Variance Cache with new Planned and Actual Amounts
If Accrual Journal Entries were not requested
Process Extra Costs by reading through F30026 or F300261. For each record found
Calculate Planned and Actual Amounts
Update the F3102 Variance Cache with the new amounts
If the Actual Amount is not equal to zero
Create journal entries for the actual amount
Update the Work Order Cache with the first and last journal entry line numbers for the work order.
D3104190 - Shop Floor Processing
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnWorkOrderNumber | DOCO | MATH_NUMERIC | OPT | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szErrorMessageID | DTAI | char | OPT | 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
| ||||
cFinalMode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cSumAcrossWO | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cSumWinWO | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cDefaultWOToSubledger | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cFlexAccounting | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cChargeToCC | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szWorkOrderBranch | MMCU | char | OPT | NONE |
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which
| ||||
szWorkOrderCompany | CO | char | OPT | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
szWorkOrderBusinessUnit | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szWorkOrderUOM | UOM | char | OPT | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
mnParentItemNumber | ITM | MATH_NUMERIC | OPT | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szParentSecondItemNo | LITM | char | OPT | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
szCostMethod | LEDG | char | OPT | NONE |
A user defined code (40/CM) that specifies the basis for calculating item costs. Cost methods 01 through 19 are reserved for J.D. Edwards
| ||||
mnWorkOrderQty | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
mnRestatedQuantity | SOQS | MATH_NUMERIC | OPT | NONE |
The number of units committed for shipment in Sales Order Entry, using either the entered or the primary unit of measure defined for this
| ||||
szParentPrimaryUOM | UOM | char | OPT | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
cPotencyControl | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnStandardPotency | STDP | MATH_NUMERIC | OPT | NONE |
The percentage of active ingredients normally found in an item. | ||||
szStdUOMConversion | TFLA | char | OPT | NONE |
Allows you to bypass the item-specific unit of measure and use the standard unit of measure. Valid values are:
blank Use the item-specific
| ||||
szShopFloorDocType | DCT | char | OPT | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
mnConversionFactor | CONV | MATH_NUMERIC | OPT | NONE |
The factor that the system uses to convert one unit of measure to another unit of measure. | ||||
mnDocumentNumber | DOCO | MATH_NUMERIC | OPT | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szOrderType | DCOT | char | OPT | NONE |
This code defines the order type. It is verified in User Defined Codes,system code '00', record type 'DT'. Reserved document types have
| ||||
szCurrencyCode | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
szParentGLCategory | GLPT | char | OPT | NONE |
A user defined code (41/9) that identifies the G/L offset that system uses when it searches for the account to which it posts the transaction. If
| ||||
szParentExplanation | EXA | char | OPT | NONE |
A description, remark, explanation, name, or address. | ||||
cCurrencyConverYNAR | CRYR | char | OPT | 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
| ||||
jdDate | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
szProgramId | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
szLanguagePreference | LNPOW | char | OPT | NONE |
The language that you want to use to print reports or documents, or to view information on the form. | ||||
szWorkStationId | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
jdGLDate | DGL | JDEDATE | OPT | NONE |
A date that identifies the financial period to which the transaction is to be posted.
The company constants specify the date range for each
| ||||
mnBatchNumber | ICU | MATH_NUMERIC | OPT | NONE |
A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
| ||||
jdBatchDate | DICJ | JDEDATE | OPT | NONE |
The date of the batch. If you leave this field blank, the system date is used. | ||||
szBatchType | ICUT | char | OPT | NONE |
A code that specifies the system and type of transactions entered in a batch. The system assigns the value when you enter a transaction.
| ||||
szCacheJobNumber | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
cOutsideOpHeaderStack | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnJobNumberHours | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
cCostByWC | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cWCAccrualJEs | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szItemDescription | DSC1 | char | OPT | NONE |
Brief information about an item; a remark or an explanation. | ||||
cSumAcrossWORpt | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
idPPATPointer | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
mnUnaccParentUnits | MN29D9 | MATH_NUMERIC | OPT | NONE |
This is a generic field used as a work field in Everest. | ||||
mnUnaccParentScrap | MN29D9 | MATH_NUMERIC | OPT | NONE |
This is a generic field used as a work field in Everest. | ||||
szSubledger | SBL | char | OPT | NONE |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
| ||||
cSubledgerType | SBLT | char | OPT | NONE |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
| ||||
szWorkOrderSubsidiary | SUB | char | OPT | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
szProjectGLCategory | GLPT | char | OPT | NONE |
A user defined code (41/9) that identifies the G/L offset that system uses when it searches for the account to which it posts the transaction. If
|
None |
None |