send feedback

❮ Previous Next ❯

Receipt Routing interface for JD Edwards

Corresponding EnterpriseOne Application

In EnterpriseOne, the application you would run to insert Receipt Routing is P43250. The menu to find P43250 is G43A14.

Processing options

Processing options for Receipt Routing interface.

The processing options version will default to ZJDE0001 if not otherwise specified in the parameter list on the call. Please note that, even if we are not directly using a particular processing option, it does not mean that it does not matter when running the interface, as JDE may use it.

Defaults tab

Order Type (szPO_OrderType_DCTO): The value of this field will be used as the default order type if no order type was provided, and a value was entered into this field.
Operation Code (szPO_OperationCode_OPRC): This field will be used to set the “from” operation code if, 1) the “from” operation code is blank (in the dcLINK data structure), and 2) this field is not equal to blank.

Process tab

To Operation Control (cPO_ToOperControl_EV02): This will control the operation codes and the order in which they can be used.
Last Status Code (szPO_LastStatusCode_LTTR): This field will be used as the Default Replacement Last Status Code (szRPLStatusCodeLast_LTTR) if no replacement status code was provided.
Next Status Code (szPO_NextStatusCode_NXTR): This field will be used as the Default Replacement Next Status Code (szRPLStatusCodeNext_NXTR) if no replacement status code was provided.

Processing option data structure for DD3N4302

The interface retrieves these parameters by calling BD3N4302.They are passed back in the following data structure.

Type	Description	Parameter
String	szPO_Version_VERS	Input
String	szPO_OrderType_DCTO	Output
String	szPO_OperationCode_OPRC	Output
Char	cPO_DisplayInvOper_EV01	Output
Char	cPO_ToOperControl_EV02	Output
String	szPO_LastStatusCode_LTTR	Output
String	szPO_NextStatusCode_NXTR	Output
String	szPO_LineType_LNTY	Output
String	szPO_P4312Version_VERS	Output
String	szP31114Version_VL30	Output
String	szPO_P43214Version_VL01	Output
String	szPO_UnscheduledDropCode_OPRC	Output
String	szPO_P4310Version_VL03	Output
String	szPO_P3711Version_VER1	Output
String	szPO_P49655Version_VERS	Output
Char	cPO_EmailPlanner_EV01	Output
String	szPO_TypeTransaction_TYTN	Output
String	szP4310BVersion_VL02	Output
Char	cEmailOriginator_EV01	Output
Char	cShowHideUCC128_EV01	Output
String	szSSCCValidationFunction_FNNM	Output
String	szCreditLineType_LNTY	Output
String	szVersionP43252_VERS	Output
Char	cEmailProjectManager_EV01	Output
Char	cEmailBuyer_EV01	Output
Char	cEmailSupplier_EV01	Output
String	szPO_AutoSelect_VL07	Output
Char	cRepriceReceiptRouting_EV01	Output

Processing

There are two primary activities that can be performed by this function – movement and disposition.

A combination of the cActionCode and cdcLINKActionCode are used to specify which activity will happen.

In order to perform movement activities, the cActionCode needs to be set to a ‘1'. Then, the cdcLINKActionCode is used to specify whether the movement will be done by order number, tare number, pack number, or EPC. A movement transaction will only move it to the next operation step that is set up for that route.

An OPSelectionExit of “4”, along with a cActionCode of ‘1', and cdcLINKActionCode of ‘A' calls the multi-location processing that allows the user to assign the quantity to a new lot of location. In this case, it will not advance the quantity to the next operation. If a movement transaction is being run using multi-location, but a different location or lot is not entered, then the dcLINK function will process the transaction as a split line instead.

A cActionCode of “2” allows the user to dispose of a given amount of an item, instead of moving it to the next operation code. When an item is disposed it may be returned, reworked, scrapped, rejected, or adjusted. The user may also enter a Reason Code field value that further explains why a quantity was disposed.

Action code	dcLINK action code	Description
1	A	Move the quantity based on order number.
1	B	Move the quantity based on tare number.
1	C	Move the quantity based on pack number.
1	D	Move the quantity based on EPC number.
2		Dispose of a quantity.

Required fields

