kriki: Can you delete customers that have customer ledger entries?

[Blog bot]

Or venders with vender ledger entries or G/L accounts with G/L Entries or Banks with bank account ledger entries or items with item ledger entries or …

You say no? Think again! YES you can … under certain circumstances.

So what I am talking about?

At a customer we found some vendor ledger entries of type invoice with a blank vendor. Doh! The posted invoices still had the vendor no. Doh Doh! But the vendor-record itself was gone. Doh Doh Doh! My colleague was close to panicking (and I can’t blame her). What has happened here?

I remembered (very weird, I know) that I once (a long, long time ago) I learned that it was possible to do these kind of things.

You can do that when the ledger entries are all closed or total amount is 0 (for G/L accounts).

The code you can find in the OnDelete-trigger of the base-tables : “MoveEntries.MoveItemEntries(Rec);” for the items. And codeunit 361:”MoveEntries” does the dirty work.

But WHY would someone do that?

I think this functionality was created because, in the old days, every megabyte of databasespace was to be paid to Navision (no, this time Microsoft is innocent! Navision wasn’t bought by Microsoft yet).

So there were a lot of routines to remove old records and some have survived thus far.

This functionality is not needed anymore to shrink the database-space in use. Even worse: it destroys referential integrity and probably (didn’t check this out) is forbidden by law in some countries.

I created a feedback on connect for it. Vote for it!



Читать дальше