How to inser number sequence in table

Finance and Operations/AX Developer Forum
1

Hello,

When I create SalesOrder then select number sequence group in Setup Tab & posting the PackingSlip.

when posting the packingSlip that time numberseq is insert into the CustPackingSlipJour table i.e packingslipId. but How it is Possible?

because I customize the WMSPickingRegistration Form. means i have added the number sequence group field in this form.

Now i want to insert the number sequence related that group in to WMSOrderTrans Table.

How it is Possible?

Please help me.

Thanks

2

I think you are taking about the OrderId in WMSOrderTrans…

Do you want to change the OrderId according to the number seuquence selected. Is this your question…

3

yes, i can change OrderId format. But I want Two Number series for Domestic and Export invoices.

4

I think you are able to differentiate the sales orders by domestic and export…

The orderId will be first created in wmsOrder not in wmsOrderTrans…

so you need to insert a number in the OrderId field of wmsOrder table…based on the type of invoice selected for that salesOrder…

for that

You add one more number sequence…(hope u know creating a number seq)- (refer WMSParameters Table → numRefWMSOrderId)

Then try to override the class → wmsCreateOrder → updateCreateWMSOrder method…