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

Re: error posting invoices



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