There are several options available when using this interface.

For a basic move, the interface requires the user to supply the action code, dcLINK action code, order number, line number, receipt line number, quantity to move, option code, from operation code, to operation code, and selection exit as a minimum. The item associated with the line number will be moved to the next operation code upon successful completion of the transaction. The amount moved will equal the quantity sent in on the call.

For a basic disposition, the following fields are required: action code, order number, the quantity to dispose of (in one of the five disposal fields), line number, receipt line number, and selection exit.

Verify the processing

Steps to verify the processing of Receipt Routing interface.

Most steps in receipt routing simply promote the item being processed to the next operation code.

To verify the processing, complete the following steps in JDE.

Open the EnterpriseOne Movement and Disposition program P43250.
Go to the menu G43A14.
Inquire on the order/line that was just processed and verify that the quantity you specified was moved to the next operation code.

Step Information

The Ledger Inquiry program, P43252, can also be used to verify that a transaction completed. This program is a log of what has happened in receipt routing, including both movements and dispositions.

Once in every route code, an item can be designated to be received into stock. If the operation code that the item was moved to happens to be the one set up to receive the item, then you also need to check CARDEX and summary availability to verify that, for the item being processed, the correct quantity was received into stock.

Input data structure

Input data structure for DD3N430A.

Name	Default value	R/O	Alias	Notes
cdcLINKActionCode_EV01	A	X	EV01	A = Order Number B = Tare Number C = Pack Number D = EPC Number This will default to ‘A' if not passed in.
cActionCode_ACTION		R	ACTION	If left blank, error number 0961 will be generated. 1 = Move 2 = Disp
jdDateUpdated_UPMJ	(Current Date)	X	UPMJ	Retrieved from GetAuditInfo.
mnTimeOfDay_TDAY	(Current Time)	X	TDAY	Retrieved from GetAuditInfo.
szUserId_USER	(Current User)	X	USER	Retrieved from GetAuditInfo.
szWorkStationId_JOBN	(Current Workstation)	X	JOBN	Retrieved from GetAuditInfo.
mnJobNumber_JOBS		O	JOBS	Assigned by Begin Document.
szProgramId_PID	EP43250	X	PID	Defaulted in program if not passed in. Any use of a program id (szProgramID_PID) other than what is defaulted in may result in odd results. In this case, anything other than EP43250 may cause problems with such things as proper costing, journal entries, etc.
szVersion_VERS	ZJDE0001	X	VERS	Defaulted in program if not passed in.
cSuppressErrMsg_EV01		O	EV01
cErrorCode_ERRC		X	ERRC	Returned from program.
szErrorMessageKey_EKEY		X	EKEY	Returned from program.
iDebugLevel_INT01		O	INT01	Leave blank except for debugging and testing purposes only. When running xml, pass in a ‘99' to get a server debug log. When running fat client, it will display M&D Debug statements if the value is greater than “0”.
cOPSelectionExit_EV01		R	EV01	“1” = Receipt Routing Movement Processing. “2” = Receipt Routing Disposition Processing. “4” = Receipt Routing Movement Processing with multi-location support. The cdcLINKActionCode MUST be an ‘A' if using multi-location.
jdDateReceived_RCDJ		O	RCDJ	If left blank, this will default to today's date.
szBranchPlant_MCU		O	MCU	If left blank, this will be retrieved by reading the master file. This field is then used when reading the F43091 Read/Write Routing Operations Cache.
jdGLDate_DGL		O	DGL	If entered, this is validated by the F0008 Edit Date business function.
mnOrderNumber_DOCO		C	DOCO	Required if cdcLINKActionCode_EV01 is equal to ‘A'
szOrderType_DCTO	(Processing Options)	X	DCTO	If blank, this field will default in from the processing options.
szCompanyKeyOrderNo_KCOO		O	KC00	If left blank, this will be retrieved by reading the master file. It will be used to retrieve the domestic currency code.
mnOrderLineNumber_LNID		O	LNID	Not used in this interface.
mnReceiptLineNumber_NLIN		O	NLIN	Not used in this interface.
szUnknownItemNumber_UITM		O	UITM	If entered, this item number will be used to derive the short item number. The short item number will be used to compare to the item number in the F43092 file. A match indicates the correct record has been found.
szContainerID_CNID		O	CNID	Not used in this interface.
szFromOperationCode_OPRC	(Processing Options)	O	OPRC	If blank, this field will default in from the processing options. If it is not equal to blanks, this field is compared to the operation code stored in the F43092. If they are not the same, the record the F43092 record is skipped.
szToOperationCode_OPRT		O	OPRT	If this field is left blank, it will default to the operation code retrieved from the F43091 Read/Write Routing Operations Cache business function. It also must be a valid code in the 43/OC UDC table.
mnQuantityToMove_QTYM		O	QTYM	If this field is left blank, the quantity at operation for the selected record in the F43092 will be used. If this is a multi-location transaction, then the quantity here will not be used.
szMoveUOM_UOM		O	UOM	If this field is left blank, the unit of measure for the selected record in the F43092 will be used.
mnOpSeq_OPRS		O	OPRS
cReplaceDisposition_RPL		X	RPL	If blank, this field is defaulted to an “N”.
mnQuantityReturned_QTYR		O	QTYR	If a disposition is being processed (Selection exit is equal to “2”), then this field is passed into the F43092 Edit Line master business function.
mnQuantityReworked_QTYW		O	QTYW	If a disposition is being processed (Selection exit is equal to “2”), then this field is passed into the F43092 Edit Line master business function.
mnQuantityScrapped_QTYC		O	QTYC	If a disposition is being processed (Selection exit is equal to “2”), then this field is passed into the F43092 Edit Line master business function.
mnQuantityRejected_QTYJ		O	QTYJ	If a disposition is being processed (Selection exit is equal to “2”), then this field is passed into the F43092 Edit Line master business function.
mnQuantityAdjusted_QTYA		O	QTYA	If a disposition is being processed (Selection exit is equal to “2”), then this field is passed into the F43092 Edit Line master business function.
szReasonCodeRet_RCD		O	RCD	If a disposition is being processed (Selection exit is equal to “2”), then this field is passed into the F43092 Edit Line master business function.
szReasonCodeRew_RCD		O	RCD	If a disposition is being processed (Selection exit is equal to “2”), then this field is passed into the F43092 Edit Line master business function.
szReasonCodeScr_RCD		O	RCD	If a disposition is being processed (Selection exit is equal to “2”), then this field is passed into the F43092 Edit Line master business function.
szReasonCodeRej_RCD		O	RCD	If a disposition is being processed (Selection exit is equal to “2”), then this field is passed into the F43092 Edit Line master business function.
szReasonCodeAdj_RCD		O	RCD	If a disposition is being processed (Selection exit is equal to “2”), then this field is passed into the F43092 Edit Line master business function.
mnQBEOrNum_DOCO		O	DOCO	For future use.
szQBEOrTy_DCTO		O	DCTO	For future use.
szQBEOrCo_KCOO		O	KCOO	For future use.
mnQBELineNum_LNID		O	LNID	If entered, this number will be used to compare to the line number in the F43092 file.
mnQBEReceiptLineNumb_NLIN		O	NLIN	If entered, this number will be used to compare to the receipt line number in the F43092 file. A match indicates the correct record has been read from the F43092 file.
szQBEBranchPlant_MCU		O	MCU	For future use.
szQBEOrSuf_SFXO		O	SFXO	For future use.
mnQBESupplier_AN8		O	AN8	For future use.
szQBEContainerID_CNID		O	CNID	For future use.
szQBERouteCode_NROU		O	NROU	For future use.
szQBEOperCode_OPRC		O	OPRC	For future use.
szQBEUM_UOM		O	UOM	For future use.
mnQBEOperSeq_OPRS		O	OPRS	For future use.
cQBEPay_PMTE		O	PMTE	For future use.
mnQBEQtyAtOp_QTYO		O	QTYO	For future use.
cQBERecAck_RCPT		O	RCPT	For future use.
szQBEUpdateItmLocn_UPIB		O	UPIB	For future use.
szlQBE2ndItem_LITM		O	LITM	For future use.
mnQBEShortItem_ITM		O	ITM	For future use.
szQBE3rdItemNumber_AITM		O	AITM	For future use.
szQBELocation_LOCN		O	LOCN	For future use.
szQBELotSerial_LOTN		O	LOTN	For future use.
cBTNSelectLocation_EV01		O/M	EV01	Multi-location processing will be initiated if either the selection exit is set to a “4”, or this field (used to simulate that the multi-location button was pressed) is set to a “1”. Multi-location only.
szSLIssueBranchPlant_MCU		O/M	MCU	This is the branch plant for the multi-location line.
szSLIssueLocation_LOCN		O/M	LOCN	This is the location for the multi-location line.
szSLIssueLot_LOTN		O/M	LOTN	This is the lot for the multi-location line.
mnSLIssueQuantity_SOQS		O/M	SOQS	This is the quantity for the multi-location line.
szSLIssueMemoLotField1_LOT1		O/M	LOT1	For future use.
szSLIssueMemoLotField2_LOT2		O/M	LOT2	For future use.
szSLIssueVendorLotNumber_RLOT		O/M	RLOT	For future use.
jdSLIssueLotExpirationDte_MMEJ		O/M	MMEJ	This is the lot expiration date for the multi-location line.
jdRPLDateTransaction_TRDJ		X	TRDJ	If not entered, this will default to today's date.
jdRPLDateRequested_DRQJ		X	DRQJ	If not entered, this will default to today's date.
jdRPLPromisedDeliveryDate_PDDJ		X	PDDJ	If not entered, this will default to today's date.
szRPLStatusCodeLast_LTTR	(Processing Options)	X	LTTR	If blank, this field will default in from the processing options.
szRPLStatusCodeNext_NXTR	(Processing Options)	X	NXTR	If blank, this field will default in from the processing options.
szRPLDescriptionLine1_DSC1		X	DSC1	If not entered, this will default from the F4101 Item Master file.
szRPLDescriptionLine2_DSC2		X	DSC2	If not entered, this will default from the F4101 Item Master file.
szRPLSupplierSO_VR01		O	VR01	This field is used to indicate the replacement supplier and is passed in using the Edit Document.
szTareNumber_PLT		O	PLT	Required if cdcLINKActionCode_EV01 is equal to ‘B'
szPackNumber_PAK		O	PAK	Required if cdcLINKActionCode_EV01 is equal to ‘C'
mnSecondaryQty_SQOR		O	SQOR	If the item is a DUAL unit of measure item this is the secondary quantity.
szSecondaryUoM_UOM2		O	UOM2	If this item is a DUAL unit of measure item this is the secondary unit of measure.
mnShipmentNumber_SHPN		O	SHPN	For future use.
mnQBEShipmentNumber_SHPN		O	SHPN	For future use.
szQBETare_PLT		O	PLT	For future use.
szQBEPack_PAK		O	PAK	For future use.
szQBESCC_SCCN		O	SCCN	For future use.
szQBESCCUoM_SCUM		O	SCUM	For future use.
mnQBESCCQuantity_SCCQ		O	SCCQ	For future use.
szQBEUPC_UPCN		O	UPCN	For future use.
szQBEUPCUoM_UPUM		O	UPUM	For future use.
mnQBEUPCQty_UPQT		O	UPQT	For future use.
mnSLIssueSecondaryQty_DQTY		O	DQTY	This is the dual unit of measure quantity for the multi-location line.
szSLIssueSecondaryUOM_UOM2		O	UOM2	This is the dual unit of measure unit of measure for the multi-location line.
jdSLIssueBasedOnDate_BODJ		O	BODJ	For future use.
jdSLIssueLotEffectiveDate_DLEJ		O	DLEJ	For future use.
cSLIssueLotStatusCode_LOTS		O	LOTS	For future use.
szContainerSerialEPC_CTSN		O	CTSN	For future use.
szCountryOfOrigin_ORIG		O	ORIG	This field is available in 9.1 and higher only. For future use.
szSLIssueCountryOfOrigin_ORIG		M	ORIG	This field is available in 9.1 and higher only. For future use.
szGuidUniqueID_GUID	Automatically generated by dcLINK	O	CFRGUID	If generate GUIDs is turned on in the dcLINK configuration utility, this field will contain a GUID (guaranteed unique identifier). The GUID is used to tie database changes in PeopleSoft to the transactions that triggered those changes to occur.
szGuidApprover1_USR1		O,R	USR1	An entry in this field or the Approver 2 field will cause a signature capture record to be written. Signature capture records are part of the GUID processing and should not be used unless a GUID is being created by dcLINK. The value of this field is a User ID, not an address book entry. There must be a value passed in to either this field, or the approver 2 field, otherwise it is an error.
szGuidFullName1_FULLNAME1		O	FULLNAME1	This field is the full name of the GUID Approver 1.
szGuidApprover2_USR2		O,R	USR2	GUID processing supports up to two approvers. If two approvers are required, this is the user ID of the second approver. There must be a value passed in to either this field or the approver 1 field otherwise it is an error.
szGuidFullName2_FULLNAME2		O	FULLNAME2	This field is the full name of the GUID Approver 2.
mnGuidReasonCode1_REASON1		O,R	REASON1	If either of the approver fields contains a value, but no value is entered into one of the reason code fields, then an error will be returned. Reason codes must match the valid reason codes setup for GUID processing, otherwise it is an error.
szGuidCommentField_COMMENTS		O	COMMENTS	This is a free form entry field that is used to further explain the reason code entered into the previous field.
mnGuidReasonCode2_REASON2		O,R	REASON2	If either of the approver fields contains a value, but no value is entered into one of the reason code fields, then an error will be returned. Reason codes must match the valid reason codes setup for GUID processing, otherwise it is an error.
szGuidCommentField2_2COMMENTS		O	2COMMENTS	This is a free form entry field that is used to further explain the reason code entered in the previous field.
szGuidScriptID_FMNMVERS		O	FMNMVERS	In PeopleSoft the screen ID where the change was made is captured. dcLINK captures the script ID.
szGuidTextMessage_TEXTMES		O	TEXTMES	This is a free form entry field.

