Re: "Stocking Up" LedgerSMB

[BeamEnds <..hidden..>]

On Fri, 2007-07-27 at 20:31 -0700, Chris Travers wrote:
> 
> 
> 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.

Sadly I don't do Perl :-( 

> 
> 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. 
> 

And I thought it was going so well..... ;-)

> Best Wishes,
> Chris Travers
> 
> 

Cheers
Richard

>         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
> 
> -------------------------------------------------------------------------
> 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