Handling Bale Packing In ERPNext

[Jyot Talreja]

Hi,

I am currently running a textile company where I receive goods from my supplier in meters. This is then packed into bales and kept in stock. Each bale is uniquely recognized by a bale no and could consists of any number of meters ranging from 300m to 600m. I receive and dispactch sales orders in terms of bales only but my invoice is based on number of meters in a bale.

An example: 

Quality X 2000 meters of batch no 15(say) received from supplier A on 26/05/2013

Quality X repacked into 5 bales of 451m, 449m, 402m, 398m, 300m. Each given a unique number say 123 to 127.

These bales are dispatched to various customers based on orders received in June.

Currently I am having an issue of representing my stock in bales as I cannot pass a stock entry as it picks up a fixed UOM conversion entered in the item details. In my case a bale can consists of any number of meters. 

One way of handling the issue according to my analysis, could be to create a doctype consisting of batch no, bale no, meters. Now for each sales order, while creating a delivery note a bale no reference is attached which provides the number of meters to be invoiced for. Also each bale no will have a delivery note reference and bales that do not have a bale no reference are available for dispatch. Though this is just one approach, I am looking for suggestions to handle bale packing in a more easier fashion.

Looking forward to your suggestions. Thanks in advance

[Rushabh Mehta]

Jyot,

here is a solution:

1. You have to create separate items for X and Bale (XBALE).

2. Bale must have UOM as NOS and must be Serialized.

3. You have to do a repacking process from X (-451m) to XBALE (+1) using Stock Entry, in the Serial Number, set the meters in that bale for that item.

4. deliver your bales using Delivery Note.

Making Custom DocTypes should be the last possible resort as it gets harder to maintain them with time.

best,

Rushabh

--
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--

https://erpnext.com

Twitter: @rushabh_mehta

[Jyot Talreja]

Hi Rushabh,

Many thanks for the suggestion. While the solution solves the problem partly, the important to note is I sell my goods to the clients in terms of number of meters. So while making the delivery note: the price of the bale depends on the number of meters it contains and hence i cannot use the pricelist feature or decide a price of a bale.

Secondly, Tally ERP 9 provides a facility of compound units/multi units. I havent done a deep dive into what tally offers: http://www.tallysolutions.com/website/html/tallyerp9/functions-specialneeds-multi-units.php

The key here is while i have inventory in bales, my sale is in meters. While your suggest solves my representation in inventory, managing my sales is difficult as everytime i sell a bale i need to manually calculate its value (serial no (that is no of meters) * rate per meter). 

Please could you suggest how to manage my delivery note creation without creating a doctype.

Thanks,

Jyot

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+unsub...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Jyot Talreja]

To futher clarify, bale is just like a reference for certain number of meters in inventory that are sold to customers based on their orders. So say bale no 123 in inventory corresponds to 400.5 meters of quality z from batch x. When I make my delivery note, my client should be billed based on number of meters based on the bale reference.

[Rushabh Mehta]

Did not understand how Tally understands it either, let me know if you figure out.

Sometimes the solution likes outside the system. For example, why not standardize the no of mtrs in a bale, this kind of standardisation will help you in other places either and also give you a better idea of your inventory. You can have various Item codes for Bale like Bale 400, Bale 410, Bale 420 etc... It may not have exact meters, but you can price it as an average. For example Bale 400 may have anywhere between 395 - 405 mtrs...

I know your answer will be "but this is not the way the industry works" -- well, sometimes you need to question that.

In the user manual, I have a chapter on this - repeatability and profitability (unfortunately not linkable, but that should 

change soon). 

Do give it a thought.

best,

Rushabh

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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@googlegroups.com.

[Jyot Talreja]

Hi Rushabh,

I have explored a little and observed how a couple of ERPs are handling the issue. In the stock entry, we can add two custom fields Alternate Quantity and Alternate UOM and for goods packed as bale, we make the following entry:

Quality X -405m
Quality X Bale +1 which is serialized as per the bale no which will have alternate UOM as meters and alternate quantity as 405.

Now while making the delivery note, we would require the software to pull the values of alternate quantity and alternate UOM from the stock entry. And the rate of the item could be specified in either of the UOMs (base or alternate).

Example: Delivery Note

Quality	Batch	Serial No	Alternate Qty	Alternate UOM	Rate	Rate UOM
Quality X	1523	32616	405	Mtr	45	Mtr

Please let me know how could I go about writing the script for the delivery note/sales invoice and stock entry customization.

Thanks

[Nabin Hait]

Hi Jyot,

You can definitely handle the issue by "Alternate Qty" and "Alternate UOM" and maintaining price list against them. But it needs a lot of changes if we want to fit it into the standard product.

If you have a background in coding, you can do the customization yourself. Otherwise, you can get it done from any third party developer, who have a good experience in doing customization in erpnext.

To start with coding, check "get_item_details" function in selling.doctype.sales_common.sales_common.py file. Here you will find the code for fetching the rate as per price list.

Regards,

Nabin Hait

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@googlegroups.com.

[Jyot Talreja]

Hi Nabin,

I will try to code it myself (have a computer science background). Will post if I need some help. Many thanks.

Jyot

[Nabin Hait]

Best of luck! And feel free to post in forum if you stuck anywhere.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@googlegroups.com.