ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Suggestions for Updates >> LOT AVAILABILITY IN INV-B
http://www.istechforum.com/YaBB.pl?num=1161706535

Message started by bigjoe on 10/24/06 at 08:15:35

Title: LOT AVAILABILITY IN INV-B
Post by bigjoe on 10/24/06 at 08:15:35

I would like to see a button in INV-B to show lot availability of an item that has lot control.

Title: Re: LOT AVAILABILITY IN INV-B
Post by GasGiant on 10/24/06 at 11:33:29

I would be great in IN-A, but why in IN-B?

Title: Re: LOT AVAILABILITY IN INV-B
Post by NovaZyg on 10/24/06 at 11:42:23

With the Drill Downs in Evo you can add it to any place there is an inventory lookup.

You just need to use SU-A to create the lot grid, then SU-B to add the drill down link.

Title: Re: LOT AVAILABILITY IN INV-B
Post by jduncan on 11/07/06 at 11:24:25

Can we get more detailed instructions on how this would be done, please.

Title: Re: LOT AVAILABILITY IN INV-B
Post by NovaZyg on 11/07/06 at 12:21:57

I just added it in 2 mins to the SU-B program. I can email it to you it is ISDRILLM.B or you can do it yourself... You need to be on the latest Evo release (10/31/06)

Run SU-B from the queries menu. select the Drill button. Press the Add button to add a new drill down, as the parent select the Inventory grid, then for the child select the LOT grid, use the mtlot.code as the index. Type in the menu text for the drop down (lot availability) then select the Source field in this case the BKIC.PROD.CODE and in the Target field select MTLOT.CODE. Save and you are ready to go. You now have a new option in the drill down (green down arrow) button on all the inventory lookups for Lot Availability.

Title: Re: LOT AVAILABILITY IN INV-B
Post by bigjoe on 11/14/06 at 12:27:06

That worked smooth for me, except now if I run a lookup for a given part and check lot availability, I get every lot number that has ever been there. So I did a filter to show only quantity on hand greater than zero. I then saved the filter. When I call it up again and go to load the filter it never loads. Is there a special sequence of steps I have to do, it acts like it is loading but never comes up?