Hello,
In our company invoices dated January 2, 2025 were issued using the old numbering series (e.g., 2-024000614, 2024000622). Once we added the correct 2025 series, the numbering continued from the old sequence, causing the new invoices to start with numbers like 2025000623 (in the INVOICE_NO field of the INVOICE table).
Is it possible to safely adjust the numbering in this situation? Would updating the INVOICE_NO field be a safe solution?
How can I correct invoice series number?
Best answer by Furkan Zengin
Hi
This is very risky and I strongly recommend you to get a technical support. If you want to do by youself then only invoce_tab is not enough. You need to update following tables
if voucher is still in hold table then voucher_row_tab for reference_number field
if voucher is updated to GL then gen_led_voucher_row_tab for reference_number field
if you have internal ledgers then Internal_Voucher_Row_Tab for reference_number field
ledger_item_tab for ledger_item_id
invoice_tab for invoice_no
if invoice is paid then matching_transaction_tab for ledger_item_id
if invoice is paid then mixed_payment_ledger_trans_tab for ledger_item_id
You may have more tables to update depending on your usage/localization etc. These table does not guarantee that update will resolve your all issues.
Hope this helps
+21Hi
This is very risky and I strongly recommend you to get a technical support. If you want to do by youself then only invoce_tab is not enough. You need to update following tables
if voucher is still in hold table then voucher_row_tab for reference_number field
if voucher is updated to GL then gen_led_voucher_row_tab for reference_number field
if you have internal ledgers then Internal_Voucher_Row_Tab for reference_number field
ledger_item_tab for ledger_item_id
invoice_tab for invoice_no
if invoice is paid then matching_transaction_tab for ledger_item_id
if invoice is paid then mixed_payment_ledger_trans_tab for ledger_item_id
You may have more tables to update depending on your usage/localization etc. These table does not guarantee that update will resolve your all issues.
Hope this helps
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
