web-erp-developers

Re: [WebERP-developers] Web-erp-developers Digest, Vol 92, Issue 19

[muthu <map...@gm...>]

Hi Phil,

Please find attached the modified BOM.php & sql for your review and
deployment. 

Regards, Muthu.

-----Original Message-----
From: web...@li...
[mailto:web...@li...] 
Sent: Thursday, January 30, 2014 2:25 PM
To: web...@li...
Subject: Web-erp-developers Digest, Vol 92, Issue 19

Send Web-erp-developers mailing list submissions to
	web...@li...

To subscribe or unsubscribe via the World Wide Web, visit
	https://lists.sourceforge.net/lists/listinfo/web-erp-developers
or, via email, send a message with subject or body 'help' to
	web...@li...

You can reach the person managing the list at
	web...@li...

When replying, please edit your Subject line so it is more specific than
"Re: Contents of Web-erp-developers digest..."


Today's Topics:

   1. Re: Feature Suggestion: Multi-Level Bill Of Materials
      Maintenance - Product Sequence Option (Phil Daintree)


----------------------------------------------------------------------

Message: 1
Date: Thu, 30 Jan 2014 21:54:26 +1300
From: Phil Daintree <ph...@lo...>
Subject: Re: [WebERP-developers] Feature Suggestion: Multi-Level Bill
	Of Materials Maintenance - Product Sequence Option
To: webERP Developers <web...@li...>
Message-ID: <52E...@lo...>
Content-Type: text/plain; charset="iso-8859-1"

Hi Muthu,

I could not pull out the BOM.php to run a diff on from these files - there
is a long word document but the best documentation is of course the code :-)
Please could you send me your modified script.

