# Check Voucher Report **URL:** \ **Category:** User Forum\ **Created:** [December 19, 2011, 3:51am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576 "2011-12-19T03:51:28Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![cristine](https://avatars.discourse-cdn.com/v4/letter/c/e95f7d/32.png) [@cristine](https://www.dynamicsuser.net/u/cristine)\ **Post date:** [December 19, 2011, 3:51am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/1 "2011-12-19T03:51:28Z")
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. ---
**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\ **Post date:** [December 19, 2011, 4:28am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/2 "2011-12-19T04:28:17Z")
You have to use Text Box only in place of lable to show vendor name… ---
**Author:** ![cristine](https://avatars.discourse-cdn.com/v4/letter/c/e95f7d/32.png) [@cristine](https://www.dynamicsuser.net/u/cristine)\ **Post date:** [December 19, 2011, 5:14am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/3 "2011-12-19T05:14:18Z")
thanks, then after i use text box, how do i able to connect it? is it SourceExpr property? ---
**Author:** ![cristine](https://avatars.discourse-cdn.com/v4/letter/c/e95f7d/32.png) [@cristine](https://www.dynamicsuser.net/u/cristine)\ **Post date:** [December 19, 2011, 5:14am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/4 "2011-12-19T05:14:42Z")
thanks, then after i use text box, how do i able to connect it? is it SourceExpr property? ---
**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\ **Post date:** [December 19, 2011, 5:17am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/5 "2011-12-19T05:17:02Z")
Yes, If it is direactly avalilable in your data item table… Otherwise you have to get it through coding… ---
**Author:** ![cristine](https://avatars.discourse-cdn.com/v4/letter/c/e95f7d/32.png) [@cristine](https://www.dynamicsuser.net/u/cristine)\ **Post date:** [December 19, 2011, 5:43am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/6 "2011-12-19T05:43:26Z")
yes thak you i found it, finally it retrieve and it is available…[:)] ---
**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\ **Post date:** [December 19, 2011, 5:47am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/7 "2011-12-19T05:47:28Z")
Welcome [:)] ---
**Author:** ![cristine](https://avatars.discourse-cdn.com/v4/letter/c/e95f7d/32.png) [@cristine](https://www.dynamicsuser.net/u/cristine)\ **Post date:** [December 19, 2011, 5:59am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/8 "2011-12-19T05:59:53Z")
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. ---
**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\ **Post date:** [December 19, 2011, 6:10am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/9 "2011-12-19T06:10:32Z")
You cannot use same variable twise…You can modify it to “GEN. JOURNAL LINE2” or give a proper name ---
**Author:** ![cristine](https://avatars.discourse-cdn.com/v4/letter/c/e95f7d/32.png) [@cristine](https://www.dynamicsuser.net/u/cristine)\ **Post date:** [December 19, 2011, 6:36am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/10 "2011-12-19T06:36:28Z")
thank you, the gen.jrn.line 2 retrieve correctly, but why the original gen journal original line create redundant line exceeds.? ---
**Author:** ![cristine](https://avatars.discourse-cdn.com/v4/letter/c/e95f7d/32.png) [@cristine](https://www.dynamicsuser.net/u/cristine)\ **Post date:** [December 19, 2011, 6:36am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/11 "2011-12-19T06:36:23Z")
thank you, the gen.jrn.line 2 retrieve correctly, but why the original gen journal original line create redundant line exceeds. ---
**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\ **Post date:** [December 19, 2011, 6:41am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/12 "2011-12-19T06:41:25Z")
I didnt get you…can you show screenshot? ---
**Author:** ![cristine](https://avatars.discourse-cdn.com/v4/letter/c/e95f7d/32.png) [@cristine](https://www.dynamicsuser.net/u/cristine)\ **Post date:** [December 19, 2011, 6:44am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/13 "2011-12-19T06:44:18Z")
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. ---
**Author:** ![cristine](https://avatars.discourse-cdn.com/v4/letter/c/e95f7d/32.png) [@cristine](https://www.dynamicsuser.net/u/cristine)\ **Post date:** [December 19, 2011, 8:28am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/14 "2011-12-19T08:28:27Z")
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 ---
**Author:** ![cristine](https://avatars.discourse-cdn.com/v4/letter/c/e95f7d/32.png) [@cristine](https://www.dynamicsuser.net/u/cristine)\ **Post date:** [December 19, 2011, 8:30am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/15 "2011-12-19T08:30:43Z")
is there any book that i can read for some basic foundation of coding c/a l code of nav ---
**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\ **Post date:** [December 19, 2011, 8:41am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/16 "2011-12-19T08:41:34Z")
You have to upload that using insert media which is besides smilies… ---
**Author:** ![cristine](https://avatars.discourse-cdn.com/v4/letter/c/e95f7d/32.png) [@cristine](https://www.dynamicsuser.net/u/cristine)\ **Post date:** [December 19, 2011, 9:35am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/17 "2011-12-19T09:35:05Z")
1. ![3554.problem.jpg](https://us1.discourse-cdn.com/flex023/uploads/dugusers/original/2X/d/d054dd1ae4f573b1c7722118e367b3dc7c946861.jpeg) ---
**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\ **Post date:** [December 19, 2011, 9:40am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/18 "2011-12-19T09:40:38Z")
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… ---
**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\ **Post date:** [December 19, 2011, 9:44am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/19 "2011-12-19T09:44:49Z")
> [@](#): > > is there any book that i can read for some basic foundation of coding c/a l code of nav You can find all training docs in partnersource/customersource… ---
**Author:** ![cristine](https://avatars.discourse-cdn.com/v4/letter/c/e95f7d/32.png) [@cristine](https://www.dynamicsuser.net/u/cristine)\ **Post date:** [December 19, 2011, 10:05am UTC](https://www.dynamicsuser.net/t/check-voucher-report/34576/20 "2011-12-19T10:05:36Z")
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. [Next page](https://www.dynamicsuser.net/t/check-voucher-report/34576.md?page=2)