Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Navision 2.6 sales invoice amount

Posted on by Microsoft Employee

where to I find the amount of a posted sales invoice?

*This post is locked for comments

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Navision 2.6 sales invoice amount

    Hi Kim,

    There are different ways to do it.

    The below is one among them:

    ExportSalesInv.FILENAME := FileNameToExport;

    ExportSalesInv.SETTABLEVIEW(SalesInvoiceHeader);

    ExportSalesInv.RUN;

    Where ExportSalesInv is a variable pointing to a dataport and SalesInvoiceHeader is a variable pointing to Sales Invoice Header, which is the source for Dataport in this example.)

    Best Regards,

    MMV

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Navision 2.6 sales invoice amount

    in the sales invoice line you have fields Amount, "Amount incl. Vat", "Line Amount excl. Vat". in the lines of form "posted sales invoice" are only field "Line Amount excl. Vat" is displayed per default. table "sales invoice header" (base table of form "posted sales invoice") has also two amount fields: amount and "Amount Including VAT". both are sum fields of the sales invoice line fields.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Navision 2.6 sales invoice amount

    how do you call a data port from within Navision

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Navision 2.6 sales invoice amount

    I have fonund it thank you

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Navision 2.6 sales invoice amount

    Hi,

    Which version of NAV you are using?  Are you using 2013?

    Best Regards,

    MMV

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