3,476

(3 replies, posted in Banking and General Ledger)

What do you mean in T format. Do you mean debit/credit side?

/Joe

You can use Quick Entries in Supplier Invoice for the GL Item llines. Have a look in the .

/Joe

It is sorted by group number (alphanumeric in 2.3).

/Joe

3,479

(4 replies, posted in Setup)

First of all, when creating Tax Types you should set correct GL Accounts for Sales and Purchase. You have set the purchase and sales accounts. This is not right. You should set Sales Tax Gl account somewhere in the liability section and a purchase Tax account either the same or one in the assets section. You can use the same account for both Sales Tax and Purchase Tax.
Secondly you should create the Tax Groups. One that includes both the 4% and 1% and one which includes only the 12.6%.
In the Item Tax types you create some types with or without the tax types.

I wonder which release you are running. We have made some improvements in 2.3 RC3, regarding supplier invoices.

/Joe

3,480

(14 replies, posted in Setup)

Hello.
Ok.
The Retained earnings account accumulates every years profit/losses. The Profit/Loss Year takes the years profit/Loss and put it here.
Let us say you have a profit during the year of $1000.
When you close the year the $1000 i credited the Retained earnings and the $1000 is debited the Profit/Loss Year. This is done automatically during closing by the last day of the fiscal year.
This is a common way of closing a fiscal year.
Also this way you can take profit/Loss statements for dimension during several years, because you still have the transaction values for Expense/Profit intact for the closed year.

/Joe

3,481

(14 replies, posted in Setup)

Hello Gaston.
If you havent done it, then create an Account for Profit and Loss Year somewhere last in the Expense group accounts.
Select this default account in the System and General GL Setup for the Profit/Loss Year. Also ensure that you have selected a correct account for the Retained Earnings. Then Update the info.
Now, make a backup of the company, so you can restore if anything goes wrong.
Go into Fiscal Years and close the year.
You should now have successfully closed the fiscal year.

/Joe
BTW. Read more about this in the fawiki.

3,482

(14 replies, posted in Setup)

Are you sure that this information in System and General GL Setup is saved ok? It might just show the first account in the account list without have been saved.

The error message just indicate that.

/Joe

Tax should never be included in standard cost. This Tax is refunded to you later from the Tax Authority. Shipping is not included in the standard cost. It is difficult to differentiate this cost over several items and quantities.
But you can create a service Item, called shipping and keep track of the shipping this way. Or you can use the GL Item lines below to manually enter the Shipping cost.

/Joe

You can purchase and sell service items. You select this option when creating Items. Service items do not involve the inventory stock.
When you purchase service like phone bills you can also use the GL Items below in the Supplier Invoice field.

/Joe

3,485

(4 replies, posted in Setup)

Please look for information regarding this in the  .

/Joe

Yes, that was needed in release 2.2.X. There is another approach in release 2.3.

/Joe

3,487

(14 replies, posted in Setup)

In System and GL Setup, Setup tab, you should choose a Retained Earnings Account and a Profit and Loss Year Account. You should create such an account last in your expense accounts. After closing the fiscal year, this account will hold the fiscal year profit.

You are right, you encountered a bug.
The problem has been fixed in release 2.3 final. If you want to fix it in 2.2.11, you can download the new file from 2.3 RC3 here and copy from line 193 and forwards until the commented out text (about line 235). Finally comment the same lines as in this new file.



You CANNOT replace your file with this one entirely.

/Joe

You can always email a scanned Photo copy to your customer. This can not be included in the sales documents.

If you want to include this in the sales invoice (/reporting/rep107.php) or any other document, have a look into the report, price list in sales tab (/reporting/rep104.php). Here you can see the algorithms for printing the item photos. They are starting with the if($pictures). Maybe you can include this into the sales document. Good luck!

/Joe

3,490

(2 replies, posted in Items and Inventory)

In tab Purchasing, Supplier Invoice, you will see the received items from the supplier. You can remove the lines that you don't want. You will have to be logged in as admin to do that.

/Joe

Yes, of course it is possible and very much appreciated. There have been some attempts to do this over the years, but nothing has happened.
Look at some of the extensions about how to do it. Also please do this for release 2.3, that are about to ship in final in december. The RC3 is the current release of 2.3 and should be used as the core FA.
And finally please share the final result with us. Thank you.

/Joe

3,492

(12 replies, posted in Accounts Receivable)

You can just send your edited files to contributions (email in the Announcement Forum). Please add your own comments.

3,493

(15 replies, posted in Setup)

Please have a look in  about setting up FA.

/Joe

3,494

(2 replies, posted in Banking and General Ledger)

Janusz has fixed the items on Mantis. He will update it in a while. He is very busy with other related FA stuff, so please be patient.

/Joe

You can use either application to create/update customers. Just remember that in FA you must also create at least one branch. You can look into the module Import Customers for this.
If you call it from TikiWiki you must connect to the FA company database and do the updates/creation, and vice versa if you do it from FA.

Another way would be to create a module extension in FA to sync the two customer tables. Look into the Import Customers about how to make a module extension.

/Joe

It is called Install / Update Extensions from 2.2.

GD is a Graphics Library. It is used inside Business Graphics. You can check your php installation with the php routine phpinfo() and see if, and which version, you have. You can use FA without the Business Graphics.

/Joe

The avg. standard_cost is stamped into the stock_moves table when delivering the items (either during delivery or direct invoice). This stamp is based on the average material cost on the delivery day for the item. So this value will also be the value that is stamped into the GL transactions when creating the delivery (direct invoice).
So with the changes done now, we should always ensure the correct values in both GL and Inventory Sales Report for the same period.

/Joe

3,498

(3 replies, posted in Setup)

Upgrading from 2.3RC2 to 2.3RC3 and 2.3 Final is just a matter of copying files unto your server. There are never database changes between minor releases.

/Joe

3,499

(3 replies, posted in Setup)

It is never easy to move from one accounting system to another. Some of the modules on the Download - Modules may help you import customer/supplier and items.
You should also consider using a newer release, as 2.2.11. And we are shortly releasing the 2.3 final.

/Joe

3,500

(1 replies, posted in Banking and General Ledger)

There is a Report, Audit Trail.

/Joe