Sage 100

Hi, using Sage 100 Standard ERP 2014 I am writing a VI job to import a Customers Sales Orders, the source file is a CSV file, Loading into SO_SalesOrderHeader the field i am having trouble with is OrderDate The date on the CSV file comes across…

I wrote a script to disable and enable certain UDF's based on certain conditions. These UDF's have different data types. when the script runs apart from the Date type UDF all others get disabled and enabled properly. Is there a special syntax to control…

I am attempting to build a report for SSRS using Visual Studio. I have a query that is returning results, and the report is functioning perfectly. However, the end user decided they wanted a date range selector on this report. I have done this hundreds…

Hello, After I run a job it shows that all the inserts and updates were failed. Almost all the error message (which I could see in 'Transaction Errors') say that 'Input string was not in a correct format'. I want to know how can I get to know…

Hello, I am working on some query and part of the query needs me to select all the records from AR_CustomerSalesHistory table with FiscalYear equivalent to current year. I have tried these and some other combinations: SELECT * FROM AR_CustomerSalesHistory…