Re: [WebERP-developers] Bug? MRP for WO at reqdate instead of startdate

[Tim S. <ti...@we...>]

Hi Klaus,

Yes keeping each revision in the table and then just adjusting the sql
in the view to pick the info from the latest revision.

Also we could track major and minor revision numbers by keeping the
numbers in the systypes table.

Would need help from someone more knowledgeable about this, such as
you, to decide on the correct fields we need, but using a view will
allow us to do that without breaking weberp.

BTW the sql in the view that I sent earlier was slightly wrong it
should have been:

 CREATE VIEW bom (`parent`, `component`, `workcentreadded`, `loccode`,
`effectiveafter`, `effectiveto`, `quantity`, `autoissue`)
AS SELECT bomheader.productid, bomlines.componentid,
bomlines.workcentreadded, bomheader.loccode, bomlines.effectivefrom,
bomlines.effectiveto, sum(bomlines.quantity), bomlines.autoissue FROM
bomheader LEFT JOIN bomlines ON bomheader.bomid=bomlines.headerid
GROUP BY bomheader.productid, bomlines.componentid

Thanks
Tim

On 30 May 2012 07:42, opto <bu...@op...> wrote:
> Hi Tim,
>
> yes, this sounds very good, epecially using the view to keep track of all
> other old scripts.
>
> One might need a new header upon every change to the BOM?
>
> Ideally, each change to a BOM needs to create a new revisionlevel.
> For file storage, web2project does something similiar, autonumbers
> major/minor revisions and also stores the old db records.
>
> The 'new' product related directives of the European community demand more
> entensive product documentation than before, so a good system/support for
> automatic (maybe in addition to a free text field) revision numbers would be
> good.
>
> thanks,
>
> Klaus
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Bug-MRP-for-WO-at-reqdate-instead-of-startdate-tp4651206p4655141.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers



-- 
WebERP Africa Ltd
+447710427049
+254706554559
www.weberpafrica.com
@TimSchofield2