We have a manufacturer that supplies us with daily stock updates for their items. What i am trying to accomplish, with no avail so far, is to create a way to track the daily changes for these items, to use in a dashboard that will track the daily inventory levels, giving us an idea to how the products stock levels changes throughout a period. Uploading the the inventory file on a daily basis, changes the quantities but does not track the changes. Is there anyway someone can point me in the right direction to accomplish this.
Thank you very much in advance for any input