On 08/04/2010 05:40 AM, Mike Mylonas wrote:
Hi Armaghan
On Wed, 2010-08-04 at 04:57 -0400, Armaghan Saqib wrote:
What our people have been doing is on the invoice put the cost of the
individual items in, and the number of containers. If the client
brought containers with them, they enter another line with the number of
containers listed as a negative figure, which gives us a correct invoice
total.
What we are finding is that these negative figures are not showing in
our trial balance at all, but the positive figures are. This means that
we cannot rely on the income statement.
Which accounts are not being updated in trial balance? Inventory, expense?
Expense was not being updated/
COGS issues.
The accounting of return handling is not correctly done in the standard
sql-ledger. I have fixed these issues in ledger123 github version.
So I shall recommend to use the github version and see if it sorts out
your issue.
Important: take backups before upgrade esp. before running the cogs
reposting procedure.
Ok, ran the COGS Reposting procedure and that seemed to tidy up a lot of
the entries (thanks).
Now the trial balance no longer balances, with the errors relating to
the negative entries on the invoices. If I run Ledger Doctor, that now
shows "Unbalanced Journals" which contains all of the negative entries
on the invoices. Any recommendations for how to correct these issues,
so that everything balances.
Open/repost these invoices and run reposting script again. This should
sort out the issue.
I am sure you have a backup before doing all this.
Regards
Armaghan
--
http://www.ledger123.com/
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
