Hello,

I am not sure which is the correct way of generating the report, but ideally tax report should show all Input amounts, Output Amounts and the tax amounts for these particular output/input amounts. And if possibles the rate of tax.

When I currently generate the tax report, it doesn't show me my Input amounts where the tax was 0%. But it does show me output amounts where the tax was 0% percent.

Would someone be able to help with the codes so that we can achieve above basic format ?

Thank you

Hello,

Not sure if this is a bug or what, but I have a few transactions where I get these supplier invoices highlighted in red, with a message at bottom of the table 'Marked items are overdue'.

The options I get against this supplier invoices are either to edit them or credit them.

I tried editing them by changing dates and also by 'entering invoice' again and straight away making the payment, but no luck.

Has anyone encountered it ?

It doesn't happen on all other transactions which have similar steps of "purchase order delivery->Supplier invoice -> supplier payment"

Any insight would be helpful.

Thanks,
GJ

Hello again,

Assuming that stock GB CoA won't create any problem, I have decided to just carry on without disturbing anything in my current installation. I had entered too many customers, suppliers and items to have any courage to start with fresh installation.

But as @apmuthu mentioned earlier, this will leave me open to ransom in case things go wrong or if I find out something is breaking apart  big_smile big_smile big_smile big_smile

Thank you for the details.

I have created Company with standard inbuilt coa but haven't done any transaction at all.

All I have done is created and modified some GLs and created few taxes and tax groups.

When I check SQL files they do not have details of any  a modification I made.

Do you think I can replace the old file with new file from your repo directly?

Creating a new company is a lot to work to be honest, both on fa and in real ha ha..

Hello,
I have to admit I didn't know the complexity of sales kit and he circular referencing.

Does this mean that we cannot at all apply auto increment just on item codes ? Or would it still be possible to create something like transaction references for item code field only, and let sales kit module work as it is ?

I mean instead of inputting the item code manually can't we automate it, how would that conflict with stock id convention.

apmuthu wrote:

The SalesKit circular issue is a bit more complex even if the self choosability of level 1 is implemented..
SalesKit SK1 is created to have some items.
SalesKit SK2 has some items.
SalesKit SK3 has some items and SalesKit1 as part of it.
SalesKit SK3 is now added to be part of SK2.
SalesKit SK1 will now be able to choose SK2 which in turn has SK3 with in turn comprises of SK1 itself!.

A complete self join based tree lookup with multiple 'inheritances' would need to be implemented.

So let us keep it simple even if slightly stupid!

Hello,

Thank you for prompt reply.

I have indeed downloaded the 2.4.2 from the snap shot after all the fixes were published, I think I have the latest version as of 17/10/2017.

But, once installed, I created a few GL accounts and updated all items etc.

If I now replace sql/<Chart sql> file would it disturb everything ?

Also, all I want it a new GL account for "GRN Clearing Account", would it be easier just to create 1005 GRN Clearing Account instead of replacing the files, because when I'll replace the file, the new file won't have my unique GL accounts which I created after installation.

If I don't replace the files, would I miss out much on functionality ?

I ended up on this page after searching about 'cost of landed goods' and your last post mentions about GRN(link below).

https://frontaccounting.com/punbb/viewtopic.php?pid=28371#p28371

And last if there has been any fix about 'cost of landed goods' please let me know.

Thank you very much.

Hello,

Just wondering if below fixes are already incorporated in 2.4.2, especially the GB CoA.

If I understand correctly, there was not GRN Clearing Acc in GB CoA before, and from looking at the files updated below, it seems GRN Clearing Acc was setup at code 1005 in updated CoA at below link.

But when I try to set up GRN clearing Account from System and General GL setup in 2.4.2, I don't see any GL option to use for GRN Clearing Acc.

Any help would be appreciated.

Thanks,
GJ

apmuthu wrote:

All these fixes are now in my FA24extensions repo.

