search

rossaddison / import_transactions

Front Accounting version 2.3.21: Import transactions from csv in journal format, payment format, deposit format, or adapted bank statement format. Features: 1. Trial check before importing. 2. Tabular display of journal entries, journals displayed as debits and credits using Front Accounting's 'items cart' class. 3. Importing of bank statements with additional columns for spreadsheet adjusted associated transaction account codes, customer, or supplier id's. 4. Additional Tax type column for VAT registered companies for vat inclusive income or expenses. 5. Inclusion of transactions automatically in an audit trail. 6. Display notifications identifying how tables within the database are being affected for a more transparent display to interested programmers. 7. Additional lookup tools for looking up customer id's, supplier id's, company setup information eg. fiscal year, and other tools that users will find useful for inclusion in their spreadsheet prior to conversion to csv. 8. Suitable validation checks for customers, suppliers, tax codes, references. 9. Example csv files are provided for each format. These can be used to test the package, and as templates for your own use. 10. Import Sales Orders / Invoices
GNU General Public License v2.0
0 stars 4 forks source link

no inventory items defined in the system. #1

Open alvin101 opened 9 years ago

alvin101 commented 9 years ago

after upgrade to latest scripts and trying to use General Journal Processing, I now get this error:

There are no inventory items defined in the system. /home4/aljotwoc/public_html/fa/includes/ui/ui_msgs.inc:14: trigger_error('There are no inventory items defined in the system.','256') /home4/aljotwoc/public_html/fa/includes/data_checks.inc:277: display_error('There are no inventory items defined in the system.','1') /home4/aljotwoc/public_html/fa/modules/import_transactions/import_transactions.php:128: check_db_has_stock_items('There are no inventory items defined in the system.')

What do you think the problem is here?

I get this under show SQL:

BEGIN SELECT counter, type, type_no, amount FROM 0_gl_trans ORDER BY counter DESC LIMIT 1 SELECT COUNT(*) FROM 0_stock_master

rossaddison commented 9 years ago

Hi Alvin, You could remove line 126 from import_transactions.php

check_db_has_stockitems(("There are no inventory items defined in the system."));

but you will inevitably have to define a service item as a product item if you are using the Sales Order / Sales Invoices procedure.

Or you could go Setup->System and General GL Setup>Inventory->Allow negative inventory.

Try these and hopefully they will give a good result.

Ross

On May 21, 2015, Alvin notifications@github.com wrote:

after upgrade to latest scripts and trying to use General Journal Processing, I now get this error: There are no inventory items defined in the system. /home4/aljotwoc/public_html/fa/includes/ui/ui_msgs.inc:14: trigger_error('There are no inventory items defined in the system.','256') /home4/aljotwoc/public_html/fa/includes/data_checks.inc:277: display_error('There are no inventory items defined in the system.','1') /home4/aljotwoc/public_html/fa/modules/import_transactions/import_transactions.php:128: check_db_has_stock_items('There are no inventory items defined in the system.') What do you think the problem is here?— Reply to this email directly or view it on GitHub https://github.com/rossaddison/import_transactions/issues/1.