2
Good day,
I have an In Transit Transfer, it was shipped. The items are allocated to the via site. But I am unable to receive the document. When I go to Receiving Transaction I am seeing the In Transit number. If I try to auto receive the number is not there, if I try manually, I can get the item number but I cannot enter the quantity, it says it's already received.
Because of the allocated quantities I cannot do the standard transfer.
How can I get around this?
Regards
Rosemary
Good day,
Thank for your detailed response, the status in the Header and Details table is 4.
The PORDNMBR is in the IV10200 table with the PCHSRCTY = '8'.
There is also a receipt batch that has not been posted with the same PORDNMBR.
The allocated quantity most likely is from the unposted receipt, I am checking with the Inventory department to verify the quantities.
Regards
Rosemary
Hi Rosemary,
When an In Transit Transfer is in a Shipped Status (in the Via Site), the status on the transaction should be set to 4.
STATUS Values for ITT tables:
0-Open
1-Picked
2-Packed
3-Partial Shipped
4-Shipped
5-Partial Received
6-Received
99-Locked record(damaged)
Based on this, I would start by verifying that the STATUS is 4 on each of the following tables. (Replacing XXXXX with your In Transit Transfer Number)
select STATUS,* from SVC00700 where ORDDOCID = 'XXXXX' -- Header Info
select STATUS,* from SVC00701 where ORDDOCID = 'XXXXX' -- Details
select STATUS,* from SVC00702 where ORDDOCID = 'XXXXX' -- Serial or Lot tracked info
If these are all set to 4, then I would see if maybe someone already selected it on a different receipt that is unposted. (Replacing XXXXX with your In Transit Transfer Number)
select * from POP10500 where POPTYPE = '8' and PONUMBER = 'XXXXX'
If you get a record in this table, note the POPRCTNM as this means that this in transit transfer is already selected to be received on that receipt number so that receipt would need to be deleted if it is not already posted if you want to receive it on a different receipt.
You could also check the inventory tables to see if it has already been posted to inventory or not. (Replacing XXXXX with your In Transit Transfer Number)
select * from IV10200 where PCHSRCTY = '8' and PORDNMBR = 'XXXXX'
If the statuses are jumbled or it's posted to Inventory but still available to receive against, then it may be best to open a support case so we can review the specific condition and make recommendations on a fix. If you are going to do any SQL updating on your own, please always do it in test first.
Thanks!
Isaac Olson
Microsoft Support
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (