Find Original quantity requested on a Transfer Order

I am writing a SSRS report that needs to go back in time to find what was originally ordered and what was sent and received and returned on a Bin Transfer. I have no problem with the sent and received and returned but can anyone tell my where the originally ordered amount can be found.

Thanks

I believe it is just the quantity. If the originally suggested is 5 and the users pick, ship and receive 4 do they leave the 1 outstanding on the order? If they do then you will have many documents fulfilling the original order, if they alter the quantity then there is, as standard, no record of the original quantity in the database - so really it depends upon how you process differences in the system.

Thanks, but is seems that the quantity to start with is not the original requested qty but the amount that was actually transfered, we may have created a transfer for 5 but only transfered 4 all we see is 4 on the quantity or am I missing something

Thanks

Thanks, but is seems that the quantity to start with is not the original requested qty but the amount that was actually transfered, we may have created a transfer for 5 but only transfered 4 all we see is 4 on the quantity or am I missing something

Thanks