Re: Fwd: Migrating from another accounting system

Thank you for responding.
See below.

Thanks.
Brian

Brian Wolf

Phone: 410.367.2958

LedgerSMB Accounting Software Integrated with Amazon Marketplace
Integrated Payment Solutions

On 09/01/2013 07:42 AM, Erik Huelsmann wrote:

Hi,

On Tue, Aug 27, 2013 at 2:40 PM, Brian Wolf <..hidden..> wrote:

Merchants in this area most frequently use Quickbooks. There is an option in Quickbooks to export to Excel spreadsheet or CSV file, but there are also commercial tools available on the market to ease and refine exporting data.

>>What I personally did when migrating from another accounting system (Excel) to LSMB is
>>to import all invoices that I wanted to retain, pay them, so they don't stick around in the AR/AP modules.

Importing list tables such as customers, vendors and products is fairly straightforward. But, importing transactions such as sales invoices and purchase orders (for someone like me who hasn't much accounting background) seems daunting.

Into which tables did you import them?
ALL transactions or just specific types?
Going back how far? (eg, one year, or to the beginning of the current year.......)

Well, there are two options. If you load only list data, then loading orders should be fine (no financial impact).

Just to clarify.......... Loading both list data such as products, customers and vendors, along with closed sales invoices and purchase orders, will NOT affect accounting data?

If so, which tables would sales invoices and purchase orders be loaded into? AR and INVOICES tables?

If you only load orders which have actually been shipped and paid, consulting an order in the new system would work just as well as consulting an invoice in the old system.

By consulting, do you mean to search for and view invoices and purchase orders which have already been closed? Being able to view them is actually crucial to some merchants because customers often contact the merchant asking for a re-order on a product which they can only describe cursorily. The merchant then must search invoices to find the product they are referring to.

The other option (which I have actually seen being used in practice) is that the merchant doesn't migrate anything but the unpaid invoices and some balance information. If they keep Quickbooks for one more year, they'll never look back at the old data after that and save themselves a costly migration. Because: after a while, the "last invoice" is in the new ERP instead of the old one.

How are unpaid invoices and balance information loaded? Which tables in LedgerSMB?

Bye,

Erik.

http://efficito.com -- Hosted accounting and ERP.

Robust and Flexible. No vendor lock-in.

------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk

_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel