Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Invoice report Layout

Posted on by 510

Hi all,

If I wanted to have an invoice layout that was specific to a customer- is this possible in Nav 2013?

Regards,

Tony

*This post is locked for comments

  • RE: Invoice report Layout

    Hi Ramesh,

    I was assuming that Toni has done the C/AL part of it and struggling with the Layout. Thank you for pointing it out.

    Kudos.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoice report Layout

    Hi Ramesh,

    Thank you for your help. You're right. It works.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoice report Layout

    Hi Toni,

    i think you missed to Give this Customer.CALCFIELDS(Picture).

  • RE: Invoice report Layout

    Hi Toni,

    You did exactly what it requires,  but you also need to add the image in the table in order to preview.

    I just created a test report to show the company information where I added the image, it works fine.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoice report Layout

    Hi,

    Thank you for your fast reply.

    I already did this:

    Select the image source: Database

    Use this field: not sure

    - =Fields!Customer_Picture.Value

    - =Convert.ToBase64String(First(Fields!Customer_Picture.Value, "DataSet_Result"))

    Use this MIME type: image/bmp

    Size: fit proportional

    But the image is not added, I can see see only its border.

    Best regards,

    Toni

  • RE: Invoice report Layout

    Hi Toni,

    Customer picture field (Field 89) is already there in Customer Table (Table 18).

    You can add the field to the report dataset and then to the layout.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoice report Layout

    Hi,

    Configured, I can read now the fields but can't insert a customer image into the layout.

    Best Regards,

    Toni

  • RE: Invoice report Layout

    No, still you need to customize!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoice report Layout

    Hi Tony,

    I'm looking for the same. Did you get any solution?

    Best Regards,

    Toni

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,135 Super User 2024 Season 2 on at
    RE: Invoice report Layout

    not possible in standard NAV. you need to customize.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans