How can I apply formatting to a cell nowrap using db_pager
276 05/20/2019 08:08:54 am
Topic: How to apply nowrap in a Cell using db_pager (1 replies, posted in Reporting)
277 05/20/2019 02:36:28 am
Re: Items Cost in negative in inventory sales report (35 replies, posted in Items and Inventory)
Hi @zia, have you you enabled Negative Inventory in Setup?
278 05/18/2019 10:47:17 am
Re: Customer Trial Balance Report (11 replies, posted in Reporting)
in rep115.php Line # 234 shall be modified as below
if (db_num_rows($res) == 0 && !$no_zeros)279 05/18/2019 10:34:05 am
Re: Customer Trial Balance Report (11 replies, posted in Reporting)
In rep206.php Line # 168 shall be modified as below
if (db_num_rows($res) == 0 && !$no_zeros) and Line # 181 shall be commented, Because ignoring the loop here is not adding up the values of $curr_cr, $curr_db and $item variables.
280 05/16/2019 10:05:56 am
Re: Writing Arabic in Fields with English User (5 replies, posted in Translations)
Great @rafat that worked for me thanks.
281 05/15/2019 07:09:34 pm
Topic: Writing Arabic in Fields with English User (5 replies, posted in Translations)
When logged in as a User with Language as English, Writing Arabic in Fields like Customer Name shows ?????????
While being logged in as a User with language as Arabic accepts it.
Even any customer name added in Arabic as an Arabic User shows as ??????? when logged in as English User.
How can we use Arabic to input some fields while Logged in as Arabic User?
282 05/07/2019 02:36:27 am
Re: Add stamp or watermark to reports on the fly – ad hoc. (15 replies, posted in FA Modifications)
Hmmm. I was trying from Customer Transaction Inquiry. So there shall be an option to Fix the Water Mark in Company Preferences so that even from Customer Transaction Inquiry the WaterMark appears.
283 05/07/2019 01:48:25 am
Re: Add stamp or watermark to reports on the fly – ad hoc. (15 replies, posted in FA Modifications)
Can't find any watermark in this report
284 05/05/2019 06:00:41 am
Re: Default Theme Redesigned And available For testing (47 replies, posted in Modules Add-on's)
@joe, can you provide the download link of flatcolor2 theme
285 04/28/2019 03:31:37 am
Re: How can i update my Arabic Language (12 replies, posted in Translations)
Hello @emiangel839 I just finished updating my arabic language using following steps. You also try them
1. Download POEdit
2. Add your Msg Strings like one below in PO file
msgid "Cost Centers"
msgstr "مراكز التكلفة"3. Open PO file using this application
4. Validate your PO file
5. Compile PO file in MO file
6. Upload both files to the cloud server
7. Restart your Web Server (Apache).
8. Logout and then Login FA.
Note: If you are using a shared hosting then you won't be able to restart apache.
286 04/28/2019 02:47:41 am
Re: Cannot Download Repo Index File (6 replies, posted in Report Bugs here)
Facing this error on my live site
fopen(../tmp/ar_EG-2.4.1-3.pkg): failed to open stream: No such file or directory in file: /home/pakerp/web/pakerp.net/public_html/includes/remote_url.inc at line 81
/home/pakerp/web/pakerp.net/public_html/includes/remote_url.inc:81: fopen('../tmp/ar_EG-2.4.1-3.pkg','wb')
/home/pakerp/web/pakerp.net/public_html/includes/packages.inc:381: url_copy('http://anonymous:password@repo.frontaccounting.eu/2.4/languages/ar_EG-2.4.1-3.pkg','../tmp/ar_EG-2.4.1-3.pkg')
/home/pakerp/web/pakerp.net/public_html/includes/packages.inc:613: get_pkg_or_list('language','ar_EG')
/home/pakerp/web/pakerp.net/public_html/admin/inst_lang.php:273: install_language('ar_EG')
Cannot download 'http://anonymous:password@repo.frontaccounting.eu/2.4/languages/ar_EG-2.4.1-3.pkg' file.
/home/pakerp/web/pakerp.net/public_html/includes/ui/ui_msgs.inc:14: trigger_error('Cannot download 'http://anonymous:password@repo.frontaccounting.eu/2.4/languages/ar_EG-2.4.1-3.pkg' file.','256')
/home/pakerp/web/pakerp.net/public_html/includes/packages.inc:382: display_error('Cannot download 'http://anonymous:password@repo.frontaccounting.eu/2.4/languages/ar_EG-2.4.1-3.pkg' file.')
/home/pakerp/web/pakerp.net/public_html/includes/packages.inc:613: get_pkg_or_list('language','ar_EG')
/home/pakerp/web/pakerp.net/public_html/admin/inst_lang.php:273: install_language('ar_EG')
Package 'ar_EG' not found.
/home/pakerp/web/pakerp.net/public_html/includes/ui/ui_msgs.inc:14: trigger_error('Package 'ar_EG' not found.','256')
/home/pakerp/web/pakerp.net/public_html/includes/packages.inc:646: display_error('Package 'ar_EG' not found.')
/home/pakerp/web/pakerp.net/public_html/admin/inst_lang.php:273: install_language('ar_EG')While on the latest repo I can download it. Unable to find the reason
287 04/25/2019 07:32:53 am
Re: Cost of Inventory For Back Dated Transactions (5 replies, posted in Items and Inventory)
Yes, I am also at Fix. Will think over it and try then revert
288 04/25/2019 06:25:55 am
Re: Cost of Inventory For Back Dated Transactions (5 replies, posted in Items and Inventory)
Yes, this can be done manually. He was insisting that system shall be smart enough to handle this automatically 
289 04/25/2019 03:10:52 am
Topic: Cost of Inventory For Back Dated Transactions (5 replies, posted in Items and Inventory)
I have been put in a situation by one of my client (a chartered accountant).
Taking transactions of Item A.
Month 1: By Recording Sales and Purchases the Weight Avg Cost of Item A comes at 85.
Month 2: By Recording Sales and Purchases the Weight Avg Cost of Item A comes at 80.
Month 3: By Recording Sales and Purchases the Weight Avg Cost of Item A comes at 73.
Now client says that after reconciliation he found that he missed on Sales Entry of Month1. When he recorded that on backdate the system recorded the cost of inventory @ 73.
He says that by this the profit of Month1 is Over Valued. The system shall record the Back Dated Transactions on the cost of inventory prevailing in that date.
Can anyone help me how to combat this argument? Is it possible to record the back dated transactions the way he is suggesting and then adjusting the latest Average Cost accordingly.
Regards
290 04/22/2019 06:50:36 pm
Re: barcode (9 replies, posted in Reporting)
@apmuthu, thanks for this report. Very useful for me.
291 04/16/2019 07:17:36 am
Re: Website Transfer. (7 replies, posted in Announcements)
@Joe, I hope 2.5 Alpha will also incorporate the Dashboard widgets developed by @notrinos?
292 04/15/2019 09:51:53 am
Re: Website Transfer. (7 replies, posted in Announcements)
2.5 Alpha is anxiously awaited.
293 02/26/2019 05:40:14 pm
Re: Tax Inquiry - Does not show output tax info (114 replies, posted in Reporting)
config.php would be useful if one FA instance is used for one Company only. Since FA has the power to operate multiple companies with one instance, putting in config.php will contradict with each other may be.
294 02/26/2019 09:42:21 am
Re: Tax Inquiry - Does not show output tax info (114 replies, posted in Reporting)
Instead of config.php, better option is to add in company_preferences.php I guess.
295 02/26/2019 03:30:33 am
Re: Tax Inquiry - Does not show output tax info (114 replies, posted in Reporting)
@BraathWate, Now I could catch the bug. It appears only when Sales Tax Account is added as GL Line Item. It is duplicating the row in the rep709, hence the input tax value is incremented.
Apart from this that it is a Bug, I am unable to understand that why one needs to enter Sales Tax Account in the GL Line Item. When Sales Tax is Auto Applied to the Item being invoiced then why to enter Sales Tax Account in GL Line Item?
However, since we can't stop any one to select this Account (for any given reason) so this bug needs to be Fixed.
296 02/25/2019 05:29:47 pm
Re: Tax Inquiry - Does not show output tax info (114 replies, posted in Reporting)
Hello All,
I have tested on the latest repo without any customization suggested by @BraatWate.
My findings are that I can't find any bug related to #1 and #2.
Here is the screenshot.
You can also login to verify at
pakerp.net/fa242org
id: admin
pass: Pakistan1947
I can see both Inquiry and Report is showing the same results. And Input Tax is also included in both.
Regarding #3 I agree with @itronics but adding a check box is a good option.
I didn't test #4.
297 02/22/2019 02:58:12 am
Re: Tax Inquiry - Does not show output tax info (114 replies, posted in Reporting)
I have gone through the whole thread today. Unfortunately none of my Sites are using Purchase Taxes so I never hear of any bug from my clients. I will try to test it myself and shall revert.
298 02/21/2019 04:05:54 pm
Re: Bug in rep101.php (3 replies, posted in Report Bugs here)
@kvvaradha I am using the latest repo.
In the above thread you mentioned, your fix covers the transaction debiting customer through Journal Entry.
While my fix also covers the transactions crediting customers through journal entry.
Check the Screen Shot I attached.
299 02/20/2019 01:16:16 pm
Topic: Bug in rep101.php (3 replies, posted in Report Bugs here)
The line # 242 shall be fixed as below
if (($trans['type'] == ST_JOURNAL && $item[0]) || $trans['type'] == ST_SALESINVOICE || $trans['type'] == ST_BANKPAYMENT)
Other wise Any Transaction crediting Customer through JE will not be contained when the report is viewed Show Balance = No
300 02/19/2019 06:06:56 pm
Re: RepGen (4 replies, posted in Modules Add-on's)
@rafat, yes RepGen has issues. The default report however produces pdf but later you are not able to do anything.
Some points were discussed earlier here but couldn't get solution to it.
However the line
$file = $comp_path.'/'.user_company(). '/pdf_files/'.$id.'.pdf';can be fixed as below
$file = $SysPrefs->comp_path.'/'.user_company(). '/pdf_files/'.$id.'.pdf';