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
Tu, you have paid (in advance) for the inventory and you have an invoice date at a later time. Even if this is a backward operation, FA handles it correctly. It is always the payment date that creates the variances, so in these cases you should wait with the closure of the fisscal year until these operations are gone. It is just that you can't calculate the variances before you have the supplier invoice.
So in my opinion everything is handled correctly.
/Joe
When the PO is received (GRN), the stock is updated with stock purchase prices. When the supplier invoice is received the prices are regulated and the JE entry is made into stock and AP. When the delivery is done the stock is credited and purchase is debited. If there are deliveries during the time between GRN and supplier invoice and there are differences in price, the delivery JE are adjusted. Every detail is taken care of, even currency variances.
So while you have traffice over two fiscal years, you should wait with the closing of the former year until done.
/Joe
Hello,
It comes from the language po file in /lang/xx_YY/LC_MESSAGES/xx_YY.po.
This language file has it's text extracted from the source code.
The language en_GB should be default, and fi the en_US.po have som texts translated, but the texts in the source might have a bad translation, because it is called VAT in Britain, right?
/Joe
The bug is now fixed and the CVS repository is updated. Affected files:
/gl/includes/ui/gl_bank_ui.inc
/gl/includes/ui/gl_journal_ui.inc
/includes/ui/items_cart.inc
Thanks for finding this bug.
/Joe
No, you detected a bug in 2.1.0RC. We will look into it.
/Joe
Not a bad ides. Would be a 2.2 issue.
/Jow
FA is a fully automatic system. The Journal Entries are created automatically. So you should not worry about that. Just make sure that your setup is done correctly.
/Joe
There will be no database change during the 2.1.X releases. Only bugfixes.
/Joe
Hello again,
Now this is fixed. The CVS repository is updated. Only one file affected. /gl/includes/db/gl_db_banking.inc
Thanks again MozMan
/Joe
Oops!
Thank you so much for finding this bug. We did some change in the Bank Account and transaction tables to release 2.1.0, and this bug slipped through.
I will be back when the CVS repository is updated.
/Joe
In release 1.16 you will have to set the user item decimals in the display setup in Setup tab. This will be for all units.
/Joe
There is already a table, X_purch_data, in the database. This table contains all the information regarding the suppliers data, so this should be very simple to implement. Today these entries are updated every time GRNs and Supplier Invoices are entered.
In the beginning, however, the items have to inserted in some way with the whole list of items. But with a flag in setup, you might be able to select that you only want the supplier's items.
So, yes, this is a candidate for 2.2.
Hi,
It is quite easy. Go into tab Items and Inventory. Select Units of Measure. Change the decimals to 1 for the item unit you are using on the item. That's it.
/Joe
Are you referring to release 2.0.X or 2.1.0 beta 2?
You can enter up to 20 characters in the stock id field, so this should be ok. I guess others have used this approach too.
I cannot tell you why nothing shows up. Haven't heard of any problems here.
You can temporary set the $go_debug flag in config.php to 1 to try to catch some errors or warnings.
/Joe
Hello,
This is the type relating to systypes. You can see the types in file /includes/types.inc
/Joe
Hello and thanks.
The trans_no is an auto_incremented value for the debtor_trans table. This auto_incremental value, that should get you the next number, is probably set wrong in the table.
You can fix that in phpMyAdmin.
If you by trans_no = 5 mean, that the next reference number is 5, then you can move the next reference number in Setup tab, form setup.
Personly, I don't like the PEAR approach. I have been looking at a SF project called Excel Writer (XML) for PHP.
This is was they claim:
Set of classes for PHP that allow Excel XML files to be generated dynamically. Nearly a full implementation of the MS XML architecture. Requires PHP 5+ Does not require any XML libraries
It is very small and elegant. It is written in PHP 5.0 but as it is very small it is easy to fix so it runs in both 4 and 5.
It creates XML files, which of course is a good thing, especially for the XBRML standard. A standard for Accounting applications. This implementation is also for the future.
And it is easy to later create a class like pdf_report.inc, where similar routines are created. Then we only have to switch to the right include pdf_report or excel_report.
This is what I think we should do.
I will do some further research on this one. Please have a look and comment on this.
/Joe
To create new companies and languages you must be superadmin. A superadmin is the admin of the first company you created, f.i. Training Co. So you must login on this company as admin to do the operation.
/Joe
Sorry henry,
Wrong name for the table. It should be X_stock_moves, where X_ is the table prefix. If this is your only company, then it could be 0_stock_moves.
/Joe
Hello Pete,
Please use joe (dot) hunt (dot) consulting (at) gmail (dot) com. Sorry, I am a little afraid of email harvesting.
Regards
Joe
Thanks Tim,
I was just about to write something similar, but have asked my partner, Janusz, to do it instead. I had the same feeling as you have. Yes, I have the feeling too, that we both push forward the cause of open source. Nice to hear that we are on the same wavelength. I also think that the clients should examine the projects extensively before planning to do something dramatic.
/Joe
OK, but I think the way it is implemented is more correctly. You are selling the same items / services to a bunch of people. It is up to you to place the correct sales groups on the branches and check that the correct sales types are used or accept the differencies.
/Joe
You can only create new companies when you are logged in as Administrator on the first company you created (super admin).
When you create a new company, you enter the Company name, the database details, choose a script (chart of accounts etc) from sql folder, and in the last text box you enter the password for the admin user (as it says). This admin user is created automatically.
You can later create other users for the company.
/Joe
The database functions for MySQL is wrapped in the files /includes/db/connect_db.inc and /includes/db/sql_functions.inc (transactions), so there should be no hard-coded mysql-functions.
But we cannot guarantee that all SQL sentenses will work in either PostgreSQL or Oracle. And we do not maintain any support on this topic.
/Joe
Thanks, yes the prices cannot be taken from the template due to that the customers can be of different sales types /currencies.
The amount from the template is merely to help idenfying the template. I will add that there must be a price set for the items in the sales prices.
/Joe
FrontAccounting forum → Posts by joe
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.