Thanks a stack Steve,
I'll have a look at that!
Regards,
Matt Benic
Axapta Developer
UTi Sun Couriers Division
"The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle."
- Col. John P. Stapp
www.smallfrymobile.com <http://www.smallfrymobile.com>
-----Original Message-----
From: Steve Wright [mailto:[EMAIL PROTECTED]
Sent: 01 February 2005 03:41 PM
To: [email protected]
Subject: RE: [development-axapta] Re-take-on
Hi Matt
You could try the following...
- Create a new Data Import/Export group and ensure you do not tick
Transaction and Worksheet types tables. If you then export your company it
should only be setup data - no transactions at all.
- Import into a new company
- Reset number sequences if you wish
- Use a product like Atlas xl (www.atlasxl.com.au
<http://www.atlasxl.com.au> ) to extract balances from your old company into
a spreadsheet, then use Atlas to send a journal back to Axapta using the
figures extracted from the old company. Atlas xl fully supports Axapta
number sequences and provides validation of the journal from Excel. I
suggest a journal per accounting period, it's a bit easier to reconcile.
- You may struggle to get the line item per customer per GL account if it's
not available from your GL. In some our implementations we changed the
transaction text to identify the customer, or use one of Axaptas dimensions
to hold the customer account, this way the customer is always available when
you look at a GL transaction.
Best of luck
Steve.
_____
From: Matt Benic [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 1 February 2005 8:32 PM
To: Axapta Dev
Subject: [development-axapta] Re-take-on
Hi all,
We are preparing for the rather drastic measure of dropping all
transactional data and doing a fresh takeon with figures calculated from
this transaction data. We will keep our 'old' data available on a separate
system, but our day-to-day processing will happen on this new 'clean' data.
Has anyone tried this before and do you have any suggestions? Can anyone
give me an idea of what data can safely be dropped?
We basically want to drop all transaction data and create a new transaction
per-customer with a line item per-customer per gl account used, totalling
all transactions that would fit that description. What sort of impact will
this have on other tables? I have been digging around frantically trying to
map out Axapta's tangled mess of a database and the deeper I get, the more
lost I get! Does anyone have any idea as to what data is 'safe' to destroy?
Thanks,
Matt Benic
Axapta Developer
UTi Sun Couriers Division
"The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle."
- Col. John P. Stapp
www.smallfrymobile.com
[Non-text portions of this message have been removed]
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
<http://groups.yahoo.com/group/development-axapta/>
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Links
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
