If the voided transactions too are taken into account when the greatest customer transaction is considered, it might alleviate this situation.
2,077 01/12/2018 04:47:59 am
Re: Trouble Deleting a Dimension (4 replies, posted in Dimensions)
If there are payments or deposits whether voided or not - pertaining to any value of the dimension to be deleted, you will not be able to delete the dimension.
2,078 01/12/2018 04:44:53 am
Re: change function (1 replies, posted in Dimensions)
Sales => Direct Invoice will make for cash Invoice by default. Try to locate the script and make the default value for Dimension 1 as what you want. Dimensions are optional in the Invoice Entry forms.
2,079 01/12/2018 04:41:58 am
Re: Fixed Assets (30 replies, posted in Fixed Assets)
It is there - see this link - maybe you are using some version other than v2.4.3+.
2,080 01/10/2018 11:29:55 pm
Re: Tax Report not showing data (12 replies, posted in Reporting)
It is possible that your earlier attempt using the erroneous CoA would have some remnants that would need to have been purged before attempting a fresh install.
2,081 01/10/2018 11:26:32 pm
Re: Print Customer Balance On Invoice (13 replies, posted in Reporting)
The function needs 2 arguments and the second one $to is missing. It should be computed to be the current date/time within the function if the argument is not given.
2,082 01/10/2018 11:10:38 pm
Re: Export customer transactions in pre-defined XML format (1 replies, posted in FA Modifications)
2,083 01/10/2018 11:06:18 pm
Re: Select Multiple Level 2 dimensions for report? (4 replies, posted in Dimensions)
Only that Dimension will be filtered.
2,084 01/08/2018 06:26:06 pm
Re: Mapping Item Code with 0_gl_trans table (1 replies, posted in Reporting)
gl_trans.type_no is retail (1) or wholesale (2) taken from sales_types table.
gl_trans.type = stock_moves.type which is the Transaction Type.
stock_moves.trans_no is the actual transaction number that does not have an equivalent directly in the gl_trans table.
The gl_trans table manages all types of transactions.
The supp_trans and debtor_trans tables handle purchase and sale transactions respectively and have trans_no and type fields in them.
The supp_invoice_items and debtor_trans_details tables have the item wise records for linking with the stock_moves table on both trans_no and type fields.
2,085 01/07/2018 09:11:12 pm
Re: What are Document Date: and Event Date: in journal entries for? (6 replies, posted in Banking and General Ledger)
Make the Journal Date alone mandatory and use it for the other two dates if empty.....
2,086 01/07/2018 03:53:28 pm
Re: Modify ITEM CODE??? (10 replies, posted in Items and Inventory)
Line 146 in reporting/rep107.php calls the function get_customer_trans_details() defined at the top of includes/db/cust_trans_details_db.inc. In the said function definition, change line 21:
line.description As StockDescription,to be:
line.description AS StockDescription, item.long_description AS FullDescription,and now change the line 166 in reporting/rep107.php:
$rep->TextColLines($c++, $c, $myrow2['StockDescription'], -2);to be:
[
$rep->TextColLines($c++, $c, (($myrow2['FullDescription'] != '') ? $myrow2['FullDescription'] : $myrow2['StockDescription']), -2);The field long_description may be available in multiple tables denoting other contexts. The existing StockDescription is retained as a fallback.
Caveat: Note that as FullDescription is taken from the stock_master table's long_description field, it may not be consistently available especially if changed or deleted in it later, whereas, the StockDescription will be available even without it from the stock_master table. It may be prudent to use both when the FullDescription is available.
@joe: would you like to commit the first code change in cust_trans_details_db.inc making the long_description for those who want it as well?
2,087 01/07/2018 08:07:43 am
Topic: Customer Allocation date zero (0 replies, posted in Accounts Receivable)
When a customer payment is allocated, the date of allocation is entered as '0000-00-00' but it is correctly entered for direct cash invoices. This happens in the cust_allocations and debtor_trans tables. The $_POST['DateBanked'] or it's processed value like end of current fiscal_year should have been used.
The set of payment and full allocation transaction sqls are:
SET @alloc=400;
SET @bankcharge=5;
INSERT INTO `1_refs` VALUES
('4', '12', '001/2018');
INSERT INTO `1_bank_trans` VALUES
(NULL, '12', '4', '1', '001/2018', '2018-01-07', @alloc-@bankcharge, '0', '0', '2', '1', NULL);
INSERT INTO `1_comments` VALUES
('12', '4', '2018-01-07', 'paid by outstation cheque');
INSERT INTO `1_cust_allocations` VALUES
(NULL, '1', @alloc, '0000-00-00', '4', '12', '5', '10');
INSERT INTO `1_debtor_trans` VALUES
('4', '12', '0', '1', '1', '2018-01-07', '0000-00-00', '001/2018', '0', '0', '400', '0', '0', '0', '0', @alloc, '0', '1', '0', '0', '0', NULL, '0'),
UPDATE `1_debtor_trans` SET `alloc`=`ov_amount`-@alloc WHERE `type`='10' AND `trans_no`='5' AND `debtor_no`='4'
INSERT INTO `1_gl_trans` VALUES
(NULL, '12', '4', '2018-01-07', '1060', '', @alloc-@bankcharge, '0', '0', NULL, NULL),
(NULL, '12', '4', '2018-01-07', '1200', '', -@alloc, '0', '0', '2', '1'),
(NULL, '12', '4', '2018-01-07', '5690', '', @bankcharge, '0', '0', NULL, NULL);
INSERT INTO `1_audit_trail` VALUES
(NULL, '12', '4', '1', '2018-01-07 10:13:49', NULL, '3', '2018-01-07', '0');2,089 01/07/2018 07:18:02 am
Re: Tax Report not showing data (12 replies, posted in Reporting)
Thanks @Foxyhimself and @bazza.
Fix committed.
2,090 01/07/2018 07:09:26 am
Re: Void a Transaction Functionality (13 replies, posted in Setup)
For now, create the new invoice and then void the previous one so that you do not void the last one.
@joe / @itronics: if this is a code bug, we need to fix it forthwith.
2,091 01/07/2018 07:06:02 am
Re: Editing Customer Payment (1 replies, posted in Accounts Receivable)
Allocation may have been made so you should not change the Customer name/branch. Void it and recreate it anew. Database intervention is possible but not advised.
2,092 01/07/2018 04:19:09 am
Re: Inventory purchasing transaction based report (19 replies, posted in Reporting)
This report is new and was not there in the release. Also the original inclusion had another file that is necessary.
2,093 01/06/2018 03:22:56 am
Re: erorr (14 replies, posted in Setup)
You need to close the fiscal years in sequence from the earliest onwards.
2,094 01/06/2018 03:20:52 am
Re: Inventory purchasing transaction based report (19 replies, posted in Reporting)
It is now part of the core.
See the original inclusion commit and the subsequent enhancement commit
2,095 01/06/2018 03:16:28 am
Re: Tax Report not showing data (12 replies, posted in Reporting)
The British CoA (among others) is broken as far as order of fields in some tables are concerned. The Official pkg repo has not been updated. Check with the schema of the en_US-new.sql.
Have a look for corrected one here.
2,096 01/05/2018 03:08:02 am
Re: Importing from DacEasy (10 replies, posted in Setup)
BTrieve Tools:
16 bit BT View - Download
BTrieve Tools Zip - Download
Technical White Papers on BTrieve conversion
Free Print Drivers:
Free DOS Printer for Windows - Download
DOSPrint - [url=http://www.andtechnologies.com/download/free20110630/DOSPrint.zip[/url]Download[/url]
Tech Notes:
Microsoft
4DOS
Tom's Hardware
2,097 01/05/2018 02:21:34 am
Re: Importing from DacEasy (10 replies, posted in Setup)
DacEasy (v9 and v10 to 14 and Utilities) when I last used it over 2 decades ago was using dBASE (.DBF) files. It should be trivial to export them out into Excel / CSV files before importing them into MySQL directly. DacEasy last used BTRIEVE database for DOS that is akin to MySQL's ISAM (Indexed Sequential Access Method) DB Engine.
The manual for DacEasy v14 is available here and it's list of files and what they are for is listed here.
Commercial products to convert Btrieve DB to MySQL DB are:
Mertech Btrieve to MySQL
FullConvert Enterprise - abandoned / unsupported / lost on the web
Nelson Software Tools
BTrieve itself is now Pervasive SQL (PSQL) - MySQL Discussion thread for conversion.
DacEasy is now part of Sage and they do not generate Activation keys for these old versions when you need to re-install. Provide feedback if this works.
If you are interested in still using DacEasy, it can be setup in a DOS emulator and run on the newer OSes along with an LPT2USB Driver for them.
Capturing LPT1 is also possible.
FreeDOS supports USB Printers.
You can also run DacEasy in a DOS VirtualBox / VMWare Player / QEMU Emulator.
DOSBox too can be used.
2,098 01/04/2018 06:32:09 pm
Re: erorr (14 replies, posted in Setup)
Open / Close the Fiscal Year as per screenshot attached.
2,099 01/04/2018 06:07:50 pm
Re: Tax Report not showing data (12 replies, posted in Reporting)
Which Chart of Accounts are you using? Update FA to the latest codebase and try.
2,100 01/04/2018 05:57:27 pm
Re: GL Account Language (2 replies, posted in Setup)
Take a backup of current FA. Do a WinMerge compare with original en_US-new.sql English that worked as desired. Now change the account heads as needed and then restore it.