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