G/L Error

Suds

Hi,

My Unit Price prints normally for normal line items, but when the type is switched to a G/L account it gives me an #Error. Has anyone run into this problem before? any ideas how to solve it?

Much obliged

Suds.

Big_D

Hi Suds

What report are you printing (is it standard) and can you submit a screenshot of the report?

With thanks

David

Suds

The Report is a Transaction Report i believe. and an image is attached.

Big_D

Hi Suds

Sorry you put this under classic client 0 hopefully somebody else can help you with RTC!

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

Belias

you're using blankzerofunction:

Public Function BlankZero(ByVal Value As Decimal)
if Value = 0 then
Return ""
end if
Return Value
End Function

but your IIF statement returns a "" if the UOM is blank (it's blank when the line is G/L, i guess). You pass that blank value to the blankzerfo function that wants a decimal instead. Thus, you get an error. A zero instead of blank should solve your issue easily (the zero will be blanked by the function)

Suds

I can get the error to disappear but the line price still doesnt appear even though there still should be one. Any idea why I'm having the problem between a regular Item and a G/L?

Belias

because your IIF says: "if there's a UOM in your line, show the price, otherwise show a zero.
Does your (temp) sales line have a UOM? if not, the report works as expected

Suds

There seems to be 2 conditions when it doesnt show (one that we just discovered). The G/L has a UOM and still does not display, as well when the Discount % field displays 100 the unit $ disappears too.

It's becoming a bigger mystery than we thought ](*,)

Thanks for the help so far!

Belias

is this report a standard one? if so, did you modify it?
is there a value (<>0) in the unit price of the sales line for your gl account?because the line discount % set to 100 should make the line amount "0" but should leave the unit price intact: did you do some modification about this standard behaviour?

mohana_cse06

and I hope "About this Report" result may help us..