Menu
▾
▴
web-erp-developers — Discussion on development of webERP
You can subscribe to this list here.
| 2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(20) |
Aug
(21) |
Sep
(12) |
Oct
(2) |
Nov
|
Dec
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 |
Jan
(3) |
Feb
(46) |
Mar
(65) |
Apr
(49) |
May
(33) |
Jun
(5) |
Jul
(79) |
Aug
(228) |
Sep
(347) |
Oct
(272) |
Nov
(270) |
Dec
(424) |
| 2005 |
Jan
(549) |
Feb
(232) |
Mar
(134) |
Apr
(103) |
May
(57) |
Jun
(74) |
Jul
(67) |
Aug
(45) |
Sep
(99) |
Oct
(187) |
Nov
(238) |
Dec
(127) |
| 2006 |
Jan
(81) |
Feb
(137) |
Mar
(46) |
Apr
(55) |
May
(62) |
Jun
(152) |
Jul
(137) |
Aug
(154) |
Sep
(176) |
Oct
(104) |
Nov
(65) |
Dec
(64) |
| 2007 |
Jan
(56) |
Feb
(303) |
Mar
(88) |
Apr
(80) |
May
(72) |
Jun
(20) |
Jul
(47) |
Aug
(28) |
Sep
(113) |
Oct
(49) |
Nov
(89) |
Dec
(24) |
| 2008 |
Jan
(24) |
Feb
(61) |
Mar
(43) |
Apr
(51) |
May
(12) |
Jun
(10) |
Jul
(49) |
Aug
(26) |
Sep
(7) |
Oct
(50) |
Nov
(19) |
Dec
(15) |
| 2009 |
Jan
(87) |
Feb
(144) |
Mar
(54) |
Apr
(72) |
May
(32) |
Jun
(23) |
Jul
(27) |
Aug
(90) |
Sep
(349) |
Oct
(174) |
Nov
(320) |
Dec
(110) |
| 2010 |
Jan
(162) |
Feb
(39) |
Mar
(80) |
Apr
(126) |
May
(45) |
Jun
(44) |
Jul
(75) |
Aug
(32) |
Sep
(100) |
Oct
(57) |
Nov
(49) |
Dec
(125) |
| 2011 |
Jan
(72) |
Feb
(41) |
Mar
(63) |
Apr
(18) |
May
(123) |
Jun
(100) |
Jul
(96) |
Aug
(84) |
Sep
(83) |
Oct
(39) |
Nov
(166) |
Dec
(103) |
| 2012 |
Jan
(158) |
Feb
(148) |
Mar
(77) |
Apr
(43) |
May
(126) |
Jun
(82) |
Jul
(67) |
Aug
(28) |
Sep
(109) |
Oct
(30) |
Nov
(23) |
Dec
(34) |
| 2013 |
Jan
(14) |
Feb
(16) |
Mar
(7) |
Apr
(79) |
May
(76) |
Jun
(13) |
Jul
(76) |
Aug
(36) |
Sep
(22) |
Oct
(35) |
Nov
(167) |
Dec
(93) |
| 2014 |
Jan
(64) |
Feb
(14) |
Mar
(57) |
Apr
(63) |
May
(60) |
Jun
(15) |
Jul
(24) |
Aug
(19) |
Sep
(56) |
Oct
(70) |
Nov
(45) |
Dec
(52) |
| 2015 |
Jan
(56) |
Feb
(73) |
Mar
(34) |
Apr
(11) |
May
(24) |
Jun
(19) |
Jul
(11) |
Aug
(8) |
Sep
(25) |
Oct
(22) |
Nov
(38) |
Dec
(7) |
| 2016 |
Jan
(7) |
Feb
(34) |
Mar
(17) |
Apr
(10) |
May
(17) |
Jun
(7) |
Jul
(17) |
Aug
(31) |
Sep
(3) |
Oct
(34) |
Nov
(5) |
Dec
(2) |
| 2017 |
Jan
|
Feb
(4) |
Mar
(18) |
Apr
(6) |
May
(10) |
Jun
(13) |
Jul
|
Aug
|
Sep
|
Oct
(6) |
Nov
|
Dec
(1) |
| 2018 |
Jan
(2) |
Feb
|
Mar
(3) |
Apr
(10) |
May
(5) |
Jun
|
Jul
(7) |
Aug
|
Sep
(2) |
Oct
|
Nov
|
Dec
(2) |
| 2019 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2020 |
Jan
|
Feb
|
Mar
|
Apr
(2) |
May
|
Jun
|
Jul
(6) |
Aug
(2) |
Sep
(4) |
Oct
|
Nov
|
Dec
(3) |
| 2021 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(3) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(2) |
| 2022 |
Jan
(2) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2023 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
|
| 2024 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(30) |
Nov
|
Dec
(2) |
|
From: ExsonQu <hex...@gm...> - 2016-01-14 10:24:10
|
*Hi, Richard,*
There is little chance for this confusion. But I am not sure.
Let me think about it again.
Best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Bug-in-GLAccountInquiry-tp4658408p4658470.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.
|
|
From: Pak R. <pak...@gm...> - 2016-01-13 03:39:30
|
Hi Exson:
Thanks for your reply. I already commited the correction of line 214 of
PCAuthorizeExpenses.php
Anyway, I'm afraid this bug has more consequences than the detected mess in
your mod, as in line 202 we were getting the next transno for type = 2, but
we were saving it into DB as type = 1.
So, some rows of banktrans table will have type = 1 and the same transno
but they have nothing in common, so info extracted from banktrans can't be
trusted 100% if Petty Cash Module has been used
Not sure if we can get a way to "un-mess" the data, without getting more
orphaned info
Update manually systype so transno for type = 2 is higher than type 1 or 2.
SELECT all rows in banktrans with texts "Petty cash" AND "ASSIGNCASH"
For every row
get a new transno for type = 2
update the row with type = 2 and new transno
endfor
I'm sorry for this mess. It affects all Assign cash transactions recorded
since the beggining of the Petty Cash Module, in 2.010.
Regards,
Ricard
2016-01-13 10:23 GMT+08:00 ExsonQu <hex...@gm...>:
> *Hi, Richard,*
>
> Thank you for the reply.
>
> Yes, I think it should be type 2 instead of type 1. Otherwise,
> we can not retrieve a correct data. And the feature is only constraint to
> bank accounts now.
> I've fixed the variables non refresh bug and commit to trunk.
> The your previous data still can not show correctly due to the transaction
> type mismatch -:).
>
> Thanks and best regards!
>
> Exson
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Bug-in-GLAccountInquiry-tp4658408p4658465.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
|
|
From: ExsonQu <hex...@gm...> - 2016-01-13 02:45:12
|
*Hi, Richard,*
Thank you for the reply.
Yes, I think it should be type 2 instead of type 1. Otherwise,
we can not retrieve a correct data. And the feature is only constraint to
bank accounts now.
I've fixed the variables non refresh bug and commit to trunk.
The your previous data still can not show correctly due to the transaction
type mismatch -:).
Thanks and best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Bug-in-GLAccountInquiry-tp4658408p4658465.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.
|
|
From: Pak R. <pak...@gm...> - 2016-01-12 09:32:14
|
Hi Exson: Thanks for your fast reply. Type = 2 (Recepit-GL). This is the gltrans records for 1 of them [image: Imatge inserida 1] I also run: SELECT * FROM `gltrans` WHERE `type` = 2 AND `typeno` = 8365 and the result are exactly the same 2 rows I'm afraid the problem comes from banktrans table, as PC tabs do not record banktrans transactions except when it's an "assigncash" movement and it records the bank account source of the funds transferred to the PC tab (as in this examples I used), using the type = 1 I coded the Petty Cash long time ago, and can't remember any problem with this, but probably the PCAuthorizeExpenses.php line 214 should read a 2 instead of 1. Please confirm if this makes sense to you. P.S.: It seems weird how such a simple and obvious bug slipped so many eyes during so many years ;-) Regards, Ricard 2016-01-12 16:02 GMT+08:00 ExsonQu <hex...@gm...>: > *Hi, Richard,* > > Thank you for your feedback. > I think the error is caused partially due to the last variable > not be refreshed. But there is other problem for this. What is the > transaction type of 8365 and 8367? > > Thanks and best regards! > > Exson > > > > -- > View this message in context: > http://weberp-accounting.1478800.n4.nabble.com/Bug-in-GLAccountInquiry-tp4658408p4658461.html > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > Site24x7 APM Insight: Get Deep Visibility into Application Performance > APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month > Monitor end-to-end web transactions and take corrective actions now > Troubleshoot faster and improve end-user experience. Signup Now! > http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > |
|
From: ExsonQu <hex...@gm...> - 2016-01-12 08:23:48
|
*Hi, Richard,*
Thank you for your feedback.
I think the error is caused partially due to the last variable
not be refreshed. But there is other problem for this. What is the
transaction type of 8365 and 8367?
Thanks and best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Bug-in-GLAccountInquiry-tp4658408p4658461.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.
|
|
From: Pak R. <pak...@gm...> - 2016-01-12 03:03:21
|
Hi Exson: Thanks for the fix. We still have some problems with the Petty Cash. Please check the screenshot: [image: Imatge inserida 1] IDR is the default currency, so 3rd entry should be 300.000 and 4th should be 500.000 Regards, Ricard 2016-01-11 18:18 GMT+08:00 ExsonQu <hex...@gm...>: > *Hi, Richard,* > > Thank you for your report! > > I've uploaded the new version to the trunk. Please check if it's > fixed. > > Thanks and best regards! > > Exson > > > > -- > View this message in context: > http://weberp-accounting.1478800.n4.nabble.com/Bug-in-GLAccountInquiry-tp4658408p4658459.html > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > Site24x7 APM Insight: Get Deep Visibility into Application Performance > APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month > Monitor end-to-end web transactions and take corrective actions now > Troubleshoot faster and improve end-user experience. Signup Now! > http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > |
|
From: ExsonQu <hex...@gm...> - 2016-01-11 10:39:29
|
*Hi, Richard,*
Thank you for your report!
I've uploaded the new version to the trunk. Please check if it's
fixed.
Thanks and best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Bug-in-GLAccountInquiry-tp4658408p4658459.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.
|
|
From: Phil D. <ph...@lo...> - 2015-12-31 20:45:25
|
Exson is still working on the new functionality... it is too soon while this work is not yet tested and debugged Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 30/12/15 08:24, Rafael Chacón wrote: > Hi, > > The quantity of changes, improvements and additions since May > continues to grow. > > To when we might expect the launch of the new version ? > > Best regards, Rafael. > > > 2015-11-15 18:41 GMT-06:00 ExsonQu <hex...@gm... > <mailto:hex...@gm...>>: > > *Hi, Rafael,* > > I think it's too rush to release it in this month! > > It's better to release next month. Expecting some new > features to add to the trunk: > > 1). Use actual cost instead of weighted average > cost during > goods receiving. > 2). Add a RMA feature. > 3). Add a location transfer feature for lot > control items. > > I hope I can finish them before next release. > > Best regards! > > Exson > > > > > > -- > View this message in context: > http://weberp-accounting.1478800.n4.nabble.com/webERP-New-version-on-November-tp4658414p4658420.html > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > Presto, an open source distributed SQL query engine for big data, > initially > developed by Facebook, enables you to easily query your data on > Hadoop in a > more interactive manner. Teradata is also now providing full > enterprise > support for Presto. Download a free open source copy now. > http://pubads.g.doubleclick.net/gampad/clk?id=250295911&iu=/4140 > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > <mailto:Web...@li...> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > > > ------------------------------------------------------------------------------ > > > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Phil D. <ph...@lo...> - 2015-12-31 20:39:28
|
1. supptransid = the supplier transaction id 2. rmadetails is the table to store the line items being returned. 3. yes 4. yes 5. ideally Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 31/12/15 11:32, ExsonQu wrote: > *Hi, Phil,* > > Thank you for your great specification of the RMA. > I have some questions about it: > > 1) What is the supptransid in the rmadetails? > 2) And there is status description of rma such as initiated, > dispatched/pickup, credit note received, completed, does this mean we should > add a status field in rma to record this? > 3) If we need above status, does that mean we quantity > dispatched, quantity credit need for it? And we need a screen for goods > dispatched just like current po received and then a new link add to credit > note to select each of these suspense RMA? > 4) Do we need any approval for the RMA just like po status? > > Thank you again and any input for this is highly appreciated! > > Best regards! > > Exson > > > > > > > > -- > View this message in context: http://weberp-accounting.1478800.n4.nabble.com/RMA-specification-tp4658453.html > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > |
|
From: ExsonQu <hex...@gm...> - 2015-12-30 22:52:04
|
*Hi, Phil,*
Thank you for your great specification of the RMA.
I have some questions about it:
1) What is the supptransid in the rmadetails?
2) And there is status description of rma such as initiated,
dispatched/pickup, credit note received, completed, does this mean we should
add a status field in rma to record this?
3) If we need above status, does that mean we quantity
dispatched, quantity credit need for it? And we need a screen for goods
dispatched just like current po received and then a new link add to credit
note to select each of these suspense RMA?
4) Do we need any approval for the RMA just like po status?
Thank you again and any input for this is highly appreciated!
Best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/RMA-specification-tp4658453.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.
|
|
From: Pak R. <pak...@gm...> - 2015-12-30 01:15:16
|
Hi Rafael: In my tests, the new fields showing the details of the transaction, sometimes are right and sometimes wrong. Could not detect any exact pattern. But, as example, expenses reported from the Petty Cash Module ($type = 1) are incorrectly shown in this new version of GLAccountInquiry. Probably the query in line 280 doesn't extract the data correctly (sorry, I had no time to check the problem in detail, and commented it out on my installation). I remember Tim reported the same bug as well, probably he remembers more details about it. Anyway, just let me know if you need any test done. Regards, Ricard 2015-12-30 3:05 GMT+08:00 Rafael Chacón <raf...@gm...>: > Hi, > > I am testing GLAccountInquiry.php. Could you give me more details about > what is wrong? > > Best regards, Rafael. > > 2015-11-15 21:09 GMT-06:00 Pak Ricard <pak...@gm...>: > >> Hi Exson: >> >> I think the idea is good and helpful, just we are showing the wrong >> results for any reason. >> >> Regards, >> Ricard >> >> 2015-11-16 5:58 GMT+08:00 ExsonQu <hex...@gm...>: >> >>> *Hi, Richard,* >>> >>> Thank you for your test! >>> >>> Since this change looks strange to accounts, it'll be >>> reversed. So I did not fix the bug. >>> I believe there are lots of small companies which have no >>> accounts and GL account inquiry is not only for accountants to review. >>> If there are more feedback about reserving this, I'll >>> change >>> it as option instead of removing from the trunk. >>> >>> Best regards! >>> >>> Exson >>> >>> >>> >>> -- >>> View this message in context: >>> http://weberp-accounting.1478800.n4.nabble.com/Bug-in-GLAccountInquiry-tp4658408p4658418.html >>> Sent from the web-ERP-developers mailing list archive at Nabble.com. >>> >>> >>> ------------------------------------------------------------------------------ >>> _______________________________________________ >>> Web-erp-developers mailing list >>> Web...@li... >>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >>> >> >> >> >> ------------------------------------------------------------------------------ >> Presto, an open source distributed SQL query engine for big data, >> initially >> developed by Facebook, enables you to easily query your data on Hadoop in >> a >> more interactive manner. Teradata is also now providing full enterprise >> support for Presto. Download a free open source copy now. >> http://pubads.g.doubleclick.net/gampad/clk?id=250295911&iu=/4140 >> _______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> >> > > > ------------------------------------------------------------------------------ > > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > |
|
From: Rafael C. <raf...@gm...> - 2015-12-29 19:24:09
|
Hi, The quantity of changes, improvements and additions since May continues to grow. To when we might expect the launch of the new version ? Best regards, Rafael. 2015-11-15 18:41 GMT-06:00 ExsonQu <hex...@gm...>: > *Hi, Rafael,* > > I think it's too rush to release it in this month! > > It's better to release next month. Expecting some new > features to add to the trunk: > > 1). Use actual cost instead of weighted average cost > during > goods receiving. > 2). Add a RMA feature. > 3). Add a location transfer feature for lot control items. > > I hope I can finish them before next release. > > Best regards! > > Exson > > > > > > -- > View this message in context: > http://weberp-accounting.1478800.n4.nabble.com/webERP-New-version-on-November-tp4658414p4658420.html > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > Presto, an open source distributed SQL query engine for big data, initially > developed by Facebook, enables you to easily query your data on Hadoop in a > more interactive manner. Teradata is also now providing full enterprise > support for Presto. Download a free open source copy now. > http://pubads.g.doubleclick.net/gampad/clk?id=250295911&iu=/4140 > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > |
|
From: Rafael C. <raf...@gm...> - 2015-12-29 19:05:22
|
Hi, I am testing GLAccountInquiry.php. Could you give me more details about what is wrong? Best regards, Rafael. 2015-11-15 21:09 GMT-06:00 Pak Ricard <pak...@gm...>: > Hi Exson: > > I think the idea is good and helpful, just we are showing the wrong > results for any reason. > > Regards, > Ricard > > 2015-11-16 5:58 GMT+08:00 ExsonQu <hex...@gm...>: > >> *Hi, Richard,* >> >> Thank you for your test! >> >> Since this change looks strange to accounts, it'll be >> reversed. So I did not fix the bug. >> I believe there are lots of small companies which have no >> accounts and GL account inquiry is not only for accountants to review. >> If there are more feedback about reserving this, I'll >> change >> it as option instead of removing from the trunk. >> >> Best regards! >> >> Exson >> >> >> >> -- >> View this message in context: >> http://weberp-accounting.1478800.n4.nabble.com/Bug-in-GLAccountInquiry-tp4658408p4658418.html >> Sent from the web-ERP-developers mailing list archive at Nabble.com. >> >> >> ------------------------------------------------------------------------------ >> _______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> > > > > ------------------------------------------------------------------------------ > Presto, an open source distributed SQL query engine for big data, initially > developed by Facebook, enables you to easily query your data on Hadoop in a > more interactive manner. Teradata is also now providing full enterprise > support for Presto. Download a free open source copy now. > http://pubads.g.doubleclick.net/gampad/clk?id=250295911&iu=/4140 > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > |
|
From: Rafael C. <raf...@gm...> - 2015-12-01 14:56:52
|
Hi Exson, Problem solved. Thank you very much! Best regards, Rafael. 2015-11-30 16:33 GMT-06:00 ExsonQu <hex...@gm...>: > *Hi, Rafael,* > > Thank you for your test! > > It's a bug. Just drop the foreign key as: > > ALTER table suppinvstogrn DROP FOREIGN KEY > `suppinvstogrn_ibfk_1`; > > Best regards! > > Exson > > > > -- > View this message in context: > http://weberp-accounting.1478800.n4.nabble.com/Error-in-suppinvstogrn-tp4658434p4658436.html > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > Go from Idea to Many App Stores Faster with Intel(R) XDK > Give your users amazing mobile app experiences with Intel(R) XDK. > Use one codebase in this all-in-one HTML5 development environment. > Design, debug & build mobile apps & 2D/3D high-impact games for multiple > OSs. > http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140 > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > |
|
From: ExsonQu <hex...@gm...> - 2015-11-30 22:49:24
|
*Hi, Rafael,*
Thank you for your test!
It's a bug. Just drop the foreign key as:
ALTER table suppinvstogrn DROP FOREIGN KEY
`suppinvstogrn_ibfk_1`;
Best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Error-in-suppinvstogrn-tp4658434p4658436.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.
|
|
From: Rafael C. <raf...@gm...> - 2015-11-30 16:31:13
|
More info:
Database Error 1452 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
ASSISTANCE: The invoice could not be mapped to the goods received record
because Cannot add or update a child row: a foreign key constraint fails
(`verdoram_erp`.`suppinvstogrn`, CONSTRAINT `suppinvstogrn_ibfk_1` FOREIGN
KEY (`suppinv`) REFERENCES `supptrans` (`id`))
Database SQL Failure : The following SQL to map the invoice to the GRN was
used INSERT INTO suppinvstogrn VALUES ('457', '123')
Operation:
Enter an invoice, from a purchase order.
Existent suppinv=supptrans.id=457. No, next auto_increment: 367.
Existent grnno=grns.grnno=123. Yes, It is the last record. Next
auto_increment: 124.
Regards, Rafael.
2015-11-30 9:33 GMT-06:00 Tim Schofield <tim...@gm...>:
> Hi Rafael, could it be that you already have a credit note with that
> transaction number. Try echoing the SQL at line 1553 of
> SupplierInvoice.php and let me know what the output is.
>
> Thanks
> Tim
>
> On 30 November 2015 at 15:08, Rafael Chacón
> <raf...@gm...> wrote:
> > Hi All,
> >
> > I updated a webERP to test. I got this error:
> >
> > Cannot add or update a child row: a foreign key constraint fails
> > (`verdoram_erp`.`suppinvstogrn`, CONSTRAINT `suppinvstogrn_ibfk_1`
> FOREIGN
> > KEY (`suppinv`) REFERENCES `supptrans` (`id`))
> >
> > Somebody has an idea abiout how to trouble shoutting this?
> >
> > Best regards, Rafael.
> >
> >
> ------------------------------------------------------------------------------
> > Go from Idea to Many App Stores Faster with Intel(R) XDK
> > Give your users amazing mobile app experiences with Intel(R) XDK.
> > Use one codebase in this all-in-one HTML5 development environment.
> > Design, debug & build mobile apps & 2D/3D high-impact games for multiple
> > OSs.
> > http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
>
>
>
> --
> Course View Towers,
> Plot 21 Yusuf Lule Road,
> Kampala
> T +256 (0) 312 314 418
> M +256 (0) 752 963 325
> www.weberpafrica.com
> Twitter: @TimSchofield2
> Blog: http://weberpafrica.blogspot.co.uk/
>
|
|
From: Rafael C. <raf...@gm...> - 2015-11-30 15:08:24
|
Hi All, I updated a webERP to test. I got this error: Cannot add or update a child row: a foreign key constraint fails (`verdoram_erp`.`suppinvstogrn`, CONSTRAINT `suppinvstogrn_ibfk_1` FOREIGN KEY (`suppinv`) REFERENCES `supptrans` (`id`)) Somebody has an idea abiout how to trouble shoutting this? Best regards, Rafael. |
|
From: gilberto d. s. a. <gs...@gm...> - 2015-11-20 15:12:49
|
Hi. Today i verify source for pt_BR translasource source file and remains without this last 100% translated version. Please could some user that have write privilege on source code sourceforge update file messages.po? Thanks for your time. [1] https://drive.google.com/file/d/0B7RGseydrhtya3RmWVNWcGRpcUU/view?usp=sharing 2015-11-16 1:42 GMT-02:00 gilberto dos santos alves <gs...@gm...>: > Hi for all! > > this link [1] have a revised verstion for all messages from weberp last > version extracted last week from sourceforge. > > Please could some one, update sources files for these updated messages? > > If there are any doubts please let me know. > > Thanks for your time! > > > > > [1] > https://drive.google.com/file/d/0B7RGseydrhtya3RmWVNWcGRpcUU/view?usp=sharing > > -- > gilberto dos santos alves > +55(11)9-8646-5049 > sao paulo - sp - brasil > > > > > -- gilberto dos santos alves +55(11)9-8646-5049 sao paulo - sp - brasil |
|
From: ExsonQu <hex...@gm...> - 2015-11-20 15:09:14
|
*Dear all,*
Sorry for my mistake!
It has been discussed before and Tim and Phil have given a details
explain:
http://weberp-accounting.1478800.n4.nabble.com/Subtier-vendor-manufacturing-operations-td4655540.html
<http://weberp-accounting.1478800.n4.nabble.com/Subtier-vendor-manufacturing-operations-td4655540.html>
Best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Make-outsourcing-manufacturing-workable-tp4658426p4658429.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.
|
|
From: ExsonQu <hex...@gm...> - 2015-11-20 14:40:54
|
*Hi, Andrew,*
Sorry I make a mistake!
Here we just need to use the dummy item. All problem will be
solved.
Thank you Tim for point this out!
Best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Make-outsourcing-manufacturing-workable-tp4658426p4658428.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.
|
|
From: Andrew G. <aga...@re...> - 2015-11-20 13:31:09
|
Hello. In this scenario is the company using WebERP manufacturing for others? Or sending their things to somebody else to manufacture? Best Regards, Andrew Galuski ResMart LLC. 817.615.2038 (Office) 817.821.0544 (Cell) www.resmart.com -----Original Message----- From: ExsonQu [mailto:hex...@gm...] Sent: Friday, November 20, 2015 2:48 AM To: web...@li... Subject: [WebERP-developers] Make outsourcing manufacturing workable *Dear all,* Thank you for your long time contribution to webERP. I've read a solution from Tim before about how to handling outsourcing manufacturing in webERP. The solution's frame work is clear. But to make it workable, there are still lots of work to do, here I'll list some of them and will find a solution for them little by little: 1. Purchasing an non stock item with the normal item code. Currently, we can purchase non-stock item, but there are no stock code stored. 2. Find a an acceptable cost calculation standard for them. It's a little tricky here, those items are untouchable, but we may need to separate them from each other when we issue them to work orders. 3. Rework the work order issue part to make these non-stock item can be issued manually. Then the cost can be collected to WIP. 4. Other feature needed like a PDF to issue raw materials to suppliers. As before, any comments are highly appreciated! Thanks and best regards! Exson -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Make-outsourcing-manufacturing-workable-tp4658426.html Sent from the web-ERP-developers mailing list archive at Nabble.com. ------------------------------------------------------------------------------ _______________________________________________ Web-erp-developers mailing list Web...@li... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: ExsonQu <hex...@gm...> - 2015-11-20 09:02:47
|
*Dear all,*
Thank you for your long time contribution to webERP.
I've read a solution from Tim before about how to handling
outsourcing manufacturing in webERP.
The solution's frame work is clear. But to make it workable,
there are still lots of work to do, here I'll list some of them and will
find a solution for them little by little:
1. Purchasing an non stock item with the normal item code.
Currently, we can purchase non-stock item, but there are no stock code
stored.
2. Find a an acceptable cost calculation standard for them.
It's a little tricky here, those items are untouchable, but we may need to
separate them from each other when we issue them to work orders.
3. Rework the work order issue part to make these non-stock
item can be issued manually. Then the cost can be collected to WIP.
4. Other feature needed like a PDF to issue raw materials to
suppliers.
As before, any comments are highly appreciated!
Thanks and best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Make-outsourcing-manufacturing-workable-tp4658426.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.
|
|
From: gilberto d. s. a. <gs...@gm...> - 2015-11-16 03:42:50
|
Hi for all! this link [1] have a revised verstion for all messages from weberp last version extracted last week from sourceforge. Please could some one, update sources files for these updated messages? If there are any doubts please let me know. Thanks for your time! [1] https://drive.google.com/file/d/0B7RGseydrhtya3RmWVNWcGRpcUU/view?usp=sharing -- gilberto dos santos alves +55(11)9-8646-5049 sao paulo - sp - brasil |
|
From: Pak R. <pak...@gm...> - 2015-11-16 03:10:00
|
Hi Exson: I think the idea is good and helpful, just we are showing the wrong results for any reason. Regards, Ricard 2015-11-16 5:58 GMT+08:00 ExsonQu <hex...@gm...>: > *Hi, Richard,* > > Thank you for your test! > > Since this change looks strange to accounts, it'll be > reversed. So I did not fix the bug. > I believe there are lots of small companies which have no > accounts and GL account inquiry is not only for accountants to review. > If there are more feedback about reserving this, I'll change > it as option instead of removing from the trunk. > > Best regards! > > Exson > > > > -- > View this message in context: > http://weberp-accounting.1478800.n4.nabble.com/Bug-in-GLAccountInquiry-tp4658408p4658418.html > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > |
|
From: ExsonQu <hex...@gm...> - 2015-11-16 00:56:32
|
*Hi, Rafael,*
I think it's too rush to release it in this month!
It's better to release next month. Expecting some new
features to add to the trunk:
1). Use actual cost instead of weighted average cost during
goods receiving.
2). Add a RMA feature.
3). Add a location transfer feature for lot control items.
I hope I can finish them before next release.
Best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/webERP-New-version-on-November-tp4658414p4658420.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.
|
231 messages has been excluded from this view by a project administrator.
