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
If you mean a company that is your own, then you set the currency in the Setup tab, Company Setup. If the currency is not here, you must set up the currency in Banking and General Ledger, Maintenance.
If you mean a customer / supplier, you do that in respective tab, Maintenance.
/Joe
We have established a new bugtracking system, Mantis, at http://mantis.frontaccounting.com. Please use it for reporting bugs to us.
You will have to register first, but we get a much better overview over all the bugs this way.
/Joe
Hello,
Create a new company and use the en_US-new.sql script for the new company. This is a stripped down sql script that is suitable for a new company.
/Joe
Good Idea, Yes it will be done asap and included in RC2 that are shipping shortly.
I guess the customer's ref will be available then in all the sales documents.
I understand that you write f.i. PO 4, where 4 is the PO number, in the Customer's Ref. field. And this way it will come on all sales documents.
/Joe
Hello sushil,
There seems to have been some interruptions when updating your companies.
There are two alter sql files, alter.sql and alter2.sql. The problems with the update_db.php is, when running it again it will bail out on a company where something has been altered before.
Therefore the latest changes are at the top.
Try to do all the sql statements one by one from the alter sql files on your client. Start at the bottom and go upwards. In case it bails out, this statement has already been executed before. No harm is done.
Hopefully you are up and running soon.
/Joe
Hello,
Yes there is. In the /reporting/includes folder, there is a file called header2.inc. This file is included when the documents are printed out. You can design your own document here, and use the texts in doc_text.inc and doc_tect2.inc (domestic and foreign texts).
Please make a backup of header2.inc before trying. So you can restore if everything go bananas 
/Joe
BTW. If there are many texts that need a special translation, you can also create a new en_AU.po file from the empty PO file. There you can change the translating only where you need it.
You caught a bug Alvin. Bug in ui_lists.inc (tax_types_list). CVS unstable updated again. Please grab another one.
/Joe
Ok Alvin,
You have convinced me and we have changed it in the CVS repository for unstable at Sourceforge.
With these changes:
Customer Branch Sales Account now overrides the Item Sales Accounts if there is a Sales Account set in the Customer Branch. Default is now the choice 'Use Item Sales Accounts'.
I guess this will help you and others to a wider analysing of the reportings.
/Joe
Hello Alvin, regarding the cash sale, we have made a change so that if you have set the Customer Branch AR Account to a Bank Account (Cash is included here too), the Direct Invoice or Credit Note will be allocated immediately when placing.
Tips:
Set up a Customer and call him f.i. Cash Invoice. Payment Terms: Cash Only. And a branch with a suitable name. Select the Cash Account as the AR Account.
When placing the Invoice/Credit Note you can use the Deliver to and Address field below to name your customer. You can eventurlly use the Comments field to write further info on the invoice. Both these infos will be seen when you see the Invoice on the Screen and on Printing.
Theese changes are in the CVS repository unstable at Sourceforge.
/Joe
You are right. This is Ajaxified by Janusz. I hope he sees this asap.
/Joe
Well, Rasmus, this is Ajaxified by Janusz. I hope he will give his comment on that.
/Joe
Yes, you can use a cash account instead of the normal AR account. I commented on that in your POS topic. The Customer Allocation Inquiry would not get right unless you make a deposit with allocations (which can be done daily, weekly or so), but the GL is ok. You can probably live with that.
The GL AR account in customer branches doesn't override the GL AR account in Items. There is no such account in Items. You only change the GL AR account from the normal debtor account to the cash account.
/Joe
Hello Alvin,
Yes I have some Java experience, but unfortunately my resources are sparse.
I have my daily consulting business to get something to eat 
. Maybe Janusz can look at it. Hopefully he is reading this post asap.
/Joe
Again, you should start with the empty en_US-new.sql file or some of the other charts from the download section. This is because that you must be sure to get the correct connections between tables. Then you can start modifying it. Take away unneeded data. You will always get a warning if you try to remove related stuff. Enter stuff you want to be here, and finally make a backup and download the file. If you export from a company that have other prefix than 0_, f.i. 1_, you should use an editor and make a search for 1_ and replace it with 0_. All new scripts must have this prefix. They will eventually be replaced internally when creating a new company with your new script.
There is no automatic way of doing this, but you will learn by doing.
/Joe
Hello again,
I've just checked in an Inventory Sales Report to the CVS repository for unstable.
If you don't use cvs, you can browse to https:/sourceforge,net/projects/frontaccounting and select Code and browse CVS. First look in the CHANGELOG.txt (for unstable) and see which files to download from here.
I hope this satisfies your request.
/Joe
I don't see the need for all these accounts on a Customer Branch. The Tax Account is based on the Tax Id, which is part of a Tax Group. The Inventory, Adjustment accounts are stock related.
But I can see a new report, based on the table stock_moves. It could create a report for you that keeps track of locations (it could also calculate the contribution). It could be for a period, per locations, per item. Detailed or Summaries.
/Joe
You can set the AR account in the Customers Branch to a cash account instead of the AR account. But you shouldn't do allocations on it. But this is an ackward solution. You end up with wrong customer balances.
It will work, however, if you use the normal AR Account, and immediately afterwards make a deposit (or daily), and allocate the deposit for the invoice(s).
Joe
You point out something here. We will have an internal discussion about this. Could you probably use a dimension for a Location to keep track of it?
/Joe
There are links to 0_gl_trans from Customer Transactions, Supplier Transactions, Item adjustments etc. You will not be able to follow these links if you delete the GL trans.
You can see in the ER Diagram which tables are related. It can be found on the download document page.
/Joe
Hello again,
The account for the product over-writes the branch account for sales.
/Joe
We will have a closer look into this.
Strange with the Date Picker. We haven't heard of problems here before.
Which release are you running?
/Joe
Hello,
It turned out to be difficult to move this item, but ti doesn't matter. Most visitors are looking in most forums, after all.
I don't think it will be that much work to write such a module. The only problem I see is, that we do not have the resources internally to do this. Maybe there are some skilled developers out there that are interested. Hopefully.
/Joe
Hello Alvin,
We have been involved in developing Accounting Systems for a long while, both for small companies as well as medium scaled companies. We have used both approaches. With both buy rates and sell rates and with only one rate. When you end up in your accounting you get some currency exchange costs and income, but overall your accounting shows you the outcome of your company. We really don't think it is a big deal to keep it so detailled.
We don't show the currency symbol, because we don't know if this field is available, but we show the ISO abbreviation (USD, GTQ). in the documents as we also shows which currency that are presenting in the inquiries.
Joe
Yes, you are right regarding the accounts, we will look at this during the RC period.
Rasmus, the search boxes in the BP selections are only used if you check the 'no_customer_list' or 'no_supplier_list' in the company setup. It's there if you have more than, let's say 100 BP's. Then you have the option to enable the search boxes.
Otherwise it works just like a normal listbox.
Hopefully we can publish the RC1 tomorrow. We have had some work to fix the Ajax stuff.
/Joe
Yes, we are currently fixing some late bugs. So the RC1 is postponed a while when fixing this.
/Joe
FrontAccounting forum → Posts by joe
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.