On 7/27/07, BeamEnds <[EMAIL PROTECTED]> 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
