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