Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Report Issue for Sales Order

Posted on by 215

Hi everyone,

I know there have 4 status available on the sales order – open, released, pending approval and pending prepayment.

I had faced a weird problem which is when I run the RTC for the sales order, only report for status = Released able to print but other than status = released had some problem as stated below:

When I run the sales order without click inside the page of the sales order (eg No.1017), then I click Print Confirmation button (in menu bar), it able to prompt out the box for user to print the report whether the status is open, released, pending approval and pending prepayment(Refer Picture 1).

Meaning here: Without click inside the page(Refer picture 3), all the 4 status able to prompt out the box for user to print the report.

Picture 1: Able to prompt out the box for user to print the report

Capture0000.PNG

But when I click the list of Sales order (eg No.101020), and double click inside the No.101020, then click Print Confirmation, it will prompt out the error as show in the picture 3.

Picture 2: List of Sales order

4382.Capture3.PNG

Picture 3 : Inside the Page-Prompt error

8015.Capture2.PNG

So does anyone can tell me where I can fix the issue above, or where I need to do setting or coding anything in any page/table?

Thanks.

*This post is locked for comments

  • Verified answer
    TeddyH Profile Picture
    TeddyH 12,868 Super User 2024 Season 1 on at
    RE: Report Issue for Sales Order

    Note that there are some logic / calculation when you release the sales order.

    Sometime it is better to print after releasing the document to make sure that all the amounts are correct.

    If you remove the status check, you need to make sure that everything is alright.

  • Verified answer
    azelaya59 Profile Picture
    azelaya59 2,807 on at
    RE: Report Issue for Sales Order

    If you have a Developer's License, go to the Report itself and F9 - C/AL the code:

    2019_2D00_04_2D00_22_5F00_1125.png 

    2019_2D00_04_2D00_22_5F00_1128.png

    2019_2D00_04_2D00_22_5F00_1128_5F00_001.png

    Once in the code, search for "Released" to find the validation line:

    2019_2D00_04_2D00_22_5F00_1125.png 

    Once you have found is, just add the hash marks (//) to disable.

    Good Luck!

  • Jade Ng Profile Picture
    Jade Ng 215 on at
    RE: Report Issue for Sales Order

    Hi,

    So can you share me some ideas on where I can make changes?

    I have try search in google, but unfortunately I not able to find any solutions on that.

  • Suggested answer
    azelaya59 Profile Picture
    azelaya59 2,807 on at
    RE: Report Issue for Sales Order

    There must be a customization on the report prohibiting Sales Order without the "Released" status to print. Before you hunt and hash out the code, confirm the business rule that required the customization in the first place.

    Good Luck

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans