Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 193 of 200)
Topics by joe User defined search
Posts found: 4,801 to 4,825 of 4,990
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
Hello Rob,
You could also just enter the budgets for the first month in very 4:th month. F.i. January 20000, May 15000, September 25000 (= total year 60000).
If you use the same periods in the P/L you get it right!
/Joe
Please do a new cvs update. This was fixed about 11 hours ago.
/Joe
Hello Bibi,
It should be sufficient to save the language in the User Setup (Display Setup is only running during the session and nothing is saved to the database).
Then logout and login again. This way the language should change.
What language are you translating to?
/Joe
Hello Rob,
We are about testing the version 2.0. We still have some items to fix, but stay tuned. It will be released as soon as we got these items fixed.
We do not have plans to change the DB further. If so, it will be found in a alter2.sql file. These alter files can be run by a utility, called update_db.php in the root folder.
/Joe
Hello Héctor,
Yes, please send me the files as an attachment. I will then prepare them for download. When the 2.0 Beta is finally released I will also put the downloads on the Website download page.
/Joe
Hi Héctor,
For FA 2.0 Beta you should use the one that is at the download section at https:/sourceforge.net/projects/frontaccounting. It is located under frontaccounting-languages. You have to expand the versions.
The MO file is automatically created when you save the project to PO file in poEdit.
This es_MX2 that is on sourceforge is based on version 1.16 but all the new strings are extracted, ready to translate.
I am not aware of anybody translating to Mexican at present.
/Joe
I've seen this error before, but can't recall what the problem is. Why do you have to change this? It is normally only needed when running Windows IIS. Maybe someonw out there can help us. I don't have the time to investigate this at present.
/Joe
Well, I guess this is a special size of paper, that is not supported by our PDF routines. It would require an add-on module, I guess. Maybe some other has a comment on this.
Joe
Hello,
In comfig.php there is a variable, $go_debug. Set this to 1, this will eventually show you what the problem is. Otherwise, look in the apache_error.log. Here you also can get some additional hints of what is wrong.
/Joe
At first I thought that you had the $go_debug flag set to 1 in config.php, but you say when running in English you have no problems. I am not that good at farsi, can anybody with this experience please help.
/Joe
Hello alvin,
There is a file in the sql folder called alter.sql. At the top it should contain 2 ALTER TABLE statements, the first one is the company table, the other one is the sales_types table. You can run the script update_db.php which is in the root folder, and select this alter.sql file from your local computer. It will bail out after the 2 alter tables, which means that the rest already have been run. This is done for all your companies.
Best regards
Joe
Posts found: 4,801 to 4,825 of 4,990
