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

Notifications

Announcements

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
I have the same question (0)
  • Gerardo Rentería García Profile Picture
    25,392 Most Valuable Professional on at
  • Valentin Castravet Profile Picture
    31,586 Super User 2025 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,202 Super User 2025 Season 2 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
    95,930 Super User 2025 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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,688

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 784 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 595 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans