Affect a specific Inventory Asset against a vendor bill

Dear ERPNext Support,

I appreciate your work and the product. You have done a wonderful job with the GUI.

We are considering this application for one of our Customers. While evaluating various aspects of the Accounting, I am unable to achieve the following:

Business Scenario - My Warehouse (an external, shared Warehouse) has an inventory item e.g. Alphonso Mango Juice, Drum of 200 KG with total inventory of 20 Drums priced at USD 100 per drum. So my Inventory cost is USD 2000.

I need to label these drums so I ask my Warehouse guy to do the same. He charges me USD 5 per drum for re-labelling. So my expense is USD 100 and my total inventory asset becomes USD 2100.

When I am selling Alphonso Mango Juice to my Customer, my inventory cost of each Drum has increased from USD 100 to USD 105. So I should sell my inventory Drum for anything more than USD 105 to make a profit. 

My Query - When my Warehouse sends me a bill of USD 100, is there a way for me to associate this cost to my Warehouse Item when I am processing a Vendor Bill?

I appreciate your response on how to achieve this in ERPNext transaction? Thanks in advance.

Sarang



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-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/52bf61c3-6e83-44dd-b38e-8f8a328cd08d%40googlegroups.com.

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

This cost can be added to the item valuation any time via Landed Cost Voucher which will be released on next week. To know more check https://frappe.io/blog/erpnext-features/landed-cost

Dear ERPNext Support,

I appreciate your work and the product. You have done a wonderful job with the GUI.

We are considering this application for one of our Customers. While evaluating various aspects of the Accounting, I am unable to achieve the following:

Business Scenario - My Warehouse (an external, shared Warehouse) has an inventory item e.g. Alphonso Mango Juice, Drum of 200 KG with total inventory of 20 Drums priced at USD 100 per drum. So my Inventory cost is USD 2000.

I need to label these drums so I ask my Warehouse guy to do the same. He charges me USD 5 per drum for re-labelling. So my expense is USD 100 and my total inventory asset becomes USD 2100.

When I am selling Alphonso Mango Juice to my Customer, my inventory cost of each Drum has increased from USD 100 to USD 105. So I should sell my inventory Drum for anything more than USD 105 to make a profit.

My Query - When my Warehouse sends me a bill of USD 100, is there a way for me to associate this cost to my Warehouse Item when I am processing a Vendor Bill?

I appreciate your response on how to achieve this in ERPNext transaction? Thanks in advance.

Sarang



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-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/52bf61c3-6e83-44dd-b38e-8f8a328cd08d%40googlegroups.com.

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



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-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMfNnTi%2BYimJaDt40euNZVezAqev-HV-eAj-v498kxxRm0aiKA%40mail.gmail.com.

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

Thanks Nabin for a prompt reply.

Will you please consider the issues I faced?

1. My inventory was imported into the Warehouse and not purchased. I am initiating a new inventory. I could not select the Purchase Receipt in the present Landed Cost Wizard because my Inventory was imported and not purchased.
2. Considering your feature update, will I be making 2 entries? Consider this - A. I have received a Vendor Bill and I need to process it as a vendor bill by affecting the Accounts Payable-Vendor Account and B. I also make an entry in the system through Landed Cost Voucher to update my Inventory Cost?

Thanks.

Sarang
 

On Saturday, August 9, 2014 12:56:28 PM UTC+5:30, Nabin Hait wrote:

This cost can be added to the item valuation any time via Landed Cost Voucher which will be released on next week. To know more check https://frappe.io/blog/erpnext-features/landed-cost

Dear ERPNext Support,

I appreciate your work and the product. You have done a wonderful job with the GUI.

We are considering this application for one of our Customers. While evaluating various aspects of the Accounting, I am unable to achieve the following:

Business Scenario - My Warehouse (an external, shared Warehouse) has an inventory item e.g. Alphonso Mango Juice, Drum of 200 KG with total inventory of 20 Drums priced at USD 100 per drum. So my Inventory cost is USD 2000.

I need to label these drums so I ask my Warehouse guy to do the same. He charges me USD 5 per drum for re-labelling. So my expense is USD 100 and my total inventory asset becomes USD 2100.

When I am selling Alphonso Mango Juice to my Customer, my inventory cost of each Drum has increased from USD 100 to USD 105. So I should sell my inventory Drum for anything more than USD 105 to make a profit. 

My Query - When my Warehouse sends me a bill of USD 100, is there a way for me to associate this cost to my Warehouse Item when I am processing a Vendor Bill?

I appreciate your response on how to achieve this in ERPNext transaction? Thanks in advance.

Sarang



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-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/52bf61c3-6e83-44dd-b38e-8f8a328cd08d%40googlegroups.com.

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



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-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/4514c8ff-daa4-4eec-b9ab-57093e5e1566%40googlegroups.com.

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