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.
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.
Best Wishes,
Chris Travers