Search This Blog

Sunday, November 15, 2009

Issue 60 XCarried DOTS into Qty Field in BDC

Generated the qty of material is wrong

What was the error?
There is a statement in the program which truncates last 4 digits in the Qty uploaded

** In the Non Unicode System, the file carried “.” into the input
** While shifting 4 to right it would consider “.000”
** In Unicode the “.” is not carried in the system
** So while shifting to right it considers “0000”
** Thus the Qty mismatched by *10

Corrected
Instead of shifting 4 digits to the right, we would only shift 3

Eg: Test Case
BZD27C6V8P-GS086409466B3211/09/0994442N2 200946CN64 15000.000 0946 22600010 000000SHB480116518
BZD27C6V8P-GS086409466B3211/09/0994442N2 200946CN64 15000.000 0946 22600010

Qty uploaded 15000.000
Previous system Qty corrected = 15000 (.000) 4 places truncated from right
New system Qty Corrected = 1500 (0000) 4 places truncated from right
After Changes in the new system
Qty corrected = 15000(000) 3 places truncated

No comments:

Post a Comment