Many thanks

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 30/01/14 15:25, muthu wrote:
>
> Team,
>
> In continuation to the below subject, I have made the required changes 
> to  enable the product sequence feature with the guidance of Tim.
> Please find attached the CR document contains the detailed 
> requirement, SQL statement & modified BOM.php file under configuration 
> register section for your review and deployment to main branch.
>
> Do let me know in case if you have any questions/clarifications.
>
> Regards, Muthu
>
> *From:*muthu [mailto:map...@gm...]
> *Sent:* Sunday, January 19, 2014 2:06 AM
> *To:* 'web...@li...'
> *Subject:* Feature Suggestion: Multi-Level Bill Of Materials 
> Maintenance - Product Sequence Option
>
> Team,
>
> While exploring further, I have noticed the following feature in 
> Manufacturing will ease the Production Planning team's life in shop floor.
>
> Multi-Level Bill Of Materials Maintenance -- User Sequence Option
>
> -Introducing the Product sequence numbering to the components will 
> establish the sequence of the bill of material. This will help the 
> Production Planning & Assembly team to focus on the items based on the 
> sequence and will help us to view the true product structure with the 
> BoM listings when we have the reporting with "Level" with "Product 
> Sequence".
>
> -I feel this option can be introduced in the existing "Multi-Level 
> Bill Of Materials Maintenance" screen by adding additionalProduct 
> sequence field.
>
> Any suggestions...
>
> Regards, Muthu
>
> *From:*muthu [mailto:map...@gm...]
> *Sent:* Wednesday, January 08, 2014 4:13 AM
> *To:* 'web...@li...'
> *Subject:* RE: Web-erp-developers Digest, Vol 92, Issue 4
>
> Team,
>
> I have rich ERP implementation experience in Manufacturing and 
> Logistics domain and started looking for spending my time in 
> contributing to any of the open source project. While exploring the 
> web,  happen to  get a chance to see the webERP and noticed that the 
> product is meeting most of the features and would like to extend all 
> my support to enhance further to benefit the community.
>
> In this connection, while getting into the flow, noticed that  the  
> "Purchase Requisition" feature is not implemented, which is a must 
> have feature. Do you have any plan or how it is handled currently in 
> webERP.
>
> Regards, Muthu
>
> Purchase Requisition:
>
> It is a first step to procurement. Any user in a company can raise a 
> purchase request for the procurement of any item (from stationery to 
> capital goods outside of MRP) and the same can be queued for approvals 
> to their supervisors and followed by available to purchase department 
> for procurement.
>
> Find below the typical purchase requisition format.
>
> *PURCHASE Requisition*
>
> **
>
> Requisition number        R ******                            Revision **
>
> Requisition date               ***/**/**
>
> Item ***************
>
> Description ******************************
>
> Approval status                * ****************
>
> Requisitioner : aaaaaaaA10
>
> Quantity nnnnnnn.nnn
>
> Purchase UM                     **
>
> Conv Factor **,***.*****
>
> Stock UM                            **
>
> Required Date                   nnnnnn
>
> Follow-up                            nnnnnn
>
> Warehouse:                       aA3
>
> Job number aaaaaaaaaA12
>
> Ship-to ID                            nnn
>
> Account aaaaaaaaaaaaA15
>
> Purchase order                 aaaaaaa
>
> Department                       aaA4
>
> Price nnnnnnnnnnn.nnnn
>
> Priority                                 n
>
> Requested vendor          aaaaA6 **********
>
> Ref number aaaaaaaA10
>
> -----Original Message-----
> From: web...@li...
> <mailto:web...@li...>
> [mailto:web...@li...]
> Sent: Sunday, January 05, 2014 10:00 AM
> To: web...@li...
> <mailto:web...@li...>
> Subject: Web-erp-developers Digest, Vol 92, Issue 4
>
> Send Web-erp-developers mailing list submissions to
>
> web...@li...
> <mailto:web...@li...>
>
> To subscribe or unsubscribe via the World Wide Web, visit
>
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> or, via email, send a message with subject or body 'help' to
>
> web...@li...
> <mailto:web...@li...>
>
> You can reach the person managing the list at
>
> web...@li...
> <mailto:web...@li...>
>
> When replying, please edit your Subject line so it is more specific 
> than "Re: Contents of Web-erp-developers digest..."
>
> Today's Topics:
>
>    1. Re: Bug in language setting and company      preferences
>
>       (Bharata Kalbuaji)
>
>    2. Re: Bug in language setting and company      preferences
>
>       (Phil Daintree)
>
>    3. Re: Bug in language setting and company      preferences
>
>       (Bharata Kalbuaji)
>
> ----------------------------------------------------------------------
>
> Message: 1
>
> Date: Sun, 5 Jan 2014 09:32:55 +0700
>
> From: Bharata Kalbuaji <bha...@gm... 
> <mailto:bha...@gm...>>
>
> Subject: Re: [WebERP-developers] Bug in language setting and company
>
>                 preferences
>
> To: webERP Developers <web...@li...
> <mailto:web...@li...>>
>
> Message-ID:
>
>                 
> <CAD...@ma...
> <mailto:CAD...@ma...ail
> .com>>
>
> Content-Type: text/plain; charset="iso-8859-1"
>
> The extension is okay. So, does the download version already include 
> locale language? I saw in the locale folder there is already exist 
> indonesian language.
>
> _____________________
>
> Bharata Kalbuaji
>
> On Jan 5, 2014 9:00 AM, "Phil Daintree" <ph...@lo... 
> <mailto:ph...@lo...>> wrote:
>
> > Try the demo at http://www.weberp.org/weberp
>
> >
>
> > There are some tricks to php config the language locale must be
>
> > installed on the server and the gettext php extension must be enabled.
>
> >
>
> > Bharata <bha...@gm... <mailto:bha...@gm...>> wrote:
>
> >>
>
> >> Hello, currently I'm developing an ERP system for some small 
> >> company
>
> >> in Indonesia. I see that WebERP already have Indonesia langauage
> buat when I change the language to Indonesian, the language is still 
> in english. I tried another language and it still the same. Is there 
> any plugin or something to change the language because I tried the 
> demo, the language can be changed. Also, I tried to change the company 
> preference like name, address, and currency, but when I click the 
> submit button, it doesn't submit and just stay o n the same page. Why 
> is this happening? Is there some bugs? Thank you for your reply.
>
> >>
>
> >> --
>
> >> -------------------------
>
> >> Bharata Kalbuaji
>
> >>
>
> >> ------------------------------
>
> >>
>
> >> Rapidly troubleshoot problems before they affect your business. 
> >> Most
>
> >> IT organizations don't have a clear picture of how application
>
> >> performance affects their revenue. With AppDynamics, you get 100%
>
> >> visibility into your Java,.NET, & PHP application. Start your
> 15-day FREE TRIAL of AppDynamics Pro!
>
> >> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.
>
> >> clktrk
>
> >>
>
> >> ------------------------------
>
> >>
>
> >> Web-erp-developers mailing list
>
> >> Web...@li...
> <mailto:Web...@li...>
>
> >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> >>
>
> >>
>
> > Phil Daintree
>
> > +64(0)275 567890
>
> > skype: daintree
>
> >
>
> >
>
> > --------------------------------------------------------------------
> > --
>
> > -------- Rapidly troubleshoot problems before they affect your
>
> > business. Most IT organizations don't have a clear picture of how
>
> > application performance affects their revenue. With AppDynamics, you
>
> > get 100% visibility into your Java,.NET, & PHP application. Start 
> > your
>
> > 15-day FREE TRIAL of AppDynamics Pro!
>
> > http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg
> > .c
>
> > lktrk _______________________________________________
>
> > Web-erp-developers mailing list
>
> > Web...@li...
> <mailto:Web...@li...>
>
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> >
>
> >
>
> -------------- next part --------------
>
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 2
>
> Date: Sun, 05 Jan 2014 16:43:12 +1300
>
> From: Phil Daintree <ph...@lo... 
> <mailto:ph...@lo...>>
>
> Subject: Re: [WebERP-developers] Bug in language setting and company
>
>                 preferences
>
> To: webERP Developers <web...@li...
> <mailto:web...@li...>>
>
> Message-ID: <52C...@lo...
> <mailto:52C...@lo...>>
>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Yes, the software comes with the translation, but the PHP server needs 
> to have the gettext extension installed a
>
> http://nz1.php.net/_
>
> and the locale of your language needs also to be installed on your 
> server. This is about web-server configuration not about webERP.
>
> Phil
>
> Phil Daintree
>
> Logic Works Ltd - +64 (0)275 567890
>
> http://www.logicworks.co.nz
>
> On 05/01/14 15:32, Bharata Kalbuaji wrote:
>
> >
>
> > The extension is okay. So, does the download version already include
>
> > locale language? I saw in the locale folder there is already exist
>
> > indonesian language.
>
> >
>
> > _____________________
>
> > Bharata Kalbuaji
>
> >
>
> > On Jan 5, 2014 9:00 AM, "Phil Daintree" <ph...@lo...
>
> > <mailto:ph...@lo...>> wrote:
>
> >
>
> >     Try the demo at http://www.weberp.org/weberp
>
> >
>
> >     There are some tricks to php config the language locale must be
>
> >     installed on the server and the gettext php extension must be
> enabled.
>
> >
>
> >     Bharata <bha...@gm... <mailto:bha...@gm...
> <mailto:bha...@gm...%20%3cmailto:bha...@gm...>>> wrote:
>
> >
>
> >         Hello, currently I'm developing an ERP system for some small
> company in Indonesia. I see that WebERP already have Indonesia 
> langauage buat when I change the language to Indonesian, the language 
> is still in english. I tried another language and it still the same.
> Is there any plugin or something to change the language because I 
> tried the demo, the language can be changed. Also, I tried to change 
> the company preference like name, address, and currency, but when I 
> click the submit button, it doesn't submit and just stay o
>
> >         n the same page. Why is this happening? Is there some bugs? 
> Thank you for your reply.
>
> >
>
> >         --
>
> >         -------------------------
>
> >         Bharata Kalbuaji
>
> >
>
> >
>
> > --------------------------------------------------------------------
> > --
>
> > --
>
> >
>
> >         Rapidly troubleshoot problems before they affect your
> business. Most IT
>
> >         organizations don't have a clear picture of how application
>
> > performance
>
> >
>
> >         affects their revenue. With AppDynamics, you get 100%
> visibility into your
>
> >         Java,.NET, & PHP application. Start your 15-day FREE TRIAL
> of AppDynamics Pro!
>
> >
>
> > http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg
> > .c
>
> > lktrk
>
> >
>
> >
>
> > --------------------------------------------------------------------
> > --
>
> > --
>
> >
>
> >         Web-erp-developers mailing list
>
> > Web...@li...
> <mailto:Web...@li...>
>
> > <mailto:Web...@li...>
>
> >
>
> >
>
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> >
>
> >
>
> >     Phil Daintree
>
> >     +64(0)275 567890
>
> >     skype: daintree
>
> >
>
> > 
> ----------------------------------------------------------------------
> --------
>
> >     Rapidly troubleshoot problems before they affect your business.
>
> >     Most IT
>
> >     organizations don't have a clear picture of how application
>
> >     performance
>
> >     affects their revenue. With AppDynamics, you get 100% visibility
>
> >     into your
>
> >     Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
>
> >     AppDynamics Pro!
>
> > 
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.c
> lktrk
>
> > _______________________________________________
>
> >     Web-erp-developers mailing list
>
> > Web...@li...
> <mailto:Web...@li...>
>
> >     <mailto:Web...@li...>
>
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> >
>
> >
>
> >
>
> > --------------------------------------------------------------------
> > --
>
> > -------- Rapidly troubleshoot problems before they affect your
>
> > business. Most IT organizations don't have a clear picture of how
>
> > application performance affects their revenue. With AppDynamics, you
>
> > get 100% visibility into your Java,.NET, & PHP application. Start 
> > your
>
> > 15-day FREE TRIAL of AppDynamics Pro!
>
> > http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg
> > .c
>
> > lktrk
>
> >
>
> >
>
> > _______________________________________________
>
> > Web-erp-developers mailing list
>
> > Web...@li...
> <mailto:Web...@li...>
>
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> -------------- next part --------------
>
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 3
>
> Date: Sun, 5 Jan 2014 11:29:56 +0700
>
> From: Bharata Kalbuaji <bha...@gm... 
> <mailto:bha...@gm...>>
>
> Subject: Re: [WebERP-developers] Bug in language setting and company
>
>                 preferences
>
> To: webERP Developers <web...@li...
> <mailto:web...@li...>>
>
> Message-ID:
>
>                 
> <CAD...@ma...
> <mailto:CAD...@ma...ail
> .com>>
>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Oh, thank you for your answer. I will install locale in my server then.
>
> _____________________
>
> Bharata Kalbuaji
>
> On Jan 5, 2014 10:44 AM, "Phil Daintree" <ph...@lo... 
> <mailto:ph...@lo...>> wrote:
>
> >  Yes, the software comes with the translation, but the PHP server
>
> > needs to have the gettext extension installed a
>
> >
>
> > http://nz1.php.net/_
>
> >
>
> > and the locale of your language needs also to be installed on your
> server.
>
> > This is about web-server configuration not about webERP.
>
> >
>
> > Phil
>
> >
>
> > Phil Daintree
>
> > Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>
> >
>
> > On 05/01/14 15:32, Bharata Kalbuaji wrote:
>
> >
>
> > The extension is okay. So, does the download version already include
>
> > locale language? I saw in the locale folder there is already exist
>
> > indonesian language.
>
> >
>
> > _____________________
>
> > Bharata Kalbuaji
>
> > On Jan 5, 2014 9:00 AM, "Phil Daintree" <ph...@lo...
> <mailto:ph...@lo...>> wrote:
>
> >
>
> >> Try the demo at http://www.weberp.org/weberp
>
> >>
>
> >> There are some tricks to php config the language locale must be
>
> >> installed on the server and the gettext php extension must be enabled.
>
> >>
>
> >> Bharata <bha...@gm... <mailto:bha...@gm...>> wrote:
>
> >>>
>
> >>> Hello, currently I'm developing an ERP system for some small 
> >>> company
>
> >>> in Indonesia. I see that WebERP already have Indonesia langauage
> buat when I change the language to Indonesian, the language is still 
> in english. I tried another language and it still the same. Is there 
> any plugin or something to change the language because I tried the 
> demo, the language can be changed. Also, I tried to change the company 
> preference like name, address, and currency, but when I click the 
> submit button, it doesn't submit and just stay o n the same page. Why 
> is this happening? Is there some bugs? Thank you for your reply.
>
> >>>
>
> >>> --
>
> >>> -------------------------
>
> >>> Bharata Kalbuaji
>
> >>>
>
> >>> ------------------------------
>
> >>>
>
> >>> Rapidly troubleshoot problems before they affect your business. 
> >>> Most
>
> >>> IT organizations don't have a clear picture of how application
>
> >>> performance
>
> >>>
>
> >>> affects their revenue. With AppDynamics, you get 100% visibility
>
> >>> into your Java,.NET, & PHP application. Start your 15-day FREE 
> >>> TRIAL
>
> >>> of AppDynamics
>
> >>> Pro!http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/414
> >>> 0/
>
> >>> ostg.clktrk
>
> >>>
>
> >>> ------------------------------
>
> >>>
>
> >>> Web-erp-developers mailing
>
> >>> lis...@li...
> <mailto:lis...@li...>
>
> >>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> >>>
>
> >>>
>
> >> Phil Daintree
>
> >> +64(0)275 567890
>
> >> skype: daintree
>
> >>
>
> >>
>
> >> -------------------------------------------------------------------
> >> --
>
> >> --------- Rapidly troubleshoot problems before they affect your
>
> >> business. Most IT organizations don't have a clear picture of how
>
> >> application performance affects their revenue. With AppDynamics, 
> >> you
>
> >> get 100% visibility into your Java,.NET, & PHP application. Start
>
> >> your 15-day FREE TRIAL of AppDynamics Pro!
>
> >>
>
> >> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.
>
> >> clktrk _______________________________________________
>
> >> Web-erp-developers mailing list
>
> >> Web...@li...
> <mailto:Web...@li...>
>
> >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> >>
>
> >>
>
> >
>
> > --------------------------------------------------------------------
> > --
>
> > -------- Rapidly troubleshoot problems before they affect your
>
> > business. Most IT organizations don't have a clear picture of how
>
> > application performance affects their revenue. With AppDynamics, you
>
> > get 100% visibility into your Java,.NET, & PHP application. Start 
> > your
>
> > 15-day FREE TRIAL of AppDynamics
>
> > Pro!http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/
> > os
>
> > tg.clktrk
>
> >
>
> >
>
> >
>
> > _______________________________________________
>
> > Web-erp-developers mailing
>
> > 
> lis...@li...https://lists.sourceforge
>
<mailto:lis...@li...https://lists.sourceforg
e>.
>
> > net/lists/listinfo/web-erp-developers
>
> >
>
> >
>
> >
>
> >
>
> > --------------------------------------------------------------------
> > --
>
> > -------- Rapidly troubleshoot problems before they affect your
>
> > business. Most IT organizations don't have a clear picture of how
>
> > application performance affects their revenue. With AppDynamics, you
>
> > get 100% visibility into your Java,.NET, & PHP application. Start 
> > your
>
> > 15-day FREE TRIAL of AppDynamics Pro!
>
> > http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg
> > .c
>
> > lktrk _______________________________________________
>
> > Web-erp-developers mailing list
>
> > Web...@li...
> <mailto:Web...@li...>
>
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> >
>
> >
>
> -------------- next part --------------
>
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> ----------------------------------------------------------------------
> --------
>
> Rapidly troubleshoot problems before they affect your business. Most 
> IT organizations don't have a clear picture of how application 
> performance affects their revenue. With AppDynamics, you get 100% 
> visibility into your Java,.NET, & PHP application. Start your 15-day 
> FREE TRIAL of AppDynamics Pro!
>
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.c
> lktrk
>
> ------------------------------
>
> _______________________________________________
>
> Web-erp-developers mailing list
>
> Web...@li...
> <mailto:Web...@li...>
>
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> End of Web-erp-developers Digest, Vol 92, Issue 4
>
> *************************************************
>
>
>
> ----------------------------------------------------------------------
> -------- WatchGuard Dimension instantly turns raw network data into 
> actionable security intelligence. It gives you real-time visual 
> feedback on key security issues and trends.  Skip the complicated 
> setup - simply import a virtual appliance and go from zero to informed 
> in seconds.
> http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.
> clktrk
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

----------------------------------------------------------------------------
--
WatchGuard Dimension instantly turns raw network data into actionable
security intelligence. It gives you real-time visual feedback on key
security issues and trends.  Skip the complicated setup - simply import a
virtual appliance and go from zero to informed in seconds.
http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk

------------------------------

_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers


End of Web-erp-developers Digest, Vol 92, Issue 19
**************************************************

Re: [WebERP-developers] Web-erp-developers Digest, Vol 92, Issue 19

[opto <bu...@op...>]

I did follow this thread only partially:

I we have a sequence number, which can be very helpful:

for MRP, we should have an additional part. required xx days from start of
WO.

For big machines with long production time, that would help the cashflow -
parts needed at the end need not be bought at the beginning.
I think it would not be too difficult to change the MRP to include this.
I am not quite sure I may even have made a proposal or even a code submissin
some time ago concerning this. (That was at the time when I discovered that
MRP procures parts for the end date of the WO, not the start date of the MO:
I think I also submitted a patch for that).
thanks,

Klaus



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Re-Web-erp-developers-Digest-Vol-92-Issue-19-tp4657203p4657205.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Web-erp-developers Digest, Vol 92, Issue 19

[Phil D. <ph...@lo...>]

Hi Muthu

I have applied your modification to the trunk... is there anywhere that 
this field should actually be used though at the moment I have only 
modified BOMs.php so the data can be input and edited. Presumably this 
field is useful on a report somewhere?

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz