Maybe create another PayPal "Cash" account!

@joe: Nice addition - want to absorb in the core?

753

(0 replies, posted in Development)

Although the forum users DB has been trimmed to be around 5300 users, over the years 45K users have registered and many have become inactive even without posting and others have gotten deleted for malicious posting too.

Attached herewith is a list of remaining users summary who have been Banned for unacceptable posts belonging to different domains where such activity exceeds 10 users in the domain.

Many legitimate domains too have been used.

754

(4 replies, posted in Fixed Assets)

You can always make a Journal entry for all account heads from the previous years balance sheet. Alternatively, make the contra an intermediary suspense account and then allot the fixed assets as if they were purchased then.

State all versions on client side: Browser, OS Platform and updation status, etc.

Then it should be okay if the sysadmin trusts the module's author.

If the form can be seen only from the logged in state, then non logged in users should not be able to get in even by cURL.

This change can be reverted and SQL injection can be addressed by removing semicolon from the POST field's value.

759

(5 replies, posted in Wish List)

A debit note to the retention account may be in order.

760

(0 replies, posted in Report Bugs here)

Can the ads not be suppressed in the forum or is it by design that needs a client side suppressal?

Here is an addition to the ....etc/hosts file links:
http://winhelp2002.mvps.org/hosts.htm
http://www.hosts-file.net/

We needed 2 more entries for complete suppression with the final ones being:

127.0.0.1 contextual.media.net
127.0.0.1 pagead.googlesyndication.com
127.0.0.1 pagead2.googlesyndication.com
127.0.0.1 adservices.google.com
127.0.0.1 ssl.google-analytics.com 
127.0.0.1 www.google-analytics.com 
127.0.0.1 imageads.googleadservices.com 
127.0.0.1 imageads1.googleadservices.com
127.0.0.1 imageads2.googleadservices.com
127.0.0.1 imageads3.googleadservices.com
127.0.0.1 imageads4.googleadservices.com
127.0.0.1 imageads5.googleadservices.com
127.0.0.1 imageads6.googleadservices.com
127.0.0.1 imageads7.googleadservices.com
127.0.0.1 imageads8.googleadservices.com
127.0.0.1 imageads9.googleadservices.com
127.0.0.1 partner.googleadservices.com
127.0.0.1 www.googleadservices.com
127.0.0.1 tpc.googlesyndication.com
127.0.0.1 www.googletagservices.com
127.0.0.1 googleads.g.doubleclick.net
127.0.0.1 adsettings.google.com

If these become insufficient, then we should not show it openly in the forums anymore if Google wants to smart it.
Caveat: Google's other programs may now check for such entries and lock you out of Gmail and their other applications - then just do not use Google anymore - there are many alternatives.

761

(5 replies, posted in Wish List)

When you provide a tax retention, do you get re-imbursed by the tax authorities or can you deduct it from payments being made to the tax authorities - this does not seem intuitive.

762

(5 replies, posted in Wish List)

Make a head of account in the CoA for a tax retention account (for supplier deductions and customer deductions separately) and make an entry for tax deduction as needed to these accounts and then contra them when paid / refunded as the case may be.

This is the only place where VARCHAR 255 is available in the sql/en_US-new.sql (msg field) Chart of Accounts - unless you used a different one:

CREATE TABLE `0_sql_trail` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sql` text NOT NULL,
  `result` tinyint(1) NOT NULL,
  `msg` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB ;

Compare lines 946-7 in includes\ui\ui_lists.inc:

    echo sales_items_list($name, $selected_id, $all_option, $submit_on_change,
        '', array('cells'=>true, 'max'=>50)); // maximum is set to 50 and not default 255.

Why was it reduced to 50 characters?

Commits on 2019-07-04 and 2019-07-18 did this change.

@boxygen: In what way is your version different from the standard one here? Your module is attached herewith along with the necessary whitspace fixes so as to easily do a diff compare with that in my the FA24extensions repo.

Several Al Ameen Accounting software exist and they may be the same as well like:
http://www.syriansoft.com/page/?Id=12
https://alameensoft.com/en/download/al-ameen-accounting-system-9-0-900-11/

@joe: When voiding sales orders / invoices, we may need different approaches to handle payment allocations - prepaid and postpaid.

Make one prepaid sales orde and then cancel it after taking backups at each stage and list the SQLs that change the DB.
Make another normal sales orde and then cancel it and do the same backups.
Now compare the final voidings in both cases and see if any difference exists - if so, the voiding routine may have to be tweaked.

Have you tried it with FireFox latest version?

767

(7 replies, posted in Installation)

@lugess: Thanks.

You need the GD extension in PHP to be installed.

<?php
$testGD = get_extension_funcs("gd"); // Grab function list 
if (!$testGD){ echo "GD not even installed."; exit; }
echo"<pre>".print_r($testGD,true)."</pre>";

The pdf forms folder is okay and so is @kvvaradha's suggestion as long as the sysadmin allows it to be uploaded after vetting. Only that it should not be uploadable by the end user into the FA system especially through a normal web interface or user input form..

As long as it is a file that is uploaded in the core it should be okay. If code is pasted into a field in a FA form, it will cause security issues.

770

(1 replies, posted in Reporting)

The PDF can be viewed before being discarded if not good or needed.

When code is pasted into FA, it can cause security concerns.

Or use PDF2HTML conversion to call the report using PDF and then output all PDFs as HTML when that flag exists.

773

(8 replies, posted in Announcements)

Post Release Fixes attached.

CHANGELOG

New SysPrefs boolean variable added: long_description_invoice on 2020-06-13
Fixes PHP 7.4 bugs and security loophole in adding languages too as of 2020-08-04
Dimensions extended to AR/AP as well - 2020-08-12
TCPDF error introduced on 2020-07-04 has been fixed now.
New layout for Login page
This also has the PHP compatibility fix stated here.

Kindly state your reason for wanting the same.

All suggestions with clear use cases will foster quicker adoption and assimilation into the codebase.

775

(27 replies, posted in Setup)

Most new user downloads from India and some other countries occur from GitHub since the Spoken Tutorial (instructions given during contact classes) use it - this will skew the SF downloads based inferences. Furthermore, many FA service providers in India use UK and US hosts.