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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

How To Calculate Quantity Sale Not Post

(1) ShareShare
ReportReport
Posted on by 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?
 
2024-07-17_16-26-39.png
  • Gerardo Rentería García Profile Picture
    27,621 Super User 2026 Season 2 on at
  • Valentin Castravet Profile Picture
    32,800 Super User 2026 Season 2 on at
    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. 
     
  • Jun Wang Profile Picture
    8,220 Moderator on at
    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.
  • Suggested answer
    YUN ZHU Profile Picture
    103,132 Super User 2026 Season 2 on at
    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

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 674 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 362 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 359 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans