Job Cost Budget Revisions interface for JD Edwards
Corresponding EnterpriseOne application
The corresponding EnterpriseOne application for the Job Cost Budget Revision interface.
In EnterpriseOne, the application you would run to launch Job Cost Budget Revisions is P510171. The menu to find Job Cost/ Daily Processing / Job & Budget Setup is G51.
Processing options
Processing options for ND3N5171.
This interface requires processing options from P510171 program. A version will default to ZJDE0001 if not otherwise specified in the parameter list on the call.
Display tab
-
Default Cost Code Range
-
From Cost Code (szCostCodeFrom_BFSU) – This is not used in the ND3N5171
-
Thru Cost Code (szCostCodeThru_BTSU) - This is not used in the ND3N5171
-
-
Default Cost Type Range
-
From Cost Type (cCostTypeFrom_OBJF) - This is not used in the ND3N5171
-
Thru Cost Type (cCostTypeThru_OBJF) -This is not used in the ND3N5171
-
-
Restrict Account Ranges (cJobCostRange_JCRANGE) – This is not used in the ND3N5171
-
Method of Computation (cMethodOfComputation_CCT) – This is not used in the ND3N5171
-
Level of Detail (cLevelOfDetail_LDA) - – This is not used in the ND3N5171
-
Budget Column Format (cJobCostFormat_JCBCFMT) - This is not used in the ND3N5171
-
Budget Change (cJobCostOptions_JCBTOPT) - This is not used in the ND3N5171
Process tab
-
Budget Amount Ledger Type (szAmountLedgerType)
-
G/L Date Editing (cJobCostByPassGLDate_JCDGL) – This is not used in the ND3N5171
-
Document Type (szDocumentType_DCT)
-
Budget Audit Trail (cJobCostAuditTrail_JCF0911)
-
Reference Number (cReference2_R2) – This is not used in the ND3N5171
-
Override Explanation (cOverrideExplanation_EXA) – This is not used in the ND3N5171
Processing options data structure
The interface retrieves these parameters by calling BD3N5171.
They are passed back in the following data structure.
| Type | Description | Parameter |
|---|---|---|
| String | szVersion_VERS | Input |
| String | szCostCodeFrom_BFSU | Output |
| String | szCostCodeThru_BTSU | Output |
| String | szCostTypeFrom_OBJF | Output |
| String | szCostTypeThru_OBJT | Output |
| String | szAmountLedgerType_LT | Output |
| String | szDocumentType_DCT | Output |
| Char | cMethodOfComputation_CCT | Output |
| Char | cLevelOfDetail_LDA | Output |
| String | szReference2_R2 | Output |
| String | szOverrideExplanation_EXA | Output |
| Char | cJobCostRange_JCRANGE | Output |
| Char | cJobCostFormat_JCBCFMT | Output |
| Char | cJobCostOptions_JCBTOPT | Output |
| Char | cJobCostByPassGlDate_JCDGL | Output |
| Char | cJobCostAuditTrail_JCF0911 | Output |
Processing
This interface allows the user to add and edit the Budget Revisions Record.
The user will pass the required value in the parameter and it will update the F0902 table. The dsiActionCode is used to determine this.
In order to add/edit a job cost bdget revisions record, the cdsiActionCode must be a 'C'.
| Action code | Advanced Inventory action code | Description |
|---|---|---|
| C | Change an existing job cost budget revisions record. |
Verify the process
The Job Cost Budget Revision will bring you to the P510171 program, where you can view all of the transactions for that Job Number.
To verify that the transaction occurred, complete the following steps in JDE.
-
Open the Job budget Revisions – Work with Job Master Application (P51006) on menu G51.
-
Select the job number to view.
-
Select Select on the screen.Example
Input data structure
Input data structure ND3N5171.
| Name | Default value | Notes | ||
|---|---|---|---|---|
| R/O | Alias | |||
| cdcLINKActionCode_EV01 | R | EV01 | ‘C' (change) are valid. If no dcLINK Action Code is passed in, it will set an error. | |
| cActionType_ACTION | ACTION | Not used. | ||
| jdDateUpdated_UPMJ | (today) | X | UPMJ | Returned from GetAuditInfo if not passed in. |
| mnTimeOfDay_TDAY O TDAY | (now) | X | TDAT | Returned from GetAuditInfo if not passed in |
| szUserId_USER | (current user id) | X | USER | Returned from GetAuditInfo if not passed in |
| szWorkStationId_JOBN | (current workstation id) | X | JOBN | Returned from GetAuditInfo if not passed in |
| mnJobnumber_JOBS | JOBS | Not used. | ||
| szProgramId_PID | ND3N5106 | X | PID | Generally leave this blank and let it default in. |
| szVersion_VERS | ZJDE0001 | VERS | Not used. | |
| cSuppressErrMsg_EV01 | EV01 | Not used. | ||
| cErrorCode_ERRC | ERRC | Indicates an error condition. Set by program. | ||
| szErrorMessageKey_EKEY | EKEY | Holds EnterpriseOne error message number. | ||
| iDebugLevel_INT01 | O | INT01 | Leave blank except for debugging and testing purposes only. Higher numbers will show more debug dialog boxes. Leaving this blank or setting to “0” suppresses all debug dialog boxes. Do not leave a value greater than “0” in this field after initial setup and testing as it will cause synchronous dialogs on the computer to pop up when the function is called. | |
| szGuidUniqueID_GUID | O | CFRGUID | ||
| szGuidApprover1_USR1 | O | USR1 | ||
| szGuidFullName1_FULLNAME1 | O | FULLNAME1 | ||
| szGuidApprover2_USR2 | O | USR2 | ||
| szGuidFullName2_FULLNAME2 | O | FULLNAME2 | ||
| mnGuidReasonCode1_REASON1 | O | REASON1 | ||
| szGuidCommentField_COMMENTS | O | COMMENTS | ||
| mnGuidReasonCode2_REASON2 | O | REASON2 | ||
| szGuidCommentField2_2COMMENTS | O | 2COMMENTS | ||
| szGuidScriptID_FMNMVERS | O | FMNMVERS | ||
| szGuidTextMessage_TEXTMES | O | TEXTMES | ||
| szLedgerTypes_LT | R | LT | Required | |
| szUnitLedgerTypes_ULT | R | ULT | Required | |
| szJobNumber_MCU | R | MCU | Required | |
| cJobPostingEdit_PECC | O | PECC | ||
| szPeriodOrDate_PNDGLOW | R | PNDGLOW | Required | |
| cLevelOfDetail_LDA | O | LDA | ||
| Subledger Type | O | SBLT | ||
| szSubledgerGL_SBL | O | SBL | ||
| cIncepCumlPeriod_CMIOW | O | CMIOW | ||
| szCostCode_SUB | R | SUB | Required | |
| szCostType_SUB | R | OBJ | Required | |
| cMethodOfComputation_CCT | O | CCT | ||
| mnCurrentUnits_UN1OW | O | UN1OW | ||
| mnCurrentAmount_AO1OW | O | AO1OW | ||
| mnUnitsPlusMinus_UN1OW | R | UN1OW | Required | |
| mnUnitCostPlusMinus_PRRCE10W | O | PRRCE10W | ||
| mnAmountPlusMinus_AO1OW | R | AO1OW | Required | |
| mnCumlUnits_UN1OW | O | UN1OW | ||
| mnCumlUnitCost_PRRCE1OW | O | PRRCE10W | ||
| mnCumlAmount_AO1OW | O | AO1OW | ||
| mnLevelOfDetail_LDA | O | LDA | ||
| mnPostingEdit_PEC | O | PEC | ||
| szUnitOfMeasure_UM | O | UM | ||
| szReference2_R2 | O | R2 | ||
| szExplanation_EXA | O | EXA | ||
| 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
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.
| Field name | Change a labor record – report actual hours |
|---|---|
| cdcLINKActionCode_EV01 | C |
| cActionType_ACTION | |
| jdDateUpdated_UPMJ | |
| mnTimeOfDay_TDAY O TDAY | |
| szUserId_USER | |
| szWorkStationId_JOBN | |
| mnJobnumber_JOBS | |
| szProgramId_PID | |
| szVersion_VERS | CFL0001 |
| cSuppressErrMsg_EV01 | |
| cErrorCode_ERRC | |
| szErrorMessageKey_EKEY | |
| iDebugLevel_INT01 | |
| szGuidUniqueID_GUID | |
| szGuidApprover1_USR1 | |
| szGuidFullName1_FULLNAME1 | |
| szGuidApprover2_USR2 | |
| szGuidFullName2_FULLNAME2 | |
| mnGuidReasonCode1_REASON1 | |
| szGuidCommentField_COMMENTS | |
| mnGuidReasonCode2_REASON2 | |
| szGuidCommentField2_2COMMENTS | |
| szGuidScriptID_FMNMVERS | |
| szGuidTextMessage_TEXTMES | |
| szLedgerTypes_LT | JA |
| szUnitLedgerTypes_ULT | JU |
| szJobNumber_MCU | 5100 |
| cJobPostingEdit_PECC | |
| szPeriodOrDate_PNDGLOW | |
| cLevelOfDetail_LDA | |
| Subledger Type | |
| szSubledgerGL_SBL | |
| cIncepCumlPeriod_CMIOW | |
| szCostCode_SUB | 2200 |
| szCostType_SUB | 1341 |
| cMethodOfComputation_CCT | |
| mnCurrentUnits_UN1OW | |
| mnCurrentAmount_AO1OW | |
| mnUnitsPlusMinus_UN1OW | 1 |
| mnUnitCostPlusMinus_PRRCE10W | |
| mnAmountPlusMinus_AO1OW | 1 |
| mnCumlUnits_UN1OW | |
| mnCumlUnitCost_PRRCE1OW | |
| mnCumlAmount_AO1OW | |
| mnLevelOfDetail_LDA | |
| mnPostingEdit_PEC | |
| szUnitOfMeasure_UM | |
| szReference2_R2 | |
| szExplanation_EXA | Now PO Blank |
| szCompany_CO |
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 his 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. |
| 2432 | Duplicate Record Already Exist This is set when the Business Unit is Blank or Null. |
| 1307 | Skip To Invalid In this interface, this will be set if the Cost Code and Cost Type is Blank or Null. |
| 0024 | Company Number Invalid This is set if the business function failed to get company from business unit. |
| 1985 | Extended Job Master Record not Found This is set when business function failed to validate Dates. |
| 1984OW | Fiscal year not within Range This is set when business function failed to validate Fiscal years. |
About Job Cost Budget Revisions interface guide
The Job Cost Budget Revisions interface is used to edit units and amount of cost code based on Job number
The Job Cost Budget Revisions modifies units and amount of cost code based on Job number and can change the explanation. This interface was written in NER and calls a ‘C' business function BD3N5171 to retrieve the processing options.
| Name | Function name | Description |
|---|---|---|
| DD3N5171 | dcLINK Interface Budget Revisions | |
| ND3N5171 | dcLINKJobCostBudgetRevisions | dcLINK Interface – Budget Revisions |
| DD3N5171A | dcLINK PO Retrieval Budget Revisions | |
| BD3N5171 | dcLINKPORetrievalBudgetRevisions | dcLINK PO Retrieval Budget Revisions |
Common error messages
| 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. |
| 2432 | Duplicate Record Already Exist: This is set when the Business Unit is Blank or Null. |
| 1307 | Skip To Invalid: In this interface, this will be set if the Cost Code and Cost Type is Blank or Null. |
| 0024 | Company Number Invalid: This is set if the business function failed to get company from business unit. |
| 1985 | Extended Job Master Record not Found: This is set when business function failed to validate Dates. |
| 1984OW | Fiscal year not within Range: This is set when business function failed to validate Fiscal years. |
Required fileds
To change a job cost budget revisions record, the interface requires the user to supply the Advanced Inventory action code (C), Ledger type, Unis Ledger Type, Job Number, Period or Date, Cost Code, Cost Type, Units Plus Minus, and Amount Plus Minus, as a minimum. This will update the existing job cost budget revision line.
Loading...
There was a problem loading this topic