mibuso.com

Microsoft Business Solutions online community
It is currently Sat May 25, 2013 12:09 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 21 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: Let's Talk Cust Date Compression
PostPosted: Wed May 09, 2012 9:21 pm 
Offline
MVP Microsoft Dynamics NAV
Site Supporter

Joined: Fri Jun 06, 2003 9:01 pm
Posts: 6979
Location: L.I., New York
Country: United States (us)
So reading this post:
viewtopic.php?f=23&t=53020

got me thinking about date compression again. Now, I have always avoided it on our live system because the concerns brought up by everything & everyone didn't seem like it was worth the possible headache.

We do have a 3.10 database with 3.7 exe's and a backup server with a new backup restored in it.
So I'll test on that!

I will run a Trial balance from the beginning of time to today.
I will run an inventory report (same date range)
and a detailed Aged A/r report.
first.

Then I will attempt "customer date compression" ONLY on one customer which get's approx 100,000 entries per month.
I will do it for 1 year (the oldest) and re-run all the reports again.
They should match.

I was just wondering where else might something or some area go wrong from anyone's experience or even hearsay.
Then I can put this curiosity i've had to bed. One compression at a time.
Thanks.

I don't even want to try G/L compression...YET :twisted:

_________________
Harry Ruiz
http://www.cosmeticsolutions.com
http://www.autismspeaks.org


Top
 Profile E-mail WWW  
 
 Post subject: Re: Let's Talk Cust Date Compression
PostPosted: Wed May 09, 2012 10:48 pm 
Offline

Joined: Tue Jun 07, 2005 5:24 pm
Posts: 2574
Location: MA
Country: United States (us)
Savatage wrote:
...I don't even want to try G/L compression...YET :twisted:



I'd think the G/L would be the least problematic of the bunch.

_________________
There are no bugs - only undocumented features.


Top
 Profile E-mail  
 
 Post subject: Re: Let's Talk Cust Date Compression
PostPosted: Wed May 09, 2012 11:21 pm 
Offline
MVP Microsoft Dynamics NAV
Site Supporter

Joined: Fri Jun 06, 2003 9:01 pm
Posts: 6979
Location: L.I., New York
Country: United States (us)
Really? That's the biggest table (28,042,010) so that's the one I worry about.

I can see how the Item Compression would be the scariest due the potential of screwing up costs on over 100,000 items. That would be total devistation!! [-o< and if the others work then there is no real need to compress that one.

As for easiest, I thought the customer one would be pretty easy due to it only having 3 choices
Invoice, Credit, Payment for us. that's why I'm trying that one first.

_________________
Harry Ruiz
http://www.cosmeticsolutions.com
http://www.autismspeaks.org


Top
 Profile E-mail WWW  
 
 Post subject: Re: Let's Talk Cust Date Compression
PostPosted: Thu May 10, 2012 12:15 am 
Offline

Joined: Tue Jun 07, 2005 5:24 pm
Posts: 2574
Location: MA
Country: United States (us)
I wasn't thinking about table size. I was thinking more in terms of data issues resulting from the compression.

_________________
There are no bugs - only undocumented features.


Top
 Profile E-mail  
 
 Post subject: Re: Let's Talk Cust Date Compression
PostPosted: Thu May 10, 2012 1:01 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Aug 14, 2001 7:01 am
Posts: 5315
Location: Prague
Country: Czech Republic (cz)
bbrown wrote:
I'd think the G/L would be the least problematic of the bunch.


As long as you don't compress entries generated from any of the Navision sub ledgers, Cust/Vend/Fa/Bank etc. Since they use the same number sequence and things go all screwy.

_________________
David Singleton
Dynamics NAV Freelancer
Dynamics Book
Go-Live International


Top
 Profile E-mail WWW  
 
 Post subject: Re: Let's Talk Cust Date Compression
PostPosted: Thu May 10, 2012 1:07 am 
Offline

Joined: Tue Jun 07, 2005 5:24 pm
Posts: 2574
Location: MA
Country: United States (us)
Note that I said "least problematic". Not "problem free". :)


Anyways I'd not thought about that. But wouldn't new entries just start from the last entry number?

_________________
There are no bugs - only undocumented features.


Top
 Profile E-mail  
 
 Post subject: Re: Let's Talk Cust Date Compression
PostPosted: Thu May 10, 2012 5:19 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8703
Location: 3rd rock from sun
Country: United States (us)
if you are using warehouse management, I would go with getting rid of warehouse entry and register new whse journal for balance.
I did for a client on 4.0 without any issues.

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/


Top
 Profile  
 
 Post subject: Re: Let's Talk Cust Date Compression
PostPosted: Thu May 10, 2012 8:35 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Aug 14, 2001 7:01 am
Posts: 5315
Location: Prague
Country: Czech Republic (cz)
bbrown wrote:
Anyways I'd not thought about that. But wouldn't new entries just start from the last entry number?


With compression, new entries are generally OK, its the application to existing entries that general causes it to fall apart. Bits of the application process look for records that are not there, registers etc and weird errors happen.

The thing is that the compress entries routines were written in the DOS version of Navision, where they sort of worked IF you customized them to suit your application. They also sort of worked in versions up to 2.01, but by 2.6 when warehouse and manufacturing got involved things got bad. The real killer though was detail entries (Cust/Vend and Value) the tools should have been thrown out and started again.

Compression can be done, but not with the Navision standard tools.

As Rashed says, focus on things that can be safely DELETED (not compressed) like Warehouse.

_________________
David Singleton
Dynamics NAV Freelancer
Dynamics Book
Go-Live International


Top
 Profile E-mail WWW  
 
 Post subject: Re: Let's Talk Cust Date Compression
PostPosted: Thu May 10, 2012 8:57 am 
Offline

Joined: Sun Jul 22, 2007 10:08 am
Posts: 264
Location: bombay
Country: India (in)
ara3n wrote:
if you are using warehouse management, I would go with getting rid of warehouse entry and register new whse journal for balance.
I did for a client on 4.0 without any issues.


Very Interesting topic.

Could you explain the above process in detail. ?


Top
 Profile  
 
 Post subject: Re: Let's Talk Cust Date Compression
PostPosted: Thu May 10, 2012 4:22 pm 
Offline
MVP Microsoft Dynamics NAV
Site Supporter

Joined: Fri Jun 06, 2003 9:01 pm
Posts: 6979
Location: L.I., New York
Country: United States (us)
It obviously goes by the "Closed at Date" field..nice.

I don't like the report options - I think Customer should be the first dataitem not Just Cust Ledger Entry.
Because I would like to test it on Blocked=Yes customers. Customers we no longer do business with.

So I added dataitem:
Customer
-Cust. Ledger Entry
(DataItemIndent to 1)
(DataItemLink to Customer No.=FIELD(No.))

I moved the code from CLE to Customer (Unless you like clicking OK alot)
Code: Select all
OnPreDataItem()
IF NOT
   CONFIRM(
     Text000 +
     Text001 +
     Text002,FALSE)
THEN
  CurrReport.BREAK;

Time to test the results....

_________________
Harry Ruiz
http://www.cosmeticsolutions.com
http://www.autismspeaks.org


Top
 Profile E-mail WWW  
 
 Post subject: Re: Let's Talk Cust Date Compression
PostPosted: Fri May 11, 2012 10:26 pm 
Offline
MVP Microsoft Dynamics NAV
Site Supporter

Joined: Fri Jun 06, 2003 9:01 pm
Posts: 6979
Location: L.I., New York
Country: United States (us)
Cust Ledger Entries & G/l Enties compressed without issue.
Looks like 9 million enties crunched down to about 300.

I've looked at the ILE Compression and mine won't even compile. Looks like our nav partner from way back when attempted to "fix it" to allow it to retain Serial no & lot No's and never finished it. I commented out those changes (we don;t use serial & lots anyway). not worth running that report!

last test is to create a backup & restore it to make sure that goes smoothly, better safe than sorry.

Just a few years of compression 2003-2006 gained 12% of the database used back.

Anyone ever run "Delete Empty Item Registers"? What would cause emptry registers?

_________________
Harry Ruiz
http://www.cosmeticsolutions.com
http://www.autismspeaks.org


Top
 Profile E-mail WWW  
 
 Post subject: Re: Let's Talk Cust Date Compression
PostPosted: Fri May 11, 2012 11:52 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 11, 2004 9:05 pm
Posts: 4858
Location: Los Angeles, CA
Country: United States (us)
I wouldn't touch compression of ILE or VE if you value your data.

_________________
Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work


Top
 Profile E-mail WWW  
 
 Post subject: Re: Let's Talk Cust Date Compression
PostPosted: Sat May 12, 2012 12:22 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Aug 14, 2001 7:01 am
Posts: 5315
Location: Prague
Country: Czech Republic (cz)
Savatage wrote:

Anyone ever run "Delete Empty Item Registers"? What would cause emptry registers?


If you delete (or compress) Item Ledger entries, then you will have empty registers. Same with Cust Vand and GL. You need to make sure now tht all your empty cust registers have been deleted. Which is a problem because you can't delete them unless you also delete/compress the associated gl entries, and there is no link now form cust to gl (since the cust entry is gone) so how do you delete it. Also what happened to the Custe Detail entry?

_________________
David Singleton
Dynamics NAV Freelancer
Dynamics Book
Go-Live International


Top
 Profile E-mail WWW  
 
 Post subject: Re: Let's Talk Cust Date Compression
PostPosted: Sat May 12, 2012 2:21 pm 
Offline
MVP Microsoft Dynamics NAV
Site Supporter

Joined: Fri Jun 06, 2003 9:01 pm
Posts: 6979
Location: L.I., New York
Country: United States (us)
It's all being tested on a test server just for curiosity sake. Ile and ve are not going to be touched. As for cust detail I will check what the results are on Monday.

_________________
Harry Ruiz
http://www.cosmeticsolutions.com
http://www.autismspeaks.org


Top
 Profile E-mail WWW  
 
 Post subject: Re: Let's Talk Cust Date Compression
PostPosted: Sat May 12, 2012 8:29 pm 
Offline

Joined: Fri Jul 08, 2011 10:20 am
Posts: 16
Country: Switzerland (ch)
Alex Chow wrote:
I wouldn't touch compression of ILE or VE if you value your data.


Same here: faced a migration of 2.60 Financials to 3.70 with compressed ILE and been through a nightmare! But it was really specific to the original version 'cause financials didn't have VE at the time and migration process tried to create these.

No need to say that item values was considered a priority to our customer (he did the compression, in spite of our recommendations, because he considered having payed for all existing features, including data compression)

What a mess :P


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 21 posts ]  Go to page 1, 2  Next

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: