Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / error with customernum...
Finance | Project Operations, Human Resources, ...
Suggested answer

error with customernumber length while creating sales invoices

(1) ShareShare
ReportReport
Posted on by SunilSharma 96
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?
 
  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,622 Moderator on at
    error with customernumber length while creating sales invoices
    In that case I would suggest to restore database to any dev VM and debug this.
  • SunilSharma Profile Picture
    SunilSharma 96 on at
    error with customernumber length while creating sales invoices
    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?
     
     
     
  • Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 17,367 Super User 2025 Season 1 on at
    error with customernumber length while creating sales invoices
    Hi,
     
    The customer account number standard size is 20 !
    you confirm that you have applied a customization on this field ?
     
    Best regards
  • SunilSharma Profile Picture
    SunilSharma 96 on at
    error with customernumber length while creating sales invoices
     
     
    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
  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,033 Super User 2025 Season 1 on at
    error with customernumber length while creating sales invoices
    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
  • Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 17,367 Super User 2025 Season 1 on at
    error with customernumber length while creating sales invoices
    Hi @SunilSharma,
     
    Can you please share with us the error ?
     
    Best reards,
    Mohamed Amine MAHMOUDI
  • Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,622 Moderator on at
    error with customernumber length while creating sales invoices
    What is the error you are getting? Please share us the details.
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 7,881 Super User 2025 Season 1 on at
    error with customernumber length while creating sales invoices
    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
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,129 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,895 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans