On Sun, 2007-08-05 at 13:20 -0700, Chris Travers wrote: > > > On 8/5/07, BeamEnds <[EMAIL PROTECTED]> wrote: > On Fri, 2007-07-27 at 20:31 -0700, Chris Travers wrote: > > > > > > 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? > > 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 > [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
