@barbarian - he also don't know when the entries are created. Because all of them are auto created. This entries created by the update average cost method. This issue was fixed from 2.4 onwards. So you can compare code between the two version and get it
576 05/22/2019 07:22:20 am
Re: Items Cost in negative in inventory sales report (35 replies, posted in Items and Inventory)
577 05/22/2019 07:19:29 am
Re: Items Cost in negative in inventory sales report (35 replies, posted in Items and Inventory)
@zia - you just removed the affected entries. Next you need to update the standard cost for that item. , Than your issues will be fixed.
578 05/21/2019 04:10:30 pm
Re: Items Cost in negative in inventory sales report (35 replies, posted in Items and Inventory)
Yes. this issue will be fixed,if you update to new FA. it was Average cost method issue. and manually, you can remove these entries or you void such a cost update entries. thats the fix for this situation. may be @apmuthu or @joe can provide any other simple solution, lets check their words before following my steps.
579 05/20/2019 05:43:44 pm
Re: Items Cost in negative in inventory sales report (35 replies, posted in Items and Inventory)
look in GL inquries or check in gl_trans table. You might able to see a "Cost Update" entry which causes this abnormal values in average cost. Similarly i faced such an issue. But it was happened like 2.4,2 or earlier version. also specifi your version to trace the issue,
580 05/20/2019 05:39:26 pm
Topic: Uncaught TypeError: found[k].className.match is not a function (8 replies, posted in Report Bugs here)
This error occurs, when we select items ,or customers from the drop down on the invoice page. Sometimes it comes after login. looks like a core level js issue. needs to be identified. why it comes sometimes.
looking developers opinion to identify the issue exactly.
Full error details.
Uncaught TypeError: found[k].className.match is not a function
at HTMLDocument.document.getElementsBySelector (behaviour.js:25)
at Object.apply (behaviour.js:6)
at utils.js:24
at JsHttpRequest.req.onreadystatechange (JsHttpRequest.js:84)
at JsHttpRequest.t._changeReadyState (JsHttpRequest.js:71)
at JsHttpRequest.t._dataReady (JsHttpRequest.js:50)
at Function.JsHttpRequest.dataReady (JsHttpRequest.js:88)
at Function.JsHttpRequest._tmp (eval at xr.onreadystatechange (JsHttpRequest.js:104), <anonymous>:1:1237)
at XMLHttpRequest.xr.onreadystatechange (JsHttpRequest.js:106)
581 05/17/2019 02:46:11 pm
Re: Writing Arabic in Fields with English User (5 replies, posted in Translations)
@joe- it's better we can add this change to core. People can write any language in input field
582 04/29/2019 04:28:29 pm
Re: Default Theme Redesigned And available For testing (47 replies, posted in Modules Add-on's)
@poncho1234: Yes, it is @kvvaradha's theme from the link he provided. If your PuroV1 is elsewhere, please provide the link.
@kvvaradha: I tested out on 1440x900 and had to scroll.
may i know which page you have to scroll to see end.
583 04/27/2019 05:05:03 pm
Re: Default Theme Redesigned And available For testing (47 replies, posted in Modules Add-on's)
I have increased both font size and space for the rows and columns. Because now a days we can see most of them has good screen size for desktop. If you open this with big ! monitor you can see them in a small space. So In my default theme I gave some extra space as well as changed the Colors to black and white for better look.
584 04/23/2019 03:25:28 am
Re: sales_order_ui.inc has a bug (13 replies, posted in Report Bugs here)
For me it works fine. If you face problem with this. find a better solution for it. we will adapt to your solutions. I tested it on Linux and Windows. Both works fine for me
585 04/22/2019 07:44:18 am
Re: removing a company messes up the system (9 replies, posted in Installation)
We better add a checkbox there, if its checked, we can remove the tables . else we will leave the tables without deleting them.
586 04/22/2019 05:42:50 am
Re: removing a company messes up the system (9 replies, posted in Installation)
@peacecop kalmer: I had several testing with your way of company creations. Looks like if you used same database, for the all companies, the deleted company data's will be erased. If you tried in shared hosting or limited resource hosting, it may failed to complete the delete process. Also the first company, you cant delete it. thats main company.
For this case, you can go with fresh install, and go with Swedish fresh COA from the begining. So it can be good to use, Always go with separate database for new companies.
@apmuthu, There is a program drawback, if you use the same database for second company,it removes the tables. and if its new database, then the tables keep it.
We should think which one is right and we have to either allow delete tables, even if its new company. or keep the tables even if it uses the same database.
@joe,write your opinion here,
587 04/22/2019 05:26:53 am
Re: Translating to nl_NL (8 replies, posted in Translations)
@joe- Update it on Core, People can use it from our new versions.
588 04/22/2019 05:25:24 am
Re: Delete old customers (8 replies, posted in Accounts Receivable)
@apmuthu, each transaction has debtor number and branch no. So thats unnecessary condition i feel. If the customer doesnot have any transactions, we can skip the branch validation and delete customer, contact, branch contact, branch and finally customer.
589 04/22/2019 05:22:15 am
Re: sales_order_ui.inc has a bug (13 replies, posted in Report Bugs here)
@joe, Yes you are right.
As like @Apmuthu words, it rolls back to the last item sold to the customer. we are not able to change the item to sell. But we can try this option.it may be fessible to work on.
We will put an if condition, if the stock_id is not exist, we can get the last_sales_order_detail,like this, here is code
if ($order->fixed_asset)
stock_disposable_fa_list_cells(null,'stock_id', null, _('[Select item]'), true, $order->line_items);
else{
if(!isset($_POST['stock_id'])){ // Check the stock id not exist
$_POST['stock_id'] = last_sales_order_detail($order, 'stk_code'); //get the llast sales stock id.
}
sales_items_list_cells(null,'stock_id', last_sales_order_detail($order, 'stk_code'), false, true, true);
}
if (list_updated('stock_id')) {
$Ajax->activate('price');
$Ajax->activate('units');
$Ajax->activate('qty');
$Ajax->activate('line_total');
}
Hope this may be fixed the problem.
if not, we remove the function from sales_order_d.inc last_sales_order_detail. It was defined there. and keep the sales item list cells like this
sales_items_list_cells(null,'stock_id', null, false, true, true);
590 04/21/2019 11:26:18 am
Re: Delete old customers (8 replies, posted in Accounts Receivable)
@joe - Why do we check branch to delete a customer. May if the customer has more than one branch. We should prevent deleting. Also we can allow them to delete a customer who has no sales transactions whatever the branches he has.
Because sometimes for testing purpose our users creating Customer. Than if they try to delete it will ask them to remove branches and than we have to delete it.
As of customer delete from the add manage customers it works fine by checking of existing transactions except the branch validation
591 04/21/2019 11:09:16 am
Re: sales_order_ui.inc has a bug (13 replies, posted in Report Bugs here)
@joe ,sorry for my mistake.
the code should be like this.
if ($order->fixed_asset) stock_disposable_fa_list_cells(null,'stock_id', null, _('[Select item]'), true, $order->line_items); else sales_items_list_cells(null,'stock_id', last_sales_order_detail($order, 'stk_code'), false, true, true); if (list_updated('stock_id')) { $Ajax->activate('price'); $Ajax->activate('units'); $Ajax->activate('qty'); $Ajax->activate('line_total'); }
By mistake i put in else part of list_updated.
@joe - here I gave the same code exactly what he committed there. So you can update it.
592 04/18/2019 03:21:35 pm
Re: Journal entries always have a blank Person/Item (5 replies, posted in Banking and General Ledger)
It can be used. If you record the customer payment. Supplier payouts or inventory adjustment. It will be used. When you see in journal entry form. You can see country party if you select "Accounts Receivable".
It can be used.
593 04/16/2019 12:16:31 am
Re: Second company does not create security roles records (5 replies, posted in Report Bugs here)
It depends on the COA . Which COA did you choose while creating new company. Based in that the issue can be fixed
594 04/14/2019 06:27:52 am
Topic: user_list_cells Real name sometimes shows empty (3 replies, posted in FA Modifications)
Yes the real name is sometimes empty, users may skip to input real name, because its not mandatory, Incase if they didnt input, the user_list_cells function will be showing an empty list. so lets change the query to be like this.
$sql = " SELECT user_id, IF(real_name = ' ', user_id, real_name) FROM ".TB_PREF."users";
suppose if the real name empty, it will show the user_id in it. which will avoid confusions
595 04/13/2019 11:03:23 am
Re: Upgrading (27 replies, posted in Installation)
You may be in the main menu section. Try to open sub module pages like direct invoice. It will prompt the message. Or you can directly goto setup-> software updates. There you can see update option available
596 04/13/2019 11:00:07 am
Re: unnecessary function inside sales_order_db.inc (4 replies, posted in Report Bugs here)
@Braath waate,
You found it where ist was called. I didn't spend time to know it.
@joe mistakes may happen, nothing to worry. Its not that much needy function.
597 04/13/2019 01:41:10 am
Re: Bar codes - scanning, printing, recording and generating (3 replies, posted in Items and Inventory)
For your all questions. The answer is "Yes". The barcode can be generated from the Items page as well as sales kit page.
But printing of barcode you have to program separately to take barcode out patch it on products.
598 04/12/2019 04:36:04 pm
Topic: unnecessary function inside sales_order_db.inc (4 replies, posted in Report Bugs here)
We have an unused function inside sales_order_db.inc
function name last_sales_order_detail
599 04/12/2019 03:21:17 pm
Re: Upgrading (27 replies, posted in Installation)
@tom - I forget the reason for it. But all these steps will help you to update database.if yoy have backup. Then go with test instance and try them.
600 04/10/2019 02:45:14 am
Re: Upgrading (27 replies, posted in Installation)
Not phpmyadmin
it's all through FA.