Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How To Calculate Quant...
Small and medium business | Business Central, N...
Suggested answer

How To Calculate Quantity Sale Not Post

(1) ShareShare
ReportReport
Posted on by RP-22070833-0 8
Hello everyone, I'm doing a warehouse report. I need the quantity of items in stock, however the Dynamic NAV ERP system my company is using allows for post-shift closing, which means selling before inventory is available. Now I need to calculate the items sold but not yet posted and the Value Entries table. For example, it is now July, my company has only finished its shift until the end of June. The data of items sold from the beginning of July until now has not been posted because the shift has not ended yet. However, I need to calculate the exact number of items in stock. Is there a way to get a list of items that have been sold but haven't been posted yet?
 
Categories:
Dynamics 365 Business Central
2024-07-17_16-26-...
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 85,674 Super User 2025 Season 1 on at
    How To Calculate Quantity Sale Not Post
    Hi, Another approach is to move in and out of a specialized LOCATION. Inventory that has been sold and not yet posted is moved to this LOCATION first, so that quantities can be easily counted.
     
    Hope this can give you some hints.
    Thanks.
    ZHU
  • Jun Wang Profile Picture
    Jun Wang 7,971 Super User 2025 Season 1 on at
    How To Calculate Quantity Sale Not Post
    based on your current processes, it would be challenging to run an accurate report for a month that hasn't been closed. I guess the user keeps track of qty of items that should have been shipped/invoiced? If so, you could manually deduct the sum of shipped but unposted qty of items for the report.
  • Valentin Castravet Profile Picture
    Valentin Castravet 28,288 Super User 2025 Season 1 on at
    How To Calculate Quantity Sale Not Post
    Do you change the status of a sales order once the inventory is sold but not shipped? For example do you change the status from open to released? If you do that, then you can built the report to look at the sales lines table for all lines where the order status is released. 
     
    Alternatively, I would look into changing your process because its not the most accurate to ship inventory but not mark it as shipped in the system. 
     
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 20,775 Most Valuable Professional on at
    How To Calculate Quantity Sale Not Post

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans