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

Re: error posting invoices



Hi Charley,

Does this always happen when converting a sales order to an invoiceif
there are parts?  Only for certain parts?

Best Wishes,
Chris Travers


On 11/9/06, Charley Tiggs <..hidden..> wrote:

A part.

Charley

Chris Travers wrote:
> Hi Charley;
>
> Unfortunately, I am in the process of moving my last test instance to
> the 1.2 codebase.  I have been reviewing our changes and have one more
> question:
>
> When this happens, is this with a part or an assembly?
>
> Best Wishes,
> Chris Travers
>
> On 11/9/06, Chris Travers <..hidden..> wrote:
>> 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
>>>
>
> -------------------------------------------------------------------------
> 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
>


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