Hello - We recently upgraded to 24R1 and now seem to be experiencing issues when trying to import AR Invoices with Doc Descriptions exceeding 512 characters. I started looking into how to create a customization to expand this, but noticed it says the limit should be 4000. When I test importing via postman or manually entering myself, it continues to stop at 512. Does anyone know why this might be and how I can go about expanding?
Answer
How to expand DocDesc character limit
Best answer by darylbowman
The ARInvoice table doesn’t have a DocDesc field. The ARInvoice DAC extends the ARRegister DAC which DOES have a DocDesc field. You’ll notice though that its length in the database is 512 (and in the ARRegister DAC).
To extend it, you’ll need to extend the ARRegister DocDesc field in the database and in the ARRegister DAC.
+15The ARInvoice table doesn’t have a DocDesc field. The ARInvoice DAC extends the ARRegister DAC which DOES have a DocDesc field. You’ll notice though that its length in the database is 512 (and in the ARRegister DAC).
To extend it, you’ll need to extend the ARRegister DocDesc field in the database and in the ARRegister DAC.
Daryl ⚡Freelance Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
Hi
+15Someone added a column length increase already, yes. However, you need to change DAC field length as well.
Daryl ⚡Freelance Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.