web-erp-developers

[WebERP-developers] Who moved the stock?

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

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

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

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
>
>

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

[ExsonQu <hex...@gm...>]

*Hi, Richard,*

           Thank you for your nice work. 
           Best regards!

           Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Who-moved-the-stock-tp4657900p4657903.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.