|
|
28ee5dfbb4
|
update history pull to match dev branch
|
2021-04-07 12:55:35 -04:00 |
|
|
|
e4604a16f5
|
merge dev branch
|
2021-04-07 10:17:12 -04:00 |
|
|
|
551a4867d6
|
increment route fiscal years
|
2021-04-05 19:22:20 +00:00 |
|
|
|
e4054326d0
|
increment scenario selector
|
2021-04-05 12:36:51 -04:00 |
|
|
|
98eff757c0
|
add route for sales basis adjustment
|
2020-06-15 18:02:21 -04:00 |
|
pt
|
834d52a2a2
|
customer swap route will do nothing
|
2020-05-12 16:55:37 -04:00 |
|
Paul Trowbridge
|
3592120b54
|
Merge branch 'hist_list' into feature/cust_swap
|
2020-05-12 15:27:23 -04:00 |
|
Paul Trowbridge
|
e3205a94c1
|
setup history listing to be based on a where clause to allow for director level
|
2020-04-02 09:55:53 -04:00 |
|
Paul Trowbridge
|
aca8fa7aeb
|
Merge branch 'dev' into feature/cust_swap
|
2020-03-19 11:52:25 -04:00 |
|
Paul Trowbridge
|
85db8616e5
|
shipto incorrectly referencing billto
|
2020-03-18 15:32:04 -04:00 |
|
pt
|
1c0e07502d
|
swap (#45)
|
2020-03-13 14:48:26 +00:00 |
|
pt
|
ebc7d90dc5
|
work on customer swap route
|
2020-03-13 01:37:57 -04:00 |
|
pt
|
3540c35629
|
add list of customers
|
2020-03-12 23:58:39 -04:00 |
|
Paul Trowbridge
|
3d5cd9b2ff
|
only swap parts if a replacement is given
|
2020-03-06 05:48:39 +00:00 |
|
Trowbridge
|
87d5dbceaf
|
handle costs and major groups
|
2020-03-05 00:59:59 -05:00 |
|
Trowbridge
|
77fe829ece
|
posting a part swap
|
2020-03-04 17:53:50 -05:00 |
|
Trowbridge
|
28865863bd
|
filter out low grade matches
|
2020-03-04 17:13:36 -05:00 |
|
Trowbridge
|
3492c802b9
|
add route to get suggested swap
|
2020-03-04 17:13:17 -05:00 |
|
pt
|
10d20e050e
|
use basline fx and new budget period fx rates
|
2020-02-26 23:55:20 -05:00 |
|
Trowbridge
|
8838fdbcbc
|
add in currency
|
2020-02-26 17:07:49 -05:00 |
|
Trowbridge
|
43a194b116
|
add terms to base mix
|
2020-02-26 17:07:35 -05:00 |
|
Paul Trowbridge
|
fb1fcabb00
|
coalesce DBA and coalesce FX for local
|
2020-02-26 10:35:41 -05:00 |
|
Trowbridge
|
ebc169e34a
|
direct not hooking up due to change to using just the name
|
2020-02-25 16:57:08 -05:00 |
|
Paul Trowbridge
|
ffee472954
|
make date ranges inclusive of lsat date
|
2020-02-25 16:50:39 -05:00 |
|
Paul Trowbridge
|
e05efeb1e2
|
24 hour format on the stamp
|
2020-02-25 16:49:46 -05:00 |
|
Trowbridge
|
df02a31000
|
the module is stored as key type in the json
|
2020-02-25 15:08:01 -05:00 |
|
Trowbridge
|
abfa3d0e7c
|
exclude initial build from tag list
|
2020-02-25 12:03:30 -05:00 |
|
Trowbridge
|
a835ed7b3e
|
date format
|
2020-02-25 12:03:11 -05:00 |
|
Trowbridge
|
03e532857d
|
change time stamp and add sort
|
2020-02-25 10:54:45 -05:00 |
|
Trowbridge
|
787cc9452f
|
remove white space in month formatting
|
2020-02-25 10:11:40 -05:00 |
|
Trowbridge
|
879319b889
|
change how currency is handled and add sort to month
|
2020-02-25 10:01:09 -05:00 |
|
pt
|
60ace348b8
|
pretty print doc
|
2020-02-25 00:27:30 -05:00 |
|
Trowbridge
|
8f23f43492
|
move a bunch of files
|
2020-02-20 14:32:43 -05:00 |
|
Trowbridge
|
fcc95ecb40
|
validate forecast matches actual, build in log entries for initial build
|
2020-02-20 14:26:39 -05:00 |
|
Paul Trowbridge
|
f924da0e4d
|
move files around
|
2020-02-19 17:05:27 -05:00 |
|
Paul Trowbridge
|
0095e1983c
|
forgot end
|
2020-02-19 16:45:52 -05:00 |
|
Trowbridge
|
ff1304be3c
|
add substance column and move some files out of the route folder that aren't actually being used by routes
|
2020-02-19 13:25:28 -05:00 |
|
Trowbridge
|
cbc2caa41d
|
add module back in
|
2020-02-18 17:10:49 -05:00 |
|
Trowbridge
|
69346646bd
|
change module to be the comment
|
2020-02-18 15:35:56 -05:00 |
|
Trowbridge
|
d3a4a45d53
|
change comment to be the tag
|
2020-02-18 14:47:46 -05:00 |
|
pt
|
83039b4a51
|
notes (#32)
|
2020-02-18 19:25:57 +00:00 |
|
pt
|
ff3e18edc7
|
add sort to month name
|
2020-02-16 22:23:38 -05:00 |
|
pt
|
53ac7f90e2
|
putting wrong sort number on month
|
2020-02-15 03:45:22 -05:00 |
|
pt
|
e7ce48405b
|
increment year
|
2020-02-15 03:26:04 -05:00 |
|
pt
|
c602564cb7
|
couple minor issues
|
2020-02-15 02:55:33 -05:00 |
|
pt
|
a83708a7ca
|
overhaul month_vp
|
2020-02-15 01:03:45 -05:00 |
|
pt
|
07f69a80ae
|
initial renaming of columns
|
2020-02-14 21:16:25 -05:00 |
|
Trowbridge
|
7635380ccc
|
ensure not to load null comments
|
2020-02-14 17:00:44 -05:00 |
|
Trowbridge
|
6774a2fdff
|
default load as not null
|
2020-02-14 17:00:06 -05:00 |
|
Paul Trowbridge
|
db13f3d38c
|
routes that make adjustments need to return comment info
|
2020-02-14 15:52:16 -05:00 |
|
Trowbridge
|
33041761c6
|
drop rows from both tables when undoing changes
|
2020-02-14 15:42:41 -05:00 |
|
Trowbridge
|
18558674c0
|
change key name to message
|
2020-02-14 14:41:51 -05:00 |
|
Trowbridge
|
6485613ab7
|
add undo route, and include comments
|
2020-02-14 14:41:29 -05:00 |
|
pt
|
1b8c101429
|
update history log
|
2020-02-14 02:24:52 -05:00 |
|
pt
|
6e8f026770
|
forgot to swap out alias
|
2020-02-14 00:15:11 -05:00 |
|
Paul Trowbridge
|
8aeecc845b
|
use materialized view of itemm and use date range object to facilitate join
|
2020-02-13 23:54:11 -05:00 |
|
Paul Trowbridge
|
8d1cd1ade6
|
functional but joining to itemm is very expensive
|
2020-02-13 17:29:13 -05:00 |
|
Trowbridge
|
acca526dca
|
overhaul new basket
|
2020-02-13 16:41:39 -05:00 |
|
Trowbridge
|
0c394b2557
|
update CTE names, remove volume filter
|
2020-02-13 14:00:04 -05:00 |
|
Paul Trowbridge
|
b3122a50bb
|
swap out return rows
|
2020-02-13 13:56:29 -05:00 |
|
Trowbridge
|
a4cf5b7607
|
insert new columns and log
|
2020-02-13 13:20:33 -05:00 |
|
Trowbridge
|
9793596d27
|
switch scale columns
|
2020-02-13 13:19:06 -05:00 |
|
Trowbridge
|
79ec4739c1
|
swap out basemix coluns
|
2020-02-13 13:18:55 -05:00 |
|
Trowbridge
|
a4d34ec83a
|
add column names
|
2020-02-13 13:10:18 -05:00 |
|
Trowbridge
|
e49c051383
|
clean-up minor errors, running now
|
2020-02-13 13:08:02 -05:00 |
|
Trowbridge
|
f83746b892
|
swap out returning columns
|
2020-02-13 12:48:51 -05:00 |
|
Trowbridge
|
fb7fdc7959
|
swap out columns on price adjust
|
2020-02-13 12:47:25 -05:00 |
|
Trowbridge
|
5e4690a1f4
|
swap out value fields
|
2020-02-13 12:47:01 -05:00 |
|
Paul Trowbridge
|
ef914f3d5e
|
insert to log and swap out columns on volume scale
|
2020-02-13 12:26:13 -05:00 |
|
Trowbridge
|
994b076321
|
swap out fb_qty or units
|
2020-02-13 12:21:30 -05:00 |
|
Trowbridge
|
610c78f36f
|
swap out basemix columns
|
2020-02-13 12:19:45 -05:00 |
|
Paul Trowbridge
|
04276a89cb
|
swap out iterdef with module, and point to osm_pool
|
2020-02-13 12:18:32 -05:00 |
|
Paul Trowbridge
|
21cb531e56
|
embed the module in the forecast pool instead of reading the json, cross join the newly inserted log file and id
|
2020-02-13 11:03:42 -05:00 |
|
pt
|
eddece49e1
|
start on scale_vd
|
2020-02-13 02:25:24 -05:00 |
|
pt
|
040ba4caf6
|
use copy not baseline, build log table
|
2020-02-13 02:25:02 -05:00 |
|
pt
|
d557fe9cc3
|
put the column names back
|
2020-02-13 01:11:51 -05:00 |
|
pt
|
ba28bb9f15
|
rebuild pool and add fx
|
2020-02-12 23:32:12 -05:00 |
|
pt
|
73ff0da13b
|
snap fx
|
2020-02-12 22:37:00 -05:00 |
|
pt
|
9ed969d9ef
|
snap item fields and customer fields
|
2020-02-12 21:42:47 -05:00 |
|
Paul Trowbridge
|
270409895c
|
exclude old orders where copying everything forward
|
2020-02-12 21:42:27 -05:00 |
|
Trowbridge
|
ae9bba67bd
|
fix casts
|
2020-02-12 17:13:00 -05:00 |
|
Trowbridge
|
e7904d5040
|
initial swipe at updating forecast structure
|
2020-02-12 17:12:49 -05:00 |
|
Paul Trowbridge
|
f111c8818f
|
start work on rebuilding for column changes
|
2020-02-12 14:33:59 -05:00 |
|
Paul Trowbridge
|
4b6cbd3ac5
|
Merge branch 'feature/newparts' into dev
|
2019-06-19 23:40:49 -04:00 |
|
Paul Trowbridge
|
c112c5a4a4
|
add bulk manipulation scripts
|
2019-06-19 23:29:51 -04:00 |
|
Trowbridge
|
031d2d4ae8
|
get rid of space
|
2019-04-30 15:43:50 -04:00 |
|
Trowbridge
|
2fb28dd85f
|
update was assigning wrong columns
|
2019-04-29 11:33:12 -04:00 |
|
Paul Trowbridge
|
cd53505d59
|
use replacement part in all cases, and apply currency
|
2019-04-16 18:50:01 -04:00 |
|
Trowbridge
|
82b0b10dfb
|
query no cost
|
2019-04-16 18:48:56 -04:00 |
|
Paul Trowbridge
|
8525e9c12a
|
rep query
|
2019-04-16 18:08:45 -04:00 |
|
Paul Trowbridge
|
9829d64368
|
swap part number and associated masterd data
|
2019-04-16 18:08:24 -04:00 |
|
Paul Trowbridge
|
f71fee5df6
|
add last change
|
2019-04-16 09:18:37 -05:00 |
|
Paul Trowbridge
|
7008f57f66
|
make sure days are between 1 and 28
|
2019-04-16 13:26:39 +00:00 |
|
Paul Trowbridge
|
06c545dbc6
|
update query to add new parts
|
2019-04-08 16:24:55 -04:00 |
|
Trowbridge
|
6cdac5ed2d
|
update part list to include clones
|
2019-04-08 10:30:44 -04:00 |
|
Trowbridge
|
7facfb963b
|
create new part master records from clones
|
2019-04-08 10:30:35 -04:00 |
|
Paul Trowbridge
|
c51c8e409b
|
star building queries to setup new retail parts as clones
|
2019-04-05 17:23:34 -04:00 |
|
Trowbridge
|
78f13c61e1
|
get rid of scrap files
|
2019-04-05 16:11:31 -04:00 |
|
Paul Trowbridge
|
bf03eff862
|
vupd was scaling from scratch instead of just cleaning up the volume increase to match the dollar target
|
2019-04-04 12:19:40 -05:00 |
|
Paul Trowbridge
|
22841d3671
|
fix issue with price adjustment
|
2019-04-03 14:07:49 -05:00 |
|
