How to set a unique code based on Store/date information ?

Hi everyone,

Does anyone know how I can generate a unique code by Store/date combination, knowing that the date is a current date that will be changing every day, it's going to be the order ID and and it going to have to start by a #:

Thank you for the help :)

Accepted answers

All comments

rob_marshall

@Dianessfa

Please don't put Date as part of the code in any list as this is against best practices which will lead to scalability and performance issues for your model. Here is an article explaining why and even though it was written in 2019, it is still valid. Please pay special attention to this part:

https://community.anaplan.com/discussion/48866/oeg-best-practice-data-hubs-purpose-and-peak-performance

Dianessfa

Hello Rob,

Thanks a lot for your answer. However I'm not sure to understand, I don't think I have put Date as part of the code in a list here.

I would like to have a unique code based on date and store.

Please enlighten me if I I did anything against best practice here.

F.Dianessy

alexpavel

@Dianessfa : not sure what your purpose exactly is.

A Store Code can be present multiple times, one occurrence for every day, because you would like to "historize" the properties that could potentially change?

A Store Code is present only 1 time, but you would like to trace the date when it was added in Anaplan ? Is the "Creation Date" part of the file imported in Anaplan ?

In function of your goal, we could try to help with some answers.

Dianessfa

Hello @alexpavel,

Thanks a lot for your answer. To give you more context :

The replenishment needs of the stores will be calculated daily in Anaplan (inventory planning) and I have to create an export, where the CSV file (containing the orders) will be imported into SAP.

this is what my csv file needs to look like and what I did in my module (in quantity we retrieve replenishment needs)

Sap code = is the SKU

Quantity = needs

Store: store (yes each line has a store code

Supplier: warehouse

Order ID: Unique order code

Creation date : updated every with D-Date

I have those business rules:

RG_01
A unique Order ID must be generated per store/day/order type in order to consolidate orders at the store level.

RG_02
The interface will work in creation mode (only the creation of new requirements will be managed)

To answer you questions,

I think first one looks a bit like what I want to achieve, I'll have a filter to export only quantities > 0.

let me give and example: if for SKU 7392802829/store 2300/ 2025-08-18/ ZTRI, I export a quantity of 300,

and the day after(after calculation during nightime) I have a new quantity of 45, the order ID must be a different one because of the date change ?

Second point is definitely NO :)

Thanks a lot for trying to help and if you have any question don't hesitate !

devrathahuja

Hi ,
So the goal is to have the unique id change based on date only if there's a change in qty right?

You can have 1 more line item in the source module where you store a "backup" of this qty which will be used to identify if the qty has changed for any line item.

You could then get a unique date based on a If/Then statement on the above stating if the qty <> backup qty then it takes the current date (This you can update in Anaplan daily using cloudworks) & if its the same then it takes the creation date.

This way, the unique id only gets updated when there's a change in qty & once new qty is uploaded to the main line item, you backup the main one to the backup so

Dianessfa

Hey there,

The goal was to have a different Order ID by date, store, order type. So what I ended up doing is I made a concatenation of Store_ordertype_date(date in text format) that I import in a numbered list. End then I retrieve the order ID in the module with a find item

I think that should work :)

jjayavalli

Hi @Dianessfa,

can you try in the target line item - SAP CODE and (Concatenate or Pipe) and Current Date

SAP Code is your line item from the same module

Pipe, Underscore or Concatenate can be done

Current date coming from SYSTEM Module with time format, change that to text in your target module?

Hope this helps

Jaya

Quick Links

Can you help?

Unanswered questions

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…