Partner Zone
Partner Zone

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

This thread is now 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 start a new post.
Contributing Partner Benjamin123
7 Posts
Contributing Partner
Contributing Partner




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


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
Get the conversation started and make a new post Start a Post