Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Sales Order

(0) ShareShare
ReportReport
Posted on by 3,051

Hi

  When i create Sale Order when i release it gives error F7 Done must have a value in Sales Header Document Type =Invoice. It Cannot be zero or blank .

Secondly i want to know how to debug this error.

Page = Sale Invoice (43)

Source Table = Sale header(36)

Thanks

*This post is locked for comments

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Sales Order

    This error seems to be thrown from the TESTFIELD line. Please remove it (it’s unuseful with a Flowfield).

    If it not solves, please post a screenshot of this field definition (properties).

  • jsshivalik Profile Picture
    jsshivalik 3,051 on at
    RE: Sales Order

    Hi

      Min Value must be 0 or 1 . In Database it is showing yes/No . Where i can check this message

    error F7 Done must have a value in Sales Header Document Type = Invoice. It Cannot be zero or blank .

    I checked in CodeUnit but there is no such line. 

    Thanks

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Sales Order

    It retrieves the minimum value of the field "F7 Done" for your document.

  • nav.mukesh Profile Picture
    nav.mukesh 617 on at
    RE: Sales Order

    As this is flow field, the Value in "F7 Done" field on Sales Header with show the Minimum value from "F7 Done" from Sales Lines related to that Sales Header.

  • jsshivalik Profile Picture
    jsshivalik 3,051 on at
    RE: Sales Order

    Hi

      o.k i will try. What does this line does

    Min("Sales Line"."F7 Done" WHERE (Document Type=FIELD(Document Type),Document No.=FIELD(No.)))

    Thanks

  • Suggested answer
    nav.mukesh Profile Picture
    nav.mukesh 617 on at
    RE: Sales Order

    I am just guessing as this is a Customized function. Press F7 key on keyboard and see if you are able to release it.

    F7 displays the statistics which also calculate the Indian Structure and Tax related fields.

    If this doesn't work means there is some process that you need to do ensure that the F7 Done gets some value.

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Sales Order

    Please remove TestField("F7 Done") and see if it works now.

  • jsshivalik Profile Picture
    jsshivalik 3,051 on at
    RE: Sales Order

    Hi

      It is Boolean type . It is defined like this

    Min("Sales Line"."F7 Done" WHERE (Document Type=FIELD(Document Type),Document No.=FIELD(No.)))

    Thanks

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Sales Order

    Who has wrote this code? :) This is custom. F7 Done is a flowfield, this code calculates it and then tests that it has a value. Check how this field is defined in Sales Header table.

  • jsshivalik Profile Picture
    jsshivalik 3,051 on at
    RE: Sales Order

    Hi

     When debug . It goes to CodeUnit 414.

    In PerformManualRelease(VAr Salesheader : Record "Sales Header") . What does CalcFields,TestField does.

    With Salesheader do

     Begin

          CalcFields("F7 Done");

         TestField("F7 Done");

    End;

    Thanks

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans