Hello Again

I wonder if someone could shed some light on the following amv procedure:

I have an order qty confirmation process,

after entering the Order No. I go and read stuff and fill a number of prompts and in particular an amv that looks something like this:

Stock Code Description Price Qty Ord Qty Rec'd

ABC01 Widget 12.30 110

ABC02 Wodget 65.75 250

ABC03 Wudget 33.66 103

All amv prompts are protected except the Qty Rec'd prompt

After leaving the Order No prompt it is meant to go to the amv.

If I do nothing, the AMV gets skipped altogether.

If I set the following code in the Post Prompt of the Stock Code

If mv=1 then

amv.action=4

* (Can use wc_amv_action% if you like)

end

then the prompt moves to the Qty Rec'd field and lets me put in numbers and behaves admirably.

Now here is the fun part…

I can navigate using the key or the and arrows except..

If at any time I press the arrow when on the Order No prompt, it goes into an infinite loop at the amv.

If I press the at the order No prompt it works perfectly fine

Why?

Moreover how do I stop it or at least prevent the arrow from being active when on the Order No. prompt

Any help would be greatly appreciated.

TIA

Claude

Claude,

If you are filling a single column of data, and all the other fields are protected, then you should make the prompt order (Shift-F7 in paint) such that the first item in the group (the controlling field) is your field that you enter data for.

The infinite loop is caused by the product item code (the earliest prompt number in the AMV group) being protected.

Steve

The loop may be caused by your method of getting the code description In some cases, if it is not controlled by the @MV variable then it could be displaying every code description for each code causing the description field to fill up with garbage descriptions.

Thanks

I didn't realise that prompt order manipulation in amvs was a stable and allowable thing to do.

I knew there must have been a simple answer

Claude

I just tried your suggestion Steve, but because it was now the first prompt in an amv it expected to be filled.

Trouble is, there may be 100 rows in the amv and the user just wants to page down to line 64 and enter a '1'. You can only do this if all the prompts in the first amv column are a value, e.g. 0.

Trouble is, it looks crap.

Also and don't work without the 0s.

I went back to the original process and added a wi.next=14 (I was on wi=7) and the whole thing started to work, arrow and all.

You learn something new ……

Thanks for your help

Claude

Claude,

You may still have problems when you use the Up arrow on the screen to track back through fields.

A better way would have been to unprotect the transaction code field, have it as the controlling field, and then traverse it until the desired item is reached, then Enter to the dollar amount.

Controlling fields must be unprotected, with all elements populated. Logically, they are like defacto key fields to their row ("record")

in the AMV.

Still, AMVs can be awkward critters to streamline, as you found out. If the screen is crap tell your client I take full responsibility .

Cheers,

Steve

Another approach might be to select the tiem of interest from a popup, and then a simple, single valued collector could collect the qty rcvd and the commuter then populates the record.

Claude,

One other thing that you could try to get rid of the infinite loop is instead of making the first prompted just protected "P", make it "Protected but do not skip","VP". This gives the cursor somewhere to "land" when the press the down arrow key.

[email protected]

Thanks for your suggestions fellas

Claude

View this thread on the forum...