Screenshots of available versions of extensions.

Sounds good so far.

So what would I need to do for the item codes to get auto populated and have auto increment ?

Is there a little piece of code which I can manipulate without disturbing the whole setup ?

Please let me know.

Thank you,
GJ

Hello,

Though I am not fully at grips with the concept of sales kit and separate item codes within them, I believe if we were to provide a system like that in transaction references where there would be a defined prefix for sales kits and item codes, won't it make them both always unique ? And then even if they were used in combination, they would never conflict I believe.

For example Sales Kit = SK### and Item code = IC###

Even if they were combined ever, they won't conflict.

Now above can only be done if the codes can be both alphanumeric etc.

Hope I am making some sense.

Regards,
GJ

Hello,

Just wondering if this has been possible at all ?

I searched wiki but couldn't find anything about auto increment, though when I search in database via php, I can see there is option for auto increment, but if I try to apply it, I get an error.

This would be a helpful tweak if possible at all.

Thank you,
GJ

61

(7 replies, posted in Installation)

Thanks a lot.

I think I know now what I need to do.

Basically do a "backup restore" from within FA and then overwrite the 2.4.1 folders with new folders from 2.4.2 using Filezilla ?

62

(7 replies, posted in Installation)

apmuthu wrote:

In general, overwriting with the FA 2.4.2 code for FA 2.4.1 should do the job. Backup (FA code and mysql) and try it..... Take the cutting edge one from Git/Github.


Thank you very much for your prompt reply.

But I'll need some guidance here.
When you say Backup (FA code and mysql), does it mean taking a backup from "/setup/backup and restore" or this is some other process of backing up FA code and mysql ?

Sorry if this is supposed to be too basic a task, but I rather ask then mess up the setup.

Regards,
GJ

63

(7 replies, posted in Installation)

Hello,

Thank you all for the amazing work that is going on, unfortunately due to my limited knowledge I am not able to contribute as much.

I started using version 2.4.1 before a few weeks to finally get started on FA, but now I see we have version 2.4.2.

Would it create any problems if I did a back up on version 2.4.1 and then restored that back up on version 2.4.2 ?

I don't want to create all the entries again on newer version(2.4.2), but on other hand I don't want to be using a version which has only been there for few months(2.4.1).

Also, would it be possible to know if there is any plan on another version release in near future for which one should wait ?

Thanks
GJ

Hello,

I get below error when I try to do delivery against sales order, which has already been allocated full payment as prepayment.

"You have to set Deferred Income Account in GL Setup to entry prepayment invoices."

May I know how did you setup this deferred account?

Thank you

bobloblian wrote:

Hi again, I am trying to figure the workflow on this scenario and I am not meeting with success.

I have an order from my customer for a given set of devices.  I have gotten a quote from a few vendors in order to fill the order.

I do not have sufficient money to pay the vendor, so the customer has agreed to make a partial prepayment. 

I have created the quote and sent it to the customer.  After it was approved, I created the sales order from the quote.  I have setup a deferred income account and a prepayment payment term.  In the sales order, I have set the "prepayment required" field to the value that the customer has agreed to pay. now when I go to sales=>invoice prepaid orders, I can only create an invoice for the full amount, not the agreed upon prepayment value. 

I am not really clear how to send them an invoice for the value of the partial prepayment.  Seems like I am missing a step, maybe in the delivery?  but I can't make delivery till I get the vendor invoice, and I can't get the vendor invoice before prepayment, so maybe there is another way to do this?

suggestions would be appreciated...

Hello,
Sorry for the long post below, but I really need some help here as I've gone live with FA for business and don't want to end up with wrong entries and accounts.

I'd be thankful if someone can help me set up/ confirm my understanding below with regards to Company Setup / Tax Period / Tax Last Period

My VAT period is quarterly and it run as below:

From    To
01-Feb    30-Apr
01-May    31-Jul
01-Aug    30-Oct
01-Nov    31-Jan

