Ok. So it is not grabbing the COGS correctly. I will look into this
tonight and see if I can get a fix out.
On 11/9/06, Charley Tiggs <..hidden..> wrote:
> -252 is the cost of the item times the price the client is paying for
> the item.
>
> Sell price is $35.00
> Vendor price is $25.20
>
> Customer requested 10 items.
>
> Charley
>
> Chris Travers wrote:
> > One more question, is the 252 the total value of the invoice, the tax
> > amount, the price of the first line item, or something else?
> >
> > Best Wishes,
> > Chris Travers
> >
> > On 11/9/06, Charley Tiggs <..hidden..> wrote:
> >> Only happens when converting a sales order to an invoice, yes.
> >>
> >> Charley
> >>
> >> Chris Travers wrote:
> >>> Hi Charley,
> >>>
> >>> The chart id should be the database id of the chart entry. This only
> >>> happens when converting a sales order? Or does it only happen with
> >>> regard to certain parts?
> >>>
> >>> Best Wishes,
> >>> Chris Travers
> >>>
> >>> On 11/9/06, Charley Tiggs <..hidden..> wrote:
> >>>> The ones generated by the US General option when creating your data set.
> >>>>
> >>>> Charley
> >>>>
> >>>> Chris Travers wrote:
> >>>>> What accounts receivable/payable accounts are you using?
> >>>>>
> >>>>> On 11/9/06, Charley Tiggs <..hidden..> wrote:
> >>>>>> Hello,
> >>>>>>
> >>>>>> I'm getting an error while trying to post sales invoices within LSMB.
> >>>>>>
> >>>>>> I create a sales order and save it. I come back to this sales order
> >>>>>> later and create an invoice. I try to post the invoice and I get the
> >>>>>> following error:
> >>>>>>
> >>>>>> DBD::Pg::db do failed: ERROR: syntax error at or near "," at character 107
> >>>>>> Error!
> >>>>>>
> >>>>>> INSERT INTO acc_trans (trans_id, chart_id, amount,
> >>>>>> transdate, project_id, invoice_id)
> >>>>>> VALUES (601973, , -252,
> >>>>>> '11-09-2006', NULL, 2)
> >>>>>> ERROR: syntax error at or near "," at character 107
> >>>>>>
> >>>>>> I am uncertain what the chart_id should be. Can anyone give me a clue
> >>>>>> as to what I'm missing here?
> >>>>>>
> >>>>>> Thanks,
> >>>>>> Charley
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>