IV00103 ItmVndTy

(0) Share

Report

Posted on by Community Member

I have over 5,000 records in IV00103 where the ItmVndTy = 0. From what I understand the only allowable values for this field are 1 and 2.

Does anybody know if 0 is an allowable value? I can update the 0 values but I'm not sure what impact (if any) that will have.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Mahmoud Saadi 32,738 on at

Like (2)

Report

I have seen this case quite often, which is an abnormal case as the standard predefined values of this field is precisely 1 and 2 (1 for primary vendor and 2 for non-primary vendor). In all the cases I see this case, the fields; vendor id and vendor item number (VENDORID, VNDITNUM) are empty with no details.

Unfortunately, I never had the time to track down the root cause of the problem to find why would such record exists. Therefore, I preferred to keep them since deleting them would never be of any added value.

Is this your case ? Is the vendor ID field empty as well ?

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The Vendor ID Field has data. They are valid VendorID numbers. The VndItNum field is also populated

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

Then I would never recommend deleting these records.

Was this reply helpful? Yes No
Redbeard 12,931 on at

Like (0)

Report

Tim,

Have you checked to see if these records are duplicates?

Was this reply helpful? Yes No
Suggested answer

GMA 1,074 on at

Like (1)

Report

I came across quite a few zeros in field ITMVNDTY of my IV00103 table as well. Then searching came across this post.

So I dug in a little and it appears that these may be related to "In-Transit" transfers. So far the last receipt date (lsrcptdt field) has tied to In-Transit transfers.

This is causing problems with a script I wrote, but instead of deleting them, I am just adding ITMVNDTY <> 0.

Was this reply helpful? Yes No