Page 1 of 1

Change Debtor Account Numbers

PostPosted: Fri Jan 09, 2026 12:04 pm
by SBarnes
I have a client that wants to change Debtor Account Numbers for certain debtor accounts in their system.

Whilst realising that under the hood the primary key is Debtor ID on DB_Main, are there any other tables to where the account number is stored as I recall there are some other tables that store the Part number if you are attemtping to do the same thing with part numbers in Jiwa.

Re: Change Debtor Account Numbers  Topic is solved

PostPosted: Fri Jan 09, 2026 5:00 pm
by Mike.Sheen
No - we don't denormalise the debtor AccountNo anywhere like we do with inventory part numbers.

Re: Change Debtor Account Numbers

PostPosted: Fri Jan 09, 2026 5:01 pm
by SBarnes
Thanks, mike