Empty Customer No. in Customer ledger entries

wmmasj

Hi,

Is there anyone out there who have customer ledger entries with no Cstomer No. attatched? If I analyze the transaction the invoice has the correct customer no, and the g/l entry also has the correct Source No.

What to do?

diptish.naskar

This is in general not possible, I beleive you must have some customizatoins...do check them....or whether this database contains migrated data...do also check this possibility.

wmmasj

diptish.naskar wrote:

This is in general not possible, I beleive you must have some customizatoins...do check them....or whether this database contains migrated data...do also check this possibility.

Yes I know its not possible but still hehe

My idea of the post was to see wheter someone have seen this in a standard 3.01 database. As you say it must be a customization that has been done....

tanks for your reply!

David_Singleton

wmmasj wrote:

Hi,

Is there anyone out there who have customer ledger entries with no Cstomer No. attatched? If I analyze the transaction the invoice has the correct customer no, and the g/l entry also has the correct Source No.

What to do?

This is standard Navision functionality. If at any time you delete a customer card, then all the attached ledger entries are given a blank Customer No. so that you know the customer card has been deleted.

This does not have to have any connection with any customizations, and ha been standard in Navision at least since the DOS version.

Alex_Chow

diptish.naskar wrote:

This is in general not possible, I beleive you must have some customizatoins...do check them....or whether this database contains migrated data...do also check this possibility.

No, this is possible and is a standard function in Navision. When you delete a customer that's no longer active, Navision will blank out the customer numbers on the ledger entries.

This is also the case with Items and vendors.

gvolkov

I have seen a customer without number? How is that possible? I still cant rename it.

Alex_Chow

gregoryvolkov@gmail.com wrote:

I have seen a customer without number? How is that possible? I still cant rename it.

This is a different topic, but nonetheless, this customer was probably inserted using a dataport. There may be some carriage return or line feeds on the field that's being recognized as a character.

David_Cox

Alex Chow wrote:

gregoryvolkov@gmail.com wrote:

I have seen a customer without number? How is that possible? I still cant rename it.

This is a different topic, but nonetheless, this customer was probably inserted using a dataport. There may be some carriage return or line feeds on the field that's being recognized as a character.

As we are off the subject!
Very common Dataport error, importing a file, with a blank "No." field and no validation, and the other way is when the Developer uses a variable to insert the record, and forgets to put a CurDataport.SKIP, on after Import record, thus inserting a blank record.

Another common error is not clearing the variables and getting wrong values on the other lines, for some reason if a variable type dataport field has no value (Null) the last value is retained, or not using the INIT on before Import records.

Dave