• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
Loading Z68 via p_file_06 results in incorrect Z68_E_PRICE and a Z601 error -- a rounding off issue with Z68 p_file_06 loading.
Loading the z68 file via p_file_04 or with “correct record” set to N in p_file_06 allows the numbers to be entered correctly.

Reported Error from Z601 Process:
0111 : Z601-ORIGINAL-SUM has no matching Z68-E-PRICE
%Mandatory errors found for record in line 000000001. Record discarded

The Z601 record is linked to Z68_REC_KEY by its doc number (in this example: 00008801800003)

Resolution:
The question is, does 45.50 - 21% = 35.94 or does 45.50 - 21% = 35.95

If the equation is calculated like this:
[1] 45.50 * 21% = 9.555
[2] 9.555 rounds to 9.56
[3] 45.50 - 9.56 = 35.94

On the other hand, if the equation is calculated in this way:
[1] 45.50 * 21% = 9.555
[2] 45.50 - 9.555 = 35.945
[3] 35.945 rounds to 35.95

The loading software allows the second version to remain (no-fix), even though Aleph uses the first method (fix).

• Article last edited: 10/8/2013