Not Valid Date

hant

Dear all,

We have an issue regarding reverse transaction in GL. When I do reverse one transaction in GL, there is a message appear "The date is not valid" so I cannot reverse it. I still can post the transaction as normal. Does any one know how to sovle this issue?

Thanks in advance.

hant

ara3n

I've never seen the error. Turn on the debugger and see where it stops. Post the code in here and we might be able to help you.

johnson_alonso

Dear hant,
Ara3n is correct, you must use debugger and manual books first then if it can't be solved, post to this forum.
G'Luck.


Rgds,
Johnson

kine

It seems, like some date is not filled in correctly (is empty). As others suggested: use the debugger to see the source of the "invalid" date...

hant

Pls. see the debug as below:

InsertGLEntry(CalcAddCurrResiduals)

IF GLEntry."Posting Date" = NORMALDATE(GLEntry."Posting Date") THEN BEGIN
BalanceCheckAmount :=
BalanceCheckAmount + GLEntry.Amount * ((GLEntry."Posting Date" - 01010000D) MOD 99 + 1);
BalanceCheckAmount2 :=
BalanceCheckAmount2 + GLEntry.Amount * ((GLEntry."Posting Date" - 01010000D) MOD 98 + 1);
END ELSE BEGIN
BalanceCheckAmount :=
BalanceCheckAmount + GLEntry.Amount * ((NORMALDATE(GLEntry."Posting Date") - 01010000D + 50) MOD 99 + 1);
BalanceCheckAmount2 :=
BalanceCheckAmount2 + GLEntry.Amount * ((NORMALDATE(GLEntry."Posting Date") - 01010000D + 50) MOD 98 + 1);
END;

.....

Reverse(ReversalEntry,ReversalEntry2)

InsertGLEntry(FALSE);

......

Post(PrintRegister)

GenJnlPostLine.Reverse(ReversalEntry,Rec);


Pls. give me some advice.

Thanks,

hant

bobnavision

Navision gives Invalid date error on GL Entry when it finds a blank date.
Please check are you supplying any blank date.
The code does not give much information.

Regards.

hant

There are 2 date fields in G/L entry table and they are filled. I am not sure that is what you want me to check. Pls. advice.

Thanks,

hant

bobnavision

Take a date variable and assign the Value of Normaldate(Date)

where date is Glentry date.
put the code before execution of the code you printed above.

Regards,

ara3n

Also make sure in user setup you have a from and to posting date.

hant

We have not activated this functionality.

selece28

I have the same problem, solved though
This is what cause the error,
When looping the reverse process, G/L Entry found 0 Date.
That's because you have 1 Line in your G/L Account table contains 0 value,
Look at top most of your G/L Entry table, delete the 0 line

See what happen

hant

Hi,

I tried your solution but cannot fix the error. There's no entry no. 0 in G/L entry table. Do you have another suggestion?

Regards,

Hant

ara3n

It could be that you have an invalid date in GL Entry.
Click on File->database->information->Tables->Find table 17->click on Test.
->Check all the options->on Option tab, select File.

Once the test is finished, open the file and take a look at it.
See if there are anything about date.