Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Clearing All Financial Transactions
06-21-2013, 07:30 AM
Post: #1
Clearing All Financial Transactions
Hi All;

Which tables, or if possible through the UI, how, do I delete all financial transactions?

Thanks
I.
Visit this user's website Find all posts by this user
Quote this message in a reply
06-21-2013, 09:23 AM
Post: #2
RE: Clearing All Financial Transactions
Hi Ian,

general ledger transactions all in gltrans
sales ledger transactions all in debtortrans
accounts payable transactions all in supptrans
stock transactions all in stockmoves stockserialmoves

Way to many implications to cover here - so be warned this is going to mess up your system beyond repair!!

There is a script that zeros a lot of tables with options as to which ones to zero (includes more than just sales) - this script shouldn't mess things up
Z_DeleteSalesTransActions.php

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
06-21-2013, 05:36 PM
Post: #3
RE: Clearing All Financial Transactions
Thanks Phil


(06-21-2013 09:23 AM)phil Wrote:  Hi Ian,

general ledger transactions all in gltrans
sales ledger transactions all in debtortrans
accounts payable transactions all in supptrans
stock transactions all in stockmoves stockserialmoves

Way to many implications to cover here - so be warned this is going to mess up your system beyond repair!!

There is a script that zeros a lot of tables with options as to which ones to zero (includes more than just sales) - this script shouldn't mess things up
Z_DeleteSalesTransActions.php
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)