Retail POS: How to modify the SaveCustomer to save a new customer field in AX and store DB

(1) Share

Report

Posted on by Community Member

Hi,

I would like to save the value of the new customer field in AX and the store DB. In New Customer form, i added my new field "INNRetail"

In frmNewCustomer.Designer.cs, i added the code for binding the field:

this.textBoxINNRetail.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.bindingSource, "INNRetail", true));

And in CustomerViewModel.cs, i added the class for extend the Customer.

Now, only i need to modify the SaveCustomer method for to save the INNRetail value. But, how i should to modify the method? Any example?

Thanks in advance,

Jorge García

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Oksana Kovaliova 3,597 on at

Like (3)

Report
Hi Jorge,

The procedure of save includes 2 steps:

A) Save new field value in AX;
B) Save new field value in store database.

The place of your code in SaveCustomer method depends on how important your new field is:

If according to business rules you cannot save customer without this field, you need to save this field in AX at first (maybe with some temporary reference to customer) and after call standard 'save' method to create customer;

If customer can have new field empty (not critical), you can add your code to the end of 'SaveCustomer' method as shown on picture below.

How to customize RTS is described here (to save field value in AX): technet.microsoft.com/.../dn126098.aspx
blogs.msdn.microsoft.com/.../ax-for-retail-2012-customizing-the-transaction-service

To save field in store database, you should execute SQL command. For example:

var dbUtil = new DBUtil(ApplicationSettings.Database.LocalConnection); SqlUpdate sqlUpdate = new SqlUpdate("[ax].[CUSTTABLE]"); sqlUpdate.Set("INNRETAIL", "YOUR VALUE"); sqlUpdate.Where("ACCOUNTNUM", custAccountId); sqlUpdate.Where("DATAAREAID", ApplicationSettings.Database.DATAAREAID); this.dbUtil.Execute(sqlUpdate);

Regards,

Oksana

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you so much Oksana!!

Very important information for retail development.

Best regards,

Jorge García

Was this reply helpful? Yes No
Ansar Basha 1,584 on at

Like (0)

Report

Hi Oksana/Jorge,

I'm required to add new fields such as mobile no, City.., in Loyalty Card.

Above fields are entered at the time of creating the loyalty card, but optional

I have added a method loyaltyupdate in RetailTransactionServiceEx class

as per technet.microsoft.com/.../dn126098.aspx

I called the update method from the commerce runtime.

I'm stuckup at next step to saveloyalty, i couldn't find any such as "Savecustomer"method to call my method.

Could you pls. guide me.

Thanks,

Ansar Basha.S

Was this reply helpful? Yes No
Ansar Basha 1,584 on at

Like (0)

Report

Hi All,

Can anyone provide some info.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ansar Basha,

If you open new tread only someone try to give you the solution. It would be easy for you to get fast replies!

Thanks

Suresh

Was this reply helpful? Yes No
Ansar Basha 1,584 on at

Like (0)

Report

Hi Suresh,

Thanks for your suggestion, as my question is related to this thread, its better to use the same instead of new.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

As addition to customizing RTS stated here: [View:https://technet.microsoft.com/en-us/library/dn126098.aspx:750:50]

When i get the result in the response i got it something like [null, true, "Success!"]. So just bare in mind that, you can get a typical AX "1" based array as result.

I found this in version AX2012 R3 CU10.

Was this reply helpful? Yes No