Menu
▾
▴
web-erp-users — User general webERP discussion list
You can subscribe to this list here.
| 2003 |
Jan
(1) |
Feb
|
Mar
(20) |
Apr
(24) |
May
(7) |
Jun
(5) |
Jul
(4) |
Aug
(35) |
Sep
(34) |
Oct
(21) |
Nov
(39) |
Dec
(15) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 |
Jan
(11) |
Feb
(30) |
Mar
(60) |
Apr
(98) |
May
(61) |
Jun
(33) |
Jul
(44) |
Aug
(102) |
Sep
(59) |
Oct
(152) |
Nov
(86) |
Dec
(39) |
| 2005 |
Jan
(96) |
Feb
(117) |
Mar
(75) |
Apr
(144) |
May
(78) |
Jun
(47) |
Jul
(58) |
Aug
(87) |
Sep
(89) |
Oct
(120) |
Nov
(43) |
Dec
(15) |
| 2006 |
Jan
(142) |
Feb
(55) |
Mar
(67) |
Apr
(79) |
May
(44) |
Jun
(62) |
Jul
(104) |
Aug
(90) |
Sep
(38) |
Oct
(70) |
Nov
(17) |
Dec
(80) |
| 2007 |
Jan
(108) |
Feb
(121) |
Mar
(33) |
Apr
(17) |
May
(18) |
Jun
(60) |
Jul
(62) |
Aug
(101) |
Sep
(94) |
Oct
(117) |
Nov
(44) |
Dec
(23) |
| 2008 |
Jan
(106) |
Feb
(67) |
Mar
(169) |
Apr
(73) |
May
(101) |
Jun
(112) |
Jul
(125) |
Aug
(149) |
Sep
(139) |
Oct
(162) |
Nov
(92) |
Dec
(88) |
| 2009 |
Jan
(199) |
Feb
(219) |
Mar
(372) |
Apr
(246) |
May
(146) |
Jun
(159) |
Jul
(276) |
Aug
(146) |
Sep
(143) |
Oct
(76) |
Nov
(65) |
Dec
(208) |
| 2010 |
Jan
(129) |
Feb
(76) |
Mar
(127) |
Apr
(131) |
May
(90) |
Jun
(237) |
Jul
(108) |
Aug
(75) |
Sep
(39) |
Oct
(92) |
Nov
(118) |
Dec
(63) |
| 2011 |
Jan
(96) |
Feb
(146) |
Mar
(190) |
Apr
(141) |
May
(142) |
Jun
(109) |
Jul
(112) |
Aug
(182) |
Sep
(115) |
Oct
(100) |
Nov
(278) |
Dec
(169) |
| 2012 |
Jan
(134) |
Feb
(156) |
Mar
(161) |
Apr
(81) |
May
(16) |
Jun
(72) |
Jul
(99) |
Aug
(64) |
Sep
(90) |
Oct
(47) |
Nov
(86) |
Dec
(49) |
| 2013 |
Jan
(29) |
Feb
(14) |
Mar
(12) |
Apr
(25) |
May
(10) |
Jun
(26) |
Jul
(12) |
Aug
(17) |
Sep
(6) |
Oct
(3) |
Nov
(13) |
Dec
(27) |
| 2014 |
Jan
(18) |
Feb
(14) |
Mar
(17) |
Apr
(17) |
May
(23) |
Jun
(25) |
Jul
(25) |
Aug
(12) |
Sep
(7) |
Oct
(33) |
Nov
(39) |
Dec
(12) |
| 2015 |
Jan
(21) |
Feb
(39) |
Mar
(41) |
Apr
(9) |
May
(16) |
Jun
(7) |
Jul
(8) |
Aug
(2) |
Sep
|
Oct
|
Nov
(24) |
Dec
(12) |
| 2016 |
Jan
(15) |
Feb
(17) |
Mar
(23) |
Apr
(11) |
May
(3) |
Jun
(7) |
Jul
(3) |
Aug
|
Sep
(5) |
Oct
(5) |
Nov
(2) |
Dec
|
| 2017 |
Jan
|
Feb
(12) |
Mar
(14) |
Apr
|
May
(1) |
Jun
(10) |
Jul
(7) |
Aug
(5) |
Sep
(3) |
Oct
(1) |
Nov
|
Dec
|
| 2018 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2019 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2020 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2024 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(27) |
Nov
|
Dec
(5) |
| 2025 |
Jan
|
Feb
(56) |
Mar
(28) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: ExsonQu <hex...@gm...> - 2015-12-09 07:57:28
|
*Hi, Terry,*
Thank you for your report!
It's a bug due to an extra blank space. I've fixed in the
trunk. You can download the file attached.
Thanks and best regards!
Exson
SelectCustomer.zip
<http://weberp-accounting.1478800.n4.nabble.com/file/n4658441/SelectCustomer.zip>
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Enter-a-partial-Phone-Number-problem-tp4658440p4658441.html
Sent from the web-ERP-users mailing list archive at Nabble.com.
|
|
From: Terry P. <te...@tj...> - 2015-12-09 05:40:49
|
Hi Phil and All, I can't search phone numbers in the customer menu because I get this error every time "please match the requested format" which I think is a PHP error as I can't find that error text in /webERP/SelectCustomer.php. Any hints or work arounds ? webERP version: 4.12.3 on freebsd. -- Best Regards Terry Porter <te...@tj...> EXPERT WiFI 2 / 32 Cassino Drive Casino, 2470, NSW Phone: 02 66628672 Mobile: 04 3211 3992 http://freenet-Antennas.com.au Distributor Nsw, Act, Qld, Vic and Tas <http://expert-wifi.com> |
|
From: ExsonQu <hex...@gm...> - 2015-12-09 01:34:27
|
*Hi, Terry,*
Thank you very much!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/WebERP-4-12-3-Schemaspy-generated-schema-now-online-for-browsing-tp4658438p4658439.html
Sent from the web-ERP-users mailing list archive at Nabble.com.
|
|
From: Terry P. <te...@tj...> - 2015-12-09 01:16:32
|
Hi Phil and All, Anyone interested in a Schemaspy webage generated from the WebERP 4.12.3 Demo database can find it on my advert/junk free website at :- http://www.portertech.org/test/webERP/schemaspy/webERP-4.12.3/weberp-4.12.3-weberpdemo/index.html It may prove helpful when searching for table column names e.t.c. to use in your own SQL applications which obtain data directly from your webERP database. My old tutorial on how to generate this information is at :- http://portertech.org/bb/viewtopic.php?f=19&t=34&sid=6fb1a7a97711732948f40c250812747d Any of my articles may be freely linked for purposes of increasing webERP knowledge among webERP users. Cheers Terry |
|
From: gilberto d. s. a. <gs...@gm...> - 2015-11-21 20:47:27
|
nice. now i will try get build one basic pt_BR environment with all modules with data/samples. regards. 2015-11-21 7:43 GMT-02:00 Phil Daintree <ph...@lo...>: > Many thanks Gilberto. > I've updated the SVN repository with your latest translation. > > Phil > > Phil Daintree > Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz > > On 21/11/15 04:12, gilberto dos santos alves wrote: > > 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 > > > > > > > ------------------------------------------------------------------------------ > > > > _______________________________________________ > web-ERP-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > > -- gilberto dos santos alves +55(11)9-8646-5049 sao paulo - sp - brasil |
|
From: Phil D. <ph...@lo...> - 2015-11-21 09:43:54
|
Many thanks Gilberto. I've updated the SVN repository with your latest translation. Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 21/11/15 04:12, gilberto dos santos alves wrote: > 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... > <mailto: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 > > > > > > > ------------------------------------------------------------------------------ > > > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users |
|
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-17 11:17:01
|
*Hi,Tyler:*
Just create a special token in Maintain Security Token and
assign this token to the role in Access permission maintenance . And then
assign that role to the scripts in page security settings, and at the last
step, assign the users to the role you set at the first step.
Best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Give-user-only-access-to-Bulk-Inventory-Transfer-Dispatch-tp4658424p4658425.html
Sent from the web-ERP-users mailing list archive at Nabble.com.
|
|
From: Tyler <tjg...@gm...> - 2015-11-17 08:56:54
|
Good day Is there a way to only give a user access to Inventory > Bulk Inventory Transfer - Dispatch part of WebERP? Thank you for any reply. -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Give-user-only-access-to-Bulk-Inventory-Transfer-Dispatch-tp4658424.html Sent from the web-ERP-users 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: ExsonQu <hex...@gm...> - 2015-11-14 12:27:04
|
*Hi, Tyler,*
I think it's a setting problem.
Just set the last three items in setup=>company preference to
'No', You problem will be solved. And this setting will make your system run
fast.
Best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/GL-transacction-record-could-not-be-inserted-because-Cannot-add-or-update-a-child-row-tp4658409p4658412.html
Sent from the web-ERP-users mailing list archive at Nabble.com.
|
|
From: Tyler <tjg...@gm...> - 2015-11-14 10:52:27
|
It was the latest version.
The problem is fixed thank you, we had added non existant gl codes to
locations we made. Deleted every gl code on the database in Location table
fixed the problem for me!
Thank you for your time.
On 14 Nov 2015 12:48 PM, "gsavix [via webERP accounting]" <
ml-...@n4...> wrote:
> you have downloaded last version from sourceforge? your version is 4.11.x
> or is your version for we try to reproduce your issue.
> thanks.
>
> 2015-11-12 13:33 GMT-02:00 Tyler <[hidden email]
> <http:///user/SendEmail.jtp?type=node&node=4658410&i=0>>:
>
>> Hi.
>>
>> I have just set up WebERP on a new site of mine. An apache sever running
>> off
>> Ubuntu Server 14 LTS.
>>
>> We really just need to use the Inventory side of the program. When we use
>> Inventory Bulk Dispatch all is ok. But when we Inventory Bulk - Receive we
>> get this error:
>>
>> Database Error 1452 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
>> ASSISTANCE: The outgoing inventory GL transacction record could not be
>> inserted because
>> Cannot add or update a child row: a foreign key constraint fails
>> (`epictr4nsp0rt`.`gltrans`, CONSTRAINT `gltrans_ibfk_1` FOREIGN KEY
>> (`account`) REFERENCES `chartmaster` (`accountcode`))
>> Database SQL Failure : The following SQL to insert records was used
>> INSERT INTO gltrans ( periodno, trandate, type, typeno, account,
>> narrative,
>> amount) VALUES ('0','2015-11-12',16,'20','H69','H69 - B9M001 x 40 @
>> 43.0000','-1720')
>> Database Rollback Due to Error Above : Rolling Back Transaction OK
>>
>> Please note gl codes may have been added when the items were created,
>> would
>> that have anything to do with this error. We have not touched the GL
>> side...
>>
>> Thank you for your time.
>>
>>
>>
>>
>>
>> --
>> View this message in context:
>> http://weberp-accounting.1478800.n4.nabble.com/GL-transacction-record-could-not-be-inserted-because-Cannot-add-or-update-a-child-row-tp4658409.html
>> Sent from the web-ERP-users mailing list archive at Nabble.com.
>>
>>
>> ------------------------------------------------------------------------------
>> _______________________________________________
>> web-ERP-users mailing list
>> [hidden email] <http:///user/SendEmail.jtp?type=node&node=4658410&i=1>
>> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>>
>
>
>
> --
> gilberto dos santos alves
> +55(11)9-8646-5049
> sao paulo - sp - brasil
>
>
>
>
>
> ------------------------------------------------------------------------------
>
>
> _______________________________________________
> web-ERP-users mailing list
> [hidden email] <http:///user/SendEmail.jtp?type=node&node=4658410&i=2>
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://weberp-accounting.1478800.n4.nabble.com/GL-transacction-record-could-not-be-inserted-because-Cannot-add-or-update-a-child-row-tp4658409p4658410.html
> To unsubscribe from GL transacction record could not be inserted because
> Cannot add or update a child row, click here
> <http://weberp-accounting.1478800.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658409&code=dGpnZXlzZXIxQGdtYWlsLmNvbXw0NjU4NDA5fC0xNDE0OTY5MDc=>
> .
> NAML
> <http://weberp-accounting.1478800.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/GL-transacction-record-could-not-be-inserted-because-Cannot-add-or-update-a-child-row-tp4658409p4658411.html
Sent from the web-ERP-users mailing list archive at Nabble.com. |
|
From: gilberto d. s. a. <gs...@gm...> - 2015-11-14 10:47:16
|
you have downloaded last version from sourceforge? your version is 4.11.x
or is your version for we try to reproduce your issue.
thanks.
2015-11-12 13:33 GMT-02:00 Tyler <tjg...@gm...>:
> Hi.
>
> I have just set up WebERP on a new site of mine. An apache sever running
> off
> Ubuntu Server 14 LTS.
>
> We really just need to use the Inventory side of the program. When we use
> Inventory Bulk Dispatch all is ok. But when we Inventory Bulk - Receive we
> get this error:
>
> Database Error 1452 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
> ASSISTANCE: The outgoing inventory GL transacction record could not be
> inserted because
> Cannot add or update a child row: a foreign key constraint fails
> (`epictr4nsp0rt`.`gltrans`, CONSTRAINT `gltrans_ibfk_1` FOREIGN KEY
> (`account`) REFERENCES `chartmaster` (`accountcode`))
> Database SQL Failure : The following SQL to insert records was used
> INSERT INTO gltrans ( periodno, trandate, type, typeno, account, narrative,
> amount) VALUES ('0','2015-11-12',16,'20','H69','H69 - B9M001 x 40 @
> 43.0000','-1720')
> Database Rollback Due to Error Above : Rolling Back Transaction OK
>
> Please note gl codes may have been added when the items were created, would
> that have anything to do with this error. We have not touched the GL
> side...
>
> Thank you for your time.
>
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/GL-transacction-record-could-not-be-inserted-because-Cannot-add-or-update-a-child-row-tp4658409.html
> Sent from the web-ERP-users mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
--
gilberto dos santos alves
+55(11)9-8646-5049
sao paulo - sp - brasil
|
|
From: Tyler <tjg...@gm...> - 2015-11-12 15:48:08
|
Hi.
I have just set up WebERP on a new site of mine. An apache sever running off
Ubuntu Server 14 LTS.
We really just need to use the Inventory side of the program. When we use
Inventory Bulk Dispatch all is ok. But when we Inventory Bulk - Receive we
get this error:
Database Error 1452 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
ASSISTANCE: The outgoing inventory GL transacction record could not be
inserted because
Cannot add or update a child row: a foreign key constraint fails
(`epictr4nsp0rt`.`gltrans`, CONSTRAINT `gltrans_ibfk_1` FOREIGN KEY
(`account`) REFERENCES `chartmaster` (`accountcode`))
Database SQL Failure : The following SQL to insert records was used
INSERT INTO gltrans ( periodno, trandate, type, typeno, account, narrative,
amount) VALUES ('0','2015-11-12',16,'20','H69','H69 - B9M001 x 40 @
43.0000','-1720')
Database Rollback Due to Error Above : Rolling Back Transaction OK
Please note gl codes may have been added when the items were created, would
that have anything to do with this error. We have not touched the GL side...
Thank you for your time.
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/GL-transacction-record-could-not-be-inserted-because-Cannot-add-or-update-a-child-row-tp4658409.html
Sent from the web-ERP-users mailing list archive at Nabble.com.
|
|
From: ExsonQu <hex...@gm...> - 2015-11-12 01:46:48
|
*Dear Phil,*
If you have no objection, I'll update the constraint to let the
F,M,D, L all are selectable.
Best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Is-the-work-order-issue-constraint-right-tp4658403p4658407.html
Sent from the web-ERP-users mailing list archive at Nabble.com.
|
|
From: ExsonQu <hex...@gm...> - 2015-11-06 08:45:15
|
*Hi, Phil,*
The script is WorkOrderIssue.php which only allow 'F' , 'D'
and 'L' which is added later.
And another script is WorkOrderEntry.ph which allows 'F' and
'M'.
It maybe forget to update as labor and other other overhead
cost is allowed to issue to Work Orders.
Thanks and best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Is-the-work-order-issue-constraint-right-tp4658403p4658405.html
Sent from the web-ERP-users mailing list archive at Nabble.com.
|
|
From: Phil D. <ph...@lo...> - 2015-11-06 06:20:49
|
What script? Memory not what it was. Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 06/11/15 16:57, ExsonQu wrote: > *Hi, Phil,* > > Thank you for your long time nice support! > > When I studied the Work Order Issue code, it currently only > allows 'F' and 'D' to issue. Is it designed or an overlook? > > I think here should allow Labor, and raw material issued too > which are no in the BOM. > > Thanks and best regards! > > Exson > > > > -- > View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Is-the-work-order-issue-constraint-right-tp4658403.html > Sent from the web-ERP-users mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > |
|
From: ExsonQu <hex...@gm...> - 2015-11-06 04:11:05
|
*Hi, Phil,*
Thank you for your long time nice support!
When I studied the Work Order Issue code, it currently only
allows 'F' and 'D' to issue. Is it designed or an overlook?
I think here should allow Labor, and raw material issued too
which are no in the BOM.
Thanks and best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Is-the-work-order-issue-constraint-right-tp4658403.html
Sent from the web-ERP-users mailing list archive at Nabble.com.
|
|
From: <ph...@lo...> - 2015-11-04 22:43:28
|
Well I am not sure about this... the contract is not a customer, it is effectively a container of costs - like a work order except there is no static BOM Issuing the stock to the contract is possible - but to produce a stock issue note that is charged to the contract but headed up for dispatch to the customer is not currently supported nor even envisaged by my simple mind! I can certainly see why you would do this though now - but I expect it is not generally the way most companies work. If you issue stock to the contract then this accomplished by issuing to the contract work order. There would be no charge or invoice for such issues. You may be referring to a contracted price? This is not what the contract module is about. Phil On 2015-11-04 07:18, rfthomas wrote: > Phil, > > We would assume that shipments of items done under a contract would be > charged to the contract. In this case the contract is a special type > of > customer, the shipping location and customer on the paperwork would > default > to the customer of the contract (over-ridden if the shipments go to an > intermediary, i.e. an integrator who integrates the shipment into the > end > product of the contract). > > The prices specific to the end-user would be charged to the contract > with an > automatic payment by the contract. > > There could be for the contract a complete list of items with other > items > being added as necessary. > > We would create orders in the system that use the contract as customer, > placing the items to be shipped on an order. When the items ship > (invoice > is created), shipping papers would be generated to accompany the > shipment > and inventory would adjusted. The value of the shipment would be the > customer's price. Such would be charged against the contract. > > The relationship of contracts to customer is many to one. We can have > several active contracts/projects with the same customer/branch. > > Bob Thomas > > > > -- > View this message in context: > http://weberp-accounting.1478800.n4.nabble.com/Contracts-Module-tp4658378p4658396.html > Sent from the web-ERP-users mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users |
|
From: rfthomas <rf...@as...> - 2015-11-04 14:31:29
|
Phil, We would assume that shipments of items done under a contract would be charged to the contract. In this case the contract is a special type of customer, the shipping location and customer on the paperwork would default to the customer of the contract (over-ridden if the shipments go to an intermediary, i.e. an integrator who integrates the shipment into the end product of the contract). The prices specific to the end-user would be charged to the contract with an automatic payment by the contract. There could be for the contract a complete list of items with other items being added as necessary. We would create orders in the system that use the contract as customer, placing the items to be shipped on an order. When the items ship (invoice is created), shipping papers would be generated to accompany the shipment and inventory would adjusted. The value of the shipment would be the customer's price. Such would be charged against the contract. The relationship of contracts to customer is many to one. We can have several active contracts/projects with the same customer/branch. Bob Thomas -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Contracts-Module-tp4658378p4658396.html Sent from the web-ERP-users mailing list archive at Nabble.com. |
|
From: Phil D. <ph...@lo...> - 2015-11-04 08:33:31
|
Bob, So these invoices/packing lists would actually be zero charges with the cost of the items on the invoice being issued to the contract? I hadn't considered that case.... I am thinking that a special contract invoice should be possible to write a whole lot of text and the invoice has no inventory item against it - this creates all sorts of trouble as there is no stock movement and all the printing requires a stock movement - not sure how to achieve it yet. The sales analysis would also be messed up as the invoice would not be classed as turnover (under a % completion scenario). Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 04/11/15 03:59, rfthomas wrote: > We would be pleased to help in refining this area. There might be mechanisms > already existing webERP to handle some of the areas that are specific to > contracts/projects. > > We will write up our thoughts with respect to projects. We have > experimented with some project management software written in PHP that > mimics much of the functionality of MICROSOFT's PROJECT application. > > One requirement is that we need to be able to ship material to the customer > creating packing slips and charging the items against the contract/project. > Many of the items that we sell are serialized/lot numbered and we need to > track by serial/lot number. Within the current webERP, we could possibly > set-up a customer that is the contract/project with the shipping information > being that of the customer. Sales orders would then be created initially > outside the Contracts Module for the items and shipments/invoices made with > the charges being accrued against the contract/project. > > The customer is not billed based on shipments but rather per the terms of > the contract. We do understand how to accomplish such using webERP. > > We have been experimenting with the Contract module and several of the > features described in the webERP Manual in the section Contract Costing do > not appear to have been implemented. Specifically entering supplier > charges. > > Bob Thomas > > > > -- > View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Contracts-Module-tp4658378p4658388.html > Sent from the web-ERP-users mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > |
|
From: Rafael C. <raf...@gm...> - 2015-11-03 17:35:39
|
Hi Bob Thomas, Thank you. Excelente! We work with EGroupware/Project Management, but we are trying with dotProject between EGroupware and webERP (using Joomla!). Best regards, Rafael. 2015-11-03 10:55 GMT-06:00 rfthomas <rf...@as...>: > Rafael, > > We use MICROSOFT Project as a project planning and management tool. We > have > experimented with DOTPROJECT available at > http://sourceforge.net/projects/dotproject/ > > Bob Thomas > > > > -- > View this message in context: > http://weberp-accounting.1478800.n4.nabble.com/Contracts-Module-tp4658378p4658390.html > Sent from the web-ERP-users mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > |
|
From: rfthomas <rf...@as...> - 2015-11-03 17:08:51
|
Rafael, We use MICROSOFT Project as a project planning and management tool. We have experimented with DOTPROJECT available at http://sourceforge.net/projects/dotproject/ Bob Thomas -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Contracts-Module-tp4658378p4658390.html Sent from the web-ERP-users mailing list archive at Nabble.com. |
|
From: Rafael C. <raf...@gm...> - 2015-11-03 15:42:28
|
Hi Bob Thomas, Which software are you using for project management? We are experiencing webERP use to bill/quotation by project activities. Best regards, Rafael. 2015-11-03 8:59 GMT-06:00 rfthomas <rf...@as...>: > We would be pleased to help in refining this area. There might be > mechanisms > already existing webERP to handle some of the areas that are specific to > contracts/projects. > > We will write up our thoughts with respect to projects. We have > experimented with some project management software written in PHP that > mimics much of the functionality of MICROSOFT's PROJECT application. > > One requirement is that we need to be able to ship material to the customer > creating packing slips and charging the items against the contract/project. > Many of the items that we sell are serialized/lot numbered and we need to > track by serial/lot number. Within the current webERP, we could possibly > set-up a customer that is the contract/project with the shipping > information > being that of the customer. Sales orders would then be created initially > outside the Contracts Module for the items and shipments/invoices made with > the charges being accrued against the contract/project. > > The customer is not billed based on shipments but rather per the terms of > the contract. We do understand how to accomplish such using webERP. > > We have been experimenting with the Contract module and several of the > features described in the webERP Manual in the section Contract Costing do > not appear to have been implemented. Specifically entering supplier > charges. > > Bob Thomas > > > > -- > View this message in context: > http://weberp-accounting.1478800.n4.nabble.com/Contracts-Module-tp4658378p4658388.html > Sent from the web-ERP-users mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > |
221 messages has been excluded from this view by a project administrator.
