How do I add a sequence to my data

[Karl_Spratt]

Hi Community,

I need to add a sequence to my data,  example, I have to ship from multiple locations so I need to advise the purchasing plant of the ship location, their ship too ( DHL / Plant) and the number of the order so they can reference it.

But each order can only be a max of 20 lines due to receiving constraints.

So I need to say PO#  is Location + Ship to + Max 20 lines = PO# 1, then start again, to give me Po#2 etc. But at each change in location or ship to start at #1 again.  So in the example. I'd expect 15 PO's for BUBAK - DHL, and 2 POs for BUBAK Plant 

Attaching sample data, if anyone can explain how to do this please. 

TIA,

Karl. 

[pedrodrfaria]

Hi @Karl_Spratt 

I was not 100% what you are trying to do.

I understand that there is a limit of 20, so should we delete the rows that calculate more than 20 times the PO# instance? Or does that mean that it should go from 2 to 3 even though the SIM PO QTY column still says 2?

I added a WF as shown below to see if this is what you are looking for.

[afv2688]

Hello @Karl_Spratt ,

I came up with this solution. The summarize tools gives you to see the amount of PO box for each location

Regards

[Karl_Spratt]

Hi Guys,

I'm not explaining myself well here,  What I'd like to see is example for the location BUBAK

PO's Numbers BUBAK-DHL-01, then next 20 lines where the condition is BUBAK-DHL and these 20 lines, codes this PO# as BUBAK-DHL-02, then next 20 lines as  BUBAK-DHL-03 so for the condition of BUBAK & DHL we'd get 15 PO ( 14 PO x 20 Lines) and 1 Po 7 Lines) then it moves to BUBAK & Plant, we get BUBAK-Plant-01, and BUBAK-Plant-02 hope this helps 

Location	DHL	Plant	Lines
BUBAK	287	37	324
KARDEX-2	21	274	295
KARDEX-3	20	171	191
KARDEX-4	12	15	27
KOLIN-WH	182	42	224
YUSEN	47	5	52
Grand Total	569	544	1113

[afv2688 · Accepted solution]

Hello @Karl_Spratt ,

I updated the formula now, let me know if the results are good now.

Regards

[Karl_Spratt]

Thanks afv2688,  that's exactly what I was looking.

Cheers,
Karl