FrontAccounting forum — Sage 100 Data Import

Re: Sage 100 Data Import

null@example.com (ScriptBASIC) — Sat, 09 Oct 2021 08:46:09 +0000

Thanks!

That makes sense.

Re: Sage 100 Data Import

null@example.com (rafat) — Sat, 09 Oct 2021 08:33:45 +0000

In ../config_db
$tb_pref_counter = 1;

Re: Sage 100 Data Import

null@example.com (ScriptBASIC) — Sat, 09 Oct 2021 07:55:53 +0000

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?

Re: Sage 100 Data Import

null@example.com (ScriptBASIC) — Sat, 25 Sep 2021 03:27:17 +0000

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

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

Re: Sage 100 Data Import

null@example.com (ScriptBASIC) — Sat, 25 Sep 2021 00:54:06 +0000

Thanks kvvaradha!

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

Re: Sage 100 Data Import

null@example.com (kvvaradha) — Fri, 24 Sep 2021 13:10:46 +0000

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.

Sage 100 Data Import

null@example.com (ScriptBASIC) — Fri, 24 Sep 2021 04:38:06 +0000

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