Sage 100

I have a customer who called and they are using the ALE in shipping data entry for Item Package LIst. Their business requirement is to be able to review the list of items in shipping data entry and also view the associated AliasItemNo.

It appears that I'm only able to see the AliasItemNo field for items that are in Package No 0001. Anything other than Package 001 shows as blanks for AliasItemNo (although other added fields such as item description will show)

Is this a bug or possibly an enhancement gone wild? 

At this point I'm curious if anyone has run across this and, if so, whether you have a resolution. Otherwise I'll open a support case with Sage to review.

------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
Moodus, CT
------------------------------

I did a little more digging on this and it appears that the lookup makes use of the SO_PackageTrackingByItem file in Sage. 

I am able to see that the SO Order and SO Invoice both are holding an Alias Item number for the respective inventory item.

My theory is that there may be a program issue where the alias isn't being copied for packages other than 0001 into SO_PackageTrackingByItem which in turn is what's causing the ALE to appear wrong ( if my theory is correct the ALEis actually functioning and there's some other program related issue which is quite possibly enhancement related)

I backed into the table that this ALE lookup used by using the lookup wizard once I get to the lookup 

------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
Moodus, CT
------------------------------