Skip to Content
0
Former Member
Jun 04, 2009 at 09:19 PM

Import GL opening balance,AR and AP aging with each open invoice data

60 Views

We tried to use Data Transfer Workbench to import GL opening balance back to 2007 year end but got an error "can not post to Control Account".

In Admin>Sys Init> Opening Balances> GL opening, Businesss Partner, 1099 opening balance can import all opening balance with AR, AP. But, can not import for each open invoice amount, invoice number, invoice date information.

If we entered those GL, AR, AP opening balance those won't affect the GL F/S, right?

We will need to close year 2007 then import each period Trial Balance Debit and Credit amount for each account then close each period to have all 2008 each account period data until May 2009.

Would like to know which is the best way to do this?

Edited by: Lily Chien on Jun 4, 2009 11:21 PM