AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
Managing the Scope ...
 
Notifications
Clear all

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

 
Everything Else
Last Post by Tim Rodman 2 years ago
4 Posts
2 Users
0 Reactions
457 Views
RSS
James McKinnon
Posts: 20
 James McKinnon
Topic starter
November 10, 2023 9:05 am
(@jmck)
Eminent Member
Joined: 5 years ago

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.

 

Topic Tags
Prepare Replenishement automation development Inventory
3 Replies
Tim Rodman
Posts: 3192
 Tim Rodman
Admin
November 10, 2023 1:15 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Would you be up for coming on my Acumatica Podcast to talk through this and share more details?

Reply
James McKinnon
Posts: 20
 James McKinnon
Topic starter
November 10, 2023 2:39 pm
(@jmck)
Eminent Member
Joined: 5 years ago

I'll bite lol is there a fixed date and time or can we be flexible?

 

Reply
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 10 years ago

Famed Member
Posts: 3192
November 11, 2023 6:22 pm
Reply toJames McKinnonJames McKinnon

@jmck Just sent you the info by email.

Reply
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • Issuing stock to a project and subaccount selection
    10 months ago
  • Auto Cancel Unserved Sales Orders
    2 years ago
  • Automated email on Failed Import Scenario
    2 years ago
  • auto-matching PO receipt to PO
    2 years ago
  • Clearing out unsalable inventory
    3 years ago
Topic Tags:  Prepare Replenishement (2) , automation (6) , development (4) , Inventory (15) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,518 Topics
  • 10.9 K Posts
  • 10 Online
  • 2,309 Members
Our newest member: Jason Rhodes
Latest Post: Table linkage for adding a customer location note to the SO Shipment form
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×