601 Reply by boxygen

(9 replies, posted in Reporting)

Dear @apmuthu thats really not practical. Sometimes we need to compare reports so quickly that saving a report locally and then opening them again in a pdf reader is cumbersome.

I went into the code and finally got the solution

In utils.js file Commenting Line no 127 and adding below line solves the problem

127  //window.open(data,'REP_WINDOW','toolbar=no,scrollbars=yes,resizable=yes,menubar=no');                         128    window.open(data);

This will work when in Preferences the option to view reports in pop up window is checked.

Hope this may help others too.

Regards.

Go to forum: Reporting

602 Reply by boxygen

(23 replies, posted in Report Bugs here)

Actually I implemented this ERP in an organization. The CFO is a chartered accountant. He put me in a difficult position that how to reconcile the COGS reflecting in Profit and Loss through Inventory Movement.

He said that COGS shall be come through formula Opening Inventory + Stock In - Closing Inventory.

For that purpose I had to review this report but the report itself is not correct.

So Please try to check the Code and Correct this bug.

Thanks

Go to forum: Report Bugs here

603 Topic by boxygen

(23 replies, posted in Report Bugs here)

Hello,

If you login here  Costed Inventory Movement

with id: admin
pass: 1234
company: gp

You will find that the Report is not Reconciled

i.e. Opening Stock + Stock In - Deliveries IS NOT EQUAL TO  Closing Stock

I tried with different categories also and found the same Non Reconciled.

If you try the Item Category 4x4 Ltr. This is the simplest. You will find the difference in Rates that are causing the difference.


Any Ideas

Go to forum: Report Bugs here

604 Reply by boxygen

(9 replies, posted in Reporting)

I can't understand your reply @apmuthu.

When we need to compare 2 or three reports each other we can't because FA opens new report in the same window of previous report. Is there any solution to it?

Go to forum: Reporting

605 Reply by boxygen

(3 replies, posted in Reporting)

You can try Payroll Module added by @Notrinos to FA2.4

Go to forum: Reporting

606 Reply by boxygen

(36 replies, posted in FA Modifications)

In Post 16 bogeyman has given the link to download

http://stuff.w3shaman.com/others/fa-autocomplete.zip

Go to forum: FA Modifications

607 Topic by boxygen

(1 replies, posted in Reporting)

Is it possible that Memo details appear in full in Bank Statement. It doesn't matter if it goes for next line.

Go to forum: Reporting

608 Reply by boxygen

(9 replies, posted in Reporting)

I have tried both chrome and firefox.

In my preferences I have marked checked Use popup window to display reports:   

Both firefox and chrome offers some plugins to manage popups but even if the report is opened in a new tab. When I click another report the same NEW TAB is updated instead of opening NEW REPORT in another NEW TAB.

I have just changed the email address and now receiving emails.

Go to forum: Reporting

609 Reply by boxygen

(9 replies, posted in Reporting)

Please help me to do it through code.

While using the browser feature the problem is that if any new report is opened the browser update the same NEW TAB just like it used to update the POP UP window.

I want to open each time a report button is clicked it goes to new tab.

By the way I am not getting forum responses in my email. Is there any problem?

Go to forum: Reporting

610 Topic by boxygen

(9 replies, posted in Reporting)

I have uncheck Use Popup for reports in my preferences.

Now report is opening in the same tab of application.

How can I modify it so that report shall open in new tab.

Any ideas?

Go to forum: Reporting

611 Reply by boxygen

