• jll
  • New member
  • Offline
  • Registered: 10/28/2008
  • Posts: 6

Topic: import batch journal entries? on more than 1 fiscal year?

instead of putting balances, I'd like to enter all my entries with correct dates.
Of course I'd love to import them within journal entries smile
I know I can fill in gl_trans table, but it seems that a journal entry write to different tables.
Is there a way to import journal entries?

Also, since it's on more than one fiscal year, how to change periods?
does closing a year dump all accounts before the date and only keep the result amount?

thks

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: import batch journal entries? on more than 1 fiscal year?

If you want to import journal entries, you have to write an import module yourself. The database is documented in two different ways. Look in Download, Documentation on our Website.
You don't have to worry about periods, they are non-existing in FrontAccounting. You define the periods yourself when reporting. You only have to make sure, there are fiscal years covering your imports.
There are no account dumps when closing a fiscal year. You do that yourself according to accounting rules.

/Joe

  • jll
  • New member
  • Offline
  • Registered: 10/28/2008
  • Posts: 6

Re: import batch journal entries? on more than 1 fiscal year?

Thanks for your quick reply Joe!
Ok, I'll try that but I'm not a programmer so not sure of the result smile