Generate custom batch number in production order release status

(0) Share

Report

Posted on by jshl

I am new to Microsoft dynamics 365 and I am having trouble where to start the customization of the following requirements:

Custom format of batch number, "Prefix" + start date of production + number sequence ex. (ABC-06222021-0001). The prefix is from an additional field added to InventNumGroup table.
Generate the custom batch number when production status is set to release.

I have already added the additional field to the table but I don't know how to append it. I was able to generate the start date+number sequence (06222021-0001) as a batch number, however it was generated before the release status of the order.

How can I add the "Prefix" and generate the custom batch number after the release status?