On 7/27/07, BeamEnds <..hidden..> wrote:
Hi All,
I've nearly finished setting up LedgerSMB with data from the old system,
using CSV files imported with phpPgAdmin and all is well. The snag is
that having imported all the stock (parts) they don't register any value
in the accounts. I cant's see a way of importing a large purchase
order/invoice in via phphPgAdmin (none of the tables in phpPgAdmin seem
to contain a cost field, other than the "parts" table), and I don't
fancy creating one maually (about 6,000 parts in stock!) - is there a
way of getting LedgerSMB to do some sort of valuation to set the correct
stock valuation (COGS) - i.e opening stock?
Short answer:
Yes, but may be easier to just script against the Perl modules.
Longer answer:
An invoice is tracked in the following tables:
ap contains summary information relating to the transaction
invoice contains line item information
acc_trans contains the actual accounting information relating to the invoice
inventory may contain warehouse-specific inventory information
You may want to run a few transactions in a test database and observe the changes in these tables.
Best Wishes,
Chris Travers
Cheers
Richard
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>
http://get.splunk.com/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users