
Using the consolidation report
This is a step-by-step guide for SEQUEL_Dashboard.EXE, ViewPoint, and the consolidation excel file
By Josh Robinson
1
Click on "Zero stock Locations"

2
Click to and select "99"

3
Drag here

4
Click on "99"

5
Click on "OK"

6
Click here

7
Click here

8
Click on "Microsoft Excel 97-2000 - Data only ( XLS )"

9
Click okay

10
Click on "OK"

11
Click on "Desktop"

12
Chane file name to "Without"

13
Click on "Save"

14
Click on "Yes" if file already exists

15
Click here

16
Click on "Zero Stock Locations" again

17
Click here

18
Drag here

19
Change to 99 again

20
Click here

21
Click on "Without" and change to "With"

22
Click on "ок"

23
Click here

24
Click here

25
Click on "- Data"

26
Click here

27
Click on "OK"

28
Change file name to "With"

29
Click here

30
Click on "Yes" if overwriting a file

31
Click on "Х"

32
Open "Website Files - DO NOT DELETE"

33
Open "Consolidations (NEW) autofunction"

34
Click on "Combine with / without"

35
Select which area you would like to consolidate

36
if you want to print the sheets for yourself or warehouse staff press yes and it will print to your default printer

After the module has been ran it will write the quantities into quantities section so we can see locations available to be freed up and units to be moved.
With and without will need to be recreated if an allocation has been ran or put away has been created to avoid moving allocated stock.