Expected cost posting

pashya1972

Hi

In nav warehouse set-up there is one option for selection "expected cost" which enables all the posting of GRN's etc on expected cost and it also posts GL Entries.

I found that some of the invoices are not reversed to interim accounts. It cud be because of set-up change? i.e. option enable/disable inadverently by somebody?..

Now it has affected around 100 transactions i.e. Invoices for which no interim entries are reversed and also Stock A/c dr to dir.cost applied ac entries are not affected.

What will be the effect on various documents, stocks etc.

Any solution?

Pash

ara3n

what version are you on?

I would write a processing report to insert records into table "post Value entry to G/L"

Then run Report Cost post to GL it will post those entries.

pashya1972

I m using version 4.0

Pls note following two accounting effects ve not been done in the system.

1. Interim A/c reversal i.e. Interim Crs Dr to Interim Inventory Cr
2. Stock A/c Dr to Dir.cost applied Cr

Also let me know is this becuase of Cost posted to GL batch job problem?

Prashant

ssingla

Run Batch Job : Post Inventory Cost to G/L
(Financial Management- Inventory-Costing-Post Inventory Cost to G/L)

pashya1972

I have arleady run the Adjust cost batch job and cost posted to GL job.

Prashant

ssingla

Check whether the Value Entry has some value in "Cost Amount Actual" , "Cost Amount expected" ,"Cost Posted to G/L" and "Expected Cost Posted to G/L".

pashya1972

Expected cost , Actual cost has some value

Expected cost post to GL and Cost posted to GL has "Nil" Value.


Prashant

ssingla

Then "Cost Post to G/L" should create entries in the G/L for these document.

pashya1972

How i can sort out this issue?..

Is there any problem with cost posted to GL batch job?..or any other issue?


prashant

ssingla

You need to run the debugger and see where it is skipping your records. I am afraid there is no shortcut to solve the problem but to dig it and find it.

ara3n

I would filter on value entries that did not post. debug the report. My guess Cost Posted the GL amount is equal to expected cost/ Cost amount (actual) so there is nothing to post.

AdamRoue

I encountered this a few years ago, at a site live for over a year an user "accidentally" turned off the expected cost posting, this was noticed about a week later and turned back on, at month end they contacted us for help. I remember we had to write a report to show us all of the purchase orders that had been affected, and then produce a financial figure for these, this was then journalled through to correctly reflect the financial entries. I am sure there was more to it than this, but the hardest part was correctly identifying the issues, and finding the financial balance to post, sounds to me like you have already done this.

After this the end user decided permissions might be a good way to go.