Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Hi Guys
I am looking for a field within sage that gives a date that the customer last made a purchase. The only date I found which was similar was LastActivityDate but this can be triggered by lots of different things. Do you guys know if this exists…
Hi All,
One of our users has been having an issue with SAGE displaying the system date incorrectly. Sometimes it will show the previous day's date, sometimes it shows the correct (today's) date, and sometimes it displays a date more than one day in…
Is it possible to subtract days from the current date? I'm trying to do an export from the AR_InvoiceHistoryHeader table, and I want this to be automated, and I don't want to export the entire table every time. I've tried things against the TransactionDate…
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…
I want to import a table's date field with a RUN ASSIGN field that has the current date (or a formula would be better) as the default instead of a static date. So that the user can either accept the default current date or enter their own date. Does anyone…
A payment was entered as 5/6/12 and should have been 5/6/13. This was not discovered until the middle of June during the monthly sales tax audit. By then, a new invoice had been created for this client.
I called tech support and was told to create a…