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.
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, rw_ivGetFuncListPrice()