Import_Item_Sales - Error -10: Invalid date - MYOB Premier Release 17.0.0

This thread is now archived and closed to new comments.
Some of the links provided in this thread may no longer be available or relevant.
If you have a question please post a new topic.
Contributing Partner Benjamin123
7 Posts
Contributing Partner

Import_Item_Sales - Error -10: Invalid date - MYOB Premier Release 17.0.0

Hi 

I am trying to import data to Clearwtr.MYO.

While importing Import_Item_Sales data thru SQL i am getting error @ myoblog.txt.Attached for your reference

 

string sql = "INSERT INTO Import_Item_Sales(CoLastName,FirstName,AddressLine1,Inclusive,InvoiceNumber,SaleDate,"
+ "CustomersNumber,ItemNumber,Quantity, Description,ExTaxPrice,IncTaxPrice,"
+ "ExTaxTotal,IncTaxTotal,Job,Memo,TaxCode,SaleStatus,AmountPaid) VALUES ("
+ "'Leisure Landscape Nursery','Leisure Landscape Nursery','No.111 North Bridge Road','N','00000022','30/01/2013',"
+ "'Cust20020704','9200',1,'Bottle Adjustment Unit',"
+ "45,49.5,45,49.50,0202, 'Sale;Leisure Landscape Nursery','GST','I',0) ";

 

 

Please let me know the SQL Syntax or Sample SQL Query to insert data to Import_Item_Sales table

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post