Fixed Assets Confirmation ND3N1201 interface for JD Edwards
About the Fixed Assets Confirmation interface
The Fixed Assets Confirmation interface is used to confirm the location and quantity of a fixed asset.
In the enterprise system the application name is P1201. The dcLINK version is called ND3N1201. The ND3N1201 interface was written in NER and calls a “C” business function BD3N1201 to retrieve the processing options.
This business function can be called two different ways. ND3N1201 can be called from the scanning device to scan item number and/or unit number with the location and quantity. The EnterpriseOne MBF F1201 Process Master Data is called within the ND3N1201 function and will process the fixed asset to update all of the necessary files. The business function ND3N120 can also be used to scan the fixed assets. This function is written in NER.
After validating the collected data, the function writes records to a temporary table FD3N120W for the user to confirm at a later time. To confirm the records the user is required to run the fixed assets confirmation application PD3N120A that calls the business function ND3N1201.
| Name | Function name | Description |
|---|---|---|
| ND3N1201 |
dcLINKFixedAssetsConfirm |
dcLINK Interface Fixed Assets Confirmation |
| ND3N120 |
dcLINKFixedAssetsConfirmation |
dcLINK Interface Fixed Assets Confirmation NER |
| PD3N120A |
Fixed Asset Confirmation |
|
| DD3N1202 |
dcLINK Interface Fixed Assets |
|
| DD3N120AP |
dcLINK Interface Fixed Assets Confirmation Data Structure |
|
| FD3N120L |
Fixed Asset Confirmation Transaction Counter |
|
| FD3N120P |
Post Report Table |
|
| FD3N120T |
Asset Number Work File |
|
| FD3N120W |
Asset Field Counts |
|
| FD3N120X |
Fixed Asset Confirmation Find/Browse |
|
| VD3N120B |
FD3N120L |
|
| VD3N120C |
Post Report's Business View |
|
| VD3N120D |
FD3N120T |
|
| RD3N120 |
Fixed Asset Confirmation Audit Report |
|
| RD3N120R |
Fixed Assets Confirmation Post Report |
|
| DD3N1201 |
PO Retrieval Asset Search |
|
| BD3N1201 |
PORetrievalAssetSearch |
PO Retrieval Asset Search |
The full name of this interface is ND3N1201 Fixed Assets Confirmation
This interface guide applies to the following JDE versions.
-
EnterpriseOne 8.10
Processing
The characteristics of an item determine which fields are required by the interface. Some characteristics are set at the item master level, and some are set at the item/branch level. The item/branch level always takes precedence over the item master. Refer to the Special Processing Interface Usage Guide for more information.
Processing options
Processing options for Fixed Assets Confirmation.
The DreamWriter will default to ZJDE0001 if not otherwise specified in the parameter list on the call.
Defaults tab
-
Category Code1 (Accounting Class) (szMajorClass_ACL1: This is the accounting class category code UDC that is used to classify assets into groups or families.
-
Category Code2 (Equipment Class) (szSubClass_ACL2): This is the equipment category code UDC that is used as a subclass to further define the accounting class.
-
Category Code3 (szClassCode3_ACL3): This is the manufacturer category code UDC that is used to further define the subclass codes.
-
Category Code4 (szClassCode4_ACL4): This is the model year category code UDC that is used to further define the subclass codes.
-
Category Code5 (szClassCode5_ACL5): This is the usage miles or hours category code that is used to further define the subclass codes.
-
Category Code6 (szClassCode6_ACL6): This is the category code used to further define the subclass codes.
-
Category Code7 (szClassCode7_ACL7): This is the category code used to further define the subclass codes.
-
Category Code8 (szClassCode8_ACL8): This is the category code used to further define the subclass codes.
-
Category Code9 (szClassCode9_ACL9): This is the category code used to further define the subclass codes.
-
Category Code10 (szClassCode0_ACL0): This is the rate group UDC that groups similar items for billing.
Version tab
-
Scheduling Workbench Version (szWOVersion_VERS): This field is used to enter the version of Scheduling Workbench (P48201) program to be used. If left blank, then ZJDE0001 will be used.
-
Select Button Exit (cSelectPO_EV10): This field is used to assign a specific application to the Select Button.
-
Asset Master Version (szAssetMasterVersion_VERS): This field is used to enter the version of the Asset Master (P1201) program to be used. If left blank, then ZJDE0001 will be used.
-
Single Asset Disposal Version (szSingleAssetDisposal_VERS): This field is used to enter the version of the Single Asset Disposal (P12105) program to be used. If left blank, then ZJDE0001 will be used.
Processing option data structure for DD3N3103
The interface retrieves these parameters by calling BD3N1201. They are passed back in the following data structure.
| Type | Description | Parameter |
|---|---|---|
| String |
szPOVersion_VERS |
Input |
| Char |
szMajorClass_ACL1 |
Output |
| Char |
szSubClass_ACL2 |
Output |
| Char |
szClassCode3_ACL3 |
Output |
| Char |
szClassCode4_ACL4 |
Output |
| Char |
szClassCode5_ACL5 |
Output |
| Char |
szClassCode6_ACL6 |
Output |
| Char |
szClassCode7_ACL7 |
Output |
| Char |
szClassCode8_ACL8 |
Output |
| Char |
szClassCode9_ACL9 |
Output |
| Char |
szClassCode0_ACL0 |
Output |
| Char |
szWOVersion_VERS |
Output |
| Char |
cSelectPO_EV10 |
Output |
| Char |
szAssetMasterVersion_VERS |
Output |
| Char |
szSingleAssetDisposal_VERS |
Output |
| String |
szCompany_CO |
Output |
| String |
szEquipmentStatus_EQST |
Output |
| String |
szItemNoUnknownFormat_UITM |
Output |
| String |
szBeginningBalance_VERS |
Output |
Verify the processing
The EnterpriseOne Fixed Asset Master Information program can be used to verify the processing.
To verify the processing, complete the following steps in JDE.
-
Open the EnterpriseOne Fixed Asset Master Information program
-
Highlight the row of the asset and then press the location inquiry row exit or the location row exit.Step InformationThe appropriate changes should have been made to the Location, Quantity, and Date fields.
Input data structure
Input Data Structure for DD3N1202 and DD3N120AP.
Input Data Structure for DD3N1202
| Name | Default values | R/O | Alias | Notes |
|---|---|---|---|---|
| cdcLINKActionCode_EV01 |
0 |
X |
EV01 |
Always defaults to a “0”. No different action takes place based on this code. |
| cActionCode_ACTION |
1 |
O |
ACTION |
|
| 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 |
||
| szProgramId_PID |
ND3N1201 |
X |
PID |
Defaulted in program if not passed in. |
| szVersion_VERS |
ZJDE0001 |
X |
VERS |
Defaulted in program if not passed in. |
| cSuppressErrMsg_EV01 |
O |
EV01 |
||
| cErrorCode_ERRC |
Blanks |
X |
ERRC |
Defaulted in program. |
| szErrorMessageKey_EKEY |
Blanks |
X |
EKEY |
Defaulted in program. |
| iDebugLevel_INT01 |
O |
INT01 |
Displays M&D Debug statements if the value is greater than “0”. |
|
| mnAssetItemNumber_NUMB |
R |
NUMB |
A valid Asset Item Number and/or Unit Number value must be entered. If Unit Number is entered and Asset Item Number is left blank, then the function will default in the value from the F1201. At least one of these two number fields is required. |
|
| szUnitNumber_APID |
R |
APID |
A valid Asset Item Number and/or Unit Number value must be entered. If Asset Item Number is entered and unit number is left blank, then the function will default in the value from the F1201. At least one of the two number fields is required. |
|
| szCostCenterLocation_LOC |
F1201 Expected Location |
X |
LOC |
Required field - if a value isn't entered, then the function will default in the F1201 location for the item. |
| mnAssetItemCurrentQuan_ARCQ |
F1201 Expected Quantity |
X |
ARCQ |
If a value isn't entered, then the function will default in the F1201 quantity for the item. |
| Globally Unique Identifier (GUID) Fields |
GUID values are all optional unless a business must comply with FDA 21 CFR Part 11 auditing requirements. Refer to Special Processing Interface Usage Guide for GUID Input Data Structure details. |
|||
O = Optional
X = Required but will default if not passed
C = Conditional (see notes for conditions)
Input Data Structure for DD3N120AP
| Name | Default values | R/O | Alias | Notes |
|---|---|---|---|---|
| cdcLINKActionCode_EV01 |
0 |
X |
EV01 |
Always defaults to a “0”. No different action takes place based on this code. |
| cActionCode_ACTION |
1 |
O |
ACTION |
|
| 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 |
||
| szProgramId_PID |
ND3N120 |
X |
PID |
Defaulted in program if not passed in. |
| szVersion_VERS |
ZJDE0001 |
X |
VERS |
Defaulted in program if not passed in. |
| cSuppressErrMsg_EV01 |
O |
EV01 |
||
| cErrorCode_ERRC |
Blanks |
X |
ERRC |
Defaulted in program. |
| szErrorMessageKey_EKEY |
Blanks |
X |
EKEY |
Defaulted in program. |
| iDebugLevel_INT01 |
O |
INT01 |
Displays M&D Debug statements if the value is greater than “0”. |
|
| mnAssetItemNumber_NUMB |
R |
NUMB |
A valid Asset Item Number and/or Unit Number should be entered. If Unit Number is entered and Asset Item Number is left blank, then the function will default in the value from the F1201. At least one of these two number fields is required. |
|
| szUnitNumber_APID |
R |
APID |
A valid Asset Item Number and/or Unit Number should be entered. If Asset Item Number is entered and Unit Number is left blank, then the function will default in the value from the F1201. At least one of these two number fields is required. |
|
| szCostCenterLocation_LOC |
R |
LOC |
Required field. If a value is not entered, then the function will display an error message. |
|
| mnAssetItemCurrentQuan_ARCQ |
1 |
X |
ARCQ |
If a value is not entered, then the function will default in a value of “1” for the item. |
R = Required
O = Optional
X = Required but will default if not passed
C = Conditional (see notes for conditions)
Additional information
Notes for Fixed Assets.
This interface gives the user the option of processing fixed asset transactions in two ways: by running the business function ND3N1201 from the scanning device, or by using the business function ND3N120AP to scan many transactions, write them to a work file, and then approve them later using the application PD3N120A. That application calls the business function ND3N1201 from the Approve button. Either way the function gets called, all of the necessary files will be updated.
ND3N120AP: When a fixed asset is scanned using the business function ND3N120AP, the Asset Item Number, Unit Number, Location, and Quantity fields will be validated for each transaction. A value must be entered in the Asset Item Number and/or the Unit Number field. The user is also required to enter values for both Location and Quantity. If the user doesn't enter a value for Quantity, the function will use the default of “1”. The record is written to a worktable named FD3N120W and it is stored there until the application PD3N120A is run to confirm the fixed asset.
The initial screen for the PD3N120A is a Find/Browse that lists how many transactions have been scanned by location. Here the user selects a location by highlighting a grid row and clicking the Select button. After that the application displays the Fixed Asset Confirmation screen. Here the user has the opportunity to filter the data by the employee ID that scanned the fixed asset. After the Find button is pressed, all of the fixed assets for the selected location from the F1201 and FD3N120W files are listed in the grid. The grid columns that are listed are the Fixed Assets Number, Description, Unit Number, Expected Location, Counted Location, Expected Quantity, Counted Quantity, Employee ID, and Status. For those scanned fixed assets in which the Counted Location or Quantity is different from the expected location or quantity, then the Counted field is highlighted in red.
There are only two changes that the user is able to make from this form. The user can delete a scanned record by highlighting the transaction and clicking on the row exit Clear Row button. The user can also change the counted quantity of a scanned fixed asset. On the form exit row there are buttons for Print Audit and Approve. The Audit Report program prints a report listing all of the fixed assets from the grid without making any changes to the F1201. The Approve button will call the dcLINK business function ND3N1201. Using the MBF F2101 Process Master Data, the data collected for the location will be processed and will update all of the necessary files to match what was scanned. It will then automatically generate a post report listing only the fixed assets that were scanned at that location.
ND3N1201: The dcLINK business function ND3N1201 can also be used to scan a fixed asset. A value must be entered in the Asset Item Number and/or the Unit Number fields. The user is also required to enter values for both Location and Quantity. If the user does not enter a value for Quantity, the function will default the quantity for the item in the F1201. If the user does not enter a value for Location, the function will default the location from the F1201. If all of the data entered is valid, then the MBF - F1201 Process Master Data is used to process the transaction and update the necessary files. No reports are generated.
Loading...
There was a problem loading this topic