Keep changing the next invoice number manually in Setup => Transaction References and then let it auto-populate this manually provided value in the invoice you enter. The responsibility of maintaining non duplicate Invoice Number will then vest with you as the system will simply reject duplicates only after entering the invoice.
1,051 08/18/2019 06:24:32 am
Re: Manually Enter Invoice Number (6 replies, posted in Accounts Receivable)
1,052 08/18/2019 06:20:56 am
Re: Editing Customer Name on Invoice (3 replies, posted in Accounts Receivable)
Direct Database intervention in the following tables among others:
debtors_master
cust_branch
crm_personsPossibly the audit_trail, sys_prefs, journal and voided tables may have some telltale leftovers.
1,053 08/18/2019 06:13:44 am
Re: Some changes in add_supp_invoice to reduce unnecessary query run time (9 replies, posted in FA Modifications)
Since this does not affect the DB schema, can we not make a start here?
1,054 08/18/2019 06:04:19 am
Re: Clone Manufactured Item -> Clone BOM? (7 replies, posted in Items and Inventory)
1. Search the forums and the wiki.
2. Study the DB changes for each transaction / form entry and see if it makes sense.
3. Keep track of the FA version and the DB version in version.php
4. Study the commits in the Repos - Core and Extensions (official and others you follow).
5. Make sure the config.php and sys_prefs table entries match the changes committed in each version.
6. Plug and Pray that nothing breaks.
7. Wish @joe & @itronics a long life to fix anything that goes wrong and gets found ![]()
1,055 08/18/2019 05:56:53 am
Re: Salesman Listing Report 106 - Fix (2 replies, posted in Reporting)
@joe committed it.
1,056 08/18/2019 05:52:15 am
Re: Arabic RTL PDF Reports (15 replies, posted in Reporting)
1,057 08/18/2019 05:37:11 am
Re: Supplier's Description of an Item resets to default defined in system. (16 replies, posted in Items and Inventory)
1,058 08/17/2019 01:35:54 pm
Re: Clone Manufactured Item -> Clone BOM? (7 replies, posted in Items and Inventory)
@joe: want to add this?
1,059 08/17/2019 01:33:29 pm
Re: Some changes in add_supp_invoice to reduce unnecessary query run time (9 replies, posted in FA Modifications)
Putting it in a variable and then using it everywhere will make sense.
@joe?
1,060 08/14/2019 06:27:59 am
Re: Config Setup Options (10 replies, posted in Setup)
If you got your en_ZA chart and language files from the official extensions repo, then try to use the ones from the unofficial repo.
1,061 08/14/2019 06:25:43 am
Re: Article WEIGHT and SIZE (LxHxW) (3 replies, posted in Wish List)
FA currently just has "Ship Via" specific Shipper info and no shipping rates based on volume/weight/distance on a per shipper basis. Maybe this might be a good inclusion into FA 2.5.
1,062 08/14/2019 06:21:40 am
Re: 2 factor authentication to FrontAccounting (4 replies, posted in Modules Add-on's)
The potential files are:
access/login.php
includes/current_user.inc1,063 08/14/2019 06:18:55 am
Re: want to get total of items in invoice (1 replies, posted in Reporting)
We cannot add apples and oranges.
1,064 08/14/2019 06:08:53 am
Re: Item Adjustments: Relative Only? (2 replies, posted in Items and Inventory)
This is so that all other actuals if changed or differently dated will still fit in and any changes that need to be done can be made to the adjustment entry alone.
1,065 08/14/2019 06:07:14 am
Re: [separate, but related to current IR bug] zero inventory adjustment (9 replies, posted in Report Bugs here)
Abbreviations.com has some nice elaborations (just in jest only):
ORACLE: One Rich A** Called Larry Ellison
SAP: Slow and Painful
MICROSOFT: My Incredible Computer Runs Oddly So Oust Forged Trash
Using above may be like using a hammer to swat a fly/ant in most cases. That's where FA scores - with KISS technologies and gratis indeed. Some things are better than what money can buy and FA seeks to be the numero uno here.
1,066 08/14/2019 06:00:11 am
Re: Looking for FrontAccounting Developer (1 replies, posted in Jobs wanted/offered, non-free offers)
The following users from your country may be of assistance:
@chase
@Farhaj
@PHPdv
@dz
@boxygen
@emiangel839
@twlight1181,067 08/05/2019 05:46:20 am
Re: Problem Importing Item Purchase Price (7 replies, posted in Setup)
Check if your input data had any extraneous characters that caused a mess up in escaping (or double escaping?). The escape was to prevent SQL injection.
1,068 08/05/2019 05:44:34 am
Re: Default Theme Redesigned And available For testing (47 replies, posted in Modules Add-on's)
It's okay now in both themes. Tnx.
1,069 08/05/2019 05:42:16 am
Re: Updating Small Typo In An Extension (6 replies, posted in Modules Add-on's)
The attachment in my previous post can be safely used to overwrite the modules files as the official module has not been really updated in a while (just version bumps).
1,070 08/01/2019 06:11:52 pm
Re: Updating Small Typo In An Extension (6 replies, posted in Modules Add-on's)
Atleast it is correct in my repo. @joe: correct it in the official repo.
My version is attached herewith.
1,071 08/01/2019 06:07:30 pm
Re: Problem Importing Item Purchase Price (7 replies, posted in Setup)
Lines 43 to 49 of import_items.php:
function get_supplier_id($supplier) {
$sql = "SELECT supplier_id FROM ".TB_PREF."suppliers where supp_name = ".db_escape($supplier);
$result = db_query($sql, "Can not look up supplier");
$row = db_fetch_row($result);
if (!$row[0]) return 0;
return $row[0];
}If an existing supplier name is available in the target table, then it will return the supplier_id, otherwise it returns a 0. Make sure that the Supplier Name is exactly the same as the one in FA when an import occurs.
1,072 08/01/2019 05:58:17 pm
Re: Default Theme Redesigned And available For testing (47 replies, posted in Modules Add-on's)
Firefox 52.0.9 on WinXP SP3
1,073 08/01/2019 05:57:31 pm
Re: Login Timeout Setting Not Always Followed? (6 replies, posted in Setup)
A possible token in the session keeps getting changed.....
1,074 08/01/2019 05:45:21 pm
Re: Problem Importing Item Purchase Price (7 replies, posted in Setup)
Are you referring to the Inventory Items CSV Import module?
1,075 08/01/2019 05:42:42 pm
Re: Updating Small Typo In An Extension (6 replies, posted in Modules Add-on's)
Which extension, which page in it and what typo?
