Browse By Tags

A client has requested a new query, specifically looking at outbound deliveries. I have created a query that shows all deliveries with a departure date, and the arrival date (for this client, any delivery with a blank arrival date will trigger an action…

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…

My client uses the Sage add-on Compleat Purchase to Pay. Since upgrading to v24.2.228, when Compleat posts to Sage, the invoice date is transposed from UK format to US format. I have asked Compleat to investigate at their end, but they do not seem to…

Good afternoon, I have just started using Sage Drive, and the date format has somehow set itself to 05-010-2017. Does anyone know how to amend to 05/10/2017? Best, Camilla

Hello I'm Kerry, Here's the issue - Half of our PC's have been updated to sage V24 were the other half are still on version 23, for those on V23 everything is fine , no issues, no problems... YET for those who are running V24 all of the memos that…

I create purchase orders from 'products and services' by highlighting my product and clicking buy/sell and then Purchase order. When I eventually update the PO to an invoice, the lastest price updates but not the last order date?

Hello, I'd like to convert datatime in a field to a string. Using datetime$ gives me '2018-06-20T07:47:32Z'. How can I get rid of all the signs between the digits? Thanks Ania

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 all. Is it possible at all to customize the standard date widget? For example, i s there a way that the week number displayed at the footer of the date picker can reflect the week of financial year rather than the calendar year? Thanks in advance…

Hi there, I'm trying to use the datatype ADATIM in classes and representations to manipulate departing times and estimated delivery times. The problem is every time I try to edit the field I get the error "invalid format type" Here is a print…

How can I go about changing the delivery date on a delivery. The delivery has been validated but not invoiced.

Hi there, I'm trying to use POSTMAN to query if an INVOICE exists by date. What DATE format should I use? I'm trying: xx.xx.xx.xxx:xxxx/.../YSINVOICEV eq '2017-05-24', but I get the response: "$message": "X3 engine error: Type incompatibility…

Just wondering about sales invoices dated into the future, i.e. beyond Sage50's session date. I've never done this before and may have need to generate a sales invoice with a 'future date,' soon. Is this even possible/advisable? If yes, are there any…

Hi I came across this problem: when I want to chose a date from calendar, it only offers me one montn, March 2017. Let's say I choose March 1st, Sage tells me it is an invalid date (!), My fiscal year starts on January 1st How come that I can…

Hey guys, I'm having an problem where the Funstop recurring task parameter REFDAT isn't tracking with the current date. I'm hoping there is a way to set the default value so that this will change. Right now I can set it to the current date and run…

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…

Hi, We are on Sage 2014 Service Pack 1 and we would like to know if there is a way to find out who made a post in GL entries and possibly the date and the time. Any clue?

does anyone know how I can prevent a Purchase Order being entered with an order date in the future thanks

Hello, When I entered receipt, I input the wrong receipt date and posting date as 01/12/2014 while it should be 01/16/2015 to match my batch deposit date. Then, I cleared it in the bank for the month of 1/31/2015's reconciliation. Later, when I reviewed…

It has always been most efficient for us to enter our time on a slip by using the 'start time' and 'stop time' popup box. In the our previous version (2007), the 'start time' on a new slip would default to the 'stop time' on the previous slip. We just…

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…