Entry No.

Navi_Learner · 2006-08-07

Does anybody have idea of Entry No in Cust. Ledger Entry table . To my knowlege all the entry no are serial no like 233333, but recently I find in my system some of the entry no are like 4/8/2180, looking like date. Once the entry no is not correct, the balance is not correct. How does it come like date? Thanks in advance!

Savatage · 2006-08-07

The Entry No. is of Type "Integer"

Did you import data directly into this table?
Perhaps you didn't have it mapped correctly.

Your should always input your data into a journal first and have Navision validate the fields.

Alex_Chow · 2006-08-07

It's not possible to have 4/8/2180 in the Entry No field. Even if you dataport directly into the table, it's impossible.

Are you sure you're looking at the right field?

Savatage · 2006-08-07

I have read this before on people who get the 1190 error.

It is usually caused by someone putting data into a Navision table through a SQL Server tool instead of using the Navision Client.

I'll guess we will just have to wait for the respone first. :-k

bestianhow · 2006-08-08

deadlizard wrote:

It's not possible to have 4/8/2180 in the Entry No field. Even if you dataport directly into the table, it's impossible.

Are you sure you're looking at the right field?

I agree what deadlizard said.
In Navision, all the Entry No. fields are Integer data type. It is not possible.
During import data to Navison, i'm sure system will given error if import non-integer data to Entry No.

Thank you,
Kok Keong

Howdy, Stranger!

Quick Links

Categories

Entry No.

Comments