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