NAV don't recognize default dimensions when creating by Code a new customer card?

(0) Share

Report

Posted on by Community Member

Hi to all:

We have created a New Customer Card in NAV 2016 via C/AL code getting data directly from a table previously filled via SQL by an external system (CRM home made by the customer).

When we review the new customer card, everything appears to be all right:

1. Customer card created. --> ok

2. Customer data inserted (address, phone number, posting groups, etc.) --> ok

3. Default dimensions are created. --> ok.

The problem is as follows:

1. We create a new sales order to the new customer.

2. The customer data and the sales lines are created correctly.

3. The dimension don't appear into the Dimension Set Entries Page.

So our conclusion is that despite that the customer card has it's default dimensions and those values appear in the default dimension card, for some reason, the system don't recognize them when we create a new sales order.

Does anyone have idea why this problem is happening and any idea of solution?

Best regards,

Gabriel Guerrero

Additional Note:

We already made the test creating the customer via code and erasing the default dimensions and putting the new default dimensions manually and everything works ok with no problem when we make the new sales order.

*This post is locked for comments

All responses (9)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

RE: NAV don't recognize default dimensions when creating by Code a new customer card?

Hi to all

Thank 's for your responses and the attitude to help us, I really appreciate that.

Finally we discovered that the problem was that we erase data from Table 480 Dimension Set Entry.

So when NAV tried to look for the set id number or create a new one, there's no information.

We created a new company and tried all over there and NAV is working fine.

Best regards,

Gabriel Guerrero
Suggested answer

Tharanga Chandrasekara 23,116 on at

Like (1)

Report

RE: NAV don't recognize default dimensions when creating by Code a new customer card?

It seems issue with the Table 352 "Default Dimension".

Filter the table data "TableID" to 18 and "No." to your customer number. Check any record available. If records are available then validate each record manually. My idea is values are not been validated properly (Sometimes it happens). Once that is done try creating a SO and see.
Maneesha 5,891 on at

Like (1)

Report

RE: NAV don't recognize default dimensions when creating by Code a new customer card?

Dear Gabriel Guerrero ,

go to chart of account select relevant gl , and check you have define dimension on their properly
Amol Salvi 18,696 on at

Like (1)

Report

RE: NAV don't recognize default dimensions when creating by Code a new customer card?

Do you mean to say that default dimension from customer not copying to sales order ?
Suggested answer

Suresh Kulla 47,789 on at

Like (1)

Report

RE: NAV don't recognize default dimensions when creating by Code a new customer card?

What do you meany by "the default dimensions are "painted" ". Once you create the customer automatic way can you open the default dimensions table and check if the dimensions exist and compare that with manually creating customer.
Community Member on at

Like (0)

Report

RE: NAV don't recognize default dimensions when creating by Code a new customer card?

Hi to all

Thank's for all your responses,

In order to clarify:

If we put data in an automatic way when we create a customer, the default dimensions are "painted" but they are not transferred to the new sales document in any way.

If we create a new customer manually, when we create a sales document via code, the dimensions are created automatically.

Best regards,

Gabriel Guerrero
Suggested answer

Suresh Kulla 47,789 on at

Like (1)

Report

RE: NAV don't recognize default dimensions when creating by Code a new customer card?

Sorry i think missed your last point, so if you delete the dimensions created by the code and add the dimensions manually and then create a sales order it works ? If so have you compared the data in the default dimension table when you create with code and when you enter manually ?
Suggested answer

Yogesh Kulkarni_ 1,762 on at

Like (1)

Report

RE: NAV don't recognize default dimensions when creating by Code a new customer card?

Gabriel,

Please check the links, if those can be of any help to you.

https://dynamicsuser.net/nav/b/mark_brummel/posts/dynamics-nav-2013-dimensions-i

https://dynamicsuser.net/nav/b/mark_brummel/posts/dynamics-nav-2013-dimensions-ii

-Yogesh Kulkarni

Please verify, if you find answer helpful.
Suggested answer

Suresh Kulla 47,789 on at

Like (1)

Report

RE: NAV don't recognize default dimensions when creating by Code a new customer card?

What is Bill-to Customer No. on the sales order ?