@notrinos as Payroll & Human Resource Management is going to come built-in in 2.5

Reference: https://frontaccounting.com/punbb/viewtopic.php?id=8137
Post: 1

What will happen to salesman table, will it use reference from employee table?

Regards

27

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

@flpages this Tax Setup Is Just For India Which Have Complex Taxation Method

For Example:

A product purchase from other state is tax with IGST, which is sold within business state and tax with CGST and SGST

A product purchase from other state is tax with IGST, which is sold in other state and tax with IGST

A product purchase within business state is tax with CGST and SGST, which is sold in other state and tax with IGST

A product purchase within business state is tax with CGST and SGST, which is sold in business state and tax with CGST and SGST

CGST + SGST = IGST
i.e. CGST = IGST/2 & SGST = IGST/2

All Input Tax Are Accumulated in GL Account Code 2050 - 2061
All Output Tax Are Accumulated in GL Account Code 2000 - 2011

Here we need two Tax Group one for business state and another for other state.

If we put same account for Sales & Purchase in Tax Type, it will be more confusing. Since same account code can't we used multiple time in FA for Tax Type. And has to be Under 3 Account Code for each tax type.

Problem behind this 2 type of tax on same product, depending upon state in which goods is sold.

The main focus of solution is to use FA as it is, without messing core. We can create extension custom report to deal with tax compliance.

Regards

28

(1 replies, posted in Setup)

GST on shipping is possible in FA

Setup GST - With reference post 8 in
https://frontaccounting.com/punbb/viewtopic.php?id=7770

Setup - Tax Group
In Shipping Tax Column Select Appropriate Tax For Shipping

29

(3 replies, posted in Setup)

@apmuthu can the above query be included in English Indian COA - New

30

(3 replies, posted in Setup)

Banking and General Ledger - Currencies

Currency Abbreviation: INR
Currency Symbol: Rs. or INR
Currency Name: Indian Rupees
Hundredths Name: Paise
Country: India

If you really need ₹ as only option then open phpmyadmin select table 0_currencies under SQL write this query and GO

Please Note: 0_ is the default prefix of primary company. Replace with your company's prefix.

ALTER TABLE 0_currencies MODIFY COLUMN curr_symbol VARCHAR(10)
    CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

Now Try Inserting ₹ symbol, it must get updated

31

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

@apmuthu - Here Is MYSQL Query For English Indian COA - New

https://mpulse.in/public/FA_indian_tax_dearmosin.txt

Since _last is set with e.selectedIndex before making ajax request. If ajax fails input value are not populated with data. but selected drop down option is e.selectedIndex. This can result in data loss or data overwrite on records.

Mantis Bug Tracking For This Issue - http://mantis.frontaccounting.com/view.php?id=5201

34

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

My approach in creating setup for Indian Tax System in FA

Step by Step Procedure

https://mpulse.in/images/FA_indian_tax_setup.jpg

@apmuthu can you please include this approach in English Indian COA - New. for Indian GST

Regards

35

(5 replies, posted in Accounts Receivable)

@paul your welcome

36

(5 replies, posted in Accounts Receivable)

If you are sure you have delivered sales order, then it should be in

Invoice Against Sales Delivery

If you can't find it there, try changing from date some month back and to date as today's date and search. It might be possible your transaction date is not between date range which may be preventing you displaying pending Not Invoiced Deliveries.

37

(1 replies, posted in Setup)

If you want to add new CLP currency

Go To

Banking & General Ledger

Under Maintenance - Currency

38

(5 replies, posted in Reporting)

@apmuthu I have already created report in Indian GST format here is sample output file

Tax Invoice
https://mpulse.in/doc/D-386-2020.pdf

Payment Receipt
https://mpulse.in/doc/CP-181-2020.pdf

In inserts.js I found this line 142

            if ((this.selectedIndex != this.getAttribute('_last'))
                ||((string_contains(this.className, 'combo') || string_contains(this.className, 'combo3')) && _update_box(this))
                )

should it be

            if ((this.selectedIndex != this.getAttribute('_last'))
                && ((string_contains(this.className, 'combo') || string_contains(this.className, 'combo3')) && _update_box(this))
                )

Also

e.setAttribute('_last', e.selectedIndex);

must be set after JsHttpRequest.request(update) request is completed

You are correct, anyways thanks for your help. Let me see if I can work this out.

Thanks for your reply Braath Waate

I have read the thread your mentioned above

to retry is good option but if retry fail as per code

                if(retry)
                    JsHttpRequest._request(trigger, form, tout, retry-1);
                else location.reload(true);

this will refresh page as this failing process will be happening in background, to see page refreshing without knowing error will make user worried about what is happening. Further it will clear all fields including selected customer/supplier/inventory option.

