701

(18 replies, posted in Items and Inventory)

rep302.php is the Inventory Planning Report.

There are only 2 main SQLs in it in the functions:

getTransactions()
getPeriods()

Do some single stepping and check the value of the $sql variable in them and see if the tables need any (non primary key) indexes to speed it up.

Hope you have the following Unique Indexes:

`stock_category`.`description`
`stock_master`.`description`

The former is there in my default install and the latter may need to be inculcated.

How many transactions are you querying and hope your PHP.ini file has adequate memory allocated.

@joe: Adding an Unique Index for `stock_master`.`description` may be in order.

@joe: any standard way out for this?

That is what a Quote is - change the language translation file to replace Quote with Proforma Invoice or hard code it everywhere!

The last error means that the query did not yield any records.

If possible, try to revert to using PHP 5.6 instead of your 7.3 and see if that solves the issue.

705

(15 replies, posted in Setup)

You can fix the tax on a per item basis for purchase - Setup => Item Tax Types - after setting up the tax and tax groups. Then apply the Tax Type for the Item desired.

You can use the Satoshi as the currency unit instead of a whole BitCoin.
Manual exchange rate entry is allowed.
You can then subsist within the FA decimals for currencies.

You are free to make an extension specific to your country and sell it to anyone.
You can, however, donate to the FA project - optional, voluntary and much appreciated.
Videos in English already exist on YouTube and at http://spoken-tutorial.org and you can make one in your preferred language.

708

(6 replies, posted in Setup)

This can be a standalone webpage written in PHP accessing the data in the MySQL database and outputting your XML file as the electronic Invoice till a custom module is built. The said Wikipedia documentation page is in Spanish and it's English Translation from Google Translate.

In Panama

Unlike Costa Rica and Guatemala, Panama does not have legislation related to electronic invoicing at this time. But on January 20, 2018 the Ministry of Economy and Finance and the General Directorate of Taxes (DGI) announced a project for the adoption of Electronic Invoicing that will be carried out in stages.

Useful Links:
https://www.edicomgroup.com/en_US/solutions/einvoicing/LATAM_einvoicing.html
https://www.uber.com/pa/en/suppliers/invoice-requirements/
https://manufacturingengineering.org/invoice-xml-format/
https://www.pgsupplier.com/en-US/current-suppliers/invoicing/invoicing-panama

It is clear that you are using an old version of the import_transactions module. Get the latest from here.

@joe: Please update the official repo with the one from my GitHub repo (attached herein) for this extension.

710

(52 replies, posted in Modules Add-on's)

PHP has a json_encode and json_decode functions to convert to/from array.

Sample Code

711

(52 replies, posted in Modules Add-on's)

Alternatively, can keep a JSON field in each such table that needs extra field data and define all such data definitions in a single table.

Yet another alternative: Keep an XML file for extra fields definition in each application - suppliers, items, customers, invoices, etc and keep all such data in a single table with an application name/type field to segregate them.

1. Take a FA sql backup
2. Make one depreciation entry manually in FA.
3. Take another sql backup.
4. Check what has changed between the two backups.
5. Construct similar sql entries for all your assets that need depreciation.
6. Execute the set of depreciation sql entries in one go in any MySQL client like phpmyadmin, sqlyog, etc.

Provide feedback on your experience here so that a menu item can be made to provide for depreciation on single click of selected asset entries.

@joe: does this deserve a reconsideration?

There are several spaces preceding each ID field. Also the prep_amount is the last field according to your insert statement with an empty value and hence the error.

715

(2 replies, posted in Setup)

If you do not want a full fledged double entry book keeping system but just want to keep track of AR/AP, then use the likes of SimpleInvoices. FA may be overkill here.

This is so that adjustment entries can be made.
You can void the said entry and make a fresh one.

Check your nginx document root and FA webroot if any in your webserver conf file that you may need an alias for depending on the url you used to install FA.

The nginx configuration file is generally at /etc/nginx/nginx.conf.

It is possible to inadvertantly change the description (typo) and the absence of the recall would entail re-entry.

@joe: have a look at @braathwaate's code and see if it is ok to include in the light of accustomed data entry after ignoring whitespace differences.

Commercial integration is okay. Place info in Job Offers board. No free version is necessary at all. A demo site can showcase it. State clearly what resides on your server and what is needed at the client / client's server end. A full disclosure is best practice.

Anyone who wants integration can manage without any extension as well if DB functions, triggers and procedures are used and both FA and the integrating application reside on the same database server (not necessarily the same database) with appropriate credentials.

Try trial first and then without it.
Also check db permissions are getting percolated into the extension and file and folder permissions. Check the error logs, mysql logs, php logs and fa logs with errors turned on in the config.

Which platform are you on and what versions of PHP/MySQL are you using?
Why don't you try with the latest FA codebase which has post release fixes.

Keep a separate Item for Printer Ink and for Tape.
Editable description is for small variations in Item description for the specific Invoice.

@joe: should we entirely delete all changed descriptions from being remembered except for the specific Invoice/Order and where none, take the default for the item?

Search the form for some of @elax's posts among others.

Create an extension to act as a bridge from within FA or make a plugin for your applications you need to integrate.

There are quite a few FA users who run webshops and they may already have a kludge of a solution to assist them. You are welcome to contribute your extensions to FA. Development requests are on the FA Job offers board.

723

(11 replies, posted in Setup)

We have been trying to access new company with the admin login but showing an error like "Incorrect Password" other than default company. Please guide us in detail. Thank you in advance.

If you fail to provide a password during company creation, then the default is "password" for the "admin" user. Only the default company login can create a new company. You need to login into the new company with your access credentials by choosing the right company in the login's dropdown select box (or textbox if set in config.php).

724

(0 replies, posted in Installation)

Recently, a scan of the apache access logs on a Linux based FA server yielded the following two entries:

45.13.93.82 ... "CONNECT ip.ws.126.net:443 HTTP/1.1" 405 408 "-" "Go-http-client/1.1"
192.241.238.130 ... "GET / HTTP/1.1" 200 452 "-" "Mozilla/5.0 zgrab/0.x"
162.243.128.149 ... "GET / HTTP/1.1" 200 452 "-" "Mozilla/5.0 zgrab/0.x"

The last 2 entries above are from the ZGrab Project which is part of the Open Source ZMap portfolio of applications.
* Hack to Learn
* Insecure default SSH Keys in IoT devices
* 580 Default HTTPS Keys in use
ZGrab2 is written in Python/Go languages and is used to grab webpage data.

ip.ws.126.net => 59.111.181.52    CN    China,Asia    59.111.0.0/16    Guangzhou NetEase Computer System Co.
https://ip.ws.126.net/ => states nginx and Forbidden
DNS verified with: https://dnsdblookup.com/ip.ws.126.net/
Referred in: https://forums.homeseer.com/forum/homeseer-products-services/system-software-controllers/hs3-hs3pro-software/hs3-hs3pro-discussion/1355113-odd-web-sever-log-entry-should-i-be-concerned
Abuse Reports: https://www.abuseipdb.com/check/59.111.181.52

45.13.93.82    DE    Germany,Europe    45.13.92.0/23    Cnservers LLC
192.241.238.130    US/California    192.241.238.0/24    Digital Ocean
162.243.128.149    US/California    162.243.128.0/24    Digital Ocean

https://ip.ws.126.net/ipquery
  var lo="泰米尔纳德邦", lc="金奈";
  var localAddress={city:"金奈", province:"泰米尔纳德邦"}
translates to:
  var lo = "Tamil Nadu", lc = "Chennai";
  var localAddress = {city: "Chennai", province: "Tamil Nadu"}

Also in your /etc/hosts file, make sure the following entries are present (In Windows it would be in C:\WINDOWS\SYSTEM32\drivers\etc\hosts:

127.0.0.1  airartapt.site
127.0.0.1  netpatas.com
127.0.0.1  hadsecz.com
127.0.0.1  ofgogoatan.com

The third one is included into the browser using a javascript file of random name masking all content to have an overlay of a link that dynamically changes redirection and captures username and password as well especially in the FA login screen.

A page refresh toggles it off.

The last one above is present in sites like in https://f2movies.to and gets into other tabs sometimes.

Conclusion:
1. Make sure all unnecessary background programs / apps are killed off.
2. When logging on to FA, make sure no other browser instance or browser tab is present.
3. After entering the login page, refresh it once before entering access credentials.

* Wiki article on session fix.
* Forum Post