Shop Floor Data Collection

Hi Everyone.

Just managed to install ERPNext on an Ubuntu 12 server, it’s up and running and I’m just starting to learn how to use it.

What I need to know is can I collect data via a bar code reader attached to a PC on our shop floor, we currently do this with our current system to collect things like clocking in and out and logging onto jobs for the shop floor staff.

This is important to us and could be a deciding factor as to whether we migrate or not.

Cheers

Martin


Martin,

Thanks for the interest.

What kind of data do you collect? From what I understand you track material movement via a barcode reader? We have not done this before. Our manufacturing (production) module is also under major redevelopment.

I would suggest if you find the other parts of the system useful and to your expectations, we can see if there something we could do for this. Maybe we could make a feature that can create a Stock Entry via a CSV file upload (though I can't promise anything now).

best,
Rushabh



W: https://erpnext.com
T: @rushabh_mehta

On 16-Aug-2012, at 6:45 PM, Martin Fryer <mf...@gmail.com> wrote:

Hi Everyone.

Just managed to install ERPNext on an Ubuntu 12 server, it's up and running and I'm just starting to learn how to use it.

What I need to know is can I collect data via a bar code reader attached to a PC on our shop floor, we currently do this with our current system to collect things like clocking in and out and logging onto jobs for the shop floor staff.

This is important to us and could be a deciding factor as to whether we migrate or not.

Cheers

Martin



Dear Martin,




Do you assign unique barcode for each unit of an item (which we actually call serial no. is system). Or is barcode nothing but a Item Code made for simplicity when making transaction? ERPNext allows you manage both, Serial nos. as well as Barcode. Below is the image of item master indicating where to enter items barcode and how to make it serialized.


Inline image 1




Considering both the scenario, lets understand role of barcode in production cycles transaction.



1. Material issue for production:



For Serial No.:

This is the stage when raw-material is accumulated into shop floor for starting production. If raw-material is serialized (unique barcode on each unit), you will be able to mention items serial nos. based on quantity of items transferred. For example, if transferring 10 units of item for production, it will ask for 10 unique serial nos.


For Barcode:
If barcode is just used for Item Code, you can scan barcode with cursor in Item Code field. System will read barcode and fetch value. And based on item code fetched, other item details like name, description, qty in warehouse will be pulled from Item master.

2. Backflush:

For Serial No.:
Backflush is a production entry which is made against production order when raw-material is converted into finished good. Here you can specify the serial no for newly produced finished good.

For Barcode:
If you are using barcode for just selecting item code in transaction, then it will not be required in production entry. As both production and raw material items will be pulled from BOM.

Hope this helps you implement production module with serial no. / barcode functionality. For more help, please check ERPNext Manual.

Look forward to hear from you.

--
Thanks and Regards,
Umair Sayyed
um...@erpnext.com
www.erpnext.com



On Thu, Aug 16, 2012 at 6:45 PM, Martin Fryer <mf...@gmail.com> wrote:
Hi Everyone.

Just managed to install ERPNext on an Ubuntu 12 server, it's up and running and I'm just starting to learn how to use it.

What I need to know is can I collect data via a bar code reader attached to a PC on our shop floor, we currently do this with our current system to collect things like clocking in and out and logging onto jobs for the shop floor staff.

This is important to us and could be a deciding factor as to whether we migrate or not.

Cheers

Martin









On Friday, August 17, 2012 10:36:22 AM UTC+1, Umair Sayyed wrote:

Dear Martin, 



Do you assign unique barcode for each unit of an item (which we actually call serial no. is system). Or is barcode nothing but a Item Code made for simplicity when making transaction? ERPNext allows you manage both, Serial nos. as well as Barcode. Below is the image of item master indicating where to enter items barcode and how to make it serialized.


Inline image 1




Considering both the scenario, lets understand role of barcode in production cycles transaction.



1. Material issue for production:



For Serial No.:

This is the stage when raw-material is accumulated into shop floor for starting production. If raw-material is serialized (unique barcode on each unit), you will be able to mention items serial nos. based on quantity of items transferred. For example, if transferring 10 units of item for production, it will ask for 10 unique serial nos.


For Barcode:
If barcode is just used for Item Code, you can scan barcode with cursor in Item Code field. System will read barcode and fetch value. And based on item code fetched, other item details like name, description, qty in warehouse will be pulled from Item master.

2. Backflush:

For Serial No.:
Backflush is a production entry which is made against production order when raw-material is converted into finished good. Here you can specify the serial no for newly produced finished good.

For Barcode:
If you are using barcode for just selecting item code in transaction, then it will not be required in production entry. As both production and raw material items will be pulled from BOM.

Hope this helps you implement production module with serial no. / barcode functionality. For more help, please check ERPNext Manual.

Look forward to hear from you.

--
Thanks and Regards,
Umair Sayyed
um...@erpnext.com
www.erpnext.com



On Thu, Aug 16, 2012 at 6:45 PM, Martin Fryer <mf...@gmail.com> wrote:
Hi Everyone.

Just managed to install ERPNext on an Ubuntu 12 server, it's up and running and I'm just starting to learn how to use it.

What I need to know is can I collect data via a bar code reader attached to a PC on our shop floor, we currently do this with our current system to collect things like clocking in and out and logging onto jobs for the shop floor staff.

This is important to us and could be a deciding factor as to whether we migrate or not.

Cheers

Martin






The data we collect is mainly worker clock in and out times and clocking on to a job to record the time taken to perform a particular task, ie. a guy may be welding a part for a project so he clocks onto that job then when he's finished he then clocks on to his next job which automatically clocks him off the first one and so on. There's usually 2 bar codes, one for the Project and one for the Task the worker is performing.

 

Just testing this posting, please ignore this line.

On Thursday, August 16, 2012 2:15:11 PM UTC+1, Martin Fryer wrote:

Hi Everyone.

Just managed to install ERPNext on an Ubuntu 12 server, it’s up and running and I’m just starting to learn how to use it.

What I need to know is can I collect data via a bar code reader attached to a PC on our shop floor, we currently do this with our current system to collect things like clocking in and out and logging onto jobs for the shop floor staff.

This is important to us and could be a deciding factor as to whether we migrate or not.

Cheers

Martin


Hi Martin,

This would be great addition to erpnext and I think there are many other users like me who would like to implement something like what you are using.

I would request you to kindly shed some light on the way you are doing this in your current system so that users like me could try and get the same implemented in the current product.


On Friday, August 17, 2012 3:42:03 PM UTC+5:30, Martin Fryer wrote:



On Friday, August 17, 2012 10:36:22 AM UTC+1, Umair Sayyed wrote:
Dear Martin, 



Do you assign unique barcode for each unit of an item (which we actually call serial no. is system). Or is barcode nothing but a Item Code made for simplicity when making transaction? ERPNext allows you manage both, Serial nos. as well as Barcode. Below is the image of item master indicating where to enter items barcode and how to make it serialized.


Inline image 1




Considering both the scenario, lets understand role of barcode in production cycles transaction.



1. Material issue for production:



For Serial No.:

This is the stage when raw-material is accumulated into shop floor for starting production. If raw-material is serialized (unique barcode on each unit), you will be able to mention items serial nos. based on quantity of items transferred. For example, if transferring 10 units of item for production, it will ask for 10 unique serial nos.


For Barcode:
If barcode is just used for Item Code, you can scan barcode with cursor in Item Code field. System will read barcode and fetch value. And based on item code fetched, other item details like name, description, qty in warehouse will be pulled from Item master.

2. Backflush:

For Serial No.:
Backflush is a production entry which is made against production order when raw-material is converted into finished good. Here you can specify the serial no for newly produced finished good.

For Barcode:
If you are using barcode for just selecting item code in transaction, then it will not be required in production entry. As both production and raw material items will be pulled from BOM.

Hope this helps you implement production module with serial no. / barcode functionality. For more help, please check ERPNext Manual.

Look forward to hear from you.

--
Thanks and Regards,
Umair Sayyed
um...@erpnext.com
www.erpnext.com



On Thu, Aug 16, 2012 at 6:45 PM, Martin Fryer <mf...@gmail.com> wrote:
Hi Everyone.

Just managed to install ERPNext on an Ubuntu 12 server, it's up and running and I'm just starting to learn how to use it.

What I need to know is can I collect data via a bar code reader attached to a PC on our shop floor, we currently do this with our current system to collect things like clocking in and out and logging onto jobs for the shop floor staff.

This is important to us and could be a deciding factor as to whether we migrate or not.

Cheers

Martin






The data we collect is mainly worker clock in and out times and clocking on to a job to record the time taken to perform a particular task, ie. a guy may be welding a part for a project so he clocks onto that job then when he's finished he then clocks on to his next job which automatically clocks him off the first one and so on. There's usually 2 bar codes, one for the Project and one for the Task the worker is performing.

 
Yeah - would be great to have views - we are in the process of a major re-write.

- Rushabh


W: https://erpnext.com
T: @rushabh_mehta

On 18-Aug-2012, at 2:32 PM, Addy <ad...@gmail.com> wrote:

Hi Martin,

This would be great addition to erpnext and I think there are many other users like me who would like to implement something like what you are using.

I would request you to kindly shed some light on the way you are doing this in your current system so that users like me could try and get the same implemented in the current product.


On Friday, August 17, 2012 3:42:03 PM UTC+5:30, Martin Fryer wrote:


On Friday, August 17, 2012 10:36:22 AM UTC+1, Umair Sayyed wrote:
Dear Martin, 

Do you assign unique barcode for each unit of an item (which we actually call serial no. is system). Or is barcode nothing but a Item Code made for simplicity when making transaction? ERPNext allows you manage both, Serial nos. as well as Barcode. Below is the image of item master indicating where to enter items barcode and how to make it serialized.

Inline image 1


Considering both the scenario, lets understand role of barcode in production cycles transaction.

1. Material issue for production:

For Serial No.:
This is the stage when raw-material is accumulated into shop floor for starting production. If raw-material is serialized (unique barcode on each unit), you will be able to mention items serial nos. based on quantity of items transferred. For example, if transferring 10 units of item for production, it will ask for 10 unique serial nos.

For Barcode:
If barcode is just used for Item Code, you can scan barcode with cursor in Item Code field. System will read barcode and fetch value. And based on item code fetched, other item details like name, description, qty in warehouse will be pulled from Item master.

2. Backflush:

For Serial No.:
Backflush is a production entry which is made against production order when raw-material is converted into finished good. Here you can specify the serial no for newly produced finished good.

For Barcode:
If you are using barcode for just selecting item code in transaction, then it will not be required in production entry. As both production and raw material items will be pulled from BOM.

Hope this helps you implement production module with serial no. / barcode functionality. For more help, please check ERPNext Manual.

Look forward to hear from you.

--
Thanks and Regards,
Umair Sayyed
um...@erpnext.com
www.erpnext.com



On Thu, Aug 16, 2012 at 6:45 PM, Martin Fryer <mf...@gmail.com> wrote:
Hi Everyone.

Just managed to install ERPNext on an Ubuntu 12 server, it's up and running and I'm just starting to learn how to use it.

What I need to know is can I collect data via a bar code reader attached to a PC on our shop floor, we currently do this with our current system to collect things like clocking in and out and logging onto jobs for the shop floor staff.

This is important to us and could be a deciding factor as to whether we migrate or not.

Cheers

Martin






The data we collect is mainly worker clock in and out times and clocking on to a job to record the time taken to perform a particular task, ie. a guy may be welding a part for a project so he clocks onto that job then when he's finished he then clocks on to his next job which automatically clocks him off the first one and so on. There's usually 2 bar codes, one for the Project and one for the Task the worker is performing.