Icon

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"
Step #1: Click on "Zero stock Locations"
2
Click to and select "99"
Step #2: Click to and select "99"
3
Drag here
Step #3: Drag here
4
Click on "99"
Step #4: Click on "99"
5
Click on "OK"
Step #5: Click on "OK"
6
Click here
Step #6: Click here
7
Click here
Step #7: Click here
8
Click on "Microsoft Excel 97-2000 - Data only ( XLS )"
Step #8: Click on "Microsoft Excel 97-2000 - Data only ( XLS )"
9
Click okay
Step #9: Click okay
10
Click on "OK"
Step #10: Click on "OK"
11
Click on "Desktop"
Step #11: Click on "Desktop"
12
Chane file name to "Without"
Step #12: Chane file name to "Without"
13
Click on "Save"
Step #13: Click on "Save"
14
Click on "Yes" if file already exists
Step #14: Click on "Yes" if file already exists
15
Click here
Step #15: Click here
16
Click on "Zero Stock Locations" again
Step #16: Click on "Zero Stock Locations" again
17
Click here
Step #17: Click here
18
Drag here
Step #18: Drag here
19
Change to 99 again
Step #19: Change to 99 again
20
Click here
Step #20: Click here
21
Click on "Without" and change to "With"
Step #21: Click on "Without" and change to "With"
22
Click on "ок"
Step #22: Click on "ок"
23
Click here
Step #23: Click here
24
Click here
Step #24: Click here
25
Click on "- Data"
Step #25: Click on "- Data"
26
Click here
Step #26: Click here
27
Click on "OK"
Step #27: Click on "OK"
28
Change file name to "With"
Step #28: Change file name to "With"
29
Click here
Step #29: Click here
30
Click on "Yes" if overwriting a file
Step #30: Click on "Yes" if overwriting a file
31
Click on "Х"
Step #31: Click on "Х"
32
Open "Website Files - DO NOT DELETE"
Step #32: Open "Website Files - DO NOT DELETE"
33
Open "Consolidations (NEW) autofunction"
Step #33: Open "Consolidations (NEW) autofunction"
34
Click on "Combine with / without"
Step #34: Click on "Combine with / without"
35
Select which area you would like to consolidate
Step #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
Step #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.

Using the consolidation report