[development-axapta] LedgerTrans summarization & record purge

2009-12-17 Thread mep53565
I'm wondering if anyone has worked on reducing size of LedgerTrans file. Our current table is 30GB, & we want to clean out data older than 4 years. I've got a preliminary class that summarizes transactions & deletes the originals and it seems to work. I've recalculated period balances and so f

[development-axapta] Re: Query about inventsumlogtts in AX 4.0 SP1

2009-07-21 Thread mep53565
We had same trouble AX3sp3. Is IMTS (inventory multi transaction system) running? If not, consider enabling it. There are various "levels" of execution to consider. My notes indicate that we could delete records where InventSumLogTTS.Committed=1. I thought AX4 had lots of revisions to MasterPl

[development-axapta] Re: Carriage Return in SysMailer body

2009-04-22 Thread mep53565
Something else to try: str CR = " 0x0D ";// Carriage return //str LF = " 0x0A "; // Line Feed I developed escape codes for old line matrix printer. You may/ may not need to pad with spaces. I found that when passing AX data, such as sales ord

[development-axapta] Re: Master Plan BOM Level (urgent)

2009-03-05 Thread mep53565
The plan calculates requirements for everything, period. We group our top level items so they are easy to distinguish using filters. If you instead mean that Planned Orders are calculated for all levels, then you have some options. Set next lower level of the BOM to type "production"; that is,