Search options (Page 6 of 6)

Janusz

Yes it can be done by creating service item for any GL account but than option to post GL item expenses in "Supplier Invoice" doesn't make sense. Another issue is if you have categories GL ledger format then using service item is not possible. Please have a look at my COA.

Deven

Janusz

I think you misinterpreted my comment. An invoice from supplier SHOULD NEVER be posted via a journal. You have to use purchase module i.e. Supplier Invoices to post expense invoices on any accounting system. General Journals are only used to reallocate costs from one department to another or accruals/prepayments or nominal adjustments. Firstly I feel that when posting expense invoices via Supplier Invoices, we should have auto calculation of tax for each line value or total taxable amount on the invoice (Just like purchase order entry form). Now tax rate assignment to each GL Account (which I suggested in my first comment) is useful for calculating tax on a purchase invoice. For example, a supplier has supplied me few items of which some are VATable @ 20% and some are Non-Vatable. On current FA supplier invoice form there is no auto calculation of tax. You can enter VAT amount either by creating new line with VAT GL account (not advisable as you don't want users to enter amounts in VAT accounts) or do a quick entry which enters tax amount for you based on the amount you put in the left text box. The user has to manually calculate total VATable amount to do the correct taxing and exclude non-vatable amount. Less user intervention/calculations in terms of taxes are highly recommend and should be auto-calculated be the system.

My suggestion is if you have tax rate assigned to each GL Account, then at the invoice level you can write a short code which calculates totals for each different tax rate for the GL accounts on the invoice and then auto insert tax line/s as per the tax rate of the GL account. Or for each GL account line VAT is auto calculated based on the tax rate of the GL account. i.e. On a supplier invoice I have 2 different GL account line (stationery & uniform which are VATable @ 20%) and 1 GL account line (refreshments – Tea which is non-vatable). The Invoice form then total of stationery & uniform line and generates a line with 20% tax. There is no tax line generated for non-vatable amount and is excluded for taxable/VATable purchases.

I think to do this you will have to create a 2 new columns in chart_master table (tax/vat rate & tax/vat amount) and a small script in supplier_invoice.php.

I hope it’s not too demanding.

Please let know contribution box email.

Many thanks

Thank you for your response

1) I've now created quick entry for applying appropriate VAT for Admin expenses entered via supplier invoices. This seems easier way if posting direct invoices.

2) This constraint is added in chart_master table. A new Boolean field to be added and before posting journals or supplier invoices with GL account, this constraint be check. If it doesn't require major code change, I think it will be useful.

3) Again this requires a field in chart_master table. This is useful from UK VAT system. But again if a simple code can do this then it will be useful.

4) I think recurring journal is definitely needed replacing "Revenue & Cost accruals".  You should be able to save multiple recurring journals with starting/expire date, frequency and amount for accruals and prepayments and post each journal at the end of each period/month or at users wish. I hope this utility is added to the system. I’m not a hardcore programmer but can provide my knowledge on system design.

In last 7-8 days, I've thoroughly tested and customised Frontaccounting for UK use. After trying various open source and free systems, I strongly feel that Frontaccounting is the best. It easy to use, very comprehensive and covers almost all modules of a good ERP system. A thousand times better than Sage.

I have created a template script for UK setup. I can upload it if you can provide me link or email address. You can test and see if you would like to put it as default UK COA.

Thank you

I like most of the functionalities of Frontaccounting. I was just giving my suggestions which might help improve the system.

Deven

I know you can use quick entries but if you have 40-50 different expense accounts then it's lot of work. One more functionality which is missing or needs modifying is "Revenue/Costs Accruals". I think we need proper recurring journal like in many ERP system including open source xTuple. You should be able to save a multiple recurring journals with starting and expire date for accruals and prepayments and post each journal at the end of each period/month or at users wish. At present the system posts transactions for all numbers of period entered and if your prepayment fall in next fiscal year, it throws an error.

Deven

I've created a tax "VAT - EU Reversal" with 20.00 and then change the value  in mySQL table to "-20.00". I've created Tax group "EU Supplier VAT Registered" and assigned 2 taxes. 1 "VAT - STANDARD RATE (20%)" & VAT - EU Reversal (-20%). When the supplier is assigned tax group of EU VAT Suppliers, on invoice 2 tax lines appears leaving total tax amount to 0 but there are 2 entries posted in GL. It works fine.