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.

 

 

 

 

 

 

 

Advertisements

Filed under: Dynamics GP, dynamics-gp,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: