Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

What is the difference between Qty. (Calculated), Qty. (Phys Inventory) and Quantity in Navision 2018?

Posted on by 4,359

Hi Community,

What is the difference between Qty. (Calculated), Qty. (Phys Inventory) and Quantity in Navision 2018?

pastedimage1644548651535v1.png

Thank you!

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 73,565 Super User 2024 Season 2 on at
    RE: What is the difference between Qty. (Calculated), Qty. (Phys Inventory) and Quantity in Navision 2018?

    Hi, the 3rd Qty, 

    Quantity = ABS (QTY(Phys. Inventory) - Qty. (Calculated))

    pastedimage1644818674095v1.png

  • joshtechsolutions Profile Picture
    joshtechsolutions 4,359 on at
    RE: What is the difference between Qty. (Calculated), Qty. (Phys Inventory) and Quantity in Navision 2018?

    Hi all,

    Thank you for your answers, I notice there is a column with "Quantity", so what does this implies?

    Since there is already QTY in physical location and QTY(Calculated).

    What does the 3rd Qty meant? Is it for us to input the difference?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,565 Super User 2024 Season 2 on at
    RE: What is the difference between Qty. (Calculated), Qty. (Phys Inventory) and Quantity in Navision 2018?

    Hi, if you are talking about  Physical Inventory Journal, hope the following info will also help.

    pastedimage1644795324650v1.png

    Thanks.

    ZHU

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: What is the difference between Qty. (Calculated), Qty. (Phys Inventory) and Quantity in Navision 2018?

    Josh,

    Adding to Inge's reply...

    pastedimage1644613167776v1.png

    On the Physical Inventory Journal the columns Qty. (Calculated) is the quantity NAV has calculated when running the Calculate Inventory function. The field Qty. (Phys. Inventory), after running the function, shows the SAME QUANTITY but you can EDIT this field to enter the actual counted quantity.

    Hope this helps.

    Thanks,

    Steve

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: What is the difference between Qty. (Calculated), Qty. (Phys Inventory) and Quantity in Navision 2018?

    I assume you are doing physical inventory.

    Qty Calculated is the qty NAV calculates that your inventory is. qty. Phys inventory is the inventory you have counted.

    You can read more about that process here.

    bc365.co/.../

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans