Commit Graph

514 Commits

Author SHA1 Message Date
Paul Trowbridge 7dab34e949 differentiate on bulk/case, and create different rates for warehouse 2021-04-08 15:45:14 -04:00
Paul Trowbridge 4c43a79f15 comments on iterations 2021-04-08 12:43:46 -04:00
Paul Trowbridge 9f208bc0b7 only snap fx for forecast orders 2021-04-08 12:35:22 -04:00
Paul Trowbridge a50de52702 update script, dont snap osm_pool fx 2021-04-08 12:11:02 -04:00
Paul Trowbridge 037070ed1e update quota_rep logic to mirror current sales matrix, create readme, adjust rebuild script 2021-04-08 11:42:09 -04:00
Paul Trowbridge ce91851d48 refresh template with new segments 2021-04-08 11:12:27 -04:00
Paul Trowbridge 3fae4d50cc update notion of segments when building the forecast pool 2021-04-08 11:09:12 -04:00
Paul Trowbridge c8cb809e18 Merge branch 'dev' of usmidlnx01:hc-companies/forecast_api into dev 2021-04-07 17:35:08 -04:00
pt 6c6452014f Create a route to facilitate swapping out customer for a given scenario
Reviewed-on: http://usmidlnx01:5440/hc-companies/forecast_api/pulls/46
2021-04-07 21:34:41 +00:00
Paul Trowbridge 19fc49420d must select the row from the list box in order ot change the customer 2021-04-07 17:33:32 -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 b487430057 forego adding in the ship-to province at this point 2021-04-07 12:56:31 -04:00
Paul Trowbridge 28ee5dfbb4 update history pull to match dev branch 2021-04-07 12:55:35 -04:00
Paul Trowbridge 6e4e64b3a4 clean up missed conflict, matches dev 2021-04-07 10:20:55 -04:00
Paul Trowbridge 07f36612d5 clean up missed conflict, matches dev 2021-04-07 10:20:33 -04:00
Paul Trowbridge e4604a16f5 merge dev branch 2021-04-07 10:17:12 -04:00
Paul Trowbridge a12fc36bad template file 2021-04-07 09:54:21 -04:00
Paul Trowbridge 94f925f1d8 initial work on baselining price 2021-04-07 09:53:32 -04:00
Paul Trowbridge 5dc43123c9 include style code in itemm snap 2021-04-07 09:04:01 -04:00
Paul Trowbridge 2013609c25 update fx to 79 2021-04-06 18:28:22 +00:00
Paul Trowbridge 694d805aaf update fx 2021-04-06 18:19:49 +00:00
Paul Trowbridge 59c32d8619 update conver_pool to match convert all equivalent, add fspr and quota rep 2021-04-06 14:14:04 -04:00
Paul Trowbridge 4acee798d2 Merge branch 'dustoff' of github.com:The-HC-Companies/forecast_api into dustoff 2021-04-06 08:35:59 -04:00
Paul Trowbridge 883840d565 master template 2021-04-06 08:35:53 -04:00
Paul Trowbridge 551a4867d6 increment route fiscal years 2021-04-05 19:22:20 +00:00
Paul Trowbridge 1b0f4b9f04 history target is wrapped in scenario key from UI 2021-04-05 19:03:31 +00:00
Paul Trowbridge a0a6a94107 add slash for directory 2021-04-05 19:03:00 +00:00
Paul Trowbridge e4054326d0 increment scenario selector 2021-04-05 12:36:51 -04:00
Paul Trowbridge 8307b7c8ea retain dsm and fx rates, couple date fixes 2021-04-05 12:06:49 -04:00
Paul Trowbridge fd855cda72 incrememnt to next year 2021-04-05 12:02:03 -04:00
Paul Trowbridge c4f3abd733 increment dates 2021-04-04 23:18:18 -04:00
Paul Trowbridge 6984b039f2 cannot do a normal join, bill to customer may not be in joined table, change to subquery 2021-03-08 17:59:20 -05:00
Paul Trowbridge b9ff9c1493 snap item master attributes 2021-03-08 17:52:47 -05:00
Paul Trowbridge c6df2774cb snap quota rep 2021-03-08 17:52:19 -05:00
Paul Trowbridge c0c0a98e1f fix a bunch of fake parts loaded for retail 2021-03-08 17:51:09 -05:00
Paul Trowbridge d53c7bec0a queries to move sales around for high-level spreading 2021-03-08 15:00:55 -05:00
Paul Trowbridge 3b983140b6 include setting fiscal period in pool conversion 2021-03-08 15:00:16 -05:00
Paul Trowbridge cf82925eca update quota rep logic 2020-06-16 15:53:02 -04:00
Paul Trowbridge 98eff757c0 add route for sales basis adjustment 2020-06-15 18:02:21 -04:00
Paul Trowbridge 22542837ac scripts to move sales dating around 2020-06-11 15:53:56 -04:00
Paul Trowbridge 5b4a61c542 forecast update 2020-06-09 18:35:52 -04:00
Paul Trowbridge 8a3baf269d increment periods 2020-06-07 22:43:50 -04:00
Paul Trowbridge 652720ff32 add destination 2020-06-02 12:36:29 -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 ca996adac6 Merge branch 'dev' into feature/cust_swap 2020-05-12 14:36:49 -04:00
Paul Trowbridge 17dc465cdc Merge branch 'dev' into hist_list 2020-05-12 14:30:37 -04:00
Paul Trowbridge 76edca43dc test for match after pool conversion 2020-05-12 08:51:25 -04:00
Paul Trowbridge f5d464677e add tie-out check for post-conversion 2020-05-11 20:54:35 -04:00