Journal Entries interface for JD Edwards
About the Journal Entries interface
This interface NER can call a "C" business function BD3N0901 to retrieve the processing options.
In the enterprise system the application name is P0911. The dcLINK version is called ND3N0911. This interface was written in NER and calls a “C” business function BD3N0901 to retrieve the processing options.
| Name | Function name | Description |
|---|---|---|
| DD3N0911 |
dcLINKInterfaceJournalEntries |
dcLINK Interface Journal Entries |
| ND3N0911 |
dcLINKInterfaceJournalEntries |
dcLINK Interface Journal Entries |
| DD3N0901 |
PORetrievalJournalEntries |
PO Retrieval Journal Entries |
| BD3N0901 |
PORetrievalJournalEntires |
PO Retrieval Journal Entries |
The full name of this interface is ND3N0911 Journal Entries
This interface guide applies to the following JDE versions.
-
EnterpriseOne 8.10
Processing options
The DreamWriter defaults to ZJDE0001 if not otherwise specified in the parameter list on the call.
Batch type tab
-
Batch Type (po_szBatchType_ICUT: This field is used to define what type of a batch is being created and is used in F0011 Write Batch Header, F0911 Begin Document, and F0911 End Document programs. This field defaults to a value of “G” if one is not entered into the processing options.
Format control tab
-
Debit/Credit (po_cDebitCreditFlat_EV01): This flag is turned on by entering a “1” in the processing options, if Debit/Credit amounts are to be entered. This option allows both a debit and a credit to be displayed in different debit/credit fields in the P0911 Journal Entries screen.
MBF version tab
-
Version (szP0900049Version_VERS): This field is used to specify the version number to be used when this program is called. ZJDE0001 is the default.
Processing option data structure for DD3N0901
The interface retrieves these parameters by calling BD3N0901. They are passed back in the following data structure.
| Type | Description | Parameter |
|---|---|---|
| String |
po_szBatchType_ICUT |
Output |
| Char |
po_cDebitCreditFlag_EV01 |
Output |
| String |
szP0900049Version_VERS |
Output |
| Char |
po_cFixedAsset_EV01 |
Output |
| String |
szVersion_VERS |
Input |
Processing
Processing information for Journal Entries interface.
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.
Verify the processing
The EnterpriseOne application, P0911, can be used to verify that the transactions have been successfully created. Key P0911 in FAST PATH box on any menu. The screen displayed will allow the user to search for the transactions by entering filters in the QBE fields to your latest transactions then by clicking on the FIND button. If the batch number is known, this is the easiest way to search. The list can further be altered by using other QBE fields to filter the data being shown.
Input data structure
Input data structure for DD3N0911.
| Name | Default values | R/O | Alias | Notes |
|---|---|---|---|---|
| cdcLINKActionCode_EV01 |
R |
EV01 |
Valid code is “0”. |
|
| cActionCode_ACTION |
C |
X |
ACTION |
|
| jdDateUpdated_UPMJ |
Current Date |
X |
UPMJ |
Retrieved from GetAuditInfo. |
| mnTimeOfDay_TDAY |
Current Time |
X |
TDAY |
Retrieved from GetAuditInfo. |
| mnDocumentNumber_DOC |
R |
DOC |
Required - comes from the Get Document function. |
|
| szCompanyKey_KCO |
O |
KCO |
||
| szDocumentCompany_KCO |
O |
KCO |
||
| szExplanation_EXA |
Employee #, Reason Code, Rate |
X |
EXA |
This field is required, but is defaulted with the Employee Number, Reason Code, and Employee Rate values. |
| szLedgerType_LT |
X |
LT |
Defaults to “AA” for domestic. |
|
| szForeignLedgerType_LT |
X |
LT |
Defaults to “CA” for foreign. |
|
| mnExchangeRate_CRR |
O |
CRR |
Defaults depending on the currency codes. |
|
| mnAmounttoDistribute_ATDOW |
O |
ATDOW |
||
| szDebitAccountNumber_ANI |
R |
ANI |
Required. |
|
| szCreditAccountNumber_ANI |
R |
ANI |
Required. |
|
| mnPercentOW2_PERCENT |
O |
PERCENT |
||
| mnAmount_AA |
R |
AA |
Required - this is the hours worked, and is multiplied by the employee rate that is either retrieved from the Employee Master or the UDC tables. |
|
| mnDebitAmount_AA |
X |
AA |
If Debit/Credit flag is on, this gets populated from the Amount field. |
|
| mnCreditAmount_AA |
X |
AA |
If Debit/Credit flag is on, this gets populated from the Amount field. |
|
| mnForeignAmount_ACR |
C |
ACR |
Required only if transaction is Foreign. |
|
| szSubledger_SBL |
O |
SBL |
||
| szSubledgerType_SBLT |
O |
SBLT |
||
| szRemark_EXR |
O |
EXR |
||
| szPurchaseOrder_PO |
O |
PO |
||
| szPurchaseOrderSuffix_PSFX |
O |
PSFX |
||
| szUnitOfMeaure_UM |
O |
UM |
||
| mnUnits_U |
O |
U |
||
| szReference2_R2 |
O |
R2 |
||
| szCategoriesWorkOrder001_WR01 |
O |
WR01 |
||
| szDocumentPayItem_SFX |
O |
SFX |
||
| szAssetNumber_ASII |
O |
ASII |
||
| jdDateCheckJ_DKJ |
X |
DKJ |
||
| jdDateServiceCurrency_DSVJ |
X |
DSVJ |
||
| cBillCode_BC |
O |
BC |
||
| mnDoiSub_DOI |
O |
DOI |
||
| cModeModelJE_MODOW |
O |
MODOW |
||
| cModePercentJE_PCTOW |
O |
PCTOW |
||
| cReverseOrVoidRV_RE |
O |
RE |
||
| cCurrencyModeForeign_CRRM |
O |
CRRM |
Defaults to “0” for domestic. If a transaction is foreign, then a “1” should be entered. |
|
| jdDateForGLandVoucher_DGJ |
X |
DGJ |
Defaults to today's date. |
|
| mnJournalEntryLineNo_JELN |
O |
JELN |
||
| mnEmployeeNo_EENOW |
R |
EENOW |
Required to retrieve the employee rate. |
|
| szCurrencyCode_CRCE |
X |
CRCE |
Defaults to “USD” if not entered (domestic). If entered, this is one way to show that foreign currency or domestic currency is being used. |
O = Optional
X = Required but will default in if not passed
C = Conditional (see notes for conditions)
Additional information
Additional information for Journal Entries interface.
Additional information
The first transaction this interface receives should have only an Action Code value. This Action Code that is received on the first transaction should be equal to a “B”. This Action Code of a “B”, causes the BD3N1410 (dcLINK ALR to EnterpriseOne Load Batch Number Cache) function to be called. This function gets a batch number and puts it into a cache, so that the batch number can be used with each transaction thereafter until the cache is cleared.
Each transaction after the first should contain, at the minimum, an Action Code of an “E” or “U”, a Document Type, an Explanation, an Amount, Debit and Credit Account Numbers, and an Employee Number. The Action Code can be an “E” or a “U” depending on where the Hourly Rate for the Employee is to come from. Entering an “E” in the action code will get the Hourly Rate from the Employee Master (F060116), while entering a “U” in the action code will get the Hourly Rate from the UDC table. The Hourly Rate is then multiplied by the Amount, added to the Debit Account, and subtracted from the Credit Account.
Each of these transactions that are run will be contained in the same batch number, until the final transaction is run to clear the cache of the batch number. This final transaction should contain nothing more than an Action Code of a “Z”. This Action Code of a “Z” will cause BD3N1410 to be called again, and the batch will be cleared from cache.
The next transactions run thereafter will require all of these steps to be repeated.
Loading...
There was a problem loading this topic