Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 9 of 9

Thread: Reporting stock

  1. 06-28-2010, 05:35 AM #1
    snowy is offline Senior Member
    Join Date
    Jan 2009
    Posts
    148

    Default Reporting stock

    Hi - We have a requirement to report on the amount of stock we have in our warehouse on a given date.

    We have ML v8.0.1.2. (but no other stock control system) and the source code.

    Has anyone done this before?

    Thank you
  2. 06-28-2010, 07:21 PM #2
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    It sounds like you want to have a summary list of inventory balances of your products, correct? Create a custom report via the admin panel and use this sql command:

    Code:
    select pv.variantid,p.sku,pv.skusuffix,p.name,pv.name,pv.inventory from productvariant pv inner join product p on pv.productid=p.productid
  3. 06-30-2010, 01:11 AM #3
    snowy is offline Senior Member
    Join Date
    Jan 2009
    Posts
    148

    Default

    Thanks Alfred, we'll give that a go.
  4. 07-09-2010, 01:05 AM #4
    snowy is offline Senior Member
    Join Date
    Jan 2009
    Posts
    148

    Default

    Hi Alfred,

    We've tried running this report and it gives us all the stock currently in the warehouse.

    We need to be able to run the inventory report for a past date. Can you please tell me how can I make this query?

    Thank you
  5. 07-09-2010, 05:12 AM #5
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    What do you exact mean past date?
  6. 07-09-2010, 07:49 AM #6
    snowy is offline Senior Member
    Join Date
    Jan 2009
    Posts
    148

    Default

    So for example 31/12/2009.

    Thank you
  7. 07-12-2010, 02:38 AM #7
    snowy is offline Senior Member
    Join Date
    Jan 2009
    Posts
    148

    Default

    Can anyone help me with this please?

    I need to be able to report our stock for 31/12/09 for our tax return....and I need to be able to do it today!

    Thank you
  8. 07-12-2010, 05:56 AM #8
    ideal_airsoft is offline Member
    Join Date
    Nov 2007
    Posts
    43

    Default

    pretty sure what your asking is not possible with a stock db.
  9. 07-12-2010, 07:03 AM #9
    Richnyc30 is offline Senior Member
    Join Date
    Mar 2009
    Posts
    340

    Default recreating inventory of date

    It is possible. I did this for an accounting system so any date the A/R and other accounting could be reproduced at any date. I had to, for example, look at every payment and convert to deposit if necessary.
    For inventory you would have to take sales, returns, breakage and other items into account which would mean looking at all transactions, including receiving, back to the desired date.
    Actually not that hard but it takes time to program. Expensive for a single time use, but in the accounting reproduction it actually is very valuable to finding anomolies and errors.