Revert UOM to inner UOM if backorders  Topic is solved

Discussions relating to Jiwa 7 plugin development, and the Jiwa 7 API.

Revert UOM to inner UOM if backorders

Postby DannyC » Thu Sep 30, 2021 3:56 pm

I've got a challenging tweak to develop when UOMs are used on sales orders. I've done sufficient hours fiddling in a plugin to realise that I need assistance! :D

Scenario:
Lets say the base SKU is called EACH.
We have a UOM called CARTON which is 12 EACHes. And a bigger UOM which is BIGCTN, which is 2 CARTONS (so 24 eaches).

We have 7 EACHes SOH.

On a sales order, they order 1 CARTON, but it goes to backorder for 5 and Qty This Del = 7. Fair enough, that's correct.
But when the warehouse staff go to pick it, they see they need to pick 0.58 of a CARTON. But the warehouse staff are, shall we say limited in their maths ability so they want to see that they need to pick 7 EACHes.
So instead of the Jiwa screen showing the UOM as CARTON, I'm trying to get it to switch to the inner UOM and have the UOM ordered qty = Ordered Qty.
In the Jiwa grid, a new line is entered as EACH. As soon as I enter 12 as the Ordered Qty, it immediately populates the UOM Qty = 1 and changes the UOM to CARTON. That is logically correct as I'm ordering a quantity which equals 1 CARTON.
But when I have backordered quantities I want the UOM to remain as EACH. This helps the warehouse staff to know to pick in EACHes, not CARTONs.

Have I explained OK? Over to the brains trust.

PS. I know that I could modify the pick slip but in this case they're using ASPluris and it uses the line UOM.
User avatar
DannyC
Senpai
Senpai
 
Posts: 718
Joined: Fri Mar 22, 2013 12:23 pm
Topics Solved: 31

Re: Revert UOM to inner UOM if backorders

Postby SBarnes » Thu Sep 30, 2021 5:00 pm

Your problem may even be a bit more complex because given you are talking about a scanning system the UOM and Unit can have different barcodes also.
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1696
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 191

Re: Revert UOM to inner UOM if backorders  Topic is solved

Postby Mike.Sheen » Thu Sep 30, 2021 11:35 pm

DannyC wrote:As soon as I enter 12 as the Ordered Qty, it immediately populates the UOM Qty = 1 and changes the UOM to CARTON

It doesn't do that for me... I add the item to an order, the Unit Of Measure is EACH, I key in 12 in the Ordered Quantity and it does not change the UOM - it remains as EACH.
DC1-SalesOrder.png


This is the inventory item UOM configuration:
DC1.png


I'm using 7.2.1 SR5 and the demo data. If you are using a different version to that, it may not be relevant - but it *might* - so that would be nice to know.
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2583
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 807

Re: Revert UOM to inner UOM if backorders

Postby DannyC » Fri Oct 01, 2021 10:23 am

It doesn't do that for me

Odd. I thought that was inherent in Jiwa but I see it also happens like that in my demo database. Must be something customised with this client....back to the drawing board.
User avatar
DannyC
Senpai
Senpai
 
Posts: 718
Joined: Fri Mar 22, 2013 12:23 pm
Topics Solved: 31


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 4 guests