Loading Z68 Via p_file_06 With Fix Results in Incorrect Z68_E_PRICE
- 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