426

(6 replies, posted in Reporting)

Did you update the utf-8 with installed_language.inc encoding ?

427

(2 replies, posted in Reporting)

This looks like issues with cookie in Firefox. Try chrome and list us the results.

428

(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

(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.

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

(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.

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

(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

(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.

@anoopmb you are right. This is a bug. @Joe fix it. By changing the parameter location.

436

(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

(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

(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.

Alright, you can get some other idea from any other expert in our community. Let's wait for it

440

(6 replies, posted in FA Modifications)

Most probably the class is used in sales. If it's used, you will be in trouble.

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.

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

(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')."'>&nbsp;&nbsp;";

just change it to

$himg='';

that's it.

444

(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.

You can query on gl_trans table. With respect to account code, you will retrieve all transactions

You can knock me for the support dude.

447

(2 replies, posted in FA Modifications)

This we can do it without touching the core. You have edited most important files of fa.

448

(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

(13 replies, posted in Setup)

My themes Saai, LTE,  Vanigam has this feature. You can refer here at Saai theme Kvcodes

450

(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.