@kvvaradha: In case your offering is commercial / encrypted / FA version dependent, just place a link to your product's web page with info and costs so that it can be useful to the FA users who want to trust and buy your product and compare with other Open Source offerings.
726 05/07/2020 02:23:52 am
Re: FA batch + expiry date (9 replies, posted in Jobs wanted/offered, non-free offers)
727 05/06/2020 04:19:54 pm
Re: Pro-Forma Invoice in FA! (12 replies, posted in Banking and General Ledger)
All payments can be related to an invoice only and any prepayments will be allocations finally. Proforma Invoice can be a dummy invoice with no linkages to the delivery / order and can be converted to an invoice much like an order. Possibly a special case of an Order with some pre-payments in the pipeline.
728 05/06/2020 04:16:24 pm
Re: FA batch + expiry date (9 replies, posted in Jobs wanted/offered, non-free offers)
Patient's Name and Case are the 2 new form fields in Sales => Direct Delivery and Sales Order in your demo. Where is the batch Selection? The Invoice against Sales Delivery has a Batch button though. None of the Purchase links have any Batch feature.
Provide some sample data to experience the Batch details.
You can do away with the 0_cases table and keep the data as a comma delimited string in a setting in the 0_sys_prefs table.
The other extra tables used are 0_stock_batch, 0_stock_batch_moves.
The 0_stock_batch_moves table can be accommodated within the core 0_stock_moves table (possibly others above too) with some combination of innocuous values in unused fields of price, reference and standard_cost.
729 05/06/2020 03:52:56 pm
Re: Stock Check Sheet | Inventory Planning Reports has serious Bugs. (12 replies, posted in Reporting)
Try to scale down to PHP 5.6 or lower and see if it helps.
730 05/06/2020 03:47:01 pm
Re: HTMLentities for quote reversion (3 replies, posted in Report Bugs here)
No. the "quot" here is the htmlentity for a quote character in the characterset.
731 05/05/2020 03:35:21 pm
Re: Payroll & Human Resource Management. (216 replies, posted in Modules Add-on's)
Enable the access role for the said feature under Setup=>Access Setup=> System Administrator (or any other user role) and tick the necessary feature and save. Logout and login again.
732 05/05/2020 03:24:23 pm
Re: Inventory Planning Report (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.
733 05/05/2020 03:13:34 pm
Re: Withholded tax deduction at PURCHASE transactions (13 replies, posted in Accounts Payable)
@joe: any standard way out for this?
734 05/05/2020 03:09:46 pm
Re: Pro-Forma Invoice in FA! (12 replies, posted in Banking and General Ledger)
That is what a Quote is - change the language translation file to replace Quote with Proforma Invoice or hard code it everywhere!
735 05/05/2020 03:08:21 pm
Re: Import of Direct Sales Invoice from csv fails (18 replies, posted in Modules Add-on's)
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.
736 05/05/2020 03:05:14 pm
Re: TAX BY ITEM LINE (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.
737 05/05/2020 02:55:04 pm
Re: Better Bitcoin Support (like currency) (1 replies, posted in Wish List)
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.
738 05/05/2020 02:52:59 pm
Re: QUESTION ABOTH FA (2 replies, posted in Jobs wanted/offered, non-free offers)
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.
739 04/30/2020 06:13:54 pm
Re: ELECTRONIC INVOCES (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
740 04/30/2020 06:06:45 pm
Re: Import of Direct Sales Invoice from csv fails (18 replies, posted in Modules Add-on's)
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.
741 04/30/2020 05:56:33 pm
Re: Additional Fields Extension (52 replies, posted in Modules Add-on's)
PHP has a json_encode and json_decode functions to convert to/from array.
742 04/29/2020 06:01:20 pm
Re: Additional Fields Extension (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.
743 04/29/2020 05:49:10 pm
Re: Fixed Assets Depreciation customization (2 replies, posted in Jobs wanted/offered, non-free offers)
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.
744 04/29/2020 05:45:54 pm
Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice (15 replies, posted in Banking and General Ledger)
@joe: does this deserve a reconsideration?
745 04/29/2020 05:41:07 pm
Re: Import of Direct Sales Invoice from csv fails (18 replies, posted in Modules Add-on's)
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.
746 04/29/2020 05:22:38 pm
Re: FA for Services Company (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.
747 04/29/2020 05:19:25 pm
Re: Debit Credit Error on Trial Balance (18 replies, posted in Report Bugs here)
This is so that adjustment entries can be made.
You can void the said entry and make a fresh one.
748 04/25/2020 06:54:44 pm
Re: Wrong path on reports, Error 404 (2 replies, posted in Report Bugs here)
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.
749 04/25/2020 06:19:24 pm
Re: Different Service Item Description From Same Vendor? (10 replies, posted in Items and Inventory)
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.
750 04/21/2020 07:05:36 pm
Re: Interest in Magento Integration or Shopify Integration (5 replies, posted in Modules Add-on's)
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.