Changing Posted Purchase Invoice Vendor Number

albertassaad@hotmail.com

Hello,
Would you please tell me the best way changing the Vendor number of a posted Purchase Invoice? If it's changing the text from the table would you please tell me what are the affected table? For now I know Table 122 and Table 5802.
Thank you.

albertassaad@hotmail.com

Sorry I meant the vendor invoice number not the vendor no. it's a field in the header I am using Nav 2009 R2

Wisa123

Of course you could just change it. However theres lots of related table using the external document no. (17,25,......).

Cleanest and probably fastest solution would be to just cancel the invoice and recreate it.

Wisa123

Just changing the Vendor number is a really, really bad Idea.
All the related Vendor Ledger Entries will be messed up badly. This also means you will also mess up payment transactions in the future related to the new and the old vendor.

The best way is just to cancel out the Invoice using a credit memo and creating the invoice again using the correct vendor no.

albertassaad@hotmail.com

Sorry I meant the vendor invoice number not the vendor no. it's a field in the header I am using Nav 2009 R2

Wisa123

Of course you could just change it. However theres lots of related table using the external document no. (17,25,......).

Cleanest and probably fastest solution would be to just cancel the invoice and recreate it.