locked
Inventory Aging RRS feed

  • Question

  • Hi,

    Can anybody please suggest to design database schema for inventory aging.

    Aging must be done based on inventory as on date.

    Thank you.

    Thursday, July 16, 2015 1:12 AM

Answers

All replies

  • You need let us what you are going design. Probably a brief new sentence about the requirement.

    -kccrga http://dbatrend.blogspot.com.au/


    • Edited by kccrga Thursday, July 16, 2015 5:09 AM
    Thursday, July 16, 2015 5:08 AM
  • Look at this web site, there is entire category named Inventory

    http://www.databaseanswers.org/data_models/


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    • Proposed as answer by Charlie Liao Tuesday, July 21, 2015 7:05 AM
    • Marked as answer by Charlie Liao Tuesday, August 4, 2015 7:43 AM
    Thursday, July 16, 2015 6:59 AM
  • Hi,

    I want to know the value of the stock based on purchase period.

    let say item A got 100 pieces in stock as on today but this quantity is segregated from difference purchases. So now i want to know Aging of this 100 pieces as mentioned below.

    25 - $1

    25 - $0.90

    50 - $1.05

    Tuesday, August 4, 2015 8:05 AM