Re: [WebERP-developers] Who moved the stock?

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

I like the sound of 2 too. But yep more work - but more generic and I am 
pretty sure as soon as you coded 1 a requirement might come up for who 
processed an invoice... credit note, adjustment etc etc.

Phil

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

On 13/12/14 22:19, Pak Ricard wrote:
> Hi all:
>
> We face the need to know "Who moved the stock", in an easy and 
> final-user-friendly way (in normal scripts), so we need something 
> besides the audit trail, aimed to system admins not for stock managers.
>
> The solution should imply the addition of the userid field somewhere, 
> and so far I see 2 options:
>
> 1) add the userid in locationtransfers table, at reception time. We 
> would then know who received the items. The "where" and the "when" are 
> already answered by recloc and recdate fields.
>
>   * Pros: it's a very limited change in webERP
>   * Cons: we miss some other kind of movements
>
>
> 2) add the userid in stockmoves table. It is a wider change in webERP 
> but would allow us to control all stock movements, not only the 
> location transfers.
>
>   * Pros: it's system wide, we will know for every step, who moved the
>     stock.
>   * Cons: a lot of scripts would need revision.
>   * Also, in case of "sales invoice" movements we already know the
>     "who sold the items", the saleperson recorded in the salesorder,
>     but not who recorded that information in webERP (might be the same
>     or not, depending on each webERP configuration.). With this new
>     field we can know that.
>
>
> Both solutions solve my problem, but I can code the option 2 if the 
> majority agrees, as I see it a better option. Besides the coding, I 
> see no side effect problem.
>
> A quick search and we have around 41 INSERT INTO stockmoves that would 
> need modification, and probably the StockMovements.php script.
>
> Does it make any sense to the community? Anything I'm overlooking?
>
> Regards,
> Ricard
>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers