"Posting Date" Vs "Invoice Date" under I

pplNet

Anyone here knows what's the difference between "Posting Date" & "Invoice Date" under Item Application Entry Table???

Thx in advanced.

kine

There are only two date fields:

Posting Date - w/o explanation :-)
Output Completely Invd. Date - date, to which was all output completely invoiced... I think that it is some date for adjust batches etc. to know, to which date thay must go...

pplNet

The issue now is, when the invoice date will ONLY be captured?

kine

If I checked it with NDT, there is error in NDT in this case (some text overflow)... but this date is set in CU22 in procedure UpdateItemApplnEntry, InsertApplEntry. Only this two places set this value. Other only filter for it (R5899, C5895 and C22)

pplNet

Sorry..
Kine,
I don't understand what you mention all about... :shock:
I'm new to Navision. Can you explain more details? I was trying to create a BOM structure detail report & the end figure must tie to my G/L figure.
I was too confused that there are too many figures playing around. At the end i was decided to collect from "Cost Posted to G/L" (Value Entry Table).
But due to filtering date, I still can't figure out which date I should refered to..

Pls anyone correct me if i'm wrong in the way of what i'm doing now.
Thx in advanced.


???

If I checked it with NDT, there is error in NDT in this case (some text overflow)... but this date is set in CU22 in procedure UpdateItemApplnEntry, InsertApplEntry. Only this two places set this value. Other only filter for it (R5899, C5895 and C22)

kine

Sorry, I don't know what are you doing and who are you... I wrote something for developer, not for report designer....

For you - use posting date, because it is date, to which the entry was posted... date of completed invoicing is not for you (but it is my point of view). I am not consultant and I don't know the accounting. If you post some more description, what is your target, I can try to help you how to reach it. But if you asked for

Anyone here knows what's the difference between "Posting Date" & "Invoice Date" under Item Application Entry Table???

and

The issue now is, when the invoice date will ONLY be captured?

you get appropriate answer... :-)

pplNet

Kine,
Sorry if i'm confused you.
My question does not relate to any accounting but it relates to developer.
My issue now was only focus on "Value Entry" table.
I was confused this field "Invoice Date".
I have no ideal when this field("Invoice Date") will fill up a date value.

So, hope i am clear enough to put the question to the board.

kine

It is OK, it is problem to know, what can be written, if you don't know the other side... 8)

As I wrote - the value is assigned in CU22 (Item Journal Line posting)... I assume in the case, when the sale is invoiced, the date is assigned... if you have only sale entry without Invoiced quantity, this date is empty...