Functional Description
Purpose
This function updates the Invoice Print-related fields (DOC, DCT, KCO, IVD, RESL, LTTR, NXTR and
Audit Information) on the Sales Order Detail table (F4211).It is also used in Sales Update to update these
and some
additional fields.
The Sales Ledger record (F42199) is also written using the business function "Write Sales History Or
Ledger" (B4200260), depending on the "Ledger Y/N" (WRTH) parameter.
Setup Notes and Prerequisites
None.
Special Logic
None.
Technical Specification
2.2 Related Tables
Table Table Description
2.3 Related Business Functions
Source NameFunction Name
B4200260Write Sales History Or Ledger
B9800100Get Audit Information
2.4 Processing
1.If fields DOCO or LNID contain zeros, or fields DCTO, KCOO, LTTR, NXTR, PID or WRTH contain
blanks, return a '1' in the error code field ERRC.
2.Read the F4211 table using DOCO, DCTO, KCOO and LNID as the unique key. If the record cannot
be found, return a '1' in the error code field ERRC.
3.Update fields DOC, DCT, KCO, LTTR, NXTR and PID to F4211 with the values passed to this
function.
Update IVD if the value passed is not zero.
Update RESL if the value passed is '1'.
Update QTYT if the value passed is not zero. 10/26/95
Update DGL if the value passed is not zero. 10/26/95
Clear the foreign fields CRR,FUP,FEA,FUC, and FEC if the Clear Foreign Fields flag is '1'.10/26/95
Update SOQS if the value passed is not zero. 5/10/96
Update SOBK if the value passed is not zero. 5/10/96
Update SOCN if the value passed is not zero. 5/10/96
Update TCST if the value passed is not zero. 5/10/96
Update UNCS if the value passed is not zero. 5/10/96
Update ECST if the value passed is not zero. 5/10/96
Update FEC if the value passed is not zero. 5/10/96
Update AEXP if the value passed is not zero. 5/10/96
Update FEA if the value passed is not zero. 5/10/96
Update UORG if the value passed is not zero. 8/2/96
Update PQOR if the value passed is not zero. 8/14/96
Update SQOR if the value passed is not zero. 8/14/96
Update ITWT if the value passed is not zero. 8/14/96
Update ITVL if the value passed is not zero. 8/14/96
Update fields USER, JOBN, TDAY and UPMJ with the parameters returned from business function "Get
Audit Information" (B9800100).
4.If "Ledger Y/N" (WRTH) is "Y", call business function "Write Sales History Or Ledger"
(B4200260) with the following parameters:
Pointer to F4211=>Ptr to F4211
PID=>Calling Application
USER=>User
JOBN=>Workstation I.D.
'2'=>Mode
UPMJ=>Current Date
TDAY=>Current Time
5. If Transportation on then call N4900010 to update Transportaion tables.
^
D4200460 - Update F4211 Invoice Data
Special Input Expected
DOCOOrder Number
DCTOOrder Type
KCOOOrder Company
LNIDLine Number
DOCInvoice Number
DCTInvoice Type
KCOInvoice Company
LTTRLast Status
NXTRNext Status
IVDInvoice Date
RESLPrinted Code
PIDProgram I.D.
WRTHLedger Y/N
EV01Suppress Error Message0 = Do not suppress any error msgs.
1 = Suppress any error messages.
QTYTQuantity Shipped To Date
DGLGeneral Ledger Date
EV01Clear Foreign Fields1 = Clear foreign fields
0 = DON'T clear foreign fields
SOQSQuantityShippedUpdate if not zero
SOBKQuantityBackorderedUpdate if not zero
SOCNQuantityCancelledUpdate if not zero
UNCSUnitCostUpdate if not zero
TCSTAmount-ExtendedCostTransferUpdate if not zero
ECSTExtendedUnitCostUpdate if not zero
FECForeignExtendedCostUpdate if not zero
AEXPExtendedPriceUpdate if not zero
FEAForeingExtendedPricUpdate if not zero
UORGTransaction QuantityUpdate if not zero
PQORQuantity Ordered PrimaryUpdate if not zero
SQORSecondary QuantityUpdate if not zero
ITWTWeightUpdate if not zero
ITVLVolumeUpdate if not zero
Special Output Returned
ERRCErrorCode0 = No errors in processing
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnOrderNumber | DOCO | MATH_NUMERIC | NONE | 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 | 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
| ||||
szOrderCompany | KCOO | char | NONE | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
mnLineNumber | LNID | MATH_NUMERIC | NONE | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
mnInvoiceNumber | DOC | MATH_NUMERIC | NONE | NONE |
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document
| ||||
szInvoiceType | DCT | char | NONE | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
szInvoiceCompany | KCO | char | NONE | NONE |
A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher,
| ||||
szLastStatus | LTTR | char | NONE | NONE |
A code (system 40/type AT) specifying the last step in the processing cycle that this order line has successfully completed. | ||||
szNextStatus | NXTR | char | NONE | NONE |
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type. | ||||
jdInvoiceDate | IVD | JDEDATE | NONE | NONE |
The date the invoice was printed. The system updates this date when you run the invoice print program in the Sales Order Management
| ||||
cPrintedCode | RESL | char | NONE | NONE |
Indicates what should happen in the event the available quantity of an ordered item is less than the quantity ordered. A B indicates that the
| ||||
szProgramID | PID | char | NONE | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
cLedgerYN | WRTH | char | NONE | NONE |
A code that tells the system to write a record to the history table (F42199 for Sales Order Management and F43199 for Purchase Order
| ||||
cSuppressErrorMessage | EV01 | char | NONE | NONE |
| ||||
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
| ||||
mnQuantityShippedToDate | QTYT | MATH_NUMERIC | NONE | NONE |
The number of units which have passed through the Sales Update process. In Workorder Processing, this field identifies the total quantity
| ||||
jdGeneralLedgerDate | DGL | JDEDATE | NONE | 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
| ||||
cClearForeignFields | EV01 | char | NONE | NONE |
ab
| ||||
mnQtyShipped | SOQS | MATH_NUMERIC | NONE | 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
| ||||
mnQtyBackOrdered | SOBK | MATH_NUMERIC | NONE | NONE |
The number of units backordered in Sales Order Management or in Work Order Processing, using either the entered or the primary unit of
| ||||
mnQtyCancelled | SOCN | MATH_NUMERIC | NONE | NONE |
The number of units canceled in Sales Order or Work Order Processing, using either the entered or the primary unit of measure defined for
| ||||
mnUnitCost | UNCS | MATH_NUMERIC | NONE | NONE |
The amount per unit, derived by dividing the total cost by the unit quantity. | ||||
mnExtCostTransfer | TCST | MATH_NUMERIC | NONE | NONE |
This is the cost of transferring inventory from one branch to another. The method of calculating this transfer cost is maintained in the Inter
| ||||
mnExtUnitCost | 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
| ||||
mnExtUnitCostForeign | FEC | MATH_NUMERIC | NONE | NONE |
The product of the cost of an item, expressed in foreign currency according to the orders exchange rate, times the number of units. | ||||
mnExtendedPrice | AEXP | MATH_NUMERIC | NONE | NONE |
The number of units multiplied by the unit price. | ||||
mnExtendedPriceForeign | FEA | MATH_NUMERIC | NONE | NONE |
The product of the foreign price times the number of units. | ||||
mnQtyOrdered | UORG | MATH_NUMERIC | NONE | NONE |
The quantity of units affected by this transaction. | ||||
mnQtyOrderedInPrimary | PQOR | MATH_NUMERIC | NONE | NONE |
The quantity ordered by the customer expressed in the primary stocking unit of measure. | ||||
mnQtyOrderedSecondary | SQOR | MATH_NUMERIC | NONE | NONE |
If the secondary unit of measure option in Inventory Constants is selected,this field will display on data entry screens. | ||||
mnUnitWeight | ITWT | MATH_NUMERIC | NONE | NONE |
The weight of one unit of an item, expressed in the primary unit of measure. | ||||
mnUnitVolume | ITVL | MATH_NUMERIC | NONE | NONE |
The cubic units occupied by one inventory item. The definition of the unit itself (cubic feet, yards, meters, and so on) is defined in the volume
| ||||
cSalesOrderStatus02 | SO02 | char | OPT | NONE |
A code that indicates if the committed inventory for this sales detail line has been relieved from the On Hand Quantity. A value of 1 reflects
| ||||
mnGenericNumericFieldValue | GENMATH | MATH_NUMERIC | OPT | NONE |
Reserved by J.D. Edwards. Generic math numeric data item. | ||||
szGenericStringFieldValue | GENSTR | char | OPT | NONE |
Reserved by J.D. Edwards. Generic string data item. | ||||
cGenericCharacterValue | GENCHAR | char | OPT | NONE |
Reserved by J.D. Edwards. |
B4000460 Free Ptr To Data Structure | ||||
B4200260 Write Sales History Or Ledger | ||||
B9800100 Get Audit Information |
F4211 Sales Order Detail File |