Re: "Stocking Up" LedgerSMB

[BeamEnds <..hidden..>]

On Sun, 2007-08-05 at 13:20 -0700, Chris Travers wrote:
> 
> 
> On 8/5/07, BeamEnds <..hidden..> wrote:
>         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?
>         
>         Has anyone done this before? It looks to me like I could
>         create all sort
>         sof problems for myself on the accounting side of things.
> 
> You could which is why scripting against the Perl modules is probably
> the safest way to go.

I'm affraid I don't even know what that means, never mind doing it!

> 
> However, if you properly hit the AP, invoice, and acc_trans tables,
> you should be OK.  My suggestion is that you run a few other AP
> invoices through a test system and look at how these three tables are
> affected first. 

I'll give it a go - I'll try and write it down, so it'll be there for
someone else.

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