FA probably does not have this kind of filtered data input feature. Create a restricted Purchase Admin role and toggle the price field to be hidden.
1,627 07/12/2018 03:35:11 am
Re: Install trouble on shared hosting using Microsoft IIS and Plesk (14 replies, posted in Installation)
Your genealogy site is proprietary that may result in externally processed PHP code obfuscated/encoded code being used.
Your server's PHP can be tested by running a php file having <?php echo "Hello World!"; ?>.
PM the access details to have a look removing and confidential info / resetting passwords to be other than your normally used ones you can revert to later.
1,628 07/11/2018 08:46:55 am
Re: Hide Menu options if not authorized (7 replies, posted in Wish List)
The current variable in the config.php for this functionality is $hide_inaccessible_menu_items. The permissions are set in the report file in the variable $page_security.
1,629 07/11/2018 08:25:43 am
Re: Install trouble on shared hosting using Microsoft IIS and Plesk (14 replies, posted in Installation)
Since your FA webroot does not have config.php and config_db.php files, FA has not been installed. It could be a matter of file permissions of the webserver user for the folder in question.
1,630 07/11/2018 06:59:03 am
Re: Adding Column Value in Drop Down (3 replies, posted in FA Modifications)
You can replace the i.description with the s.long_description with appropriate substitution there or add in the latter where the former is.
1,631 07/10/2018 04:28:31 pm
Re: Fiscal year delete leads to undefined variable $total (4 replies, posted in Report Bugs here)
@joe: How did this miss us? Probably no one generally deletes fiscal years that often....
There is no $total available anywhere in the said function's scope. Is it any global one?
The commit that introduced this line of code is here.
What is the need to add this journal entry here? There is no such addition in FA 2.3.26 and the rest of the code in this block was introduced in July 2011 in FA v2.3.6.
1,632 07/08/2018 04:24:51 pm
Re: Test out new Sales Map and other Modules (25 replies, posted in Modules Add-on's)
Let us push it for a later release when you have more time as vetting it and it's ramifications are important. At the moment, @brathwaate's fork can be used by those interested.
1,633 07/08/2018 04:30:03 am
Re: Test out new Sales Map and other Modules (25 replies, posted in Modules Add-on's)
@joe: is it worth adding in this core feature?
1,634 07/07/2018 06:51:55 pm
Re: VAT Payment and Repayment (5 replies, posted in Banking and General Ledger)
Check the for Sales Return and De-Allocation
1,635 07/07/2018 04:45:55 am
Re: FA Upgrade (2 replies, posted in Setup)
The list of changed files is available in an Announcements post from previous version to current one and from current one to bleeding edge master set. Just use those files to overwrite the counterparts in the working fileset one after the other. Take a look at the differences in the en_US-new.sql file between the existing and new versions using a diff tool like WinMerge. Generally there may be minor schema differences (not in your instance) and some extra records / change in defaults especially in the sys_prefs table. Synch with your working tables and chosen Chart of accounts accordingly.
The method you listed will need to migrate your files from the company/# folders as well besides affecting the dependencies - files, tables and security choices - of various addons like languages, themes, extensions, etc.
1,636 07/07/2018 04:38:17 am
Topic: FA Upgrade (2 replies, posted in Setup)
This topic is for upgrade issues / best practices.
1,637 07/07/2018 04:35:08 am
Re: Transaction References : The value is not incremented (10 replies, posted in Setup)
Not displaying the reference number in such forms and then automatically generating it and populating the appropriate tables with it was discussed but that detracted from the freedom to make any non standard transaction reference by the end user and hence given up.
This happens when two or more transactions of the same type are being created and submitted (by different users or the same user from different browser tabs/windows) either simultaneously or one after the other after all had opened the entry form for creation.
When each instance opens an entry form for record creation, the current accepted dispensation makes the next available reference number as the default value in the form. This will be the same in all such form instances across users / browser instances as long as the last record for the transaction type reference has not changed. When the first one submits the record it is taken without any error. When the second one is submitted, it is bearing the old "next reference" still and hence is rejected as it had been allotted to the one which was submitted first. Whilst it is possible to allot the real next reference that obtains at the time of submission, it was thought to be best presented to teh end user for choice of reference number instead - it may be implemented in private FA dispensations by allotted the next reference directly though and the code for it has been placed in the forum and possibly in the wiki adn the end user can make a choice.
The best way forward to have made a sys_prefs flag for prompting the enduser for choice of new reference or automatically take on the next available one. Although this affects a plethora of forms, it can be implemented directly in the add method of the relevant class definition.
@joe: If taken into the core with the appropriate default, it will save a few heart stops.
1,638 07/07/2018 04:23:20 am
Re: Access setup: Edit one's own transactions (6 replies, posted in Setup)
@joe: This may be integrated into thec ore, but study it's ramifications on related entries / derived / child entries of such "owners".
1,639 07/07/2018 04:21:57 am
Re: VAT Payment and Repayment (5 replies, posted in Banking and General Ledger)
Treat the VAT Office as a supplier/vendor (even though citizens who do not get their taxes worth are entitled to consider them dacoits selling thin air ). Make each VAT claim a supplier's invoice. Make each re-payment from the VAT Office as a Debit Note first and then fulfilled by their re-payment by allocation.
@joe: any SOP for it?
1,640 07/06/2018 04:55:51 am
Re: Test out new Sales Map and other Modules (25 replies, posted in Modules Add-on's)
Wiki-ed it.
1,641 07/05/2018 05:52:06 pm
Re: Italian Translation (13 replies, posted in Translations)
You need to install the it_IT locale in Ubuntu on the console first.
1,642 07/05/2018 05:44:16 pm
Re: Test out new Sales Map and other Modules (25 replies, posted in Modules Add-on's)
The function scroll_down() is defined in @braathwaate's version of includes/ui/ui_controls.inc:
function scroll_down($div)
{
global $Ajax;
$js = "
var objDiv = document.getElementById('" . $div . "');
objDiv.scrollTop = objDiv.scrollHeight;
";
if (in_ajax()) {
$Ajax->addScript(true, $js);
} else
add_js_source($js);
}
You can include the above function in the bank_gl_inquiry.php file or comment the scroll_down() call as @braathwaate stated.
1,643 07/05/2018 02:02:41 pm
Re: Italian Translation (13 replies, posted in Translations)
Windows or Linux server?
1,644 07/05/2018 02:02:19 pm
Re: REST API (86 replies, posted in Modules Add-on's)
All the $ variables need to be populated and then the sql needs to be extracted.
Read the Troubleshooting page in the Wiki.
1,645 07/05/2018 08:36:09 am
Re: REST API (86 replies, posted in Modules Add-on's)
Try to display the sql after the sql. The where clause addresses the issue of absence of voided entry.
1,646 07/05/2018 08:01:27 am
Re: REST API (86 replies, posted in Modules Add-on's)
Are you using the new method of pattern based document numbering or is it based on the old v2.3 method?
File: admin/db/transactions_db.inc line 183+:
function get_systype_db_info($type)
{
switch ($type)
{
case ST_JOURNAL : return array(TB_PREF."journal", "type", "trans_no", "reference", "tran_date");
case ST_BANKPAYMENT : return array(TB_PREF."bank_trans", "type", "trans_no", "ref", "trans_date");
..
..
File: includes/references.inc Line 183:
$db_info = get_systype_db_info($type);
## For a Journal entry, it will be:
## $_db_info = array(TB_PREF."journal", "type", "trans_no", "reference", "tran_date");
Line 170+ in the same file:
$sql = "SELECT MAX(CAST(SUBSTR($ref_fld, ".(strlen($prefix)+1).",LENGTH($ref_fld)-".(strlen($postfix)+strlen($prefix)).") AS UNSIGNED))"
." FROM `$trans_table` tbl
LEFT JOIN ".TB_PREF."voided v ON tbl.`$tno_fld`=v.id AND v.type=$type"
." WHERE ISNULL(v.id)"
.($type_fld ? " AND tbl.`$type_fld`=$type" : '')
." AND `$ref_fld` REGEXP ".db_escape('^'.preg_quote($prefix).'[0-9]*'.preg_quote($postfix).'$');
@joe: anything wrong here?
1,647 07/05/2018 07:58:48 am
Re: Cost Estimation Sheet (9 replies, posted in Manufactoring)
What I meant was for on-the-fly cost estimation. In your case, you would create a separate manufacturing work order and then zero the output and treat it as fulfilled and keep it like a template for future use.
1,648 07/03/2018 04:47:04 pm
Re: Cost Estimation Sheet (9 replies, posted in Manufactoring)
Actually it will the other way around. When a form is filled in, it acquires the cost data from the tables and outputs it.
1,649 07/03/2018 04:27:50 pm
Re: Clearing for Deposit GL Account after Allocate Payment (1 replies, posted in Accounts Receivable)
Sales => Customer Payments => make the customer deposit and not through journal.
Then Sales => Allocate Customer Payments or Credit Notes => and allocate what you want to the XYZ invoice.
1,650 07/03/2018 04:45:24 am
Re: How to Reverse Supplier Invoice (2 replies, posted in Accounts Payable)
If your Administrator Role has the permissions to change old entries, you then can.
See Attachment.
Logout and Login again for permission changes to take effect.