1,935
Hi,
I'm integrating data from CRM into AX through journal type daily.
The invoice column in ledgerjournaltrans table is 20 chars (nvarchar(20)).
Client wants me increase this length upto 60-70 chars. Would it be okay to use such a large length?
What is the best way to achieve this? Increase the EDT length set on the invoice colum?
*This post is locked for comments
Hi MYGz,
Whether you use a prefix or suffix is a matter of 'taste'.
When I search for invoices, I always enter a suffix (e.g. 'INV...') and then a number but that is my personal preference.
I don't think that it makes a big difference from a system perspective whether you use a prefix or suffix but for your users it can make a big difference if they have to use a different/new search term.
So, I would recommend clarifying with the users.
Best regards,
Ludwig
Hi MYGz,
I'm more worried how the customers will have to post your invoice and do the payment with the invoice attribute. They will probably use the number part only. In that case, you will have more work to do the settlement if the invoice specification in the payment is not 100% matching with your ID. For sure, I would also recommend an abbreviation or just use a single numbering per company.
Hi André, Ludwig.
Thanks for the input.
The client has implemented fresh CRM system. Therein they have Invoice Number Series. They have initialized around 5-10 series.
The Series is a long phrase of 40-50 chars. for eg. "Company XXX Inv with VAT", "Company XXX Inv without VAT", etc.
For each series, the invoice Number starts with 1. If i consider only invoice number then there will be ambiguity as to which series that invoice number belongs to, so one way to solve this can be "Series Name + Invoice Number"
The other way I suggested to client is create an abbreviation for each series and use "Abbr + Invoice Number", but they are reluctant to use that.
I'm already filling the Description and DocumentNum columns with some other detail.
I'm worried, if I change the Invoice Length, what all tables and reports will be affected (whether there will be issues in report display) and whether out of the box code will get disturbed.
Hi MYGz,
Like Ludwig, I'm also interested to know what you put in an invoice number. 60 characters is in my opinion too long for an invoice identification number.
Hi MYGz,
You need a developer to extend the length of the invoice number field.
Before doing that can you let us know why your invoice number needs to have 60-70 characters?
I imagine that some additional information shall be putted into this field that might better fit into other fields such as the description field that you also have available in a daily journal.
Can you provide some additional details what shall be entered into the invoice number field in addition to the invoice number?
Best regards,
Ludwig
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,407
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
