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.