Search options (Page 18 of 25)

Hi, although I have no experience of IIs, it is mentioned in the installation page of the wiki found here

Can you also change the line 

$go_debug         = 0;  
to 
$go_debug         = 1; 

in config.php in the root directory of FA and post any errors on here.

You could also try running phpinfo - and comparing results with some of the php settings mentioned on the wiki installation page; eg magic_quotes_gpc = 0 and register_globals = 0, etc. Then make the necessary changes to php.ini and restart your server. (Keep a record of what you change with line #)

Basic troubleshooting advice can be found here

@cambell demo site here with no changes to core or added js, only changes made to default.css and renderer.php
Very much WIP as a test to see what is possible; with very little styling, mainly structure: Works fine down to just over 300px wide for the following pages only:-

Sales:-
Transactions
Sales Quotation Entry
Sales Order Entry
Direct Delivery
Direct Invoice

Maintenance
Add and Manage Customers
Customer Branches

Purchases:-
Transactions
Purchase Order Entry
Direct GRN
Direct Supplier Invoice

Maintenance
Suppliers

Items & Inventory:-
Maintenance
Items

Setup:-
Preferences

Scale down to 300px ish add some item rows in either sales or purchases and see what happens

username: demo
Password: password

Comments and feedback welcome

Also you can have a different tax for each item, but will still show how as apmuthu states above

Wiki..ed

@campbell

I completely agree that FA needs a html framework.
Does that framework need to be bootstrap? IMHO No, its bloated and relies on js; and from what I've read on here (or not read) has little support from the devs.

Perhaps FA devs would be more willing to change to a purely css framework? No js.

There is so much you can do just in css now, js use is decreasing as css functionality increases. Even css has its own grid system now!

Hi, I'm not sure about paths,

I'm getting:-

Use of undefined constant VARLOG_PATH - assumed 'VARLOG_PATH' in file: /home/path/path/path/config.default.php at line 32

Use of undefined constant VARLOG_PATH - assumed 'VARLOG_PATH' in file: /home/path/path/path/config.php at line 32

include_once(./vendor/autoload.php): failed to open stream: No such file or directory in file: /home/path/path/path/modules/api/index.php at line 41

include_once(): Failed opening './vendor/autoload.php' for inclusion (include_path='.:/opt/alt/php56/usr/share/pear:/opt/alt/php56/usr/share/php') in file: /home/path/path/path/modules/api/index.php at line 41

Class 'Slim\Slim' not found in /home/path/path/path/modules/api/index.php on line 54

Is this defined in File: /home/path/path/path/config_api.php

01: <?php
02: 
03: if (file_exists(__DIR__ . '/_frontaccounting')) {
04:     $rootPath = realpath(__DIR__ . '/_frontaccounting');
05: } else {
06:     $rootPath = realpath(__DIR__ . '/../..');
07: }
08: //Tried this results as above
09: // define('API_ROOT', $rootPath . '/modules/api');
10: // define('FA_ROOT', $rootPath);
11: //tried this same results
12: define('API_ROOT', '.');
13: define('FA_ROOT', './../..');
14: 

Or somewhere else?

What should the path be?

Hi, have you read the Wiki?

I've been concentrating on the reference # number, I should be working on the trans_no and id number in debtor_trans and voided respectively.

In File: includes\references.inc

193:     function _get($type, $trans_no=0, $ref=null)
194:     


203:         $sql = "SELECT `$ref_fld` 
204:                 FROM `$trans_table` tbl
205:                     LEFT JOIN ".TB_PREF."voided v ON 
206:                 tbl.`$tno_fld`=v.id AND v.type=$type"
207:             ." WHERE ISNULL(v.id)"
208:             .($type_fld ? " AND tbl.`$type_fld`=$type" : '');
209:         if ($ref)
210:         {
211:             $sql .= " AND tbl.`$ref_fld`=".db_escape(trim($ref));
212:             if ($trans_no)
213:                 $sql .= " AND tbl.`$tno_fld` != ".db_escape($trans_no);
214:         } else {
215:             $sql .= " AND tbl.`$tno_fld`=".db_escape($trans_no);
216:         }

It checks that the reference number has not been used, so do I need to add the compare statement before this?

ah...

so I should be looking at:-

File:  includes\references.inc

83:     function _parse_next($type, $template, $context=null)
84:     {

this section:-

File: includes\references.inc

169:         // retrieve last ref number in the refline from original transaction table
170:         $sql = "SELECT MAX(CAST(SUBSTR($ref_fld, ".(strlen($prefix)+1).",LENGTH($ref_fld)-".(strlen($postfix)+strlen($prefix)).") AS UNSIGNED))"
171:                 ." FROM `$trans_table` tbl
172:                     LEFT JOIN ".TB_PREF."voided v ON tbl.`$tno_fld`=v.id AND v.type=$type"
173:                 ." WHERE ISNULL(v.id)"
174:                 .($type_fld ? " AND tbl.`$type_fld`=$type" : '')
175:                 ." AND `$ref_fld` REGEXP ".db_escape('^'.preg_quote($prefix).'[0-9]*'.preg_quote($postfix).'$');
176:         $result = db_query($sql, 'cannot retrieve last reference');
177:         $result = db_fetch_row($result);

?
My understanding of this (and my knowledge of sql is worse than php!) and ignoring the Regex..
Select the largest reference from debitor_trans
Join table with voided where id and type match

so this function returns the result which is then increased or decresed in function _increment($reference, $back=false)
    {

so the changes need to be made in function _parse_next.....???

You may have to give me some better clues...please

So...
search refs, find highest value for that type
if id equals id in voided
increment ref by 2
else
increment ref by 1