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