Dynamics Community Forum Thread Details

Duplicate Lines in ReqTrans

Hello

I am pulling data from REQTRANS table REFTYPE = 8. I am getting duplicate lines with either the same quantity or 2 lines with quantity that's been received and remaining quantity. Each line has 2 different REQPROCESSID. How do I get the correct lines with correct remaining quantity?

Thanks!

Daren

Did you ever figure this out? If not, maybe the following will help a little.

1) In ReqTrans for RefType = 8 (Purchase Order), the same RefId can appear any number of times.
I am looking at our environment and the first example of a ReqTrans for RefType = 8 I found has RefId xxx0137919. There are 253 ReqTrans records for that RefId in a single plan (our static plan) for a single MRP run (single ReqProcessId value).

First, the RefId is for the purchase order, not the purchase order line. If the purchase order has 10 lines, then you could easily have 10 ReqTrans records with that same RefId.

Second, a single purchase order line can have multiple rows in ReqTrans. For example, if 500 units were purchased to be used in producing finished goods, those 500 units on that one PurchLine could be assigned to 100 different production orders (their production BOMs) where each production order BOM line gets qty 5.

2) As to why you have duplicated ReqProcessId values, I don't know.
You can query the ReqLog table using the ReqProcessId to see the StartDateTime and EndDateTime. If one of them is not recent (maybe it is from last year), you MIGHT want to consider writing an X++ job/Runnable class that deletes the ReqTrans records for that RecProcessId.

Quick Links

Leaderboard