Skip to Content


Hello helpful people

I'm trying to do a stock audit for report for a product code to see the quantity sold in a certain time frame, but the report only gives me a total for that time frame, for example, 245 of "con256" between 22-3 to 24-3.

I would like a way of showing how many product sold per day in that time frame rather than the total sold over the entire time frame, I dont think the standard business one report can do this, so if the only way to create a query for this, but can I get it so show the breakdown per day. ie

22-3 con256 qty44

23-3 con256 qty 56

24-3 con256 qty 145

thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 26, 2018 at 09:37 AM

    Stock audit report I mean

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 27, 2018 at 06:54 AM

    Hi Chris,

    The Stock Audit Report shows exactly what you are describing, a separate entry for each quantity leaving (deliveries, etc.) and coming in (goods receipts, etc.).

    In case you only get a single line for an item, as you described, then that item is not in any transactions during the given period. In other words, any and all transactions that led to the stock, as it is on 24-3, happened before 22-3.

    22-3 to 24-3 is only 2 days, and 24-3 is a saturday. Please try selecting only this one item, and choose a bigger interval, say 1-3 to 31-3.



    Add comment
    10|10000 characters needed characters exceeded

    • I certainly understand that, and in your case again I strong recommend that you learn SQL coding. Using the link I provided earlier, and the Query Generator tool found in the B1 client (Tools > Queries > Query Generator), I am confident you'll find it easier than expected to write at least a very simple query.

      With the Query Generator, and some help from this forum, you will be able to create all those reports yourself. Additionally, the skill will allow you to start making more effective use of Formatted Searches. Once you've gotten the hang of it, your SAP Partner is going to start calling you why they haven't heard from you in such a long time ;-)

      If you need custom addons, let me know. My guy only charges about 100€/h (85-90£), or I can put you on the road to building them yourself.