Calculated Field Functions
stephenkinnear@m4systems.com asked 10 years ago
Hi There, I am hoping you can help me with a query that one of our customers has. They are trying to add a calculated feild to an extender window. However when they click the arrow to open the Edit Calculated Field window all they can see is the fields section. They do not have access to the Functions and Conditions sections. In a screenshot in the user manual on page 64 there is a screenshot showing both of these sections. I have also tested on my install of extender and I also do not have the sections. How do the functions and conditions sections become visible? Also the user is trying to add a calucated field to take one date away from another to display the difference in days between the two dates. Is this possible in extender via a calculated field? If so what would the formula look like to produce this result? Many thanks in advance. Kind Regards, Nia.
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
Thanks,
Nicole
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 support@eonesolutions.com. They will be able to help you ensure all of the tables are correct.