• tsi1
  • New member
  • Offline
  • Registered: 12/16/2014
  • Posts: 1

Topic: Removing all generic info from FA

How do I remove all of the generic items in the item list so that they are no longer there so that I dont have to see them every time. Also remove all of the generic data so that I can start my yearly numbers from today? Any help would be greatly appreciated.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Removing all generic info from FA

Upload the en_US-new.sql into your company/#/backup folder Setup=>Backup & Restore => Restore and change the admin password to what you want. Then edit the fiscal years table to have what data you want and then begin operations within the GUI.

Alternatively check what extra data is in the current backup as compared to the en_US-new.sql file and strip them out - beware of resetting all AUTO_INCREMENT values to 0 (zero) so that they auto synch themselves to the next available primary key number.

apmuthu's Website