Date Compression & Posted Sales Shipments

couberpu

Hi All,

I just did a item ledger entry date compression for 2003. Right after I finished my compression, I ran into a credit memo posting error. It was caused by a charge item using one shipment line and the item ledger entry for that shipment line was one of the item ledger entry I compressed!

Is there a "thing" in Navision 3.6, or Navision 3.70b, takes the posted sales invoice, credit memo, shipment away along with the date compression to make the date compression completed? Or I am just confused!!!!

Please HELP! :oops:

Alex_Chow

Date compression does not compress posted invoice or posted shipments. You'll have to ask your local solution center to create a process for you.

ara3n

What kind of error are you getting couberpu?

Alex_Chow

The Item Charge process assigns the cost to the item ledgers when you get the shipment lines. When it can reference the item ledger you're talking about, you get an error.

couberpu

Thank you all for the information. Yes, I got error message on item ledger entry missing and I fixed it already. I was looking for instructions on steps to complete the "compression" process.


CouberPu

ara3n

I would run test db process and see if there are any fields that foreign key constraints to item ledger value entry, item application tables.

couberpu

Good Morning All,

I had a "not too smart" question? Can I just "kill/delete/erase" the sales shipment, shipment lines, posted sales invoice, posted sales invoice lines...for the period I did date compression? I knew there are issues, but if I had my backup server running and 99% of the time I do not need the information. Would it make easy on my life not to face my bossES everyday to explain to them the reason they spend more money to get slower is to keep more data they do not need on a daily bases!?

Well, I just had it and please advise!

CouberPu :oops: :evil:

ara3n

Yes you can delete old shipment and invoice documents. The only thing that will stop you is that it has to be printed once. What I usually do is to not waste paper is to print to pdf. then delete the documents. I would not delete anything that is for the open accounting period.

couberpu

ara3n wrote:

Yes you can delete old shipment and invoice documents. The only thing that will stop you is that it has to be printed once. What I usually do is to not waste paper is to print to pdf. then delete the documents. I would not delete anything that is for the open accounting period.

Thank you very very much ara3n. =D> =D> =D>

CouberPu

Savatage

The PDF is a good idea.

So a similar purpose we have a phoney network printer created
(any type doesn't matter - it's not really printing anything)

it's always set on Pause Printing, so all the reports sent to it sit in the Queue and can be deleted at any time.

We call it the "Dead Reports" printer 8)