[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Reverse Invoice bug in 1.2.8-1
- Subject: Reverse Invoice bug in 1.2.8-1
- From: Paul Bente <..hidden..>
- Date: Fri, 12 Oct 2007 18:22:09 -0400
Steps to reproduce:
Install LedgerSMB 1.2.8 and apply Hotfix 1.2.8-1
Create a fresh database and user and import the standard
US_Manufacturing-chart.sql
Log in
System > Audit Control > Enforce transaction reversal? NO
Activate Audit trail? NO
Set up a Vendor: Vendor1
Set up a part, part1
Add account 1061 "Cash Clearing" similar to 1060 checking to aid in
setting up initial inventory. I will purchase the starting inventory
from the Vendor1 at the correct cost and then "pay" Vendor1 from the
Cash Clearing account to get the inventory entered at its proper cost.
Add transaction:
Db 1061 Cash Clearing $1,000.00 (which is the value of the as yet
un-entered inventory.)
Cr 3590 retained Earnings $1,000.00 (to balance). Ordinarily there
would be
lots of other asset and liability entries in this transaction
corresponding to initial set-up. Being able to correct and re-post
transactions was a real help in getting these initial entries
correctly labeled and in beginning to understand how lsmb handles
things.
Now, create an vendor invoice for the parts, 1,000 ea part1 @ 1.00
totaling our $1,000.00. Post the invoice. The entries now show up in
the GL and Report parts shows the correct quantities on hand.
However, the "Last Cost" field shows no entry. Why? Seems like it now
should be $1.00.
Now I want to pay the invoice. How to find it? I select AP > Reports
> AP Aging and there it is. Click the invoice number and up it pops
with a nice place to enter the payment at the bottom. Enter the
payment of $1,000.00 and a source note, select acct 1061 and Post.
Now the warning that I am posting an existing transaction pops up but
I've seen that before and (I think) I am just revising the
transaction so OK, hit continue.
Oops. Now the General Ledger shows I have duplicated the invoice and
I have added another 1,000 of part1 to inventory, paid for out of
acct #1061 and I still have a remaining CR of $1,000.00 in acct
#2100 "AP". My first question is how should I have paid the invoice
as that certainly didn't work?
Realizing that was clearly a mistake, I click on the invoice number
in the General Ledger, bring up the invoice now showing 2,000 ea of
part1, $2,000.00 due and one payment of $1,000.00. I attempt to start
over and remove this invoice by clicking Delete. Am I sure I want to
delete Invoice P101? Click Continue. The transaction no longer
appears in the General Ledger, but using List Accounts shows
#1530 Inventory Db $2,000.00
#2100 AP Cr $1,000.00
#1061 Cash Clearing shows 0.00
#3590 Cr $1,000.00 as before
Listing parts shows a quantity of -1,000 (negative!) for part1.
The General Ledger shows only the first set-up transaction and no
transactions involving #2100 or #1530.
Question #1: What is the recommended way to pay a previously entered
invoice?
Question #2 Is there a way to clean up or reverse this mess? I've
done something similar but with a lot more entries. Failing that, is
there a way to migrate all of my Parts, Customers and Vendors to a
fresh database without re-typing them to start over?