O = Optional

R = Required

X = Required, but will default in if not passed

Transaction test scenarios

The following test scenarios demonstrate a variety of ways in which this interface could be used, and the fields that would be passed for each scenario.

The data structure fields are in the left column, and the corresponding values for each scenario are listed by column.

Field name	Basic movement	Movement using MLS	Dispose of an item - Rejected	Dispose of an item - scrapped - no reason code
szUserId_USER
szProgramId_PID
mnOrderNumber_DOCO	5166	5163	5163	5163
szOrderType_DCTO	OP	OP	OP	OP
szCompanyKeyOrderNo_KCOO	00001	00001	00001	00001
mnOrderLineNumber_LNID
mnReceiptLineNumber_NLIN
szFromOperationCode_OPRC
szToOperationCode_OPRT
mnQuantityToMove_QTYM	3
mnQuantityAdjusted_QTYA
mnQuantityRejected_QTYJ			1
mnQuantityReturned_QTYR
mnQuantityReworked_QTYW
mnQuantityScrapped_QTYC				1
szReasonCodeAdj_RCD
szReasonCodeRej_RCD			DIS
szReasonCodeRet_RCD
szReasonCodeRew_RCD
szReasonCodeScr_RCD
cReplaceDisposition_RPL
jdDateReceived_RCDJ
jdGLDate_DGL
mnTimeUpdated_TDAY
szUnknownItemNumber_UITM
szBranchPlant_MCU	30	30	30	30
szContainerID_CNID
cdcLINKActionCode_EV0
mnOpSeq__OPRS
szWorkStationId_JOBN
szVersion_VERS	DSI0001	DSI0001	DSI0001	DSI0001
cActionCode_ACTION	1	1	2	2
jdDateUpdated_UPMJ
mnJobNumber_JOBS
cSuppressErrMsg_EV0
cErrorCode_ERRC
szErrorMessageKey_EKEY
iDebugLevel_INT0
mnQBEOrNum_DOCO
szQBEOrTy_DCTO
szQBEOrCo_KCOO
mnQBELineNum_LNID	1	1	1	1
mnQBEReceiptLineNumb_NLIN	1	2	2	2
szQBEBranchPlant_MCU
szQBEOrSuf_SFXO
mnQBESupplier_AN8
szQBEContainerID_CNID
szQBERouteCode_NROU
szQBEOperCode_OPRC
szQBEUM_UOM
mnQBEOperSeq_OPRS
cQBEPay_PMTE
mnQBEQtyAtOp_QTYO
cQBERecAck_RCPT
szQBEUpdateItmLocn_UPIB
szIQBE2ndItem_LITM
mnQBEShortItem_ITM
szQBE3rdItemNumber_AITM
szQBELocation_LOCN
szQBELotSerial_LOTN
cOPSelectionExit_EV0	1	4	1	1
szMoveUOM_UOM
cBTNSelectLocation_EV0		1
szSLIssueBranchPlant_MCU		30
szSLIssueLocation_LOCN		1 A 1
szSLIssueLot_LOTN		00036
mnSLIssueQuantity_SOQS		5
szSLIssueMemoLotField1_LOT
szSLIssueMemoLotField2_LOT
szSLIssueVendorLotNumber_RLOT
jdSLIssueLotExpirationDte_MMEJ		12/31/25
jdRPLDateTransaction_TRDJ
jdRPLDateRequested_DRQJ
jdRPLPromisedDeliveryDate_PDDJ
szRPLStatusCodeLast_LTTR
szRPLStatusCodeNext_NXTR
szRPLDescriptionLine1_DSC
szRPLDescriptionLine2_DSC
szRPLSupplierSO_VR0
szGuidUniqueID_GUID
szGuidApprover1_USR
szGuidFullName1_FULLNAME 50
szGuidApprover2_USR
szGuidFullName2_FULLNAME 50
mnGuidReasonCode1_REASON
szGuidCommentField_COMMENTS
mnGuidReasonCode2_REASON
szGuidCommentField2_2COMMENTS
szGuidScriptID_FMNMVERS
szGuidTextMessage_TEXTMES
szTareNumber_PLT
szPackNumber_PAK
mnSecondaryQty_SQOR
szSecondaryUoM_UOM
mnShipmentNumber_SHPN
mnQBEShipmentNumber_SHPN
szQBETare_PLT
szQBEPack_PAK
szQBESCC_SCCN
szQBESCCUoM_SCUM
mnQBESCCQuantity_SCCQ
szQBEUPC_UPCN
szQBEUPCUoM_UPUM
mnQBEUPCQty_UPQT
mnSLIssueSecondaryQty_DQTY
szSLIssueSecondaryUOM_UOM
jdSLIssueBasedOnDate_BODJ
jdSLIssueLotEffectiveDate_DLEJ
cSLIssueLotStatusCode_LOTS
szContainerSerialEPC_CTSN
szCountryOfOrigin_ORIG
szSLIssueCountryOfOrigin_ORIG

