item posting date???

kanika

Hi experts,

I have a problem with the posting date in a purchase order.

The purchase order has 5 lines with Planned receipt date = 13/02/2013

in header order date and document date = 08/02/2013

In Financial Management, Allow posting from: 01/01/2013, Allow posting to:28/02/2013

F11+Receive with posting date= 13/02/2013 and this mistake appears :

Posting Date is not within your range of allowed posting dates in Item Journal Line Journal Template Name=",Journal Batch Name=",Line No-='0'.

but if I delete the last line, I can do the posting without problem.

It Exists a posting date for the item????

thanks for all

jspopp

Hi, what have you done so far to investigate this issue?

Himanshu_Nigam

Hi

please Check General Ledger Setup Allow Posting From and Allow Posting To date

kanika

Here is the bug report

kanika

In General ledger setup:

allow posting from :01/01/2013
allow posting to: 28/02/2013

the record date is within the period

kanika

any idea?

chi

Hi
Have you checked Allow Posting From and Allow Posting To date in the User Setup form yet?
Regards

chi

Hi kanika
Could you please share how the issue is solved?
Thanks in advance.

kanika

I deleted all dates in user setup and too in general ledger setup

later I enter the dates (with the same data) and inexplicably stopped giving the error

dates are the same, verified!

krzychub83

I will describe the most common reason for that error. This error will be raised if the "Allow Posting From" from the General Ledger Setup is set before "Allow Posting From" from the user setup and automatic cost adjustment enabled.

When you post a transaction against an item NAV is trying to adjust this item cost. For all adjustments related to entries posted before "Allow Posting From" date (from General Ledger Setup) NAV will use "Allow Posting From" from the General Ledger Setup as a Posting Date. It will build an adjustment entry in the temp table and then it will try to post it. However then, during the post, NAV will check "Posting Date" not only against “Allow Posting From" date (from General Ledger Setup) but "Allow Posting From" from the User Setup too. Thus if that date is after the date used in the General Ledger Setup NAV will rise an error message: Posting Date is not within your range of allowed posting dates in Item Journal Line Journal Template Name=",Journal Batch Name=",Line No-='0'. Adjustment line is built on fly in temp tables, thus it doesn't have primary fields filled in and that's why they are missing in the error message.

Conclusion: "Allow Posting From"/"Allow Posting To" from the General Ledger Setup has to be always set to the smallest range allowed in current period. Any exclusion from that range should be set in "Allow Posting From"/"Allow Posting To" in the User Setup table.

Kind regards
KB