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
Just hold it a bit, Chris. We try to keep all core reports in portrait mode. I understand that certain reports would benefit from being in landscape. You could probably just show the different lines, so other users can correct this for themselves if they need it.
Remember to make a backup of your own report, so you can restore it when updating to a new release.
Joe
Now Chris has final succeeded in printing this report.
A new /reporting/rep306.php1 can now be downloaded above.
Please download again, rename and replace.
The HG repository is updated.
Thanks to Chris for helping testing this.
/Joe
Inside FA, you can select Setup tab, Install / activate chart of accounts.
I am sure that there is at least one dutch COA.
/Joe
The two files, /reporting/rep306.php1 and /reporting/reports_main.php1 has been replaced above in the 3 files download.
Please download again, rename and replace.
Thanks for pointing out the problems.
HG reository for default updated.
/Joe
@chris
Remember that the items must be invoiced before they can be seen.
Also ensure that your invoice is inside the selected period.
Joe
@Chris
Regarding the Wiki, you must login before editing. You can use the same credentials as you use for this forum.
/Joe
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
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
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
But you are still getting a warning before the voiding, right?
Joe
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
@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
This seems to be a good report, I will include it in core FA to next minor.
/Joe
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
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
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
@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
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
@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
Please check that your Cash Only is not set to Prepayment type in Setup tab, Payment Terms. It should be set to cash.
/Joe
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
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
If you can edit the sales order in the inquiries, you should be able to Cancel the order.
Joe
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
You can setup the prices in Items and Inventory tab, Sales Pricing.
/Joe
FrontAccounting forum → Posts by joe
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.