 Paul Trowbridge
|
4f33136a15
|
style code was not getting set as part of the item master snap
|
2021-05-13 13:54:42 -04:00 |
|
Paul Trowbridge
|
1faa832c5b
|
use inbound segment to hook with exisiting baseline data
|
2021-05-12 11:46:02 -04:00 |
|
Paul Trowbridge
|
4c926b63e6
|
include log pieces for initial use
|
2021-05-12 11:42:09 -04:00 |
|
Paul Trowbridge
|
4560c82903
|
initial work on forcing forecast to match targets by account
|
2021-05-12 08:07:57 -04:00 |
|
Paul Trowbridge
|
b4e592bbf1
|
exclude retail from pricing upload
|
2021-05-10 16:53:36 -04:00 |
|
Paul Trowbridge
|
e0d32cf4cf
|
get rid of commented out stuff
|
2021-05-10 16:06:55 -04:00 |
|
Paul Trowbridge
|
e376a9df2e
|
many changes
|
2021-05-07 14:32:18 -04:00 |
|
Paul Trowbridge
|
b7eb94202c
|
work on getting to right price
|
2021-05-07 10:12:33 -04:00 |
|
Paul Trowbridge
|
032736f0e9
|
convert script to live db and do rounding on final build
|
2021-05-03 12:33:34 -04:00 |
|
Paul Trowbridge
|
f2b6686f3e
|
insert directly into the pool and igonore net cost amount as a filter
|
2021-05-03 09:09:21 -04:00 |
|
Paul Trowbridge
|
e79c0d5bb4
|
round before removing, keep any rows that have a qty, value, or cost
|
2021-04-30 11:25:44 -04:00 |
|
Paul Trowbridge
|
36d80dd296
|
relable actuals later as copy so it is considered part of the baseline
|
2021-04-29 18:25:09 -04:00 |
|
Paul Trowbridge
|
8de3ee5717
|
fiscal period was blank cause rows not to net to -0- with merge, iteration name incorrect for baseline
|
2021-04-29 16:12:54 -04:00 |
|
Paul Trowbridge
|
b4e2ca7919
|
target osfm_dev as forecast staging area, no need to preserve; set fspr; stage pool instead of direct insert for debug
|
2021-04-29 13:42:10 -04:00 |
|
Paul Trowbridge
|
0a96759945
|
all forecast builds become an iteration overtop existing data
|
2021-04-29 11:16:23 -04:00 |
|
Paul Trowbridge
|
ac3c50dbba
|
work on merging actuals
|
2021-04-28 17:34:44 -04:00 |
|
Paul Trowbridge
|
97f73e5107
|
notes on old update prior year baseline approach
|
2021-04-28 11:14:43 -04:00 |
|
Paul Trowbridge
|
78a9658e80
|
need to include director comparison to hook for changes
|
2021-04-23 09:41:38 -04:00 |
|
Paul Trowbridge
|
67e5466f72
|
need to set director while snapping quota rep
|
2021-04-23 09:08:47 -04:00 |
|
Paul Trowbridge
|
0d7cabd0ee
|
merge dev
|
2021-04-22 17:48:00 -04:00 |
|
Paul Trowbridge
|
c92f945a71
|
join to materialized view
|
2021-04-22 17:47:29 -04:00 |
|
Paul Trowbridge
|
da8e1353f3
|
notes on regional pricing and link in target pricing
|
2021-04-22 17:46:56 -04:00 |
|
Paul Trowbridge
|
704957a2fa
|
update product notion to include color tier
|
2021-04-21 17:24:05 -04:00 |
|
Paul Trowbridge
|
683921dda0
|
work on last price
|
2021-04-20 16:11:34 -04:00 |
|
Paul Trowbridge
|
c9811e69db
|
round all routes to 2 decimal places
|
2021-04-19 09:39:53 -04:00 |
|
Paul Trowbridge
|
66b74e31cb
|
update all routes to round to 2 decimals for units, value, and cost
|
2021-04-19 09:20:52 -04:00 |
|
Paul Trowbridge
|
1f96081a41
|
update script to snap the whole pool to the
appropriate quota rep.
|
2021-04-16 13:58:30 -04:00 |
|
Paul Trowbridge
|
e3722193c5
|
populate dsm when swapping customers, rework pool quate rep snap
|
2021-04-16 13:57:32 -04:00 |
|
Paul Trowbridge
|
d3937fc406
|
update customer swap route to evaluate a new quota rep and channel based
on the revised customers
|
2021-04-16 12:05:09 -04:00 |
|
Paul Trowbridge
|
d541ee16cc
|
re-assign channel based for customer swaps
|
2021-04-16 12:04:17 -04:00 |
|
Paul Trowbridge
|
60b57263d0
|
re-asign quata rep and director for customer swaps
|
2021-04-16 12:04:00 -04:00 |
|
Paul Trowbridge
|
745f83e502
|
Merge branch 'dev'
|
2021-04-14 11:55:49 -04:00 |
|
Paul Trowbridge
|
5162839c5d
|
Merge branch 'dev' into last_price
|
2021-04-14 11:28:27 -04:00 |
|
Paul Trowbridge
|
6f0d8745d2
|
include module used
|
2021-04-14 11:28:11 -04:00 |
|
Paul Trowbridge
|
d13519c07c
|
trim part number coming from CMS listing in spreadsheet with whitespace at end
|
2021-04-14 15:26:36 +00:00 |
|
Paul Trowbridge
|
89e4983a03
|
Merge branch 'dev' into last_price
|
2021-04-13 17:44:19 -04:00 |
|
Paul Trowbridge
|
3854bed603
|
further isolate odd orders, create change log
|
2021-04-13 17:44:06 -04:00 |
|
Paul Trowbridge
|
cf6e3b6695
|
save work on post-volume price adjustment
|
2021-04-13 16:51:00 -04:00 |
|
Paul Trowbridge
|
14ed4a95fe
|
Merge pull request #2 from The-HC-Companies/dev
part# whitespace
|
2021-04-13 16:23:42 -04:00 |
|
Paul Trowbridge
|
fee1b9202f
|
trim white space off part numbers
|
2021-04-13 16:15:11 -04:00 |
|
Paul Trowbridge
|
ab7af8d2ed
|
redefine segment
|
2021-04-13 16:10:04 -04:00 |
|
Paul Trowbridge
|
94ae5e192c
|
isolate short an over shipments
|
2021-04-13 16:01:00 -04:00 |
|
Paul Trowbridge
|
b38150e128
|
Merge pull request #1 from The-HC-Companies/dev
update master
|
2021-04-13 12:55:44 -04:00 |
|
Paul Trowbridge
|
7e4049d27d
|
set item master attributes prior to anythign else
|
2021-04-13 12:48:09 -04:00 |
|
Paul Trowbridge
|
50da4dfa17
|
prevent last price iteration from being available to delete, and rebuild price iteration to only look at baseline activity
|
2021-04-12 15:10:45 -04:00 |
|
Paul Trowbridge
|
3b3b01bb90
|
create procedure to convert pool to sales matrix columns
|
2021-04-12 13:13:38 -04:00 |
|
Paul Trowbridge
|
9db81ace17
|
do not snap fx rates when converting the pool
|
2021-04-12 11:28:04 -04:00 |
|
Paul Trowbridge
|
f156d599e5
|
refresh cut-off date, and correct spelling error in file name for rebuild script
|
2021-04-12 08:29:34 -04:00 |
|
Paul Trowbridge
|
409522677e
|
exclude dbeaver stuff
|
2021-04-08 15:47:21 -04:00 |
|
Paul Trowbridge
|
ab1d8f8778
|
validate the pricing upload is being included
|
2021-04-08 15:46:08 -04:00 |