@ud doesn't catch what you'd think it would

[Mike Fedkiw]

So after all of this, I decided to check something, it seems as though 
all the 09/15/14 dates on the reports were probably accurate because I 
was dropping all of the thems that were tagged deleted. When I went 
looking into the invy file through IUA, I was starting at the beginning 
of the file, like record #1 but that file is so old, everything I looked 
I saw with different dates were actually tagged deleted now and not 
included in the report.

Now I have no idea exactly what process I may have run that actually 
updated everything on 09/15/14 but apparently something I imported or 
ran updated all of the active items @ud on that day.

As for the useless @ud field,I just tried adding a few items to an 
invoice and then took a look at the items through IUA in the invy file. 
Guess what, the @ud field didn't change at all. BUT, if i actually 
change something on that record from within IUA, I see tha @ud instantly 
change.

What use is the @ud if it can't catch changes to the records in a file.

All I do when I change something like the on hand is do a lookup to that 
inventory record and then something like 
invy(97)=invy(97)-xinv(20);write invy;return, well something like that 
anyway.

Thanks for all of the reply's today, at least it helped me figure out 
that I was going in a direction that's just a dead end for what I needed.

Mike





On 9/24/2014 7:04 PM, Kenneth Brody wrote:
> On 9/24/2014 6:14 PM, Mike Fedkiw wrote:
> [...]
>>>> start  ◄ If:
>>>>         Then: lookup invy  k=xx   i=E -ng
>>> [...]
>>>
>>> Forget about the lookup entirely.  Go into dscreen on "invy", and add
>>> "!@UD" to a screen.  Then go into dclerk directly to the "invy" 
>>> file, and
>>> scroll through the files.  What does @UD show?
>>
>> That's what I did and It shows different dates on pretty much every 
>> record
>
> So, a lookup to "invy" shows one date for "invy(@UD)", but plaing 
> "!@UD" on a screen in invy shows a different date?
>
> Can you simplify the processing, and arrange to send files to fPTech 
> to demonstrate?
>
> BTW:
>
>> getud  ◄ If:
>>        Then: rn=invy(@rn)
>> 104  -------   -   -   -   -   -   -   -   -
>>        ◄ If:
>>        Then: lookup invyud = invy  r=rn   -e
>> 105  -------   -   -   -   -   -   -   -   -
>>        ◄ If:
>>        Then: ud=invyud(@ud)
>> 106  -------   -   -   -   -   -   -   -   -
>>        ◄ If:
>>        Then: return
>> 107  -------   -   -   -   -   -   -   -   -
>
> This is pretty much a "useless use of a lookup", as the entire 
> subroutine can be replaced with "ud=invy(@ud)".  (I am assuming that 
> you tried this, assuming that there was something "wrong" with getnext 
> here?)
>