Common error messages

The following are common error messages that can be generated by this BF, and what those error messages mean.

Error message	Meaning
0002	Record Invalid. This error is returned when an error has been detected from one of these three business functions: dcLINK Set User ID, dcLINK Utility Set Audit Info, or dcLINK Utility Write Signature Capture Record. It will be set if the cOPSelectionExit_EV01 is ‘1', and the dcLINK Action Code is not equal to ‘A'. It will be set if the record cannot be found in the V43092JA view.
0860	A Required Field Has Been Left Blank. In this interface, this will be set if the dcLINK Action Code is 'B', 'C', or 'D' and the tare, pack, or EPC number is not passed in.
0961	Invalid Selection Code . This will be set when the Action Code is not passed in.
107U	Operation not valid for Receipt Route. This is set when an invalid TO operation code is passed in.
110T	Invalid Action. This is set when using Multi-Location and the update balance bucket in the F43092 won't allow it.
113C	Reserved by. This error occurs when the order is open in the receipt routing application while the transaction is being run.
128X	Invalid UDC Value. In this interface, it is used when an invalid reason code is passed in when doing a disposition.
2717	Overshipment Not Allowed. This is used when the passed-in Quantity Moved is greater than the quantity at operation in the F43092.
4636	Order Number required. This will be set when the dcLINK Action Code is 'A' and an order number is not passed in.

There was a problem loading this topic

Mobile Enterprise Platform