@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
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by dearmosin
@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
@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
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
@apmuthu can the above query be included in English Indian COA - New
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
@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
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
@paul your welcome
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.
If you want to add new CLP currency
Go To
Banking & General Ledger
Under Maintenance - Currency
@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
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.
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
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";
FrontAccounting forum → Posts by dearmosin
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.