Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Dynamic GP Report writer
Microsoft Dynamics GP (Archived)

Dynamic GP Report writer

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Dear All,

Can i modify by adding new field to the below mentioned inbuilt report writer field(field2)?

8055.image_2D00_2.jpg

Actually i wanted to take the value of document number field from payable transaction entry table (see red color box on below image) and...

I need to  display that document number in below mentioed red colored box in voucher  (report writer- first image )wich is getting from edit paybles check.

is there any way to add this field (document number ) in that field2(first image)i RW ?? this field to is dispalying maultiple lines..or any other way?

Some body please help?

*This post is locked for comments

  • soma Profile Picture
    soma 24,406 on at
    RE: Dynamic GP Report writer

    Belraj, sorry for my late response... Surely, i will update you on tomorrow..

  • Justin Thorp Profile Picture
    Justin Thorp 2,265 on at
    RE: Dynamic GP Report writer

    Hi All,

    This is possible using VBA with Report Writer.

    You basically need to make some conditions in VBA to test if it's an invoice (based on the value of "Field9"), then retrieve the DOCNUMBR from PM30200 (based on the first X number of digits from "Field2", because "Field2" prints the voucher number along with the date.

    Also, querying PM30200 assumes the invoice is fully paid off by this check.  If it's not then you'll need to do a little more coding to check the PM20000 also).

    Thanks,

    Justin

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Dynamic GP Report writer

    I believe that Leslie is correct - the problem with adding a field to a report that uses the Array type presentation like this, is that it uses subreports to get to the answer.

    In laymen terms, it means that the developer had to write code to get the data onto the screen for you.  Not the best, but it is the way this application works.

    Hope this help.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Dynamic GP Report writer

    I don't think he'll be able to do it. Not in Report Writer anyway.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamic GP Report writer

    Dear soma..,

    Kindly let me know, if you have any updates.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamic GP Report writer

    Dear Mr.Soma.

    Any updates?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamic GP Report writer

    thank you very much Mr.soma,

    Avaiting for your response ..

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Dynamic GP Report writer

    Thanks Soma,

    I look forward to reading about what you find. Whenever I've looked into changing those reports with Report Writer I run into a brick wall. What I learned is that those 'Field 2' type entries were like embedded subreports because they actually contain other one to many relationships. it's just like how you'd have to do a sub-report in Crystal. At that point we used a not RW solution. I've never tried to create a RW function to drop in the middle of all of that.

    Leslie

  • soma Profile Picture
    soma 24,406 on at
    RE: Dynamic GP Report writer

    Leslie, Report name - MC Computer Checks Posting Journals.

    Belraj,

    I will update you on coming sunday.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Dynamic GP Report writer

    Hi,

    I know Soma recognizes the report, but on my screen I cannot read the title. Which report is this?

    Leslie

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans