Material Management for material issued by client

Shujaat_Kargathra · October 1, 2018, 10:37am

Hi, nice to contact you

Please inform if following feature is available in ERP Next.

One of our business unit consists of service projects, but material to be installed on site is issued to our client. Our client is electricity utility company of our city.
Please refer below:

Project scope is service project.
Various material is issued to our company by warehouse (Store) of our client
We receive this material from client warehouse and transport to our warehouse
Some material requires unit conversion for installation at site
Required material is transported to project site and it is installed at site.
Remaining material is returned back to our store, which is later on returned back (submitted back) to client.
if material is not installed at site, and also if it is not returned back to client, we have to bear deduction of amount for missing items.

Please Note:
For invoicing and billing of services provide, we understand that project and Service Items available in ERP next can be used.

Please inform if the above mentioned material management is available in ERP.

ushashmi · October 2, 2018, 5:46pm

Do you charge any handling fee or warehousing fee to your client for that material?

Shujaat_Kargathra · October 3, 2018, 4:32am

Dear Ushashmi,

When We charge handling fee or warehousing fee, then it is included in client purchase order for service project, and hence we are paid that fee by client.

We want to manage and maintain the following:

Material received from client, and transported to our store-1.
Material is moved from store 1 to store 2.
Installable Material is installed at site. - like cables,wires, clamps, distribution boxes, nuts & bolts, poles, bus bars etc.)
Step 2 or step 3 also involves unit conversion, for example material is issued in weight, but installed in length like copper wires. or nut & bolts, issued in weight but installed in quantity.
Material is installed or consumed at site.
Remaining material is returned back to client.
Fixed amount is deducted from our service invoice if any installation material is damaged or lost.

ushashmi · October 3, 2018, 6:54am

@Shujaat_Kargathra you can achieve this as follows;

In addition to your normal stock accounts in Chart of account create one more account by name lets say “Temporary Stock” under the main inventory group.
Receive inventory on cost through Stock entry Material Receipt option and charge the difference account to “Temporary Stock”. So technically speaking Debit Credit will be under one group account and there will be zero impact on balance sheet.
All the transfers within stores will be Debit Credit within that group only.
when stock is consumed you can use stock entry with purpose material issue and charge the difference account to same “Temporary Stock” the stock will be depleted and difference will be Debit Credit under same group.

Hope this will fulfill all your requirements

Shujaat_Kargathra · October 3, 2018, 10:17am

Thanks dear ushashmi,

We will confirm you with successful implementation

Shujaat_Kargathra · November 10, 2018, 11:51am

@ushashmi, when creating Stock Entry Material Receipt, we cannot maintain record of store from where material is issued.

Shujaat_Kargathra · November 10, 2018, 12:21pm

@ushashmi - Please refer to attached files, and the following error is displayed when creating Items Transfer,

Valuation rate not found for the Item 10002160, which is required to do accounting entries for Stock Entry . If the item is transacting as a zero valuation rate item in the Stock Entry, please mention that in the Stock Entry Item table. Otherwise, please create an incoming stock transaction for the item or mention valuation rate in the Item record, and then try submiting/cancelling this entry.

Shujaat_Kargathra · November 10, 2018, 12:31pm

Material Request and transfer for Item issued by Customer/Client

Installed Apps:
ERPNext: v10.1.66 (master)
Frappe Framework: v10.1.58 (master)

We provide service to install material purchased by client at project(s) / site(s) / scheme(s) of respective Customer/client.

A. This scenario is for management of client supplied items by our client K-Electric.
Service Items(Invoice Items) are seperate from these items.
We have created both the service items and Client Supplied Material Items in stock
Hereby we require solution to manage Client Supplied Material.

A.1 Item is issued from client from their store/warehouse upon our request
A.2. This item transfer does not creates any receivable or payable, nor it affects any payments etc for storage, warehousing or transportation.
A.3. We have to keep track of material request, issue, transfer, Installation at site (fixing at the project), and return back any extra quantity to the client.
A.4. Client Issued Material and Purchase Invoice for installation service of these items are entirely different, having different item codes and description.
Item codes and description is provided by client, and we are bound to use respective item codes and description.
A.5. These items are not purchase or sales item
A.5. We do have unit conversation wiht some items, such as Cable is issued in Weight from KE Store, consumed in feet at site, returned back to store in weight.

Customer → K-Electric

Material Issued by different stores of K-Electric(KE) for their various Project/Sites.

1.a We have 2 business units, dealing with two different sections of K-Electric - Underground Cable laying (UG), Overhead cable (OH)/transformer/poles installation
1.b. We have to receive material for UG or OH Project from store/warehouse of k-electric
1.c Upon awarding of Project, we make material request to the specified store/manager.
1.d Complete or partial material issuance is made.
1.c Some material is transferred at our office store, some material is transferred directly to Project Site (Store)
1.d. Material transferrd at our store is transfferred to Project store upon requirement
1.e. After installation job is complete, remaining material is either transferred to our office store, or directly transferred back to client store.
1.f. Remaining material transferred to office store is than transferred back to client store.

There are not strict restrictions:
Material issued from one K-Electric store can be returned back either to same K-E store or any other K-E store
Material issued for Project 1 can be used in project 2, project 3 etc.

Requirement:
We want to keep track of material requested, issued, installed/consumed at site, remaining quantity, quantity returned back to client.

Please find the following attatched herewith

Warehouse tree
Two items being used in material transfer
Transfer screenshot
error received when we make transfer.

Your help and assistance are highly appreciated.

Salmanmulani · November 13, 2018, 4:43am

About Valuation rate error:

As per perpetual inventory system, system books expenses (COGS) while delivering the items. To book the expense, system tries to pick the actual buying amount (landed cost) as per valuation method. But if system does not found any incoming entry for the delivery warehouse, then it tries to get the valuation rate from any incoming transaction against any other warehouse. If still valuation rate not found, system picks valuation rate from Item master.

Also you can specify an item is a sample item in any stock transaction. There is a field “Is Sample Item” in every Item table in the stock transactions. If an item is a sample item, system will allow that item with zero valuation rate.