(45 replies, posted in Modules Add-on's)

Thats great I will test it and will respond.

Go to forum: Modules Add-on's

612 Topic by boxygen

(0 replies, posted in FA Modifications)

On Sales Order Entry Form the Line Discount is in Percentage. I want to add another text box that should take input the Line Discount as Absolute Value.

Upon Lost Focus of that Text Box the Discount Percentage is automatically calculated and updated in the Discount Percentage Box through Javascript.

Can any one help me in that regard?

1. From where can I add another text box?
2. From where can I configure the Javascript code to update Percentage Box through Absolute Value Discount.

Regards.

Go to forum: FA Modifications

613 Reply by boxygen

(45 replies, posted in Modules Add-on's)

By the way while installing with 2.4RC1 I am receiving following error.

Package 'Payroll' is incompatible with current application version and cannot be activated. Check Install/Activate page for newer package version.

With 2.3.25 it installed successfully but had problem in accessing pages.

Go to forum: Modules Add-on's

614 Reply by boxygen

(45 replies, posted in Modules Add-on's)

Oh yes I installed with 2.3.25.

I think 2.4 doesn't have stable release till now. Shouldn't you have it for 2.3.25 as well?

Regards

Go to forum: Modules Add-on's

615 Reply by boxygen

(45 replies, posted in Modules Add-on's)

I installed this extension. It is giving following errors on all pages

Undefined property: sys_prefs::$use_popup_windows in file: D:\xampp\htdocs\boxygen\modules\Payroll\emp_payslip.php at line 24
Call to undefined function user_use_date_picker() in D:\xampp\htdocs\boxygen\modules\Payroll\emp_payslip.php on line 26

Go to forum: Modules Add-on's

616 Reply by boxygen

(36 replies, posted in FA Modifications)

Any help expected @anoopmb?

Go to forum: FA Modifications

617 Topic by boxygen

(1 replies, posted in Report Bugs here)

I am getting this error today while few days back it was working perfectly.

I have checked in Chrome as well as firefox.

Any Idea?

Go to forum: Report Bugs here

618 Reply by boxygen

(25 replies, posted in Reporting)

@apmuthu there is a logical bug in this modification. It multiplies the display on report times the number of branches. If a Customer has 2 Branches then its information will be displayed 2 times and if it has 3 branches then its info will be displayed 3 times. on the same report

http://prntscr.com/dyra0n

You can check the screen shot

Go to forum: Reporting

619 Reply by boxygen

(3 replies, posted in FA Modifications)

The process you suggested is by default process of front accounting but I have a customized need to record a payment without leaving invoice form.

I have added a text box on order entry form and added a custom coded defined above but having issues in calling the recovery text box value in that custom code

Go to forum: FA Modifications

620 Reply by boxygen

(25 replies, posted in Reporting)

Your File Giving Following Errors

DATABASE ERROR : The customers could not be retrieved
error code : 1054
error message : Unknown column 'debtors_master.debtor_no' in 'field list'
sql that failed was : SELECT debtors_master.debtor_no, debtors_master.name, debtors_master.curr_code FROM 1_debtors_master INNER JOIN 1_cust_branch ON debtors_master.debtor_no=cust_branch.debtor_no INNER JOIN 1_areas ON cust_branch.area = areas.area_code INNER JOIN 1_salesman ON cust_branch.salesman=salesman.salesman_code WHERE salesman.salesman_code='1' ORDER BY name

Go to forum: Reporting

621 Topic by boxygen

(3 replies, posted in FA Modifications)

I am trying to add a Field Recovery on Cash Invoice. Sometimes while recording a cash invoice we are also receiving some outstanding recovery against previous invoices. I am trying to add a option that payment recorded at Invoice Screen shall create a Customer Payment

<a href="http://prntscr.com/dl88p5">Click Here to View the Screen</a>

Then I added following lines of code in /sales/includes/db/sales_invoice_db.inc on Line 183 onwards

        global $water_business;
        $recovery=100;//$invoice->recovery;
        if ($water_business)
            write_customer_payment(0, $invoice->customer_id,
                $invoice->Branch, $invoice->pos['pos_account'], $date_,
                $Refs->get_next(ST_CUSTPAYMENT), $recovery, 0,
                _('Cash invoice').' '.$invoice_no);


Now I need to know how to pass the value in the Recovery Filed till here. I am not very good at php so I don't know how to change the /sales/includes/cart_class.inc

I also need to save this information in a field recovery in sales_orders table. That I will create a field there.

@apmuthu Can you help me?

Go to forum: FA Modifications

622 Reply by boxygen

(36 replies, posted in FA Modifications)

I am using your auto complete in 2.3.25

Please suggest any changes to make it usable in 2.4 as well

Go to forum: FA Modifications

623 Reply by boxygen

(36 replies, posted in FA Modifications)

Can anyone help with this Auto Complete in 2.4?

Go to forum: FA Modifications

624 Reply by boxygen

(29 replies, posted in Wish List)

Hello @apmuthu What is this ISN shown in the image? Is this something similar to batch number? I can't find it in the 2.3.25. Is it in 2.4

Regards.

Go to forum: Wish List

625 Reply by boxygen

(25 replies, posted in Reporting)

apmuthu wrote:

In @dz's post no. 6 in this thread, please correct the function invocation "zone_cells" to be "zone_list_cells" to match the "function zone_row" definition above it.

You are right however for this report only zone_list function is used.

apmuthu wrote:

Also, compare your "rep102.php" with the current master file as it has been corrected in 4 places that does not reflect in your post - you may be using a dated version. See lines 44 and 49 to 51 in the said file for changes.

Is there any log where I can keep checking for any modifications in Master Files or I can Subscribe to changes notifications?

Go to forum: Reporting