I have searched for this in the community but not found an answer.
Our 1st supplier in the database has some random numbers as the Supplier ID, all of th others have something recognisable. I cant seem to find a way to edit / change the Supplier ID.
Can it be changed, if not can it be done directly in the database? If yes are there any unwanted side effects, maybe reporting wouldnt have complete records?
Thanks
D
Our 1st supplier in the database has some random numbers as the Supplier ID, all of th others have something recognisable. I cant seem to find a way to edit / change the Supplier ID.
Can it be changed, if not can it be done directly in the database? If yes are there any unwanted side effects, maybe reporting wouldnt have complete records?
Thanks
D