Skip to main content

Regression Suite Automation Tool - Create unique values

The RSAT doesn't have any roll back feature. So, it can be frustrating updating the excel file with
unique records.


Well not to worry - RSAT supports Excel formulas. The user guide suggests using RandBetween(a,b) Excel function.
However, that isn't really reliable and you are hoping you don't get the same random number.

I have been using date formula. The below concatenates the datetime to the string.
=CONCATENATE("SS",TEXT(NOW(),"yymmddhhmmss"))


If you want to get started with RSAT.
Download the tool and the user guide from here.
https://www.microsoft.com/en-us/download/details.aspx?id=57357

You can also watch a short video that walks you through how to use it.

Comments

Marysia said…
This comment has been removed by a blog administrator.
Unknown said…
Great Post!
Is reverting data in RSAT tool is not possible ? Regards, Sanjay.C
Munib Ahmed said…
Not possible to roll back data on RSAT.
I wish there was.
shivani said…
This comment has been removed by a blog administrator.
Arvind Dubey said…
Hi Munib,

We have started using RSAT tool recently. Just needed one help.

We want to add the two variables the excel file generated

for ex: After creating a bank account, we want to generate a statement which has below details

opening balance:3000, Net Amount:1000
Ending Balance: 3000+1000,
We are unable to capture the ending balance.

We went through the release notes published recently and changed the config file and tried but failed. Please let me know, the way we can achieve this.

Thanks,
Arvind
Bhanu Sree said…
This comment has been removed by a blog administrator.
GK_Photography said…
Hi I have recently started RSAT. Need a help.I am aware that excel functions can be used.

Scenario i am trying :-
To fetch the SalesTotal from application and compare it with the formula that i have computed in excel something like below. It works but , unable to apply the Round() in same cell. Need help

Round({{SalesTable_SalesLine_LineAmount_41706_Copy}} + =({{SalesTable_SalesLine_LineAmount_41706_Copy}} * ({{TaxTmpWorkTrans_showTaxValue_41706_Copy}} / 100) ))

Any help will be appreciated.


But is it possible to combine a variable and excel formula in a single cell ?

Popular posts from this blog

AX - How to use Map and MapEnumerator

Similar to Set class, Map class allows you to associate one value (the key) with another value. Both the key and value can be any valid X++ type, including objects. The types of the key and the value are specified in the declaration of the map. The way in which maps are implemented means that access to the values is very fast.
Below is a sample code that sets and retrieves values from a map.
static void checkItemNameAliasDuplicate(Args _args) { inventTable inventTable; Map map; MapEnumerator mapEnumerator; NameAlias nameAlias; int counter = 0; ; map = new Map(Types::String, Types::Integer); //store into map while select inventTable { nameAlias = inventTable.NameAlias; if (!map.exists(nameAlias)) { map.insert(nameAlias, 1); } else { map.insert(nameAlias, map.lookup(nameAlias) + 1); } } //retrieve from…

Azure DevOps Release Pipeline–Walkthrough

It is a great start to 2019. Joris from Microsoft has welcomed the year with the release of the Azure DevOps Release Pipeline task on the marketplace. Official blog:https://community.dynamics.com/365/financeandoperations/b/newdynamicsax/archive/2019/01/18/first-azure-devops-task-released Addition blog:https://daxmusings.codecrib.com/2019/01/azure-devops-release-pipeline.html I thought I would do a walkthrough for those that haven’t had a chance to play with it yet.
New release pipeline In Azure DevOps, click on the New release pipeline.
You will get an option to select from a template. Just select “Empty Job”. In the first stage, make sure the Agent job is using “Hosted VS 2017”.

In the Agent job click on the + icon to add a task. Select the LCS Asset Upload task. If you don’t see, then you have not installed it. Just select the “Dynamics 365 Unified Operations Tools” link at the bottom. Otherwise, install from here https://marketplace.visualstudio.com/items?itemName=Dyn365FinOps.dynamics36…

Detailed guide on creating Business Events with Azure Service Bus

I have been working with the new Business Events feature released in FinOps and you should read the docs site first.
This blog post focuses primarily on setting up Azure Service Bus endpoint. Setting up the Azure services can be tricky if you are not familiar with Azure Key Vault and application registrations.
I have sequenced the post so that you don't have to jump around. There are four key elements to this: Create the app registrationCreate the service busCreate the key vault secretConfigure FinOps Create an App Registration In the Azure Portal, navigate to the Azure Active Directory menu. Click on App registrations (there is the old one and the preview menu - they are the same but the UI is a bit different). I will show the original App registrations way.


Create a new Web app/API registration and give it a name. It doesn’t really matter in our case what the sign-on url is.




Take note of the Application ID as you will need it later for setting up the Business Event.

Under the Ke…