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