Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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