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