Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

The following error pops up on invoicing an order that has been dispatched …what shall I do?

0
Posted

The following error pops up on invoicing an order that has been dispatched …what shall I do?

0

CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK ASSISTANCE: The sales GL posting could not be inserted because: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ ‘C1039 – 10615 x 1 @ 500.0000′, -500 )’ at l The following SQL to insert the GLTrans record was used: INSERT INTO GLTrans ( Type, TypeNo, TranDate, PeriodNo, Account, Narrative, Amount ) VALUES ( 10, 2, ‘2004/11/01’, 59, , ‘C1039 – 10615 x 1 @ 500.0000’, -500 ) You must define the sale General Ledger Posting codes. This is the general ledger analysis of sales. It maybe that all sales go to one general ledger account. In which case this general ledger account needs to be set up under main menu, setup, Sales GL Interface postings. The cost of sales GL Postings should also be setup if you wish to have stock integration. If you dont wish to have general ledger integration this should be switched off by going into Setup tab of the main menu and Comp

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123