Looking at the parts table, there is no expense_accno_id for any of my
parts, and the inventory_accno_id is all the same for all parts,
income_accno_id is the same for all parts.
Charley
Chris Travers wrote:
> Look at the parts table and the income_accno_id, expense_accno_id, and
> inventory_accno_id columns and see if anything is odd.
>
> Also Seneca deserves a great deal of the credit for tracking down this issue.
>
> Best WIshes,
> Chris Travers
>
> On 11/9/06, Charley Tiggs <..hidden..> wrote:
>> Seems to be happening only on certain items. That's weird. Do you have
>> a suspicion for a reason why?
>>
>> Charley
>>
>> Chris Travers wrote:
>>> 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