Check Voucher Report

Hi…

I’m trying to redesign the Check Voucher Report, but for me to be able to acheive my desire report it’s a need to learn and know how to manipulate codes even in some simple one.

do you have any idea how to code MS NAV

like:

label ID 42.caption = textbox ID 33.text

textbox33 retrieve the Vendor Name from database vendor’s table and i want to appear that vendor name in the new Label 42

is it posible for me to learn codes? i’m eager to know. please help me can you give me some sugestions.

You have to use Text Box only in place of lable to show vendor name…

thanks, then after i use text box, how do i able to connect it? is it SourceExpr property?

thanks, then after i use text box, how do i able to connect it? is it SourceExpr property?

Yes, If it is direactly avalilable in your data item table…

Otherwise you have to get it through coding…

yes thak you i found it, finally it retrieve and it is available…[:)]

Welcome [:)]

but i found another problem, i’v descovered that it only function in the body where it belong so that links have connected, and then i create new body which cause problem

states:

“the variable GEN. JOURNAL LINE is defined more than once”

i know that it error because it can be use once to populate the records to be post.

what is the proper thing to do? i just want to retrieve the Vendor Name base on the vendor i tag on the line.

can you help me through codes?

from textbox.text -to- caption.

please guide me.

You cannot use same variable twise…You can modify it to “GEN. JOURNAL LINE2” or give a proper name

thank you, the gen.jrn.line 2 retrieve correctly, but why the original gen journal original line create redundant line exceeds.?

thank you, the gen.jrn.line 2 retrieve correctly, but why the original gen journal original line create redundant line exceeds.

I didnt get you…can you show screenshot?

oops… the first page is the coorect retreival of report but, it the following page retrieved some of journal line already posted.

why this happen i cant control the retreival of records.

i couldnt paste printscreen here.it wont paste…

if only there is a code that just reflect to label so that records from database wont be affected.

GnlJrnLine2.“LABEL4”.CAPTION = GenJrnLine.“Description”.TEXT

is there any book that i can read for some basic foundation of coding c/a l code of nav

You have to upload that using insert media which is besides smilies…

If I guess correctly, first 2 screenshots are of base report and 3rd one is customized…is it?

You have to filter the report with record which you have selected…

You can find all training docs in partnersource/customersource…

it’s only one retrieval of report in Payment Journal, i just fade the 3rd screenshot.

the report must retrieve only 1 report, but due to adding new gneral journal line in data item to have new body where i can put the new text box, it generate more records w/c not belong to the current entry

the only report to retreive is the second screen shot, that is my current entry to be post & prnt only 1 line entry.