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

Re: error posting invoices



The items that worked probably had not ever been purchased yet, so no
COGS associated.

We should probably do some further checking when we save goods and
services...  But for now I am content to wait until we get around to
re-engineering that part of the software.

Best WIshes,
Chris Travers

On 11/10/06, Charley Tiggs <..hidden..> wrote:
That fixed it.  Thanks, Chris and Seneca!

But that doesn't explain why some items worked and some didn't.  None of
the items had an expense account associated with them.

Charley

Chris Travers wrote:
> Parts should have an income_accno_id, an inventory_accno_id, and an
> expense_accno_id.
>
> On 11/10/06, Charley Tiggs <..hidden..> wrote:
>> 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
>>
>
> -------------------------------------------------------------------------
> 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