[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