Take a look at:
https://frontaccounting.com/punbb/viewtopic.php?id=7455
You might find the solution there.
301 04/02/2020 03:53:33 am
Re: Import_transactions Error 404 (2 replies, posted in Modules Add-on's)
302 03/27/2020 03:14:27 am
Re: Tax Inquiry - Does not show output tax info (114 replies, posted in Reporting)
@seahawk,
I applied the changes to 2.4.8 and it works OK for me.
Of course the changes are not part of any 2.4.x distribution and need to be applied when one upgrades from one release to the other, I understand its going to be part of the 2.5 release.
303 03/18/2020 10:16:41 am
Re: Supplier Payment Report rep203 (3 replies, posted in Reporting)
Thanks @kvvaradha
It works..as attached.
304 03/18/2020 05:01:49 am
Topic: Supplier Payment Report rep203 (3 replies, posted in Reporting)
Supplier Payment Report rep203 has two things that seem not correct; (to me at least).
1. Transaction # is showing Supplier Reference Instead.
2. Not sorted by date.. (a more logical display of info)... its sorted by some internal choice I guess
How can one correct the above?
As attached.
305 03/13/2020 05:31:30 am
Re: Print Statements (rep_108) Date (3 replies, posted in Reporting)
Sorry @notrinos
I was looking at a different system when I posted the above.
adding
$rep->formData['document_date'] = date2sql(Today());did not help resolve the issue.
306 03/12/2020 07:02:18 am
Re: Print Statements (rep_108) Date (3 replies, posted in Reporting)
Thanks @notrinos
Your code addition works.
307 03/12/2020 06:14:49 am
Topic: Print Statements (rep_108) Date (3 replies, posted in Reporting)
The date on rep_108 always picks the server date (hosting server). I have specified the time zones in
.htaccess
config.php
/includes/date_functions.inc
all to be Asia/Dubai.. still rep_108 shows the system date and not the timezone date.
Attached screen shots.
Any suggestions on how to correct this to show the timezone date?
308 03/02/2020 03:10:46 pm
Re: suggestions on how to do recurring membership fees and payment types (5 replies, posted in Accounts Receivable)
https://frontaccounting.com/fawiki/index.php?n=Help.RecurrentInvoices
is helpful.
309 02/27/2020 05:03:40 pm
Re: Item Description Field Length FA2.4.8 (10 replies, posted in Items and Inventory)
Sorry Joe just answered..
310 02/27/2020 05:02:00 pm
Re: Item Description Field Length FA2.4.8 (10 replies, posted in Items and Inventory)
Yes apmuthu
Reversing the same line to what was in 2.4.7 does resolve the issue. But why it was changed as you asked?
echo sales_items_list($name, $selected_id, $all_option, $submit_on_change,
'', array('cells'=>true));311 02/27/2020 03:43:38 pm
Re: Item Description Field Length FA2.4.8 (10 replies, posted in Items and Inventory)
A very strange behavior as I was testing:
1. Existing DB field is preserved..ie an old invoice of 255 char..all char are displayed and can be saved as is.
2. Editing is allowed only on deleting the content (some or all) ... Once deleted one cant insert a substitute..even before saving.
I tested with 2.4.7 and its OK. Only 2.4.8 where I faced the problem.
Its easily reproducible. Both my 2.4.7 and 2.4.8 are vanilla.
My test DB is imported 2.4.4 live DB with no changes to the structure of 2.4.7 or .8 default COA empty or demo US db.
312 02/27/2020 10:05:14 am
Topic: Item Description Field Length FA2.4.8 (10 replies, posted in Items and Inventory)
Although this has been highlighted in other posts I thought it might need a different attention.
The editable Item Description in 2.4.4 is 255 char. The same field in 2.4.8 is reduced to 50 char.
Can someone please advise why the change?
I am unable to enter more than 50 char in either SQ or PO or Invoice or Direct Delivery using 2.4.8.
I can enter 255 Char in 2.4.4 without a problem
313 02/25/2020 04:18:50 am
Re: After upgrading to 2.4.8, Chrome no longer shows PDF in window (8 replies, posted in Reporting)
I dot have a problem with Chrome Windows and PDF's.
I agree with @corporatei that the Item Description field length has been drastically reduced in 2.4.8
314 02/17/2020 10:15:31 am
Re: Select Item Tax Type On Sales Quote, Order and Invoice (12 replies, posted in FA Modifications)
I believe this has been discussed before:
https://frontaccounting.com/punbb/viewtopic.php?id=7495
No decisive answer as It seems it is a huge effort to change the core to accommodate this.
315 02/16/2020 06:20:30 am
Re: Select Item Tax Type On Sales Quote, Order and Invoice (12 replies, posted in FA Modifications)
Could this be of any help?
https://frontaccounting.com/punbb/viewtopic.php?id=452
316 02/10/2020 01:10:27 pm
Re: Tax Report rep702 order by date (4 replies, posted in Reporting)
Sorry Braath
Your change works perfectly.
I was too quick to answer. Should have paid more attention.
Thanks
317 02/10/2020 12:52:48 pm
Re: Tax Report rep702 order by date (4 replies, posted in Reporting)
Thanks Braath,
I actually tried this before and I got this error in the log:
[10-Feb-2020 13:48:11 Europe/Berlin] <b>DATABASE ERROR :</b> No transactions were returned<br>error code : 1054<br>error message : Unknown column 'taxrec.trans_date' in 'order clause'<br>sql that failed was : SELECT tt.name as taxname, taxrec.*, taxrec.amount*ex_rate AS amount,
I could not understand why the ORDER BY gives such an error if one changes the order.
318 02/10/2020 07:13:08 am
Topic: Tax Report rep702 order by date (4 replies, posted in Reporting)
Dears,
How can I get the tax report to sort entries by date instead of Transaction type?
I tried to look around but being a novice I couldn't make it out.
Any ideas?
319 02/06/2020 03:50:21 pm
Re: Bank Statement Report (13 replies, posted in Reporting)
Just downloaded 2.4.8 and I was expecting this issue will be resolved. but it seems not.
I cant understand why Braath Waate pull request is not incorporated in the core yet. It works nicely.
Is there a reason?
320 02/03/2020 02:50:17 pm
Re: How do I allocate inventory items to internal use (2 replies, posted in Items and Inventory)
What I would have done:
I created a customer called 'Internal Use'. and assigned Discount Percent 100%
Created Price List named 'Internal Use' with base factor of 1.00
Then proceeded to run a direct invoice selling to this "internal use" customer using the "internal use" price list, the sale went through.
There was a GL entry with delivery note with the actual cost price and corresponding Inventory account.
Try it and give us some feedback.
321 02/03/2020 10:51:11 am
Re: How to print Cash Receipt Voucher (3 replies, posted in Banking and General Ledger)
You have two options as illustrated in the attached.
These two options are also available immediately once you enter the Payment... via Bank Account Payment Entry..as an example.
Also you can add the company name as a header as suggested in this thread.
https://frontaccounting.com/punbb/viewtopic.php?id=7771
rafat.
322 01/28/2020 02:52:25 am
Re: how to edit invoice QTY and amount (3 replies, posted in Accounts Receivable)
https://frontaccounting.com/punbb/viewtopic.php?id=7951#p34007
In the above link your issue is discussed in detail.
323 01/27/2020 04:49:45 am
Re: rep601 question (2 replies, posted in Reporting)
You also might look at
https://frontaccounting.com/punbb/viewtopic.php?id=7405
The pull request helped me.
I dont know why this is not in the core.. Its not in 2.4.7
324 01/23/2020 10:05:49 am
Re: Tax Inquiry - Does not show output tax info (114 replies, posted in Reporting)
Hi Sledge,
What I would have done:
===Trial 3===
3.1) Applied the 8 file changes from @Braath Wate git branch on v2.4.7
3.2) Carried on with my upgraded production DB from Trial 2
3.3) Slipped in DB row in table `0_sys_prefs` as per his branch (Just o make sure it exists)
3.4) Setup->Company Setup->Tax Bank Payments and Deposits (Ticked)
3.5) Test and advise if OK
Good Luck
325 01/15/2020 03:13:48 am
Re: Purchase Order Report rep209 (6 replies, posted in Reporting)
Thanks @notrinos
You are right.. maybe we need to commit this one.