How do I correct balances in 0.0.70.98?

Modified on Mon, 16 Oct, 2023 at 3:25 PM

In order to identify the batch that created the entry in 0.0.70.98 you need to identify the date in which the posting was made. 


Go into NavigatorNominal LedgerTransaction Report 


In the Code field enter 0.0.70.98


Enter a date range (I usually go about a year back from current date). 


The report will show a list of all the transactions that are currently in 0.0.70.98.


Make a note of the dates and the amounts of each entry that display - or export to spreadsheet, notepad, etc. 


Select Reset on the Transaction Report so that you can continue with your search.
This time leave the Code field blank.


In the Date From and the Date To - enter the first date of the 0.0.70.98 on your transaction list (it is easier to do it day by day if there is more than one item on your list). 


When the report has finished, filter by batch number (drag the column header to the grey bar).
You will notice that most of the batches show as zero - the items that do not, these are the batches you are looking for. 


Scroll down the list, and make note of each batch number that does not balance to zero, as well as the amount (an amount on 0.0.70.98 can be the tally of a few batches rather than individual ones).


Once you have made a list of all the batches, Reset the Transaction Report - and then select from the drop-down list search by "Batch" on the Transaction Report rather than "by Code".


On this report, enter the required batch number and select Report.


You will then need to investigate the batch to identify where the amount in 0.0.70.98 should have actually gone.


Once you identify the nominal account the balance should have gone to, journal the amount out of 0.0.70.98 and into the required account.


I always advise to enter a "Reference" when posting the journal so you know what the transaction links to when looking back.


Also, if journaling to a Stock Record, Job Number etc. - don't forget to enter this onto the journal in the available fields. 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article