SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Oct 2012
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Inventory Report

    My database with the following table:
    ITDetail Table:

    InvTrans Table:

    Currency Table:

    Database Relationship:



    I need to build a report with the time parameter (use the procedure) with the following requirements:



    MaterialID, Art, Color, Width is taken from the table ITDetail
    Period: 1 to 90 (days)
    a. Quantity: with TypeID is 'X' is the OUT quantity (X001, X002, ...), with TypeID is 'N' is the INT quantity (N021, N014, ...)
    A: Total quantity IN of 1 to 91 (days)
    B: Total quantity OUT of 1 to 91 (days)
    C: The quantity need to find

    If: A≥B then C = A B; If A<B then C = 0

    b. Price:

    USD: Price = Quantity * ExchangeRate (USD in InvTrans table)
    VND: Price = Quantity * 1
    3. Period: After 271 days

    X: Time parameter
    A: Total quantity IN of X to 271 (days)
    B: Total quantity OUT of X to 271 (days)
    C: The quantity need to find

    If: A≥B then C = A B; If A<B then C = 0

    Appreciate your help! Thanks!

  2. #2
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,496
    Mentioned
    163 Post(s)
    Tagged
    4 Thread(s)
    Welcome to the SP forums.

    Homework assignment?
    What do you have so far?


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •