You’re offline. This is a read only version of the page.
515
Hi i need help in inventory serial /lot quantity missing in IV30400 table.
I was doing Inventory Transfer Transaction with one line item with serial/lot quantity of 150. while saving the transaction the data was fine in tables IV10001 and IV10002 with same 150 quantity. And my currency decimal is 6 and Quantity decimals is 3.
Where as now i post that transaction, the serial/lot quantity 150 is change to 149 in IV30400 table. i dnt have clue why its happening. And it happens once for a while for different lot items.
Waiting for help...
thanks and Regards,
sathiya
*This post is locked for comments
Hi Sa3ya,
I got the issue. actually GP is trying to insert the remaining qty (1 Piece) in another line in iv30400 via the procedure zdp_iv30400si but the second row is having exactly the same primary key of the first row hence it won't be inserted and no error message comes (Great!) simply ignoring that record and proceeding. Ideally the line seq. number should have been increased to distinguish the additional lines - if any.
I've modified the procedure ZDP_IV30400SI by adding the following code before the insert statement and it works like magic:
DECLARE @ExistingRecordFlag int
set @ExistingRecordFlag = 0
select @ExistingRecordFlag =
count(*) from .IV30400 WHERE
TRXSORCE = @TRXSORCE AND
IVDOCTYP = @IVDOCTYP AND
DOCNUMBR = @DOCNUMBR AND
LNSEQNBR = @LNSEQNBR AND
SLTSQNUM = @SLTSQNUM
IF @ExistingRecordFlag > 0
BEGIN
SET @SLTSQNUM = @SLTSQNUM + 16384
END
Regards,
Hi SA3YA & Soma,
I guess this issue is not in Quantity decimal places. this issue is the affecting of lot item's remaining qty in the SERLTQTY field in IV30400 not as Qty transferred.
Settings may be missed for configuring lot items.
if the general items with the above mentioned UofM results the same issue?
Sathiya,
I think your issue is not solved yet. But you have marked above my and Natarajan suggestions as verified.
Mark the suggested answers as verified if only your issue has been resolved. Otherwise don't do that. Because this will helps to somebody who having the same issue.
Hi SA3YA,
can you attach the item through Item Transaction Entry Inquiry as screen shot?
can you share the screen shot of Item Serial\Lot Definition from Item Maintenance->Options->Track & click arrow(->)
Any customization associated with this window?
Once again thanks for your Reply Natarajan.
In my inventory only two lot items were there. Both the items were causing this issue. But not all the item.
Some times the serial/lot quantity for both the item get updated wrongly as like in the picture.
Will the decimal places will causes this error?
Thanks and Regards,
sathiya
Hi SA3YA,
Usually transferred QTY value get affected in SERLTQTY field. How about other LOT items and during Transfer?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (