On Wed, 2007-12-05 at 11:18 -0800, Chris Travers wrote: > > > On Dec 5, 2007 11:00 AM, BeamEnds <[EMAIL PROTECTED]> wrote: > > On Tue, 2007-12-04 at 15:33 -0800, Chris Travers wrote: > > > > > > On Dec 3, 2007 5:06 PM, BeamEnds <[EMAIL PROTECTED]> > wrote: > > Hi All, > > I posted a couple of days back about invoice > creation failing > > for > > all parts, and the accounts associated with a part > not > > appearing > > in the Parts Report. > > > > The problem was that I'd loaded all the parts fro > CSV files, > > and > > to get the parts to associate with the accounts each > record > > has > > to be updated (with the Update button on the Part > record > > window). > > > > As I have 26,000 parts to do, this could be a tad > boring. Is > > there > > a way to automate this (my SQL knowledge tends > towards zero > > I'm > > afraid)? > > > > I am not sure exactly what you are trying to do-- are you > trying to > > set default accounts? > > > > Best WIshes, > > Chris Travers > > > > > Hi Chris, > this is the story.... > > I imported all the parts from a CSV file, in doing so the > three "link > accounts" were set to : > > Inventory : 1001--Stock > Income : 4000--Sales > COGS : 5000-Metrials Purchased > > > Ok. Were they set to the numbers (i.e. 1001, 4000, 5000) or to the > full string (1001--Sales)? > > Since this is consistent, we should be able to fix this using an SQL > query, but the answer to the above question will help determine what > sort of query we will use. > > Best Wishes, > Chris Travers >
Hi Chris, on the Parts record screen they are set to the full string, e.g. 1001--Stock Cheers Richard > > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: The Future of Linux Business White Paper > from Novell. From the desktop to the data center, Linux is going > mainstream. Let it simplify your IT future. > http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 > _______________________________________________ > Ledger-smb-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users ------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
