0

My database with the following table:

ITDetail Table:
Click Here

InvTrans Table:
Click Here

Currency Table:
Click Here

Database Relationship:
Click Here

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

  1. MaterialID, Art, Color, Width is taken from the table ITDetail
  2. 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
Contributors
1
Reply
11
Views
5 Years
Discussion Span
Last Post by LastMitch
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.