Tasks #10428: Locator Issues - Temp Projects - Posibolt

Tasks #10428

Locator Issues

Added by Rijas P over 1 year ago. Updated 8 months ago.

Status:

Closed

Priority:

High

Assignee:

Rijas P

Start date:

05/04/2023

Due date:

% Done:

50%

Estimated time:

Spent time:

1.00 h

Description

Dear Thanesh,

Case 1

If there is only 1 locator with no stock, then it's ok come to the -ve stock if we did Stock out transactions.

But if the item has multiple locators and have stock on 1 locator then the Qty should less from the locator have stock instead of getting negative in other locators.

Eg:            
              Locator wise Stock
            Product Name: EU18785

Quantity Locator Warehouse Organisation

2619.00 D17 EURO Warehouse Euro Novelties LLc
-202.00 0-0-0 EURO Warehouse Euro Novelties LLc
-202.00 D13 EURO Warehouse Euro Novelties LLc
-205.00 D12 EURO Warehouse Euro Novelties LLc
-211.00 D4 EURO Warehouse Euro Novelties LLc

Case 2

We need an option In Sales return screen to choose the Locator where we want to keep back the item.

Case 3

The To Locator option is not working proper in Stock transfer screen

Eg: if we add 3 items in Stock transfers with different "To locator" then after complete it, the last line locator will update for all items.

Item To Locator

EU19754 A1
EU19753 A2
EU19752 A3

Once complete all the items will update in Locator A3.

Case 4

"To locator" field in CSV template in Stock transfer import.

History

Updated by Peer Thanesh over 1 year ago

Assignee changed from Peer Thanesh to Mohamed Suhail

For Case1,2 & 4, when discussed with Rijas, He is expecting an enhancement on this. Do I need to create a ticket for this?
For case 3 is a bug, can I create a ticket for that?

Updated by Mohamed Suhail over 1 year ago

Status changed from New to In Progress
Assignee changed from Mohamed Suhail to Peer Thanesh
% Done changed from 0 to 50

Peer Thanesh wrote:

For Case1,2 & 4, when discussed with Rijas, He is expecting an enhancement on this. Do I need to create a ticket for this?
For case 3 is a bug, can I create a ticket for that?

Peer Thanesh Please raise a bug for #3

I checked issue #1 and found that it happened due to a locator made inactive (D17) in the system where there was stock qty for the item

See the list of inactive locators in the warehouse where stock qty is there for the item

name   | m_product_id | m_locator_id | value | qtyonhand 
---------+--------------+--------------+-------+-----------
 EU18784 |      1011017 |      1010835 | D17   |      4101
 EU18785 |      1011018 |      1010835 | D17   |      2618
 EU18786 |      1011019 |      1010835 | D17   |      3189
 EU19754 |      1011864 |      1010835 | D17   |        57
 EU23006 |      1026581 |      1010835 | D17   |      1845
 EU23009 |      1026584 |      1010835 | D17   |      1930
 EU21951 |      1024237 |      1010838 | D18   |      1283
 EU23005 |      1026580 |      1010838 | D18   |      1806
 EU23007 |      1026582 |      1010838 | D18   |      1818
 EU23008 |      1026583 |      1010838 | D18   |      1866
 EU19883 |      1012033 |      1000298 | IG    |     -1092
 EU15807 |      1005988 |      1000223 | X     |      1390
 EU15807 |      1005988 |      1000222 | Y     |     -1390
(13 rows)

We need to make an enhancement in the system to check if there are any items with non-zero stock available on the locator before marking it as inactive @savad