3,926

(1 replies, posted in Wish List)

This algorithm is setup now to increase the first numeric field and not the last. You should swap the info to:
MYCOMP/000000/2010, then it will increase correctly.

/Joe

3,927

(7 replies, posted in Items and Inventory)

If the Location has an email address and if the variable $loc_notification = 1; in config..php and the stock goes below the re-order level, the Location will receive an email regarding this.

Otherwise this field is only for your information to purchase or manufacture new items.

/Joe

Test3 and Test4: I guess you mean GRN (not GRV). How did you succeed to invoice non received GRNs?

This mechanism GRN, Invoice, creditnotes, voiding the items etc. has been rigoriously tested two years ago. And it should work.

/Joe

Thanks Towhid,
Yes, this was a bug. But Sales Quotation shouldn't be calculated at all. Only Sales Orders.
CVS Main trunk updated. You can get the new file here:



/Joe

Another tips regarding the tax paying.
If you have a tax reporting period for January and print this tax report out in the beginning of February. You want to pay this in February.
Then you should consider using an extra liability account for accumulated tax.
Then you can empty the tax accounts per Jan 31 and counter book them on this accumulated tax account. Now you are not destroying the statistics for February when you are paying the tax. This entry will debit the accumulated tax and credit the bank account.

I will put these instructions on the Wiki.

/Joe

Thanks.
A)
1, 2 and 3 are info that are put on the various dimensions, workorders and deliveries. After these days the records are marked as overdue in the inquiries.
4. When using multiple deliveries for one invoice, the shipping cost could either be accumulated or only use a single freight cost.
5 and 6 are related to the underlying sales order. You can only deliver a certain percent more items than origin.

B)
1. These tags are going to be used as extra selectors in reports. This is not implemented yet. Only prepared. Will come during the 2.2.X releases or in release 2.3.

/Joe

3,932

(24 replies, posted in Accounts Payable)

For gl items, you should create Quick Entries for your various non items related entries. This is the best way of doing this.

/Joe

Hello Again Tom,
You are right tom. It didn't void the amount, because the type was set to Bank Payment. A safety-guard that Janusz did some while ago.
But this is not a big deal here.
IMPORTANT.
You must run the Tax Report before you make any payments from the tax accounts inside the tax period.
The trans_tax_details holds the tax information on the documents. But it is also used for the quick entries to make cash sales or payments for utility bills.
So when you pay tax and debit a tax account, the statistic in not available anymore, because the trans tax details are updated.
The next time you run the tax report is maybe one month (period) later and now the payment from last period is no longer picked up on the new tax report. After the tax report is run, and you have a hardcopy you can pay/receive your tax for that period.

I would prefer if you do the payment in the Bank Payment. Then if this payment is voided, the trans tax details are also voided.

/Joe

3,934

(24 replies, posted in Accounts Payable)

If you have setup your supplier and items with correct tax groups/item tax types and correct purchase account, there shouldn't be any problems getting the correct tax calculated automatically for you.

/Joe

Yes, voiding a JE also void trans tax details.
Adding a JE with tax account will also create a trans_tax_detail record.

/Joe

3,936

(4 replies, posted in Setup)

You can reset the admin password for a company by using phpMyAdmin. Enter the company database and find the correct table prefix f.i. 0_users.
Edit the user Admin. Paste the following md5 password, 5f4dcc3b5aa765d61d8327deb882cf99 , for 'password' into the password field.
You can now login as username: admin and password: password .
Please change this password this asap.

/Joe

Hello Tom.
Your first question. It seems correct what you did. Credit bank. Debit the Sales Tax accounts. And finally credit Prompt Payments (yes it is a revenue).

The Difference between Assets and Liabilities is the Net Profit for the year. Also the difference between revenue and expense is the Net Profit.
If the balance is positive (positive Net Profit is normal) you credit this value Retained Earnings. And you should debit an Account called Net Profit Year (I guess it is called). This should be done on the last day of last year.
FA does this automatically when you close a fiscal year, but you can also do it yourself.
But since you have had problems, it maybe better you do it yourself. Then you can better fine-tune it.

I hope this helps, Tom. You could eventually also talk to a local Accountant to get some advice regarding this.

/Joe

GP stands for Gross Profit. The difference between price and cost. and the percent is calculated as price - cost / price * 100.
Another word for this is Contribution Ratio,

This is on the Website for download now.

/Joe

Please see fawiki regarding this.



/Joe

3,941

(6 replies, posted in Accounts Receivable)

Do you mean something like the new Remittance document on the supplier side? A document called a RECEIPT instead?
You know we have the STATEMENTS also.

/Joe

Check that you have the credit sale marked in the POS Setting (setup tab) for the Location.

/Joe

I am not sure I follow you, Chaitanye. Do you mean that you have 200 bank/acsh accounts linked to a single GL cash a/c account?
Or?

/Joe

3,944

(2 replies, posted in Reporting)

It is only used for deliveries / packing slip. In other documents it might be redundant.

/Joe

Sorry, there was a mistake during an upload. Ok to download again.

/Joe

3,946

(1 replies, posted in Modules Add-on's)

Many of the CSV Import modules are for earlier releases. Try to pick one that is for release 2.2.X.

/Joe

I haven't tested the COA for South Africa myself. So I am not sure if the account types are correctly, but I hope they are.
I guess this is based on the infotechaccountants.com COA and this COA has been rigoriously tested by infotechaccountants.com.
You could try to download the en_US COA done by infotechaccountants.com and compare with you COA to see if there are differences in the Account Types and Accounts.

/Joe

3,948

(6 replies, posted in Installation)

I am sorry. The install instruction at  https://frontaccounting.com/punbb/viewtopic.php?id=4 is almost 3 years old and outdated. It has been deleted. Follow the instructions in install.html that is in the root directory after unpacking FA.

/Joe

These texts are printed from file /reporting/includes/header.inc and related text files doctext.inc and doctext2.inc.

/Joe

Which version of FA are you running?
Did the PL and Balance Sheet sort it correctly?
We have never tested this with more than 2 sub-group levels, so if you still feel there is a problem, then you could send us a SQL backup of your
client database (setup tab). You can send us to the email address that are shown under Annoncement Forum.
Of course we will handle your data on a need to know base.
We will then test your solution and see where the problem is.

/Joe