201 Reply by notrinos

(13 replies, posted in Report Bugs here)

Google finance API does not work anymore, should we stop chasing their updates ? neutral

Go to forum: Report Bugs here

202 Reply by notrinos

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

Updated with new custom reports: commit

Go to forum: Modules Add-on's

203 Topic by notrinos

(4 replies, posted in Report Bugs here)

If we make purchase or produce a work order for an items while quantity on hand of this items is zero then item's material cost will be replaced by last transaction's price.
This is not causing overall problems but makes  a small issue which can be seen in Inventory Dashboard:
-Top 10 sold Items shows sold item's cost but in the mentioning case this cost is being constituted by the last items cost that have not been sold.

Why is this important ? In single unit production the price (material cost) of products is rarely the same, even change with large amplitude between orders

I would like to propose new calculation that calculates a more realistic costs for manufacturing items:

lines 106 - 107 of work_order_costing_db.inc should be :

if ($qty > 0 && ($qoh != -$qty)) {
    if($qoh == 0 && $avg_cost != 0)
        $avg_cost = ($avg_cost + ($unit_cost*$qty_new)/($qoh+$qty))/2;
    else
        $avg_cost = ($avg_cost*($qoh+$qty_delayed)+$unit_cost*$qty_new)/($qoh+$qty);
}

Go to forum: Report Bugs here

204 Reply by notrinos

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

Yes, sorry I misunderstood your point replacing the whole module not the module name only

Go to forum: Modules Add-on's

205 Reply by notrinos

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

@kvvaradha
Did you test your method ?
as I know function init() of class front_accounting calls all build-in modules before custom modules so the module name of AP (Purchases) will show before the Kvcodes module can change anything.

Go to forum: Modules Add-on's

206 Reply by notrinos

(12 replies, posted in Report Bugs here)

one more record is missing for table wo_manufacture

INSERT INTO `0_wo_manufacture` VALUES (1, '001/2017', 1, 2, '2017-05-05');

Go to forum: Report Bugs here

207 Reply by notrinos

(12 replies, posted in Report Bugs here)

@Joe
No, the mentioned table is 0_stock_moves not the workorders table.

Go to forum: Report Bugs here

208 Topic by notrinos

(12 replies, posted in Report Bugs here)

In en_US-demo.sql line 1947, unit cost of item 202 should be 360 instead of 0

So this line needs to be replaced with:

('10', '1', '201', '26', 'DEF', '2017-05-05', '0', '001/2017', '2', '360'),

Go to forum: Report Bugs here

209 Reply by notrinos

(4 replies, posted in Accounts Payable)

Set Customer discount can meet your requirement.

Go to forum: Accounts Payable

210 Reply by notrinos

(3 replies, posted in Manufactoring)

You seem to be talking about single-unit production, which has variable BOM per unit ?

Go to forum: Manufactoring

211 Reply by notrinos

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

Added options for department based salary basic account which has been mentioned on post #34.
Now FrontHrm can be useful on countries with this accouting practice
These options added without eliminate the current accounting method.

https://github.com/notrinos/FrontHrm

Go to forum: Modules Add-on's

212 Reply by notrinos

(13 replies, posted in Report Bugs here)

Line 153 has an extra semicolons

Go to forum: Report Bugs here

213 Topic by notrinos

(13 replies, posted in Report Bugs here)

Google currency converter url has been changed to finance.google.com/bctzjpnsun/converter?a=1&from=USD&to=EUR

So lines 153 and 221 of gl_db_rates.inc should be:

153 $filename = "/bctzjpnsun/converter?a=1&from={$curr_a}&to={$curr_b}";
221 $filename = "/bctzjpnsun/converter?a=1&from={$curr_b}&to={$curr_a}";

Go to forum: Report Bugs here

214 Reply by notrinos

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

I think contact the API author should be better than finding a wiki
Andrés Amaya

Go to forum: Modules Add-on's

215 Reply by notrinos

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

Not updated @mnhpiash

Can you give suggestions for this feature ? How will we arrange things on attendance view, and then how will user manipulate new process... ?

Actually I am a bit busy now but if someone helps for user request then I can generate codes faster.

Welcome your suggestions smile

Go to forum: Modules Add-on's

216 Reply by notrinos

(8 replies, posted in FA Modifications)

This theme may be a good reference for your scheme
https://drive.google.com/file/d/0B4ARYK … sp=sharing

Go to forum: FA Modifications

217 Reply by notrinos

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

Check all Human Resource security areas in Setup -> Access Setup for your user access role then logout and login.

Go to forum: Modules Add-on's

218 Reply by notrinos

(8 replies, posted in Reporting)

I mean choose paper size on browser when printing, like this
https://imgur.com/8EWm4Z1

Go to forum: Reporting

219 Reply by notrinos

(8 replies, posted in Reporting)

Why don't you change paper size on your Browser

Go to forum: Reporting

220 Reply by notrinos

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

There is an important thing is accounting rule in several countries stipulate that salary of different departments must be accounted into different accounts

example:

                           Accounting for Sales department          for Production department
                           ------------------------------------------------------------------
                             Debit           Credit                  Debit            Credit
5710 - sales expenses       1000.00         
5120 - production labor                                             1000.00
2100 - accounts payable                     1000.00                                  1000.00

I'm planning to change FrontHrm payroll basic account based on department but done this would eliminate the current method - salary scale based accounting
So the question is:
Is the current method useful ? Should we replace it with Department based accounting method ?

Go to forum: Modules Add-on's

221 Reply by notrinos

(40 replies, posted in Translations)

The simplest is edit the es_MX.po

You can find in this somthing like 

msgid "Start installation process"
msgstr ""

Just enter your translations to double quotes, example:

msgid "Start installation process"
msgstr "Comience el proceso de instalación"

Do the same with all strings and post you completed po file here then FA chiefs will implement it to next release

Go to forum: Translations

222 Reply by notrinos

(9 replies, posted in Report Bugs here)

No one has caught this problem because this function update_journal() has never been used in any where.
Don't know whether to be happy or sad neutral

Go to forum: Report Bugs here

223 Reply by notrinos

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

@Rmendes

FrontHrm now can be installed for companies those don't have Prefix in their tables : Commit

Go to forum: Modules Add-on's

224 Reply by notrinos

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

@mnhpiash

Thanks for your suggetions about leave with and without pay, it will be implemented later (maybe next month).

Attendance input now allows integer numeric values and can be updated.

Go to forum: Modules Add-on's

225 Reply by notrinos

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

@Rmendez

I have tested install FrontHrm on fresh FA2.4.4 pack and got no problems.

Based on your problem description tables were not created I guess you installed FA without Prefix

Please try to install new FA2.4.4 with table s prefix then install FrontHrm and see if your problem persists or not

Remember to choose Use '0_' Table Prefix during installation, like this image

Go to forum: Modules Add-on's