[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Invoice Creation Failing



On Wed, 2007-12-05 at 11:18 -0800, Chris Travers wrote:
> 
> 
> 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
> 

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
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users