Strange, it works like a charm here. It did not work correctly before, just like you said, but with this new file everything is ok at my place.
Caching problem? Try to empty the browser cache.
/Joe
2,176 01/12/2013 09:09:56 am
Re: Report for items purchased (sorted/totaled by supplier) (32 replies, posted in Reporting)
2,177 01/12/2013 08:58:50 am
Re: Report for items purchased (sorted/totaled by supplier) (32 replies, posted in Reporting)
Hello Chris,
Please go back and download a new rep306.php1. Follow the instructions about rename and replace.
It should now be fixed. Good luck with the report.
/Joe
2,178 01/12/2013 07:51:48 am
Re: Setting up shipping paid on purchases (3 replies, posted in Items and Inventory)
When you create the shipping item, you must select Category 'Service' and Item type 'Service'. Then it should work. At least it worked in my environment.
If you forgot the Item type 'Service' you will have to use phpMyAdmin to change this directly in the DB. FA will not allow for changing (for scurity, but it should be ok to do this here).
/Joe
2,179 01/11/2013 09:19:11 pm
Re: View what you void (6 replies, posted in Wish List)
But you are still getting a warning before the voiding, right?
Joe
2,180 01/11/2013 02:13:26 pm
Re: Report for items purchased (sorted/totaled by supplier) (32 replies, posted in Reporting)
This report has now been incorporated in FA core. It has been sent to HG repository for default.
The three affected files are /reporting/rep306.php1, /reporting/reports_main.php1, and /reporting/includes/reports_classes.inc.
Rename rep306.php1 to rep306.php and reports_main.php1 to reports_main.php before uploading/replacing the files.
/Joe
2,181 01/11/2013 07:47:39 am
Re: View what you void (6 replies, posted in Wish List)
@chrison,
Which release of FA are you using. In the latest releases you can view the transaction by pressing the number link in the pager link.
/Joe
2,182 01/11/2013 07:40:48 am
Re: Report for items purchased (sorted/totaled by supplier) (32 replies, posted in Reporting)
This seems to be a good report, I will include it in core FA to next minor.
/Joe
2,183 01/09/2013 07:34:17 pm
Re: How to clear "current credit" in the direct invoice screen? (6 replies, posted in Accounts Receivable)
No, it is stored as positive.
Example customer payment:
Customer pays 100. Discount is 10.
debtor_trans table.
ov_amount 100
ov_discount 10
Gl posting:
Bank debit 100
AR. Credit. 110
Discount debit 10Joe
2,184 01/09/2013 06:48:26 pm
Re: No longer able to enter negative amounts after upgrade 2.2 -> 2.3 (3 replies, posted in Banking and General Ledger)
I recall that this was implemented to avoid mistakes when entering the right sign in using either bank payments /deposits.
But it was considered more safe when using quick entries.
Joe
2,185 01/09/2013 08:20:09 am
Re: Due Date is Before Invoice Date on Cash Only Direct Invoices (13 replies, posted in Accounts Receivable)
This is strange. I cannot reproduce this (only if the invoice date is before todays date, the due date is todays date, when payment type is cash).
Which release of FA are you using?
/Joe
2,186 01/09/2013 08:09:16 am
Re: How to clear "current credit" in the direct invoice screen? (6 replies, posted in Accounts Receivable)
@apmuthu
Yes it is correct. The ov_discount should be added in these cases. When the customer payments are done, they should include the ov_discount.
/Joe
2,187 01/08/2013 03:49:06 pm
Re: How to delete outstanding order (14 replies, posted in Accounts Receivable)
I guess there are so many algorithms interacting between the 3 stages, sales order, deliveries ans invoices, that trying to make further features is a candidate for more bugs.
So in my opinion we should stay where we are.
Joe
2,188 01/08/2013 03:41:27 pm
Re: How to clear "current credit" in the direct invoice screen? (6 replies, posted in Accounts Receivable)
@apmuthu
I am not in office at present. Please make a test on the training Co. Make a direct invoice on a customer with some discount percent.
Also try a payment with a discount. Look into the table 0_debtor_trans and see if it is negative or positive. I cannot recall right now.
Joe
2,189 01/08/2013 07:49:24 am
Re: Due Date is Before Invoice Date on Cash Only Direct Invoices (13 replies, posted in Accounts Receivable)
Please check that your Cash Only is not set to Prepayment type in Setup tab, Payment Terms. It should be set to cash.
/Joe
2,190 01/07/2013 11:23:54 pm
Re: How to clear "current credit" in the direct invoice screen? (6 replies, posted in Accounts Receivable)
Remember that the credit limit is not included in the information.
You can look at the function for duing this calculation in file /sales/includes/db/sales_order_db.inc, function
function get_customer_to_order($customer_id)
This is about line 457.
/Joe
2,191 01/07/2013 10:59:10 pm
Re: Invoice # Not Incrementing, No Customers in Direct Invoice Entry (2 replies, posted in Accounts Receivable)
1. You can increase the number reference counter for invoices in Setup tab, forms setup.
2. Check that you haven't checked the search customer/items list in Setup tab, company setup.
You can learn more about searching customer/items/suppliers here:
/Joe
2,192 01/07/2013 08:02:49 pm
Re: How to delete outstanding order (14 replies, posted in Accounts Receivable)
If you can edit the sales order in the inquiries, you should be able to Cancel the order.
Joe
2,193 01/07/2013 01:09:12 pm
Re: How do I record cash payments? (3 replies, posted in Banking and General Ledger)
You can always use the reference fields. You can setup these start numbers in Setup tab, forms setup.
You can also use a combination of characters and numbers.
Joe
2,194 01/06/2013 12:06:35 am
Re: Price for a Service (2 replies, posted in Items and Inventory)
You can setup the prices in Items and Inventory tab, Sales Pricing.
/Joe
2,195 01/05/2013 08:43:32 pm
Re: Multiple Units of Measure in Inventory (6 replies, posted in Items and Inventory)
You can use Manufacturing for this. Create some manufactured items in Items and Inventory tab. Select the new units. Select the original item in the Bill of Materials (BOM) for the new item in Manufacturing tab. Also select quantities of the original item.
Now you can create simple assemblies in Manufacturing tab.
Joe
2,196 01/05/2013 09:03:15 am
Re: BOM creation (11 replies, posted in Manufactoring)
No, but you can have just one bill of items (could be service item ) and then you can issue extra items if you use the advanced assemply.
/Joe
2,197 01/03/2013 03:00:03 pm
Re: Error on update of supplier (6 replies, posted in Accounts Payable)
Thanks, please download the file suppliers.php1. Rename it to suppliers.php and replace the file in /purchasing/manage/suppliers.php.
/Joe
2,198 01/03/2013 01:53:22 pm
Re: Error on update of supplier (6 replies, posted in Accounts Payable)
This was a strange behaviour. Have tried to reproduce, but the default field value of tax_included is 0.
Which version of FA are you using?
/Joe
2,199 01/03/2013 12:05:06 pm
Re: Error on update of supplier (6 replies, posted in Accounts Payable)
Certain newer versions of MySql doesn't accept empty values for numeric values.
Will be fixed to next minor.
/joe
2,200 01/03/2013 07:17:36 am
Re: Hard-coded problems in reports for translation (5 replies, posted in Reporting)
@erwindebruin
Will the work into be sufficient?
/Joe