Hi Girish,
There is a setting that causes data in SalesTable and related tables to be
removed when posted, and I understand that the Parm tables are used as
intermediate data storage when posting occurs, so I would have expected them
to be flushed after posting..
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
-----Original Message-----
From: Girish Bhatkal [mailto:[EMAIL PROTECTED]
Sent: 24 November 2004 12:04 PM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] SalesParmLine and SalesParmTable
Matt,
Whenever u try to do a Sales order posting (it might be delivery note,
invoice etc) the system will pick up the records from the sales lines
,depending on the criteria used for posting and stores in these 2 tables
(used on form saleseditlines), which you have mentioned.
I am not sure if there is any setting to be checked in order to delete
these records. These records might be deleted by making some modification
(but you have to check if this will affect any other functions)
cheers,
Girish
_____
From: Matt Benic [mailto:[EMAIL PROTECTED]
Sent: 24 November 2004 07:46
To: Axapta Dev
Subject: [development-axapta] SalesParmLine and SalesParmTable
Hi All,
We implemented Axapta to not keep sales line data but to delete the sales
order lines and headers once invoiced. Yet we still find that the
SalesParmLine and SalesParmTable tables are amongst our biggest tables
(totalling over 4Gb). What gets stored in these 2 tables and should we be
able to delete it once the orders have been invoiced and posted?
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
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=1294k3uml/M=298184.5639630.6699735.3001176/D=gr
oups/S=1705006764:HM/EXP=1101376353/A=2434970/R=0/SIG=11edksnhv/*http:/www.n
etflix.com/Default?mqso=60185402> click here
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=groups/S=
:HM/A=2434970/rand=315597152>
_____
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]
<mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
| Yahoo! Groups Sponsor | |
|
|
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.
