web-erp-users

[webERP-users] Changing a serial number

[rfthomas <rf...@as...>]

Is there a means/utility to changing the serial number of an inventory item? 
If we receive/create a serialized item and the user mistypes the serial
number there is no obvious way to correct the error.  So far the only
mechanism is to delete the item and re-enter it.  The problem occurs when
there is significant activity involving the mis-serialized item.  Deleting
the item does correct/update the item's history.



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Changing-a-serial-number-tp4658735.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Changing a serial number

[gilberto d. s. a. <gs...@gm...>]

hi. please what is your version? are you using phpmyadmin? how many itens?

--
gilberto dos santos alves
+55(11)9-8646-5049
sao paulo - sp - brasil





2017-02-01 15:44 GMT-02:00 rfthomas <rf...@as...>:

> Is there a means/utility to changing the serial number of an inventory
> item?
> If we receive/create a serialized item and the user mistypes the serial
> number there is no obvious way to correct the error.  So far the only
> mechanism is to delete the item and re-enter it.  The problem occurs when
> there is significant activity involving the mis-serialized item.  Deleting
> the item does correct/update the item's history.
>
>
>
> --
> View this message in context: http://weberp-accounting.
> 1478800.n4.nabble.com/Changing-a-serial-number-tp4658735.html
> Sent from the web-ERP-users mailing list archive at Nabble.com.
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>

Re: [webERP-users] Changing a serial number

[rfthomas <rf...@as...>]

Our version is 4.13.1.  We do have phpmyadmin.  Currently it would be for 4
items.

Unfortunately, we did not catch this problem early enough in our
manufacturing so we need to have some means of updating history or formally
noting that a serial number was changed.

Also we are seeing inventory counts that are incorrect when adds and removes
are performed of serial numbered items.

The user attempted to correct the problem by deleting the part with wrong
serial number and then adding parts with correct serial number.  He did this
3 times and the stated quantity on-hand is 12 instead of 4.  HE was using
the ability to make a notation when removing and inserting items so that
there was an audit trail.



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Changing-a-serial-number-tp4658735p4658737.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Changing a serial number

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

Hi, Bob,
        
        You can use inventory adjustment to correct this problem. It's
currently the only method available in weberp. I've developed some scripts
to improve the serial no control facility before but it's not available now
since i'm out of office in the following weeks. 
         Best regards!
         Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Changing-a-serial-number-tp4658735p4658738.html
Sent from the web-ERP-users mailing list archive at Nabble.com.