Calculated Field Functions
The Calculations window had those in early builds, but they were removed from the eXtender Enterprise version on GP 2010. The documentation was not updated to reflect this.
To calculate the date differences, you can use the DateDiff function. The syntax is as follows.
DATEDIFF (datepart, startdate, enddate)
You can find a list of the functions in a How to Article on Microsoft's CustomerSource at the following URL.
https://mbs.microsoft.com/customersource/documentation/howtodocuments/msdgpfuncsberextender.htm?printpage=false&sid=ald1ragquihthmvzmyuwezu0&stext=SmartList builder functions
Hi Nicole, Thank you for the update, the DATEDIFF function worked perfectly. However we now have an issue when trying to export the window to import into a different GP company. When the export option is selected the following error message appears "A get/change first operation on table 'PT_Extender_Palettes' failed accessing SQL data", then more info [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'TWO.dbo.zDP_EXT40800F_1'. [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'PT_Palette_ID'. [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'PALETNME'. I have checked my installation and I also receive the same error message, the stored procedure does not exist in any of the GP company databases. How do I obtain this stored procedure? Is this a known issue? Are there any alternatives to the export option? Kind Regards, Nia.
The error you are receiving now indicates that you may have gone from the Extender Standard from Microsoft to Extender Enterprise from eOne, or vice versa. There are a few table changes that need to be made when you do this. If you were always on the Enterprise version, it possible that a Service Pack for GP without taking Extender out of the Dynamics.set file before applying the Service Pack. This will automatically convert it to the Standard version for the code which could also cause errors like this.
You can recreate the Stored Procedures for Extender in the company databases through the SQL Maintenance in GP (Microsoft Dynamics GP – Maintenance – SQL). If the tables have already been updated, recreating the views will work for you. If the tables haven't been changed, you will probably want to contact the support team by e-mailing firstname.lastname@example.org. They will be able to help you ensure all of the tables are correct.
If you would like to submit an answer or comment, please sign in to the eOne portal.