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,626 07/08/2018 04:24:51 pm
Re: Test out new Sales Map and other Modules (25 replies, posted in Modules Add-on's)
1,627 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,628 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,629 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,630 07/07/2018 04:38:17 am
Topic: FA Upgrade (2 replies, posted in Setup)
This topic is for upgrade issues / best practices.
1,631 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,632 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,633 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,634 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,635 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,636 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,637 07/05/2018 02:02:41 pm
Re: Italian Translation (13 replies, posted in Translations)
Windows or Linux server?
1,638 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,639 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,640 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,641 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,642 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,643 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,644 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.
1,645 07/03/2018 04:40:36 am
Re: Canada GST/HST Setup (1 replies, posted in Banking and General Ledger)
As long as each tax is named uniquely, they should all be added correctly. What does the UI now show? Make sure that the tax on tax is configured as desired. Maybe you want a Tax Group to be assigned.
1,646 07/03/2018 04:39:12 am
Re: problem logging in as admin after installation (5 replies, posted in Installation)
@oakstreet1: Thank for the feedback.
Stands Wiki-ed.
1,647 07/03/2018 04:13:29 am
Re: Cost Estimation Sheet (9 replies, posted in Manufactoring)
Provide sample cost estimation sheet and what fields from it need to go into what fields in the which form in FA.
1,648 07/03/2018 04:12:04 am
Topic: Adding Item Category Filter to the core (5 replies, posted in Setup)
@braathwaate has provided an item category filter mod that can be included in the core.
The attachment has the diff file and the file set for the current core version.
@joe: want to include it into the core?
1,649 07/02/2018 10:47:55 am
Re: Italian Translation (13 replies, posted in Translations)
Unzip the attached file into your <FA_webroot>/lang folder.
Just add a stanza for your language in lang/installed_languages.inc.
Now you are good to go.
Preferences => Italian
1,650 07/02/2018 06:53:57 am
Re: Fixed Asset Category Configuration and GL Accounts (4 replies, posted in Fixed Assets)
@jkent3rd: Thanks for the info.
Stands Wiki-ed.