You’re offline. This is a read only version of the page.
Announcements
18
Hi all,
We saw some invalid characters are there in Invoice Id and Description field in particular Vendor and Particular Voucher in Vendor Transaction.
Because of this , when user run the Vendor aging report and save the data is excel. and trying to open the excel, it's throwing error "invalid characters..."
So, they asked us to remove the invalid characters and update the invoice id like B4005
Kindly let me know how I will achieve this through script? In which tables we need to update the Invoice Id?
Please give me more shed on this.
thanks!
That was the first thing InvoiceId is not the primary key in the table.
Try at main table (vendivoicejour)
I didnt tried but you can try your luck with rename function
Or you can create Excel via code and change values at runtime
Or you can add New field, update New field with corrected invoiceId s and use New field at the report
Hi Arpan,
This thread discussed the same question. Please take a look and see if it helps you.
Hi Arpan,
I am not sure if this is the best way to update the invoice number. Here are the tables I can see where you will need to update the invoice Id - VendInvoiceJour, VendInvoiceTrans, VendTrans. You will also need to update DocumentNumber field in GeneralJournalEntry.
If the invoice was generated from Vendor invoice journal, you will need to update LedgerJournalTrans\Invoice field. If it was generated from Purchase orders, you could check VendInvoiceInfoTable and VendInvoiceInfoLine tables as well.
#1
André Arnaud de Cal...
294,095
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
