D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Reset Number Sequence when creating Batches for a job

  • 1.  Reset Number Sequence when creating Batches for a job

    Posted 13 days ago
    We are currently using Batch Number Groups to automatically create batches when Shop orders are created with the format [ShopOrder]-####.  The process works as expected but the number sequence for the batch number continuously goes upward.  I was wondering if anyone knew a way to either
    a) Have the number sequence start at 0001 for each shop order
    or b) at least have the sequence number reset to 0001 when it reaches its maximum of 9999



    ------------------------------
    Scott Anderson
    IT Manager
    Nomaco
    Zebulon NC
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Reset Number Sequence when creating Batches for a job

    TOP CONTRIBUTOR
    Posted 12 days ago
    Neither of these options are viable out of the box, you would need a modification.  May I ask what the business problem is that you are trying to solve by having the number sequence set up this way?  You can always get back to the creating production order from the batch # by using the Inventory Transactions screen.  ​

    ------------------------------
    Colby Gallagher
    Managed Application Services Supervisor
    RSM
    OH
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Reset Number Sequence when creating Batches for a job

    Posted 12 days ago
    In our case we are using batches not just for identification but also as part of a "Curing" process.  In our process, one batch is equivalent to one pallet of product in our warehouse.  We could just use a large serialized number as our batch number but for visual management of the inventory we like to use the job number as a part of the batch number - makes it easier to find and segregate products when defects are found.  The curing process is in place because products must remain in inventory for a certain period of time before they are safe to ship (ie: they are hazardous before that)

    ------------------------------
    Scott Anderson
    IT Manager
    Nomaco
    Zebulon NC
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Reset Number Sequence when creating Batches for a job

    TOP CONTRIBUTOR
    Posted 12 days ago
    Ah, understood.  If you're using advanced warehousing, maybe this would work?

    • RAF to a license plate per pallet and an inventory status that is not "Available", maybe "Curing".  
    • Have the Inventory Status change run in batch with selection criteria based on days since created date on the license plates that are still in "Curing" status.


    ------------------------------
    Colby Gallagher
    Managed Application Services Supervisor
    RSM
    OH
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Reset Number Sequence when creating Batches for a job

    Posted 4 days ago
    Thanks Colby, I'm not sure this would help for the original issue but certainly offers us some options for dealing with placing items on-hold.  The quarantine warehouse options is not very effective for us because we lack the space to actually segregate our on-hold products and having a single physical space in two warehouses is confusing to our associates.

    ------------------------------
    Scott Anderson
    IT Manager
    Nomaco
    Zebulon NC
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role