Get all items that weren't sold

[Yousef_Amarneh]

Hello,

I have 2 tables, the first one is "Sales Transactions" and the second on is "Inventory", I need to get all items that weren't sold when thier quantity in the inventory is greater than zero.

Thanks.

[Yousef_Amarneh]

the client want to see a report that represent the sleeping stock since a specific date.

[paulyeo11]

Hi Sir

I see  now i understand . it is same like what i did.

My stock data file have last sold date and last purchase data.

So i manage to make use of last sold date to compute those items not move or sleep for more then that it can help us list those sleep stock and write off list.