I'm new to DAX and am part of the migration team.
Here is the scenario.
When we create a sales order by its own it takes an automatic number sequence. thats wroking properly.
Then When create a new Sales agreement the system gives a specific number lets say SA-201
now, when we create a new release order, this order is taking the automatic number sequence (as expected).
Is there a way to change this behavior when a release order is created and assign a different number to this sales order? sequence like: SA-201-01
So we can identify more easily the sales orders that come from Sales agreement.
Sales agreement: SA-201
first release order ; SA-201-01
Second release order ; SA-201-02 and so on.
Thanks in advanced