Custom Stock Entry

ERPNext
, , , ,
1

Can I create a custom Stock Entry Doctype instead of using the standard one in ERPNext? I think it is possible, but I want to map the table of the custom Stock Entry to the standard Stock Entry table. Is it possible?

2

What are you trying to achieve that you can’t do with the standard/customised Stock Entry?

3

I want to perform some of the calculation on the basic rate and other field in stock entry .

4

Then why not add custom fields to the Stock Entry DocType? They can always be hidden when not used or required.

5

Let me expain , Again !

I want to create a Custom Stock Entry doctype as per our requirements. I want to achieve the functionality where, when I work with the Custom Stock Entry, the data should be reflected in the standard Stock Entry table in the database . it is possible ?

6

No need for the attitude, your original request was vague as to why you needed your own custom Stock Entry DocType, so I asked for clarification.

AFAIK on creation each DocType is linked to it’s own database table, you can’t get it to point to another table for data entry. I was in a similar situation when first starting out on v14, where I wanted different functionality to a standard DocType but a lot of the benefits. It was not possible. The Stock Entry DocType is linked to so many other functions within ERPNext that it was not going to be possible to duplicate it and integrate it in the same way that Stock Entry DocType was.

You could probably write scripts galore to transfer the information in your custom DocType to the original Stock Entry type but the key question is why/what is so different that you need a separate DocType for this?

However, it could just be a lot easier to customise the Stock Entry DocType, by creating a new Stock Entry Type. They are limited to present functions (repack, material issue etc.) but you can create your own and add the fields you require and target scripts to it specifically.

7

Thanks for the clarification!

I have some questions regarding the Standard Stock Entry doctype:

  1. Is it possible to provide the basic_rate manually from my end?
  2. For the Stock Entry type : Manufacturing - In the standard Stock Entry, why is one product considered as the finished product and another as scrap? In my production process, a single raw material results in multiple finished products, and I do not want to treat any of them as scrap.

Expectation:
I would like to:

  • Manually set the basic_rate.
  • Handle a single raw material that results in multiple finished products without categorizing any as scrap.
8

  1. It seems to depend on the Stock Entry Type selected, the basic rate field can be read only or changeable.
    However, you can customise the Items table to add the checkbox Set Basic Rate Manually that allows you to override this.
    image

  2. Haven’t really used this option. Perhaps looking in to the actual Manufacturing side of ERPNext might be a better option. There has been a new series of videos on Build with Hussain about it.
    https://www.youtube.com/@BuildWithHussain

Alternatively you could use the Repack option if it is a simple one raw material makes a different product.