• From: Anacortes, WA USA
  • Registered: 11/01/2015
  • Posts: 51

Topic: Sage 100 Data Import

I'm seriously thinking about doing a Sage 100 to FA data migration utility. Sage has transitioned to a subscription model which prices keep rising every time I check. Many of the MAS90 / Sage 100 users that bought the software aren't happy about buying it again on subscription.

Is there any FA schema docs that might help me with my mapping and translation effort?

Thanks!

John

ScriptBASIC's Website

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,182

Re: Sage 100 Data Import

I am not sure you have gone through this link

https://frontaccounting.com/fawiki/index.php?n=Devel.ERDiagram23

Which helps you to understand the table structure of FA.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • From: Anacortes, WA USA
  • Registered: 11/01/2015
  • Posts: 51

Re: Sage 100 Data Import

Thanks kvvaradha!

That was very helpful. I must of missed it in my last peek at the wiki.

ScriptBASIC's Website

  • From: Anacortes, WA USA
  • Registered: 11/01/2015
  • Posts: 51

Re: Sage 100 Data Import

Does FA do rollups on G/L account number segments?

I'm assuming I can use Dimensions as a substitute for Sage 100 Divisions?

ScriptBASIC's Website

  • From: Anacortes, WA USA
  • Registered: 11/01/2015
  • Posts: 51

Re: Sage 100 Data Import

I created a new company 1_ and decided I wanted to start over. I deleted the company and tried to use 1_ again but my only option is 2_ or None. Where is this drop down getting its data from so I can reset it?

ScriptBASIC's Website

  • rafat
  • Senior Member
  • Offline
  • From: UAE, Dubai
  • Registered: 11/28/2017
  • Posts: 540

Re: Sage 100 Data Import

In ../config_db
$tb_pref_counter = 1;

rafat's Website

7 Reply by ScriptBASIC (edited by ScriptBASIC 10/09/2021 10:52:31 am)

  • From: Anacortes, WA USA
  • Registered: 11/01/2015
  • Posts: 51

Re: Sage 100 Data Import

Thanks!

That makes sense.

ScriptBASIC's Website