Search options (Page 197 of 201)

Generally speaking, you have to update the table gl_trans (possible with a leading prefix like 0_). But you have to ensure that the dates are inside the fiscal year, that the account exist in chart_master table, that you understand the journal type no's. Look in the database with a tool to see the types and finally you should download the modules Import Items and Import Customers to get an idea of how to write the module.
Or if this seems too difficult, you could try to get another person to write this. Use the specific forum for this.

Joe

Check your reference value in the Jornal Entry and go to Setup, Forms setup.
Look up the refence values for Journal Entries. If this is non numeric you must keep track of the next number yourself. If it is numeric, you should increase the number. This should help you.

/Joe

Just select a balance sheet or profit & loss statement, and filter by the dimension. It is just that simple! You can take the profit & loss statement over several fiscal years. Just select it.

/Joe

Done
No we don't have a scheme for FrontAccounting. You should try to follow the source.
You may very well help us with such a scheme .

/Joe

This is quite simple. You create your projects in the Dimension tab. Every time you enter a journal entry line for the company you decide if this should belong to a project (dimension). All journal entries belongs to the company but you could define if the lines should be associated with a project (dimension).
This way you can filter the dimensions in most reports belonging to the General Ledger.
Please look elsewhere for a definition of the Dimensions.

/Joe
PS. You can also associate a customer, supplier and/or an item with a Dimension.

Thanks Jan, this is really appreciative.

Kind regards
Joe

Janusz, lets take these discussions in the Mailing List. I've created a list and it will be available within 24 hours.
There is always a reason why things are implemented in a specific way. All the reports are taken care of in a 2 click away report centre, where your last document is default for printing.
The form_items table is a left over from the former project, where they used a non published java based report generator. We are not using it at present, and could possible eliminate it in the future.

/Joe

Thanks for your contribution. It warms our hearts. Did you see the oppurtunity to select jalali or islamic calenders as well. See in config.php. I don't know if you are using it, but they are there for your pleasure.

We also need some better fonts for the PDF presentations. There are some links around the website about it (Download Language page and some Feeds pages). The Farsi font we have tried is not the best one. There are some problems with it. If you have the time and interest you could probably dig into this a bit to get optimal solutions.

/Joe

Hello again,
Now it popped into my mind what the Retained Earning Clearing Account is about. It is the account for accumulating the profits during the fiscal years.

To your last question you should create an account, probably the last one in your cost group and call this account for something like 'Year Profit Clearing'.

The last transaction of the fiscal year will then be a debit to this account for your profit and credit to the Retained Earning Clearing Account.

If there is no profit, but loss, you should use credit and debit instead.

You don't have to this before creating a new fiscal year and start entering on the new year. You can do this later on when your transactions of the previous year has finished. As soon as you have done it, you should close the previous year, to avoid entrance on this year by mistake.

This is the normal way of doing it. There might be slightly different methods in various countries. In that case you should ask an accountant.

/Joe

The dot was mistakenly included. Here is the link again
https://frontaccounting.com/grid/sample16.php .

Fixed in the CVS repository at Sourceforge. Thanks janusz.

/Joe