Value enties deletion

damodar123

Dear All,

One of my client is using Nav3.7. he is running periodic acitivity for inventory valuation at that time we found that some value entries,item ledger entires are missing. is there any possibility of deletion from navision application except manual deletion from table level?

any ideas!

Regards,
Damodar

Deep

No chance of getting deleted automatically, or with user license.

ssingla

Somebody with the developer license must have done it :bug: :bug:

ritesh.singh

No. can be missing if the Date Compression batch is run..

David_Singleton

ritesh.singh wrote:

No. can be missing if the Date Compression batch is run..

Ritesh is correct, the compression batch can incorrectly delete entries. This is why I recommend NEVER to use this routine. IN my many years of working with Navision I have never seen it work successfully.

austin

ritesh.singh wrote:

can be missing if the Date Compression batch is run..

what is Date Compression batch job In Navision ?

when we need to run this batch job ?

what is the necessity to run this ?

Please explain ?

ritesh.singh

For detailed explanation please read help (Product help)

ssingla

Refer to David's remark earlier in the post and follow it religiously.

austin

Thank you ,



I gone through the help , it says that batch job will work on if u have the ware house entries.

is it correct ?

for example if we are using the locations only( with zones, bins ) , then it will delete the entries ?

Please correct me about this .


Thanks in advance

ritesh.singh

I do not know which help you 've gone through..

"The Date Compress Item Ledger batch job compresses item ledger entries, that is, combines them so that they take up less space in the database. You can compress entries from closed fiscal years only, and only item ledger entries whose Open field contains "No."

The compression works by combining several old entries into one new entry. For example, item ledger entries from previous fiscal years can be compressed so that there is only one credit and one debit entry per account per month. The amount in the new entry is the sum of all the compressed entries. The date assigned is the starting date for the period that is compressed, such as the first day of the month (if the entries are compressed by month). After the compression, you can still see the net change for each account in the previous fiscal year.
.....

Warning
Date Compression deletes entries, so you should always make a backup copy of the database before you run the batch job.

austin

Thanks ritesh,


If it deletes the ledger entries then we will face some probelems when we run the AICE , then y we have to run this batch job .

Do i need to run the batch job daily or system will run automatically ?

till now i did not run this batch job in my live database .

Just we use to run the AICE, Post Inv to G/L.

Let me know do i need to run this daily ?


Thanks and regards

ritesh.singh

austin wrote:

Thanks ritesh,

Do i need to run the batch job daily or system will run automatically ?

till now i did not run this batch job in my live database .

Just we use to run the AICE, Post Inv to G/L.

Let me know do i need to run this daily ?


Thanks and regards

David Singleton wrote:

ritesh.singh wrote:

No. can be missing if the Date Compression batch is run..

Ritesh is correct, the compression batch can incorrectly delete entries. This is why I recommend NEVER to use this routine. IN my many years of working with Navision I have never seen it work successfully.

ssingla wrote:

Refer to David's remark earlier in the post and follow it religiously.

austin

Thanks,



what is the path of that batch job.

thanks