Provide assistance to Sir Mike de Villa regarding his inquiry on the last transaction of location 7710.
Step;
a. Query CSHDET table - no sales yet
b. Query Transfers table - last transaction date is Oct 14 from warehouse
As pre Sir Mike they wanted to deactivate location 7710, but I told him to consult this first with ICG because there were balances already for this location.