Warning Indicator is seen only when there is ajax error so user is aware something is wrong. Further I have noticed for example there are

OPTION A
OPTION B
OPTION C

user first selected OPTION A ajax call is made and failed mean while user has already selected OPTION C during ajax process. Now user want details of OPTION C not OPTION A

Reload button after ajax fail will eliminate this issue. Now when user will click reload only details of selected option will be populated into input fields.

Regards

Hello Everyone

When select onchange ajax request fail on dropdown menu in customer/supplier/inventory. When we get see warning triangle, the selected customer/supplier/inventory is different from populated input field. To get the correct data we have to change customer/supplier/inventory to other value then back to previous value.

Here is screenshot example
https://mpulse.in/images/FA_feature_suggestion.jpg

In the above example while selecting customer Keshav Enterprise my ajax request failed. The input field below are populated with previous selected user which is K.K. Enterprises. Now to get details of Keshav Enterprises We have to select some other customer then again Keshav Enterprises.

It would be appreciated, if reload button with onclick ajax function to populate the input field could be added beside warning triangle .

Thanks and Regards

While creating new customer -> sales type / pricelist field value must be inserted in customer branch -> group field.

Try creating new customer xyz and select sales type / pricelist save customer. New Customer and Branch is create. Now browse customer branch select xyz customer. Here you will see group field is not updated with value of sales type / pricelist.

While creating a new customer Sales Type/Price List field does not insert value into database. We have to update it into branch again.

Manufacturing/Bills Of Material component search magnifying glass icon is not opening popup window linking

inquiry/stock_list.php

My company setting is $SysPrefs->print_invoice_no() is FALSE

HOW TO PRODUCE THIS ERROR
I tried voiding invoice and then created invoice with same reference number which I voided earlier. When I try to print invoice it is displaying two invoice with same reference in drop-down

SOLUTIONS
in reporting/includes/reports_classes.inc I made these changes to prevent voided invoice displaying in print invoice section

                case 'INVOICE':
                    $IV = $type_shortcuts[ST_SALESINVOICE];
                    $ref = ($SysPrefs->print_invoice_no() == 1 ? "trans_no" : "reference");
                    $sql = "SELECT concat(debtor_trans.trans_no, '-', debtor_trans.type) AS TNO,
                                concat('$IV ', debtor_trans.$ref,' ', debtor.name) as IName
                        FROM ".TB_PREF."debtors_master debtor,"
                            .TB_PREF."debtor_trans debtor_trans
                        WHERE type=".ST_SALESINVOICE." AND debtor.debtor_no=debtor_trans.debtor_no AND version = 0
                        ORDER BY debtor_trans.trans_no DESC";
                    return combo_input($name, '', $sql, 'TNO', 'IName',array('order'=>false));

In where clause I just added  AND version = 0

47

(1 replies, posted in Report Bugs here)

When we try to make payment amount greater than Left to Allocate

FA fails to insert new row into cust_allocations, I also I have found debtor_trans column alloc is not updated with new value.

48

(5 replies, posted in Reporting)

You need to edit rep114.php to achieve this, but creating a custom report is always a good idea. I am using TCPDF for my custom reports, my rep114.php looks as shared in screenshot below

Screenshot rep114.php

https://imge.to/i/Ge5RC

You can use

Reports and Analysis -> Customer -> Customer Trail Balance

Use Sales Folk to filter salesman wise balance

50

(2 replies, posted in Reporting)

Salesman Listing Report 106

while fetching salesman listing report current sql query is conflicting with order_no displaying mismatch data. I have fix this adding AND sorder.trans_type = 30 to correct this issue.

    $sql = "SELECT DISTINCT trans.*,
            ov_amount+ov_discount AS InvoiceTotal,
            cust.name AS DebtorName,
            cust.curr_code,
            branch.br_name,
            sorder.customer_ref,
            salesman.*
        FROM ".TB_PREF."debtor_trans trans,
             ".TB_PREF."debtors_master cust,
             ".TB_PREF."sales_orders sorder,
             ".TB_PREF."cust_branch branch,
            ".TB_PREF."salesman salesman
        WHERE sorder.order_no=trans.order_
            AND trans.branch_code=branch.branch_code
            AND sorder.trans_type = 30
            AND branch.salesman=salesman.salesman_code
            AND trans.debtor_no=cust.debtor_no
            AND (trans.type=".ST_SALESINVOICE." OR trans.type=".ST_CUSTCREDIT.")
            AND trans.tran_date>='$fromdate'
            AND trans.tran_date<='$todate'
        ORDER BY salesman.salesman_code, trans.tran_date";