Skip to main content

Notifications

Announcements

Share Your Journey with Power Pages and Help Shape Its Future!
News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / How To Calculate Quant...
Business Central forum
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:
Reports and Business Intelligence
2024-07-17_16-26-...
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,325 Super User 2024 Season 2 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,113 Super User 2024 Season 2 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 22,093 Super User 2024 Season 2 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. 
     
  • gdrenteria Profile Picture
    gdrenteria 9,228 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

News and Announcements

Share Your Journey with Power Pages and Help Shape Its Future!

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,480 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,388 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans