Finance | Project Operations, Human Resources, ...

error with customernumber length while creating sales invoices

(1) Share

Report

Posted on by SunilSharma

We have some customers in dynamics who have 12-digit customers

when we try to create an invoice for sales orders for these customers, the creation of an invoice fails.

Is there any limit on the customer-number(AccountNum) field in custTable?

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Customer Account limit size is 20 characters, what is the error that you have?

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

What is the error you are getting? Please share us the details.

Was this reply helpful? Yes No
Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (0)

Report

Hi @SunilSharma,

Can you please share with us the error ?

Best reards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

Hi,

I don't think so there is any relation of generating invoice based on customer account number sequence lenghth.

Unless you are having any customization where you are picking invoice number sequence based on customer account.

In general Dynamics supports total 20 lenghth for any sequenece , out of which 10 can be your running number and rest your prefix/suffix

Was this reply helpful? Yes No
SunilSharma 96 on at

Like (0)

Report

The customer account numbers we are using are 10-digit numeric numbers like below.

3234567890

when trying to generate an invoice for the sales order for the customer we get the below error. After checking different scenarios, I identified that the issue was because of the customer account number length. If the customer account number is less than 10-digit numeric numbers then the generation of an invoice works fine.

Message details
Posting
Posting
Exception has been thrown by the target of an invocation.
An error occurred during update

Posting - An error occurred during update
Fix issues

Was this reply helpful? Yes No
Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

The customer account number standard size is 20 !

you confirm that you have applied a customization on this field ?

Best regards

Was this reply helpful? Yes No
SunilSharma 96 on at

Like (0)

Report

We do not have any customization on the customer account number field.

customer creation works fine with customer account numbers with 10 or bigger digits.

The issue happens only when we try to generate an invoice from a sales order for these customers.

Is it a limitation in Dynamics with sales invoice creation, that the sales invoice table has a different data type length for the customer account number than then customer account number in custTable?

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

In that case I would suggest to restore database to any dev VM and debug this.

Was this reply helpful? Yes No