JDE : COB0000012 - GetProcAddress failed

1888/3672 WRK:Starting jdeCallObject         Fri  Oct 14 16:21:16.565001 Jdeobj.c1261
 COB0000012 - GetProcAddress failed CCUSTOM.dll function _GetFileFromPathMatchingWildcard@12 Error = 0

The name of the APIs are mentioned in two places
1) In the JDE BSFN Object ( Mapping to the Template DataStructure)
2) In the c source file.

Scenario 1: If this error is seen in the client's JDE.log itself
Make sure the name of the API given in 1) and 2) are same.
In my case, the name given in BSFN Object(GUI) is GetFileFromPathMatchingWildcard
But the name given in the BSFN .c file is GetFileFromPathMatchingWildcardXXX().Due to this the CCUSTOM dll is not updated with the name given in the JDE object.

Scenario 2: Working in FAT client, but not on Enterprise Server
The BSFN is not properly deployed on the Server


Hope it helps : )

Preventing Check Fraud : Positive Pay

Check fraud is one of the common payment frauds.In order to avoid this, ERP softwares usually go for Positive Pay file.

Frauds?
Some of the frauds that can happen with checks are
1) Changing the amount the on the check
2) Counterfeiting the checks

Positive Pay/Enhanced Positive PayIt is a mechanism that requires companies to send a text file with the list of checks issued to the bank
This flat file contain information like
1) Payee Name
2) Check Date
3) Check Amount etc.

So when the Payee takes check to the bank, bank person will match the check with the information in the flat file before releasing the funds.If any mismatch is found, an exception is raised and sent to the Company...

JDE : Export the output data in Excel format

The default output of a report in JDE is PDF file.The report can be designed to generate csv ( along with PDF) as well. But at times an excel file is required instead of csv.

Here is the way
1) Write the Data to a abc.txt file using one of the BSFN APIs.The fields/columns have to separated by TAB.
2) Now after writing all the data, rename the file to abc.xls
3) Here comes the catch, JDE tool set does not allow to type TAB character.So you can open notepad, press TAB key, copy it and paste in JDE. :)

JDE NO DATA SELECTION INFORMATION FOUND

Error Message on the Pop up Message
NO DATA SELECTION INFORMATION FOUND
Data Selection information for this report has not been generated. Please contact your administrator

Error Messages in jas logs
[SPEC_NOT_FOUND] Unable to find OneWorld specification for REPORTSEL-R550411PT-KJG0001 (and/or)
[SPEC_NOT_FOUND] Unable to find OneWorld specification for PRINTINFO-R550411PT-KJG0001 (and/or)
[SPEC_NOT_FOUND] Unable to find OneWorld specification for REPORTSEQ-R550411PT-KJG0001 (and/or)
[SPEC_NOT_FOUND] Unable to find OneWorld specification for REPORTINFO-R550411PT-KJG001

Release : E811


Problem/Solution : 
The serialized Specs generated by the Generator were inserted in to F989999 in Data Source A. But JAS server is looking into F989999 from a Data Source B.
So make sure both Generator and HTML Server are looking into the same Data Source

JDE Retrieve of UBE file failed

UBE: Retrieve of UBE file failed. The file may not exist on Enterprise Server.

If you see the above message and the output is supposed to be present,check the 'Suppress All Output' flag under File->Report Properties option.Make sure it is not cheked.

You can also find the following message in the log : --UBE--[1]-- Output is disabled. No PDF file will be created for this report.

JDE MICR E13-B font

I was developing few cheque/check(BoA and BoM) printing applications in JDE.I came across the gnuMICR font from the website : http://sandeen.net/GnuMICR/ and used it for writing the micr line in the check/cheque.
The micr line passed both the bank tests.

Incase you are developing any MICR E-13B based check reports in JDE, see if this font meets your requirement.
Speak to the developer/author of the Font : Mr Eric Sandeen.(Email id is available in the web page) for the TnC of usage and more information

Note: This font may or maynot solve your purpose.Just give a try

Little More

• MICR stands for Magnetic Ink Character Recognition.It is a technology that allows computers to read information printed on checks
• Unlike Barcode information,MICR information is human readable.
• Popular MICR font standards are E-13B and CMC-7
• E-13B is used for cheque printing in US,Canada,UK,Australia,African Countries,India,China etc.,
• CMC-7 is used in France,Israel,most of the South American countries etc.,
• E-13B Character set contains 10 numerals(0-9) and 4 control characters.
• CMC-7 contains 10 numerals and 5 control characters