86225ea7e5
Get pounds to update for each forecast adjustment.
...
Lots of cleanup here too, removing large swaths of code that are no
longer needed. Many improvements the Excel workbook, which is kept in
Teams, not git. These changes may or may not have had accompanying VBA
changes.
2023-04-27 16:54:37 -04:00
fde6c97964
Too many changes, too few commits.
...
A lot has changed here, including:
1. Adding pounds to the data available for display in pivot table.
2. Visual improvements
3. Code simplification
4. Hiding / showing sheets as needed. A developer's backdoor allows for
easy toggling for debugging purposes: Ctrl+RightClick on the Forecast
Adjustment form's "Selected Scenario" label.
5. Fixed a bug that happened when deleting rows from the basket. The
definition of the Target variable was lost in some cases.
6. Made use of the Cancel and Default form properties to purge some
unnecessary code.
7. Added a sheet that contains Help text for the users.
8. Replacing more harcoded range reference with range names.
9. Refactor checks for division by zero errors, and improve error
messages for users.
10. Remove manual formatting. It's already done and saved in the
workbook; there's no need to redo it in code.
11. Added more data validation before Save operation proceeds.
12. Added a new IntersectsWith function to simplify If statements.
2023-04-24 21:46:13 -04:00
Paul Trowbridge
12c17b0be6
adjust rep source to rlarp.repc, adjust join logic to match current osm definition
2023-04-05 13:02:53 -04:00
480adef789
Update some 2022 references to 2024, and fix round() function calls.
2023-04-05 12:37:35 -04:00
Paul Trowbridge
cc656d7c24
increment dates
2023-03-07 17:32:45 -05:00
bd8aa18208
Merge branch 'dev' of github.com:The-HC-Companies/forecast_api into dev
2023-03-01 18:00:18 -05:00
ed5975daf7
Switch source table from rlarp.itemmv to "CMS.CUSLG".itemm
2023-03-01 17:55:30 -05:00
Paul Trowbridge
5dc5a11489
increment year
2023-03-01 17:07:44 -05:00
5b507d3d65
Updates to the newest season in scenario_package.sql
2023-02-27 16:15:35 -05:00
Paul Trowbridge
ed1cd2b074
change iterations in monthly adjustments
2021-07-30 12:13:34 +00:00
Paul Trowbridge
28c14ece67
include plan and diff ase baseline iterations
2021-07-16 09:40:34 -04:00
Paul Trowbridge
f548780d9f
sort result sets by id
2021-06-02 15:50:21 +00: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
e3722193c5
populate dsm when swapping customers, rework pool quate rep snap
2021-04-16 13:57:32 -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
d13519c07c
trim part number coming from CMS listing in spreadsheet with whitespace at end
2021-04-14 15:26:36 +00: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
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
a328aaeaaf
running the SQL was commented out in the router, also the columns were incorrect when swapping customer, and outer join was spelled wrong
2021-04-07 21:23:19 +00:00
Paul Trowbridge
f7f26b2804
finish work on customer swap, start testing this
2021-04-07 20:23:12 +00:00
Paul Trowbridge
28ee5dfbb4
update history pull to match dev branch
2021-04-07 12:55:35 -04:00
Paul Trowbridge
e4604a16f5
merge dev branch
2021-04-07 10:17:12 -04:00
Paul Trowbridge
551a4867d6
increment route fiscal years
2021-04-05 19:22:20 +00:00
Paul Trowbridge
e4054326d0
increment scenario selector
2021-04-05 12:36:51 -04:00
Paul Trowbridge
98eff757c0
add route for sales basis adjustment
2020-06-15 18:02:21 -04:00
834d52a2a2
customer swap route will do nothing
2020-05-12 16:55:37 -04:00
3592120b54
Merge branch 'hist_list' into feature/cust_swap
2020-05-12 15:27:23 -04:00
e3205a94c1
setup history listing to be based on a where clause to allow for director level
2020-04-02 09:55:53 -04:00
aca8fa7aeb
Merge branch 'dev' into feature/cust_swap
2020-03-19 11:52:25 -04:00
85db8616e5
shipto incorrectly referencing billto
2020-03-18 15:32:04 -04:00
1c0e07502d
swap ( #45 )
2020-03-13 14:48:26 +00:00
ebc7d90dc5
work on customer swap route
2020-03-13 01:37:57 -04:00
3540c35629
add list of customers
2020-03-12 23:58:39 -04:00
3d5cd9b2ff
only swap parts if a replacement is given
2020-03-06 05:48:39 +00:00
87d5dbceaf
handle costs and major groups
2020-03-05 00:59:59 -05:00
77fe829ece
posting a part swap
2020-03-04 17:53:50 -05:00
28865863bd
filter out low grade matches
2020-03-04 17:13:36 -05:00
3492c802b9
add route to get suggested swap
2020-03-04 17:13:17 -05:00
10d20e050e
use basline fx and new budget period fx rates
2020-02-26 23:55:20 -05:00
8838fdbcbc
add in currency
2020-02-26 17:07:49 -05:00
43a194b116
add terms to base mix
2020-02-26 17:07:35 -05:00
fb1fcabb00
coalesce DBA and coalesce FX for local
2020-02-26 10:35:41 -05:00
ebc169e34a
direct not hooking up due to change to using just the name
2020-02-25 16:57:08 -05:00
ffee472954
make date ranges inclusive of lsat date
2020-02-25 16:50:39 -05:00
e05efeb1e2
24 hour format on the stamp
2020-02-25 16:49:46 -05:00
df02a31000
the module is stored as key type in the json
2020-02-25 15:08:01 -05:00
abfa3d0e7c
exclude initial build from tag list
2020-02-25 12:03:30 -05:00
a835ed7b3e
date format
2020-02-25 12:03:11 -05:00
PhilRunninger
Paul Trowbridge
pt
pt