What do you mean by Quantity the field? Do you mean single code or something?
I have tried using your method but what field should I be taking from the 2 tables to link up as source?
Yes, I believe so but it is not a 1 table to 1 table, I think here they are 3 tables involved so even if I change the date to ActualSalesDate, I need to lookup from another table for the Attributes on Item Master.
I have seen people using the below command. Will that help and how should I be coding it?