Post Reply 
 
Thread Rating:
  • 1 Votes - 4 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Receive serialised purchased items
08-21-2016, 05:14 PM
Post: #1
Receive serialised purchased items
I am using webERP 4.13.

When I receive purchased items which have been set up as serialised & controlled, I have to enter a serial label for each unit of items.

We order items in kg, which means that if we order 100 kg of a given item, we have to enter 100 different labels. That seems wrong. We want to order a single label for the 100 kg, or if our order comes in 2 bags of 50 kg we want to be able to enter a labels for each 50kg bag.

How do we do this? In previous versions of webERP we use to be able to setup manual qty for each label, why can't this be done anymore?


Attached File(s) Thumbnail(s)
   
Find all posts by this user
Quote this message in a reply
08-22-2016, 07:16 AM
Post: #2
RE: Receive serialised purchased items
Well if the item is defined as controlled ... NOT serialised then you can use LOT control and work as you describe.

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
08-22-2016, 05:02 PM
Post: #3
RE: Receive serialised purchased items
(08-22-2016 07:16 AM)phil Wrote:  Well if the item is defined as controlled ... NOT serialised then you can use LOT control and work as you describe.

Dear Phil

thanks, I realised this with some more experimentation last night. However, I now have 1 more question,

if we have controlled purchased items, which are used to make serialised products, can we still trace which item batch were used for mfg'ing these products?
Find all posts by this user
Quote this message in a reply
08-23-2016, 08:45 AM (This post was last modified: 08-23-2016 08:47 AM by phil.)
Post: #4
RE: Receive serialised purchased items
Yes the data for the stock movement contains the detail of which batch it came from there is a table called stockserialmoves that contains the details for all controlled stock movements (not just serialised items).
You will have to specify the lot that the material comes from when it is issued to the work order to make a serialised item. So the issue will have a stock movement record that can be interrogated.

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
08-23-2016, 05:28 PM
Post: #5
RE: Receive serialised purchased items
(08-23-2016 08:45 AM)phil Wrote:  Yes the data for the stock movement contains the detail of which batch it came from there is a table called stockserialmoves that contains the details for all controlled stock movements (not just serialised items).
You will have to specify the lot that the material comes from when it is issued to the work order to make a serialised item. So the issue will have a stock movement record that can be interrogated.

Thank you for the explanation, I have been -re-reading the manual, and understand now that Serialised items are special cases of Controlled items. It is now much clearer.

Quote:Controlled

This field denotes whether the item is to have lot control on it. Lot control is known by several terms including, batch control, bundle control, roll control. In short it allows a reference for each batch of the item to be entered at the time of delivery, transfer, stock check, invoicing etc. When booking in controlled items the batch references and the quantities in each batch must be entered. Many quality control systems that require traceability of raw materials need this functionality to establish what batch of raw material was used in a given work order. Or what roll of cloth was sold to a given customer. Other industries call their lots of product by different names a melt, a cut, a run etc. Every time a transaction involving a controlled item is created, the system will accumulate the quantity from a separate form for selecting the batches (Lot/roll/melt/work order/serial numbers).

Serialised

Serialised is a special case of controlled where the batch size is always one. The system will prompt for the serial number of each item of stock being received and stock records will be maintained for all serial numbers separately. Serialised does not have any effect if controlled is not set.
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)