Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 31 of 247)
In each menu item you want add / edit role separation do the following:
1. Take a FA sql backup
2. Add a record in the menu item
3. Take another FA sql backup
4. Compare the 2 backups and see what SQL statements are needed for the Add operation.
5. Edit the record in the above menu item for the fields desired to be edited (or in it's entirety)
6. Take yet another FA sql backup
7. Compare the last 2 backups and see what SQL statements are needed for Edit operation.
8. Compare the field list for the Add and Edit operation's SQL statements.
Now either code the PHP in a way that achieves the above (OR)
Create a new MySQL DB (non-edit) user giving it suitable rights over the desired tables/fields and program the FA mysql_connect based on the logged in (non-edit) user and switch to those credentials.
We will then need another kind of Sales document type for "Goods reserved for Sales Order".
rep302.php - Inventory Planning Report - Line 52
rep303.php - Stock Check Sheet - Line 164
The above reports have a function getTransactions() which uses item.description in the GROUP BY clause - this assumes that each item.stock_id can have different item.description(s) - may even try to remove the offending Line making sure it is unique or make an index for it with:
ALTER TABLE `1_stock_master` ADD INDEX `ItemDetailIdx` (`description`);
"Goods waiting for delivery" will then mean "Goods in Stock reserved for said order" and inability to sell such stock to others if the "Proforma Invoice" is not converted into an order forthwith!
Do you really want this complication?
Better stick with "Sales Quote" and make a move of the proposed items and quantities to a holding account till it gets converted into an order for delivery and revert it just before Invoicing it finally!.
@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.
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.
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.
Try to scale down to PHP 5.6 or lower and see if it helps.
No. the "quot" here is the htmlentity for a quote character in the characterset.
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.
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.
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.
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.
PHP has a json_encode and json_decode functions to convert to/from array.
Sample Code
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.
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.
Posts found: 751 to 775 of 6,171
