Goods In Transit ( stocks are getting doubled.)

netmanthan · November 6, 2019, 1:08pm

Hi every one,

Goods In Transit
Send to Warehouse: If the Material is being sent at a Warehouse and needs confirmation at the receiving end, this document will be selected in the Stock Entry with type ‘Receive to Warehouse’ to confirm how many items were received. The status will be ‘Goods In Transit’ until all goods are received, after which the status will change to ‘Goods Transferred’.

it’s not working according to the above scenario.

As I send Item from warehouse-A to another warehouse-B then the same time Stock is also get received at Warehouse B. And status is showing In transit.

If I do receive In Transit stocks, then the stocks are getting doubled.

or am I doing wrong ??

pls guide.

R&T
Jawahar R Mallah

netmanthan · December 1, 2019, 12:17pm

Hi Erpext community,
Will anybody guide help me on this topic.

olamide_shodunke · December 1, 2019, 12:35pm

Hi @netmanthan

I did not even know ERPNext has a goods in transit functionality. How did you achieve this??

pipech · December 12, 2019, 2:37pm

I think it’s new feature in version 12.

pipech · December 12, 2019, 2:57pm

I’ve trouble getting this to work too.

When I create “Sent to warehouse” stock entry from warehouse A to B, after submit in “Stock Ledger” or “Stock Summary” it shows that stock already transfer to warehouse B.

When I tried to create “Received at warehouse”.

If I let auto-fill fill all fields (Source is warehouse B, Target is blank) and press Submit it will create error show that “Target warehouse is mandatory for row #”.
If I tried to manually select target warehouse it won’t work either ways
- (B to B) Error: “Source and target warehouse cannot be same for row #”
- (A to B) It will work with double entry (One when create Send to and another when create Received at) (A to B)
- (B to A) Will work but it’ll revert stock transfer

https://github.com/frappe/erpnext/pull/16925

Should we create GitHub issues?

netmanthan · December 12, 2019, 8:10pm

yes create it.
facing same here.

Muzzy · December 12, 2019, 10:16pm

Its in develop branch. Wait for testing to happen and move into V13. I dont think it will be available in V12.

pipech · December 13, 2019, 2:24am

I think it’s in develop branch 9 month ago and has been merged into v12.

As you can see at stock_entry.json on version 12 it already has Send to Warehouse and Receive at Warehouse options.

github.com

frappe/erpnext/blob/dc7a4ac8aff9736c3cde0e68fd65c6e32c743177/erpnext/stock/doctype/stock_entry/stock_entry.json#L133


      
          {
           "bold": 1,
           "fetch_from": "stock_entry_type.purpose",
           "fieldname": "purpose",
           "fieldtype": "Select",
           "hidden": 1,
           "in_list_view": 1,
           "label": "Purpose",
           "oldfieldname": "purpose",
           "oldfieldtype": "Select",
           "options": "Material Issue\nMaterial Receipt\nMaterial Transfer\nMaterial Transfer for Manufacture\nMaterial Consumption for Manufacture\nManufacture\nRepack\nSend to Subcontractor\nSend to Warehouse\nReceive at Warehouse",
           "read_only": 1
          },
          {
           "fieldname": "company",
           "fieldtype": "Link",
           "label": "Company",
           "oldfieldname": "company",
           "oldfieldtype": "Link",
           "options": "Company",
           "print_hide": 1,

olamide_shodunke · December 14, 2019, 12:36am

This would be a very much needed feature, but at the moment it is not working as conceptualized, it is doubling the transaction as stated.

Muzzy · December 14, 2019, 8:28am

If I am not wrong, this feature is already in POS Bahrain. I know one of our client is using it to transfer goods from 1 location to another by having an intermediary warehouse.

Essential_Queries · December 14, 2019, 11:13am

I also have queries related to stock when we create an item we get the field named as ‘opening stock’ . What is its function …as in if we write any number in it i dont see it getting linked to any warehouse

olamide_shodunke · December 14, 2019, 12:14pm

Am not sure of this Muzzy.

I use bahrain and it does not have this feature.

Unless there is a setting I need to check ?

Muzzy · December 14, 2019, 12:27pm

I know this feature is being used. No sure how. @fkardame is on leave this. He knows how it was deployed.

pipech · December 16, 2019, 3:52am

I’ve created GitHub issues for this issues.

https://github.com/frappe/erpnext/issues/19954

Abhinav_Jain1 · February 24, 2020, 11:08am

I am facing the same problem.
Was stuck on it for the whole day thinking I am doing something wrong yesterday before dropping to this page and realizing that its a fault with the system.

Looking forward to a solution to this, since its a very important and needed functionality.

gmbelart · February 27, 2020, 6:56am

Here how I fix this.
I edit this file apps/erpnext/erpnext/stock/doctype/stock_entry/stock_entry.py
on update_stock_ledger method

it will update from this

to this

tested on
erpnext 12.5.1
frappe 12.3.0

Muzzammil_Hussain · June 14, 2020, 9:49pm

Not working.

Majid_Ejaz · August 16, 2020, 2:29pm

How can we fix this?

erpnext 12.10.1
frappe 12.8.4

Muzzammil_Hussain · August 25, 2020, 1:40pm

still no idea

markgates · November 14, 2020, 8:01pm

Hi, did you get any fix for this issue?