Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Transaction Level Detail
Microsoft Dynamics NAV (Archived)

Transaction Level Detail

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

I am not a user of Dynmaics NAV.  I am requesting transaction level detail from a company I am working with (from sales and cost perspective) for the prior three years.  What I would like to know (without having familiarity with the interface, capabilities, or the users proficiency with the system) is 1) is it possible to pull transaction level detail (date, invoice/po#, customer, product, supplier, invoice amounts, material costs, quantity, etc.) in excel format? and 2)are there any resources or step by step guides that could walk us through this process?  Thank you in advance for any assistance or insight.

*This post is locked for comments

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Transaction Level Detail

    NAV is very flexible to provide you with needed data.

    Generally it has several ledgers that store the data (General Ledger stores accounting transactions; Customer and Vendor ledger store related information on invoices and payments; Item ledger contains the information on items movement and values).

    E.g., you can first refer to the lists of posted sales invoices. Type "Posted Sales Invoices" in the search field to get the needed list. Then you can export it to Excel using standard tools.

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Transaction Level Detail

    You need to search the reports in Navision for getting these details as there are lot of reports available.

  • Verified answer
    JUBEL THOMAS JOY Profile Picture
    JUBEL THOMAS JOY 231 on at
    RE: Transaction Level Detail

    Hi,

    Lots of Standard reports available. As you said you don't have much understanding about system. Suggested way is to consult any consultant and find out any report already there in your format. If not there then create the same to overcome this situation.

    Also there is several integrated functionality available on NAV. By the help of that you can extract the data directly from Excel as well by writing simple SQL query.

    Regards,

    Jubel

    navisionplanet.com

  • Verified answer
    tpupko Profile Picture
    tpupko 2,048 on at
    RE: Transaction Level Detail

    Hi,

    1) is it possible to pull transaction level detail (date, invoice/po#, customer, product, supplier, invoice amounts, material costs, quantity

    Of course it is possible, you can easily take this data from NAV using standart NAV reports like Customer/Item Sales or Sales Analisys by Dimensions (msdn.microsoft.com/.../hh169156(v=nav.90).aspx

    msdn.microsoft.com/.../hh168163(v=nav.90).aspx)

    If you want to see all transactions you can check Item Ledger entries and Vallur entries by entry type - Sale

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: Transaction Level Detail

    Which version of NAV are they using ?

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Transaction Level Detail

    Hello, There are several finance and sales reports in Navision which can provide you the information you requested, you just need to run those reports and choose the export to excel option.

    Daily Invoicing Report, Customer/Item Sales Report

    See this link for some of the reports

    msdn.microsoft.com/.../hh179053(v=nav.90).aspx

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans