web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Sales line table
Microsoft Dynamics NAV (Archived)

Sales line table

(0) ShareShare
ReportReport
Posted on by Community Member

Hi ,

1.What is the difference between Quantity and Quantity(base) field in Sales line table?

2.Will Quantity and Quantity(base) field differ? If yes, Pls explain that case.


Thanks in Advance.


Regards,

Dinesh.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,985 Super User 2025 Season 2 on at
    RE: Sales line table

    Quantity (Base) depends upon the Unit Of measure Code you have selected in Sales Line and calculates based on setup of Item Units of Measure setup and Qty. per Unit of Measure on Item Card

  • Verified answer
    mmv Profile Picture
    mmv 11,471 on at
    RE: Sales line table

    Hi,

    As mentioned by Mohana, if your Item's Base Unit of Measure is PCS and you wish to sell it in BOX too.  If one BOX contains 10 PCS, you would set up the Item Unit of Measure as BOX with Base Unit of Measure 10 PCS.  

    So if you sell one BOX of that Item, the Quantity would be 1 and Quantity (Base) would b 10.

    Best Regards,

    MMV

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,241 Super User 2025 Season 2 on at
    RE: Sales line table

    Quantity is the quantity you enter on the sales line where as Quantity(Base) is the multiply of the Qty. Per Unit of Measure of the UOM you select on the sales line.

    For example: if you have an item with two UOM, PCS and PALLET where PALLET is defined as 12 PCS, then on your sales line when you enter qty. 1 and select UOM as PALLET then

    the Quantity is 1, and Quantity(Base) will be 12.

    So to answer your question Quantity and Quantity(Base) may differ depending upon the UOM you select on the line and same rule applies for other quantity fields.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Alexander Ermakov Profile Picture

Alexander Ermakov 2

#2
SC666 Profile Picture

SC666 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans