Yes, you are right.
/Joe
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by joe
Yes, you are right.
/Joe
Hello,
The Sales tax should be in a liability group and the Purchase tax could be in the Assets group, but is mostly placed in the liability group to keep these tax accounts together.
The taxes has nothing to do with your profit and loss report. There should be nothing about taxes here.
You owe to the tax authorities The sales tax, and you have an outstanding from the tax authorities for the Purchase tax.
You will see the sales tax and purchase tax when you run a Balance Sheet.
/Joe
You set the tax included/excluded in the Sales Types in Sales tab.
First you create your tax types, then the tax groups and the item tax types.
And finally you decide how the tax should be handled in the Sales Types.
These Sales Types is set on the Customer. The tax groups is set on the branches.
I hope this info cleaed it a bit.
/Joe
BTW, we have several advanced users from Canada.
You can use the 4030 Shipping and Handling for this. You should then set this account as the Sales account on the service item for Wire Fee.
The COGS account is only used by the delivering. When delivering the Inventory (for stock items) the Inventory is credited and the COGS account is debited, but this is only for stock items. Service items do not create any GL transactions during delivery.
When you are registering the customer payment you can enter the wire fee (together with other fees) under Bank Charges. These fees are debited the 5690 Interest and Bank fees and credited the bank account you are using.
I hope this make the procedure clear
/Joe
Yes, kerrsmith,
You are on your way to be a pro Accountant . Yes, just debit the old account and credit the new account with the value 11.50. And maybe make a memo about it.
Well, Khaled. We have just implemented a selector for either decimals (user setup for decimals) or rounded values).
Maybe we in the future could change the selector to show with user_price_dec(), rounded, hundreds and thousands, but with these values we need to put that information on the report.
I guess we are talking Balance Sheet and P/L Statements here, right?
Regarding A3, isn't this quite rare? Not many use these sophisticated printers. Maybe you should consider creating a report like the one that is downloadable from the Download section. This report uses Landscape and can hold much more information. Just a thought.
Maybe you can put this on the Wishlist on the Wiki, Khaled.
/Joe
You are charging the customer for a fee, so it should be in the income section. However there is already an expense account for Bank Charge but this is merely for your own costs. So my advise is to create this in the income section.
Please check if you should charge tax on this wire amount. If not you should mark this with the correct item tax type. The item should be as a service.
If you have this cost yourself, then you should enter the fee in the bank charge field. The item code from the invoice line will only handle the sales (sales tax, charged bank fees and so). So you will most likely enter this cost when you do customer payment.
/Joe
You are right, it should be an income account (you charge your customer for this amount). I have created a new account, called 4910 Shipping. And put this on GL Setup for Freight.
The changes are uploaded to Website.
So please make this change locally. Thanks
/Joe
Hello again,
Regarding the Retained Earnings account I see that there is a SHARE CAPITAL group. I didn't realize that there was such a group. There is also an account, called 3200 Profit and Loss. This account belongs to SHARE CAPITAL group. We will rename 3200 to Retained Earnings (instead of Profit and Loss).
So please select this account 3200 for the Retained Earnings in GL Setup and rename it in the GL Accounts. You may also delete the other setup Retained earnings you did before.
I will do the fix in the COA.
/Joe
Thanks,
I will make the changes and upload a new COA for en_GB-general.
/Joe
A pity you didn't know this. It is not the dimension id that is shown in front of the dimension, but the reference number. If you don't change that during creation, it will use a numeric serie, identical with the internal id.
So when you created the dimension, you could have put MJ125 in the first reference field. You can freely overwrite this reference nr, but it has to be unique inside the dimensions.
You could, without any side-effect, use phpMyAdmin to change your dimension references in the reference field. Then you could probably give them a more relevant name too.
After this you will have the list sorted by reference numbers and name.
/Joe
This feature, multiple items of same item id, is implemented in release 2.3. You can use the memo field for extra info. This info is printed on the PO/SO/INV after the lines.
In the Sales docuemnts you can click a line down, and add/change extra info to the description.
/Joe
The sentense you changed has been commented out in the code and gone into a later algorithm, where you can see how the average cost is calculated and also the adjustment when it arrives.
Well, it should work now, but you know, maybe it is safe to wait. I have tested it rigorously, but the developer should maybe not be the main tester.
If you do not enter a temporary Standard Cost for your 0 stock new items, you will not get any COGS values in the GL untill you get a PO or Item Adjustment, because there are no Standard Cost values to fetch. It is, however, corrected in the long run.
/Joe
Hi again,
The CURRENT LIABILITIES should be of class type Liabilities.
The Retained Earnings should belong to LONG TERM LIABILITIES if there is no EQUITY group. However, you don't need this EQUITY group.
/Joe
The two first accounts is used by Fiscal Year closure. There should be a relevant account in the Liability/Equity section you can choose for Retained Earnings. If you can't find a suitable account for Profit/Loss Year, then create one. It should be the last one in the Expense groups.
There should also be an expense account for Bank Charges. If not, then create one in the Expense groups.
/Joe
We have just fixed it and the CVS Main trunk is updated.
We can not use the proposed approach from the Company Setup, because we don't know if it is filled correctly.
What we do, is almost the same way as they do in Oracle and QuickBooks.
If there is an Average Standard Cost before the stock goes below 0, this is used until we get some better values from PO or Item Adjustments. Then the GL Inventory/COGS are updated in the background.
If you have new items and you want a start value for Standard Cost, then you can set in in Item and Inventory tab, Standard Costs.
You can enter an initial Standard Cost even if there are no stocks there yet.
This has the advance for new items that you get a better estimate for COGS and these values will later be corrected when POs or Item Adjustments are done.
/Joe
Go into Setup tab, Sales Points. Edit the Default Sales Point and update it again. There are some missing setting in the GB COA. This should help.
/Joe
The average material cost is a common way of handling the producs. Other methods are LIFO and FIFO, where LIFO is last in first out and FIFO is first in first out.
Both Oracle and quickBooks are using the Average Material Costs. And we have been looking at how they handle the 'Allow Negative Stock'. There is a possibility to continue with the Average Material Costs during the negative period of stock, but this value is not correct. But when the stock again passes positive values, either with PO or Item adjustments, all the deliveries done during this period will have to be adjusted for correct values.
We will fix it in this way, but it will take a while.
/Joe
In the GL Inventory, it is not possible to have a negative inventory stock value. This is physical impossible. Just like you cannot have a negative cash. Therefore when the stock is going negative the average material cost is going to be set to 0. First when the value is going into a positive value again, the average material cost is growing again.
When you later buy the stock that is missing, the values will not increase the GL stock inventory before the stock item value is over 0.
You must be avare of that. If you operate with this flag set, you should always check the values when the stock is positive again and make adjustments in the GL.
/Joe
Try emptying the browser cache.
/Joe
Please write enable your /company/1/ and sub-folders.
/Joe
Just remove as much of the transactions that you can see, and I will clean the rest and prepare it for a new COA. Just remember to keep the hart_master, chart_types and chart_classes and the standard accounts on the company.
/Joe
You can just send the sql dump as an attachment. They are not that big. Or you can zip it.
If there are more companies in the file, I will pick the one with 1_ as table prefix.
If they have a 1_, in front of the tables (table prefix), I will change them to 0_. 0_ is the standard in the COAs. This prefix will be replaced when you the create company in FA. If you want such a file with 1_ or other values you must first make a search and replade (1_ should be replaced by 0_). But as told, I can do that for you and I can adjust the COA as much as possible.
/Joe
Hello again,
Remember first to make a backup of your company
You can send the sql dump to:
contributions@frontaccounting.com
/Joe
Hello Khaled,
The use of the font utily package is quite complex. When I started create some fonts, I did get some information on the TCPDF website, , on how to use it.
They also have some forums here.
I am afraid that this all I can help with.
/Joe
FrontAccounting forum → Posts by joe
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.