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

[Pak R. <pak...@gm...>]

Hi all:

Was not that hard :-)
Commited  in commit 7021. Being quite a few files, please double check in
case I missed something.


Regards,
Ricard

2014-12-14 7:00 GMT+08:00 Phil Daintree <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 567890http://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, FREEhttp://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
>
>
>
> _______________________________________________
> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> 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
>
>