Did you update the utf-8 with installed_language.inc encoding ?
426 11/16/2020 07:58:37 am
Re: pdf utf8 and german special chracters (6 replies, posted in Reporting)
427 11/06/2020 01:45:36 am
Re: Purchase Order print PDF now showing (2 replies, posted in Reporting)
This looks like issues with cookie in Firefox. Try chrome and list us the results.
428 11/06/2020 01:43:31 am
Re: Search Customers Invoice by phone number (6 replies, posted in Reporting)
You need to create a column inside debtor trans table and add a textbox in direct invoice. So it can be stored to each invoice. And finally you can use mobile no to find the right invoice customer.
429 11/05/2020 01:38:20 pm
Re: Search Customers Invoice by phone number (6 replies, posted in Reporting)
Usually walk in customers, if you created invoices with phone no. It's easy for you to search and get it. If you saved the phone in customer contact. It not possible to identify it. Because more than one contact can be added to a customer. And in debtor trans table we record only the debtor no and branch code.
430 11/05/2020 12:10:26 pm
Re: Display quantity on hand on purchase order (5 replies, posted in Items and Inventory)
this will work for you. you need to open your po_ui.inc
and paste you need to update this code inside display_po_items
$th = array(_("Item Code"), _("Item Description"), _("Qty in Hand"),_("Quantity"), _("Received"),
_("Unit"), _("Required Delivery Date"), $order->tax_included ? _("Price after Tax") : _("Price before Tax"), _("Line Total"), "");
if ($order->trans_type != ST_PURCHORDER)
array_remove($th, 6);
if ($new)
array_remove($th, 4);
and then you need to update this code
$dec2 = $_POST['qty_hand'] = 0;
and few more lines to be updated.
$_POST['qty_hand'] = get_qoh_on_date($_POST['stock_id']);
if (list_updated('stock_id')) {
$Ajax->activate('price');
$Ajax->activate('units');
$Ajax->activate('qty');
$Ajax->activate('req_del_date');
$Ajax->activate('line_total');
$Ajax->activate('items_table');
}
and then you need to add the display function to see them in results.
}
label_cell(price_format($_POST['qty_hand']));
if ($order->fixed_asset) {
if you update this code you can see them in po, grn, direct invoices pages with quantity in hand
431 10/28/2020 02:24:33 pm
Re: POS Invoice and Receipt (2 replies, posted in Accounts Receivable)
You need to add your paper size in pdf_report.inc and use that in report. And customize the invoice to print.
432 10/20/2020 10:23:37 am
Re: Devel - SimpleAPI module UTF8 problem (6 replies, posted in Modules Add-on's)
Can you post your api call parameters and function you handle it from your server side.? It will help us to explain you it
433 10/10/2020 02:11:58 pm
Re: Can't login (7 replies, posted in Setup)
It's not permissions or password problem. It's php version deprecated some functions. That's the issue you are facing in server.
434 10/09/2020 06:22:34 pm
Re: Can't login (7 replies, posted in Setup)
FA version 2.3.x are very old programs. It supports the level of MySql version 5.6.And it works with MySql_query. And it's completely deprecated with php 7.3. You have to downgrade your php and MySql to use.or you need to find a developer to upgrade your files and database to new version.
435 09/26/2020 05:07:07 am
Re: bug in purchase order delete when invoking hook_db_prevoid () (5 replies, posted in Report Bugs here)
@anoopmb you are right. This is a bug. @Joe fix it. By changing the parameter location.
436 09/24/2020 05:26:17 am
Re: Shipment Tracking Module (15 replies, posted in Modules Add-on's)
Good update dude. Keep rocking with changes. There are some real time users are there. They can feedback you in better way to get it.
437 09/22/2020 04:55:51 pm
Re: Shipment Tracking Module (15 replies, posted in Modules Add-on's)
@deamosin, You have done a good job with it.
Looks like there is an error in your update.sql file.
CREATE TABLE `0_shipments` (
`shipment_id` int(11) NOT NULL AUTO_INCREMENT; #here the bug
`trans_no` int(11) NOT NULL DEFAULT '0',
to be
CREATE TABLE `0_shipments` (
`shipment_id` int(11) NOT NULL AUTO_INCREMENT,
`trans_no` int(11) NOT NULL DEFAULT '0',
and also add a readme for users to understand it. And also You have an options table to record the status of shipment, thats good. But you can provide an option to change them, otherwise, you can keep them in an array and show it here. If you provide an option to change it, it would be great for the users.
now a days the shipment should be further connected with shipping company api to get the status of goods movement. This is possible with help of shipping companies tracking API.
Overall its nice feature that you tried.
@joe, i think it can be added to core extensions repository for other users.
438 09/09/2020 12:42:07 pm
Re: modifying the array $class_types (6 replies, posted in FA Modifications)
@joe has the point. Simply goto banking and general ledger. Under maintenance you can see GL account classes. Just edit to remove the account classes used with cogs. It's done.
439 09/09/2020 12:38:09 pm
Re: Can I create customer with multi currency (5 replies, posted in Accounts Receivable)
Alright, you can get some other idea from any other expert in our community. Let's wait for it
440 09/08/2020 03:18:07 pm
Re: modifying the array $class_types (6 replies, posted in FA Modifications)
Most probably the class is used in sales. If it's used, you will be in trouble.
441 09/08/2020 03:13:13 pm
Re: Can I create customer with multi currency (5 replies, posted in Accounts Receivable)
There are two possible ways.
1. Change it with customer ( debtors_master ) table.
2. Customer branch level.
But both are really a bit of tricky and lengthen the process.
You need to record the currency in debtor trans tables and it's customer allocations table.
So you need to pass it overall sales module to get it working.
442 08/23/2020 05:28:00 pm
Re: FREIGHT AND OTHER EXPENSES IN SUPPLIER INVOICE (1 replies, posted in Banking and General Ledger)
As of current situation, we dont have option to do that. may be do it like this.
make the GRN and goto "Supplier Invoice" ,
there you can able to add the items that you already added them in GRN. and you can able to input the GL entries to use it. Here you can enter in Supplier currency as well. That will automatically convert to company currency while making system entry into it. But you should set the supplier currency clearly.
And if you want to do this many times means, add quick entry. Banking and General Ledger ->Quick Entries . Than you can get it easily. Hope this helps to solve your problem.
443 08/23/2020 05:23:47 pm
Re: How to disable Help on frontaccounting (3 replies, posted in Setup)
its comming from /themes/default/renderer.php or the theme that you have
/themes/yourtheme/renderer.php find help.gif or _('Help'). then it should be like this
$himg = "<img src='$local_path_to_root/themes/".user_theme()."/images/help.gif' style='width:14px;height:14px;border:0;vertical-align:middle;'' alt='"._('Help')."'> ";
just change it to
$himg='';
that's it.
444 08/23/2020 05:20:29 pm
Re: Setting up in NL using Belgian COA (4 replies, posted in Setup)
Looks like the fiscal years might not be updated. kindly check with fiscal year setup and if its right date. it will work.
even if it failed to work, enable debugging mode and get the issue error messages. we can assist you better.
445 08/20/2020 05:39:04 am
Re: Database Schema FA 2.4.6 (3 replies, posted in Banking and General Ledger)
You can query on gl_trans table. With respect to account code, you will retrieve all transactions
446 08/19/2020 09:47:58 am
Re: Install theme in theme directory of FrontAccounting files in ubuntu (3 replies, posted in Setup)
You can knock me for the support dude.
447 08/19/2020 01:56:25 am
Re: Switch company without logout (2 replies, posted in FA Modifications)
This we can do it without touching the core. You have edited most important files of fa.
448 08/17/2020 03:00:07 pm
Re: edit login page (2 replies, posted in FA Modifications)
To change the drop down to text box.
Just goto config.php and there you simply edit this to true.
$text_company_selection = true; // it was false before change it to true
449 08/17/2020 08:52:20 am
Re: Multiple company access (13 replies, posted in Setup)
My themes Saai, LTE, Vanigam has this feature. You can refer here at Saai theme Kvcodes
450 08/15/2020 04:05:58 pm
Re: Cannot Invoice Sales Order (5 replies, posted in Accounts Receivable)
Once you deliver the order . You have to invoice from the delivery. Not from order. Just goto customer transaction inquiry and select the specific customer and select type as customer delivery. Than you can get the delivery lists there. From there find the right delivery and there is in icon to proceed from delivery to invoice.
This way you can invoice it.