Edit Bin Location in JIWA7

[Ernst]

Our customer has been using Bin Location Mode- AllowDirecEdit in JIWA6, and now looking at moving to JIWA7, would like to keep this option available, as they type in all kinds of information
relating to the Stock item. They already use comment line for other info.

Looking at the table, the IN_SOH still contains a BinLocationDesc text field and not a pointer to the lookup, so it should be possible to edit this from the Inventory Maintenance, SOH tab.

Has anybody been able to get this going?

[Ernst]

Could serialno, be made modifiable?

[Scott.Pearce]

So what they really need are custom fields against stock lines? I'm actually surprised that we don't already have IN_SOH line custom fields - you should log a enhancement request via the helpdesk.

[Ernst]

That was my first check... Thx.

I found a plugin to open serialNo. Just wonder if anybody has been able to open bin location yet?

[Ernst]

Used the serialNo Plugin.. Updated it to 721, and made it do Bin Location also.

Will this be OK- Scott?

[Mike.Sheen]

You need to check for a null bin location here:

Code: Select all

sohItem.BinLocation.Description = grdSOH.GridText(ColID, Row)

if sohItem.BinLocation is not null, then you can set the description of it. If it is null, then you need to set it to a new BinLocation entity.

Also, you don't need that SQL in the SaveEnding to update IN_SOH with the description - the business logic will do that for you. Serial numbers behaved a little different, so the SQL there was necessary.

Good effort - your grade is a B-

[Ernst]

B- .. Wow thx. You made my day..

[Ernst]

OK commented out the update SQL, and Bin location still updates. You are right...thx

Not sure how to do this..

if sohItem.BinLocation is not null, then you can set the description of it. If it is null, then you need to set it to a new BinLocation entity.

[Mike.Sheen]

OK commented out the update SQL, and Bin location still updates. You are right...thx

Not sure how to do this..

if sohItem.BinLocation is not null, then you can set the description of it. If it is null, then you need to set it to a new BinLocation entity.

Actually, I was wrong on this, after checking.

You can't have a SOH item with a null bin location - it gets created for you when a SOH item is created, so it should never be null.

But the way to set it (if I happened to be wrong about being wrong and it turns out I was initially right) then you'd do this:

Code: Select all

sohItem.BinLocation = sohItem.Manager.EntityFactory.CreateEntity(Of JiwaApplication.Entities.Inventory.BinLocation)()


So your grade is revised to an A-

[Ernst]

Double thank you sensei.. Here is completed plugin.. for anybody who want to make Serial No/ Bin Location modifiable on SOH tab.. in 721. And its in VB.. Double plus.