Should I use:
Tax Period =3
and
Tax Last Period = 1 ( ideally I have a month before I pay/collect the tax from tax office, but I can do it anytime in next 3 months)

mind it, I have an odd fiscal year which runs from 29/July/2017 to 28/July/2018


I read below on wiki and have a few questions:
=========
Using the Tax System
1. After you have setup your Tax System it is time to explain how to use the Tax System in practice.

2. Let us say, that you have a Tax Reporting Period of 1 month and you have to report this per the 15th of the following month.

3. Then you will run The Tax Report somewhere between the 1st and the 15th of the following month.

4. Let us say that you have to report the Tax on Feb, 15. You run a Tax Report, and if you have set the period value and the months back value to 1 in the Company Setup, FA will suggest the period 01/01/2010 to 01/31/2010. Print out this report.

5. Before we go any further, it is time to consider how the Tax Transaction Details are collected. They are kept inside a table, called tax_trans_details. This table also holds the tax details for all documents and quick entries.

==
6. To avoid booking The Payment directly against the Tax Accounts, we should create or use an Accrued Account for our Tax collection.
Question Do i have create a GL account for this Accrued Account for Tax collection ???
==

==
7. So per 01/31/2010 we would enter a JE where we empty the Tax Accounts and counter book them on the Accrued Tax Account.
Question How exactly do I emtpy the Tax Accounts and book them on Accrued Tax ??? I have created a different types of taxes and few GL accounts for each of the taxes, do I post credit/debit entries with each of this tax accounts and Accrued Tax account (at this point I believe I do have to create a new GL account for Accrued Tax collection)

And am I correct that once I emtpy the tax accounts in to Accrued Tax account, they'll be empty ? Or would they be emptied on basis of above 'tax perioed' / 'tax last period'?
==

8. Now, when you pay the Tax via Bank Payment, you debit this Accrued Tax Account and your bank account is credited.
9. If you should have a Tax collect, you would of course use the Bank Deposit instead, and book the other way round.

apmuthu wrote:

Yes.


Thank you very much.

Hi,

Coming back to this topic, am I correct in understanding that this fields are to be used for correctly calculating the monthly/quarterly GST/VAT payments owed/due to/from tax office?

Hi,

Seems I just found it on below link, but please feel free to add further knowledge you have.

Hope this topic helps someone.

https://frontaccounting.com/fawiki/index.php?n=Main.TaxSystem

Hi,

Sorry if this has been covered already but I couldn't find any information after doing multiple searches.

Could someone help me understand how these two fields are used within Company Setup page?

Thank you
GJ

70

(1 replies, posted in Setup)

Hello,

I did a fresh install for version 2.4.1, but upon running system diagnostics I get below warning (i believe).

Test
MySQL version >=4.1

Test type   
Required

Value   
10.1.23-MariaDB-1~xenial

Comments
Upgrade MySQL server to version at least 4.1


Could someone help me understand if it is something to worry about ?
Below are the details from my 'phpMyAdmin' dashboard.

Database server
Server: abcxyz.com.mysql via TCP/IP
Software: MariaDB
Software version: 10.1.23-MariaDB-1~xenial - mariadb.org binary distribution
Protocol version: 10
User: abcxyz_com_fa@10.27.18.48
Server charset: UTF-8 Unicode (utf8)

Web server
nginx/1.10.3
Database client version: libmysql - mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $
PHP extension: mysqli Documentation

phpMyAdmin
Version information: 3.5.8.1
Documentation
Wiki
Official Homepage
Contribute
Get support
List of changes

71

(10 replies, posted in Reporting)

Thanks a lot Ap.Muthu I'll have to try below and get grips with it all.



apmuthu wrote:

Just re-compile the standard en_US.mo file. Only changed strings need be in the new .po file and compiled into the .mo file.

In the case of Australian or Indian English too the same applies with changed strings.

Extract the .po file from your current .mo file - only those stings that changed need/will be there. Then refer to the empty.po file and add in "the strings you wish to change" into the extracted .po file and recompile and use it.

In future, do not upgrade the language file at all from the GUI and instead only incorporate the changes in them into your version of the extracted .po file, compile and use the resultant .mo file.

In most instances language files have little or no changes and version bumps occur regularly - good business for "consultants".

72

(6 replies, posted in Setup)

dvarsani wrote:

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.

Hello,

Just came across this post to mitigate the issue about EU VAT (which UK buyer needs to pay in UK) and then needs to claim it back, (in my case as I export the goods outside EU/UK).

I understand above work around from dvarsani but confused with what GL accounts do I need to assign to 'VAT - EU Reversal' Tax ?

In case, if above means that you replicate standard 'VAT - STANDARD RATE' by a new name and then change its value to "-20.00%" in mySQL table, could this not be done by creating entire new GL accounts as below ?

UK VAT (20%) in Current Liabilities
UK VAT Refund(20%) in Current Assets

EU VAT (20%) in Current Liabilities
EU VAT Refund(20%) in Current Assets

I am still a lot confused on how to set up VAT for UK business which buy from UK/EU [either paying vat to supplier in UK, or paying vat to UK govt for EU aquisition, and selling outside EU (zero VAT)]

Any help would be appreciated, thanks a lot once again for all the work that goes on here.

Regards,
GJ

73

(3 replies, posted in Setup)

Hello again,

Just wondering if this UK CoA have been fixed now or would I still need to perform below procedure for correct CoA files before setting up a new UK company ?

Also, not sure if this is right place to ask, but how can I set up taxation where by I can reflect the VAT enteries for:

1. EU acquisitions to UK(where I need to pay 20% in UK to govt, instead of paying it to EU supplier),

2. Domestic UK purchases (where VAT is paid to supplier)

3. Sales in EU and outside EU(eg. India/China), where I don't charge any VAT,

4. Sales in UK where I charge VAT.

Would I need to set up mutiple GL accounts to capture above scenarios for purchases/sales separately ?

Any help would be appreciated.

Thanks
GJ

apmuthu wrote:

First of all the UK Chart of Accounts is broken if taken from the official pkg repo. After installing it from there, just update the en_GB-general.sql file from my GitHub Repo. Just upload the said sql file overwriting the one in the sql folder and then create your UK company. Let your default company be created with the en_US-new.sql and your actual company be created with the new UK sql file.

When entering your items, just choose Tax Exempt for now. When you get to qualify for VAT, then change the settings to Tax in the items. All the old invoices will remain in their Non Tax state.

74

(10 replies, posted in Reporting)

Thanks a lot Ap.Muthu,

But honestly speaking that is a bouncer as I a illiterate in terms of .Mo and .PO and compiling the files. But would be keen to understand or learn if this is documented somewhere as I'd definitely want a smooth upgrade process and not get stuck after having implemented the system.

Thanks
GJ

75

(10 replies, posted in Reporting)

Ap.Muthu and bogeyman,


Thanks a lot for wonderful help. After manipulating the code below in doctext.inc, I've managed to get desired and much required result of changing the title to commercial invoice and Com Inv No."


            $this->title = ($packing_slip==1 ? _("PACKING SLIP") : _("COMMERCIAL INVOICE"));
            $this->formData['document_name'] = _("Com Inv No.");

I've just changed the above code in doctext.inc and have not done any changes to rep110.php file.

But wanted to confirm one more thing.

As Ap.Muthu has suggested, as I am only ever going to use English language, should I hard code the changes within docttext.in file ? Or should I leave it as above for now ?

Also, do I need to make changes to rep110.php file or leave it as it is?

And finally, would any of these changes upset anything else, apart from translation issue, which I don't think I'll need ?

Sorry for queries and thanks a lot once again.

Regards,
GJ