Change Debtor Account Numbers  Topic is solved

Discussions relating to Jiwa 7 plugin development, and the Jiwa 7 API.

Change Debtor Account Numbers

Postby SBarnes » Fri Jan 09, 2026 12:04 pm

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.
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1696
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 191

Re: Change Debtor Account Numbers  Topic is solved

Postby Mike.Sheen » Fri Jan 09, 2026 5:00 pm

No - we don't denormalise the debtor AccountNo anywhere like we do with inventory part numbers.
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2583
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 807

Re: Change Debtor Account Numbers

Postby SBarnes » Fri Jan 09, 2026 5:01 pm

Thanks, mike
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1696
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 191


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 1 guest