Questions Managing the Scope of Evaluation for Prepare Replenishment, Screen ID : IN508000

Hello everyone!

I'm working through the implementation of Automated Replenishment for our company and we've come across a few interesting challenges. Here's a bit of a picture...

I'm working on automating the replenishment of several warehouses. Some have gone very well while others seem to have their challenges. At this point in time we're only considering those replenishment fulfilled via a transfer.

Challenge One : When transferring between warehouses we would like to a UoM not set within the normal Stock Item screen, Base UoM, Sales UoM, and Purchase UoM. It's like we need a Warehouse to Warehouse UoM, which doesn't exist. We would like to reference the units as a "40 Pack", being a box with 40 widgets in it. From what I've read elsewhere, this would require a Customization Project. hrmmm... not what I was hoping to hear...

Challenge Two : A short term solution to Challenge One is to allow our Logistics team to edit the TR SO's with a level of control so they can modify the quantities up or down based on quantities divisible by the UoM's not available in Challenge One. I've created my first code based Customization Project with the help of the latest ChatGPT and it works like a charm and even makes sense lol

Challenge Three : restricting the scope of the evaluated transactions that the Prepare Replenishment Screen consider while rendering the results. The problem here is that we have orders in our system that could have Ship Dates well into the future. If we don't limit the scope then the items necessary to fulfil these orders will sit in Shipping for months. This isn't at all practical. We figure a reasonable option would be to limit the systems scope to include those transactions that are no more than one week into the future.

Think that paints the picture...

So... as you may have guessed the main point of this pertains to Challenge Three. I believe we're on the right track but not 100% certain. I have started building out a Customization Project that might work BUT have run into other issues, like BQL... I'm using ChatGPT to help me learn how this works, to translate it into SQL and then back lol

I'm happy to share more about all these challenges and will do so as it seems more fitting, rather than now.

Please let me know your thoughts and have a wonderful day! 😉

p.s. I like to share and don't believe that information should be kept behind a gatekeeper so I'm happy to share my experiences and even some of my more ambiguous code that works for the purposes of education.