Trial balance error
  • Andres Timmermanis
    Trial balance error

    by Andres Timmermanis » Mon Oct 09, 2006 12:01 pm

    Have been using the new trial balance function under customer reports however for Sept it is returning the message that there is are invalid or damaged transactions. It then goes on to produce the sales part of the report but no expense data and therefor no P/L.

    What is the best method of identifying these transactions and correcting them.

    The reporting for October appears to be unaffected.
  • COBS Tech Support
    Posts:683
    Joined:Fri Sep 09, 2005 8:23 am

    by COBS Tech Support » Mon Oct 09, 2006 12:43 pm

    I am guessing you are referring to Report 226, Trading Statement.

    You may have a damaged transaction somewhere within the period you're attempting to report on.

    The best approach is to execute the report for half the period, e.g, the 1st to the middle of the month and/or the middle of the month to the end of month. Then check to see in which day range the problem is in. Repeat this process until you have the problem narrowed down to one or more days. You should then 'zoom' on each of the transactions on this day. CAPITAL should inform you if the transaction does not balance and then you can inspect the contents of the transaction at that point and decide what to do.

    To repair a damaged transaction:

    1. Go to the main menu.
    2. Select Special|Installation Workshop.
    3. Enter your password if applicable.
    4. Select from the menu Diagnose|Recalculate Invoicing.
    5. Enter the transaction number of the problem transaction in the 'From' And 'To' Fields or enter the transaction number range if there are a number of transactions that have problems.
    6. Press Start to fix the problem.

    NOTE: The above procedure only re-balances transactions that are not balanced. If the problem is due to, for example, damage to your database files resulting in missing information, the missing information may not be restored. It's important to inspect and check any transactions that had to be re-balanced.

Who is online

Users browsing this forum: No registered users and 34 guests