Adjust item cost entries batch job problem

ameen

Hi,

I am working Nav 4.0 Sp3.

When i run the A I C Entries batch Job, I am getting the following error.

that is Item Ledger No " YYY "Does not exist.

What is the problem?

Even i gone through the Item ledger entry tabl;e , but i could not find that entry No.

So how to solve this problem.

Please help me to solve this problem .



Thanks and regards

ara3n

Is the number greater than the highest Entry no in the table? or lower?

Dave_Cintron

This comes from the Item Application Entry table, it's pointing to an ILE that was deleted manually or by date compression. Either way, you'll have to handle this IAE to process.

bbrown

I have seen this issue on a database that had data compression run with negative inventory. (another reason I am not a big fan of data compression) When they purchased inventory and ran adjust cost the process blew up because data compression had deleted the entries to which the purchases needed to be applied.

ameen

Hi experts,

Yes that’s true .

That entry was deleted in Item ledger entry and same as Value entry was also deleted for that ledger entry

But Item Application has that entry.

So how to solve this problem .

Experts please throw Your valuable information to solve this problem to Run the A I C E.

ara3n

May I ask why or how they were deleted?

As far as fixing it, it uncharted territory. You have to look how the items are applied and maybe even recreate the deleted entries.

ameen

Thanks Mr. Rashed ,

Is it possible to recreate the deleted entries ?

If yes , Could u throw some path ,

We will work on that issue .

Please ……………………..

ara3n

How where the entries deleted?

ameen

Here I would like to tell some story .

They created a wrong Positive adjustment trhough Item Journal. For 10 items .

So for they to Item ledger entry for each item they have taken the Date item , Lot no, Entry No ……
Same as go to Value entry based on the Value entry No ….

According to above they deleted .

So any how past is past .

So could u throw your valuable help to solve this problem.

bbrown

:shock: And they didn't think to simply post reversing entries? Part of your solution needs to be some basic accounting principle training. Someone with this level of data access needs to have a better understanding of data integrity.

ara3n

I would follow bbrown advise, and get rid of the person entirely or remove his permission to do this.
Get a more senior person to look at the data and try to fix it.
You won't be able to fix this online.

ameen

Thanks Mr. Bbrown, Rashed.

I will take care about that person.

But could u throw some suggestions to solve this problem to run the Adjust cost item entries.

Please throw your help.
we are in ](*,)

Dave_Cintron

Fight fire with fire - you can go to the Item Application entry table and delete all references to these Item Ledger Entries.

ara3n

If Item application has already happened, after deleting any reference, you'll will be left with one sided application entries.


I would recreate the deleted item ledger and value entries.

ameen

Thanks Mr. Rashed ,

I could not understand your valuable statement 1.
Could u explain some more about statement 1.

Could u throw some infrmartion how to recall the deleted information.

We will work on that .

ara3n

Well first you need to find out How the entries were posted. Posted through Item journal or document.

You can find this info in Item Register table.
If it was posted through document, then I would find the posted document.

Write a report that would print only posted shipment that do not have corresponding Item Ledger entry. Once you've find the shipment/ receipt and posted invoice and see how they were posted. Then I would on separate copy of the db create a new sales Order just like the shipment and post it. So now you have item ledger entry and value entries just like the original entries except the entries number are wrong. I would write a dataport to export the ILE and Value entry and subtract X from Entry No. to get the Correct "Entry No.". Once I have the text file for ILE and Value Entry with correct "Entry No." I would import them into Original db. As you are importing the ILE, you need update the remaining quantity based on Item Application entry table.
Here is how to determine Remaining Quantity
If the missing ILE are Inbound Entry. E.g. Purchase, then Filter in Item Application Entry table on "Inbound Item Entry No." and calcsum the Quantity field.

If the missing ILE is Outbound Entry E.g Sales filter on outbound entry and calcsum Quantity.


Let me know if the entries were posted through item journal

ameen

Thanks Mr. Rashed,

I posted the Transactions through Item Journal.
all transactions which deleted were posted through Item Journal.

Thanks and regards

ara3n

Did you say "I" posted the transaction?


LOL


Well follow the same process as above excep create the journal entries and post them in a copy db. then export them with a dataport and follow the same process explained above for remaining qty.

ara3n

Btw are you an end user, or working for NSC?

klavin

I'm assuming backups of transaction log and/or database (just db in native obviously ) are out of the question?

If you had some sort of backup between the time they were made and deleted you could always then port them back. Always have a backup

Lavin

ameen

Thanks expert,




Mr. Mashed duty in Hurry i posted above post with one misteke.

That was i deleted . Actaully we ae going live ,

Here one person is key person .
stores person had done one mistake , then stores peron intimate to Key peron then that key person without asking us directly deleted that data regarding ledger entry , value entry.

So dont misunderstand me.

when it comes to problem


When I run the A I C E then system Following error

Item Ledger entry “ 2314 doesnot exist .

So I gone to back up take that entry and go back to Live databse enter that entry.

Then again I run A I C E
Then again system show s one error

That is

There is no value entry with in the filter

Item ledger entry : 4513 Qty <>0

Again I gone to that entry and inset the value entry for that ledger entry.

Like this system throws 4 errors.

I inser t all the entries what system suggested.

After that I run the batch job .

But batch job is keep running for around 9 hours ………

When I run the batch job

These fields are chaning in that batch job :

Adjustment Level : 27590031

Item No : Blank
Adjust : applied cost

Cost FW Level : 1

Entry No 12282

After some time Only adjustment Level field is changing but rest of the fields are not changing.

item No field is Balank .
What is the problem .

How to stop that batch job.

What is the wrong ?

Pleazse help me.

ara3n

Do you have an item no with blank No.?

You need to delete it with delete (false).

ameen

Thanks Mr. rashed,


I deleted that item .
Now the Adjust item cost batch job running smoothly.

I asking one suggestion from .

My client operations are

Daily 20 Purchase orders , 20 Sales orders , 30 Transfer orders ,
5 Prouction orders( Complete), Item journal( Negativeadjustment) to issue material ( 100 transactions).

So what is your valuable suggestions about Automatic cost Posting, Automatic cost Adjustment ?

Should i place always checkmark ?

Or do i need to run batch job manually.

Please suggest me.

ara3n

With volume being low, you can set it to always.
I suggest to do it by trail and error. Set and see if users complain.

bbrown

With purchase orders (and their impact on Adjust Cost) the issue is not so much the numebr or size of the purchase orders, but rather the number of sales on which the product appears.

Purchasing 1000 cases and selling all on 1 sales order has a much smaller impact then selling on 1000 sales orders.

ameen

Thanks Mr. Rashed,

since two weeks we did not run AICE, Post inventory cost to G/L.

When it comes to AICEntries batch is running smoothly.
But when i run the post inventory cost to G/L batch job is manually Only two items are posted general ledger .

Rest of the items did not post to General ledger.( In report it is showing only two items , Actaully in report it has to show atleast 200 items)


what is the wrong ?

please suggest me.

ara3n

You need to make sure there are records for every value entry in this table

Post Value Entry to G/L.


Also do they show up in the error section of the report?