Re: Invoice Creation Failing

["Chris Travers" <..hidden..>]

On Dec 5, 2007 11:00 AM, BeamEnds <..hidden..> wrote:

On Tue, 2007-12-04 at 15:33 -0800, Chris Travers wrote:
>
>
> On Dec 3, 2007 5:06 PM, BeamEnds <..hidden..> 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