another blog

Icon

About Microsoft Dynamics GP :-)

Hints and Tips… On going Post

This is on going post and points will be added from time to time. 🙂

.. with Field Level Security we can not restrict document access on Sales transaction entry Window. Means we can not make user to choose only ‘Invoices’ in SOP Type drop down.

.. we can not add custom table in table relationship of GP tables for report writer, while modifying report in dictionary. Because we can not drop/create GP table and update it’s relationship information.

..To access ‘Human Resource Preferences’, go to Tools>>Setup>>System>>Human Resource Preferences

.. To have ‘Mail Recipient (PDF)’ option available, Adobe PDF writer must be install on machine.

.. Triggers can be register against local fields on window.

Filed under: Dynamics GP, dynamics-gp

Reversing the sort order of Receivable Transaction Inquiry – Customer by Document Date

Last few months we got more request on changing sort orders of Inquiry windows and lookups and to cover them all in a one place I have been working on a small project which will provide a simple sorting without much effort. In Dynamics Community there was a post having similar situation, I have already worked on this sort option and so sharing a solution here so if anybody want can use it ( free of any cost). This one window is a part among other windows I have added sorting functionality and it will hopefully be completed very soon with easy to install and remove functionality. Below is a link for downloading chunk file, all we need to do is to copy this chunk file inside a GP folder and then login to GP with user ‘sa’ and on message to add new code press ‘yes’ button and login to GP. The product ‘amSort’ will be added in .set file.

In order to remove the functionality , product can be easily delete from dynamics.set file.

https://www.dropbox.com/s/v4zvknh2o49l6w8/amSort.zip?dl=0

 

 

Filed under: Dynamics GP, dynamics-gp

Enter your email address to follow this blog and receive notifications of new posts by email.

Enter your email address to follow this blog and receive notifications of new posts by email.

3rd party database access 3180 adding CR in text field Adding NULL values in dropdown Adding Sample Company Data Adding Symbol to Currency fields Alternate Window Analytical Accounting Attachments cancel button Can I ... Carriage Return chunk CH_SPACE CMMTTEXT Cross Dictionary Dexterity Development Cross Dictionary Triggers Currency Symbol in Dynamics GP windows Damo Data for Dynamics sample company Datatype dex DEX.DIC dexterity Dexterity Currency field Dexterity Dropdown Dexterity finditem() Dexterity Triggers DEX_ROW_TS Dict_GetPathname() Dynamics GP Dynamics GP Posting Issues Finding GP Field finding specific field in tables Finding Table Focus Trigger FP: Script not found errors GETUTCDATE() great plains Grid How to identified product related to error. hyperspace Hyperspace property of dexterity field. Increasing Field Size of Dynamics GP Table INFORMATION_SCHEMA.COLUMNS Link Format Selector Microsoft Dynamics Error Modified Reports Modifier MOP_Order_MSTR Path_MakeNative() Path_SelectPathname() Posted receipts not showing on Enter Match Invoice window.Enter Match Invoice window. Project Accounting For Dynamics GP Reading Folder Redisplay Refill Report Destination Sales Transaction Entry Scroll Sanscript Saving Images Script Error Script Not Found Session access denied SmartList Favourites SQL Script to Find column in tables SQL_Execute SUSER_SNAME() TextFile_ReadLine() TextFile_WriteLine() The SELECT permission was denied on the object "XXX" transaction entry User access Using SQL in Dexterity VBA for Dynamics GP You may not edit this document . it is being edited by another user.

Enter your email address to follow this blog and receive notifications of new posts by email.

Freddys blog

Learn something new... - then Teach someone!

حلقۂ دام خیال

عالم تمام حلقۂ دام خیال ہے

M@ria

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*

Ghostriver Studios Blog

Sculptural stained glass of Andrew Kosorok

Dynamics GP Builders & Reporting

How to use MS Dynamics SmartList Builder, Excel Report Builder and other Reporting tools to get the data and analysis you need.