Post inventory Cost to G/L

Lion

Hello

I have problem with Value Entry in NAV 5.0 SP1. Script "Post inventory Cost to G/L" don't post every entries and I have a lot of very old entries that I must post to G/L. How can I do this entrie with actual date? I try to setup "Allow posting from" date but still I have error message "Posting Date is not within your range of allowed posting dates in Gen. Journal Line Journal Template Name='',Journal Batch Name='',Line No.='0'." I try to close item period but I can't.

Thanks for every help.

krzychub83

Hi Maciej
I am not sure if this is the case here, but please try to validate Allow Posting From and Allow Posting To for your user in User Setup (Administration -> Application Setup -> Users -> Users Setup).

You will receive very similar error if Posting Date used at the generated General Journal Line does not match your's user posting date permissions.

I will try explain you what might be happening there. When you execute the 'Post Inventory Cost to GL Batch Job' you are not specifying any Posting Date. Instead of that NAV is trying to find out 'on fly' what date should be used on generated General Journal Lines. To find it out NAV is comparing Posting Date from Value Entry against posting date restrictions applied in General Ledger Setup. There are three scenarious here:
1. If you have Posting Date restrictions in the General Ledger Setup then:
a) If Posting Date from the Value Entry record is outside of posting date restrictions from General Ledger Setup, then NAV uses date from the Allow Posting From field as the new Posting Date.
b) If iPosting Date from Value Entry record is within posting date restrictions from General Ledger Setup, then NAV uses date from Value Entry record as new Posting Date.
2. If there are no posting date restrictions in General Ledger Setup, then NAV is using Posting Date from the Value Entry record in generated General Journal Line.
Please notice that during that proces NAV is not taking under the consideration any posting dater restrictions applied to your user!
In the next step NAV is trying to post generated journal lines. It is posting them by using standard posting routines. There Posting Date from generated journal line is validated versus posting date restrictions from General Ledger Setup & posting date restrictions, which has been applied for your user in User Setup. If your user was limited to use some period only, then you will get an error message which is very similar to your one.

Generated General Journal Lines are stored in temporary tables. They do not have any values in the Primary Key's fields because they do not need to have them. Thus error message does ont give you any clue where Posting Date is incorect (in Gen. Journal Line Journal Template Name='',Journal Batch Name='',Line No.='0').

One more thing. Whenever I use Automatic Cost Posting in Inventory Setup and I need to use posting date restrictions in the General Ledger Setup and User Setup, then I am setting posting date restrictions in the General Ledger Setup to be the smallest ones available in current period. Any user, who needs to be allowed to post outside of that period is gained to do that by User Setup.

I hope that this is the case and that my explanation will help you resolve this issue.

PS: This is not related to that error, but remember to execute Adjust Cost - Item Entries… Batch Job firstly.