another blog

Icon

About Microsoft Dynamics GP :-)

Not all RW_Function are meant for reports.

There are lots of RW functions available in a report writer Calculated Field Definition window and almost all of them are so handy while working on report writer, but it is a matter of fact that some of them are not actually meant for report writer. Usually RW functions are associated with report writer and dex people sometime ignore a fact that RW function can be created equally as for Form or window access, and may be called by multiple windows and events.

While working with report writer I com across a similar function, which is actually call by dynamics gp window and when I tried to use it on report write it returns nothing. The function I am talking about is rw_ivGetFuncListPrice().

When I called the same function from dexterity window it returns me the correct value. So I log a script of my code calling this function and gets a bunch of activity.

ListPriceLog

On calling function, it creating instance of form ivItemCurr and then setting values, and then calling another function GetListPrice() of form ivItemCurr, These functions may referencing the various information for item objects and GetListPrice() function is actually returning the List price of item, and that’s why when calling from item maintenance window returning a valid value. Calling same function from Sales transaction Entry window with passing same item number returns nothing, just like a report writer.

To get list price, a custom RW_Function is a solution, and if directly using repory writer modifier and VBA can do the work.

 

 

 

 

 

 

 

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.