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 172 of 200)
Topics by joe User defined search
Posts found: 4,276 to 4,300 of 4,985
To get MYR as the default currency on the company, you can set this currency on the company in Company Setup. You may need to first create this currency. If you want to change some customer/supplier to use MYR you can change that on the customer/supplier. If you have many you can do this in phpMyAdmin by using an UPDATE statement on all customers and suppliers.
When you get a message that says that the currency rate cannot be retrieved from the ECB you can do as the message says. Enter an exrate yourself. You don't have to do this every day. Probably once a week. FA will always use the nearest value.
The routine will try to get the best value, but will always fall back to your last entered value.
/Joe
Please send me the .po file and I will extract the strings for 2.1.3 and return it back to you.
You can find my email in the user list.
/Joe
If the customer has payment terms 'Cash Only' it will show Cash Payment otherwise it will show Delayed Payment. You can override this above.
/Joe
Oh yes it is. Please follw the intall instructions.
/joe
I know you Tom, after having had some mailing correspondance with you over some time. You want everything to be at your fingertips, right? 
So please copy the link yourself from another script. 
/Joe
If you use an SQL script to create a new company, the prefix 0_ will be changed to the one used for the created company. But this is only for the script files having table prefix 0_ . If you look in the file en_US-new.sql (in the sql folder) you will see the prefix 0_ . This file can be used to create all companies you want.
So if the prefixes in the file is 0_ everything is ok.
/Joe
Assuming you only have one company, the company with prefix 0_. Make a backup of this company and download this file.
Now create a new company. Make sure it gets table prefix 1_. Use your newly downloaded file as the SQL script file when creating the new company.
And now everything should be ok.
/Joe
No you are doing it right. I forgot that you were importing from osCommerce.
But as this is quite ackwards to make a payment directly to delayed invoice, I think you should make a change for yourself to satisfy this.
/Joe
The version stamp is in config.php. You have probably not updated this file. You can write the version in the file $variable, $version='2.1.3';
/Joe
Isn't it rare to do a payment immediate after creating a delayed invoice. If you want to pay at once you should use the cash invoice option.
/Joe
You should NOT do a software upgrade, when upgrading from 2.1.2 to 2.1.3. Only back your config_db.php file and other data files you have changed.
Please always follow the instructions in update.html when upgrading.
The only thing you should do, as pointed out in update.html, is to change the account classes class type in bank and general ledger tab.
/Joe
yes, but this is one effective way of doing it. Probably the best one. This repost gives you all the data to see what is going on.
You can actually copy this report into the 2.1.3 system by looking at the reports_main.php and copy the file rep305.php into the 2.1.3 system.
/Joe
Such a report is now available for 2.2 unstable and is called GRN valuation Report and it placed in Item and Inventory reports-
/Joe
I could prepare a report for 2.2. Something like this:
GRN Report
Period mmddyyyy - mmddyyyy.
A GRN Report with item lines
item - PO no - Qty Received - unit price - actual price - total.
Subtotal per item and grand total.
Eventually filtered by category.
Such a report will give you the actual prices for every received item during a period.
/Joe
It should now work in 2.1.3. Please read the sticky instructions in Items and Inventory Forum, Purchase Pricing, on how to use it.
/Joe
Well, I know that the missing sync can be the various bugs we have had in this complex system. With all the possibilities to change prices, voiding posts and so on.
I also know that the last bug is probably not found here yet, but nevertheless we are doing our best.
I am not sure this would help, while all the GL postings are based on the average material costs.
The actual prices are saved on the PO item lines, so it would probably be possible to make such a report based on these lines. This would be an topic for the 2.2 release. Unless you are writing a specific module for this
/Joe
The 2.1.3 is ready for download now at Sourceforge.net. There is a link on the download page.
You can just make a new installation.
/Joe
You are lucky. We have just released 2.1.3 with this option as default. Follow the instructions in update.html before updating, and after updating you should fix the new classes as stated in update.html (update from 2.1.X to 2.1.3).
/Joe
This is even better
/Joe
You are a clever guy, Tom, I know. You would probably fix a script asap to change these accounts, right?
/Joe
We are planning to have an automatic price calculator based on a percent contribution. I cannot promiss when we are implementing this, maybe in 2.2 that are coming later this year.
In your case the factor would be 0% or something like that.
/Joe
BTW you can always 'hardcode' this, I guess it is in the file /sales/includes/ui/sales_orders_ui.inc. The default price is calculated somewhere here.
This is, however, not recommended, because when we ship new sub-releases it will override your changes.
The changes to the documents can be made in /reporting/includes/header2.inc. The domestic texts and international text are found in doctext.inc and doctext2.inc.
/Joe
An alternative would be to create a dimension for each item and associate this dimension with the item. And then make Budget Entries for these dimensions. Then you can select adequate reports from the GL section.
Well, maybe it doesn't work. But the target field is some kind of budgetting, right?
You could take a look at the report, Inventory Planning Report. Maybe you can get some ideas from this.
If you come up with something smart, please share it with us.
/Joe
The payment terms are belonging to the customer/supplier and the due date field is calculated from this. But you can always override the due date in the documents.
/Joe
Hello,
Try to look in the Banking and General Ledger tab, just below Journal Entries. You can also make budget on dimensions.
/Joe
Posts found: 4,276 to 4,300 of 4,985
