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

    System changes small amounts on unbalanced invoices

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

    Description:
    When an invoice is not balanced and the discrepancy is a small amount, closing the invoice causes ALEPH to close the invoice without the usual warning then alters each invoice line by one or two pence up to the point where it is balanced.
    If the discrepancy is large, ALEPH still behaves as expected: issues a warning 'Invoice not balanced, close anyway?', and after closure leaves the invoice lines alone (does not change them).
    Can this be turn off?

    Resolution:
    This is functioning as intended, but since v16, it is possible to turn it off.

    Description: When the General Invoice is slightly unbalanced, the system will attempt to round it by splitting the remainder sum on all item debit lines. It is now possible to prevent this by setting the CALC-INV-LINE of the tab100 table to "N". The default is "Y".
    ! Y = If the balance between the Total Amount Line Items (Z75) and the
    ! Total Amount of General Invoice (Z77) is less than 0.05 then the balance
    ! is distributed among the preceding invoice line-items.
    ! N = The balance between the Total Amount Line Items (Z75)
    ! will not be recalculated.

    Additional Information

    invoice, balance, alter, amount


    • Article last edited: 10/8/2013
    • Was this article helpful?