Troubleshooting In-transit Documents

In-Transit documents

1. In-transit documents are used to transfer items from one site to another using a Via site.

2. The Via site is not required. If you are not using the Via site, the reason for using an In-transit Transfer would be that you can add Landed Cost to an item when you transfer it.

3. In-transit transfer functionality originated in the Field Service module and was later included in GP Inventory. The tables are inventory tables and they tie to inventory. The tables will start with the prefix SVCxxxxx

4. Life cycle of an in-transit document

   1. Create an in-transit document in the In-transit Transaction Entry window.

   2. Pick you items from the From site in the In-transit Transaction Entry window.

      1. This allocates items at the From site.

   3. Ship your items to the Via site from the From site in the In-transit Transaction Entry window.

      1. This physically moves the items from the From site and places them in the Via site.

   4. Receive your item from the Via site into the To site using a POP Receipt Entry window with an In-transit Receipt type.

      1. This physically moves the items from the Via site and places them in the To site.

   5. Closing the In-transit document. When all lines, and the header, on the In- transit document have a status of 6 the document will automatically move to history (SVC30700, SVC30701, SVC30702)

Tables involved in In -Transit documents

1. The main In-transit tables are the SVC00700, SVC00701, and SVC00702.

2. Inventory tables involved are IV10200, IV10201, IV00200, IV00300, IV30300 and the SEE30303.

3. POP tables involved are the POP10500, POP10300, POP10310, POP10330, POP10390, POP30310, POP30300.

Important columns in the In-Transit tables

1. 1. SVC00700 -In-transit header tables

      a. One line will be added when the in-transit document is created.

      b. Important Columns

• • • ORDDOCID- In-transit document number

    • STATUS

      • 0=Open

      • 1=Picked

      • 2=Packed (not used)

      • 3=Partial Ship

      • 4=Shipped

      • 5= Partially Received

      • 6=Received

      • 99 = Locked

• • • TRNSFLOC -From site

    • ITLOCN-Via site

    • LOCNCODE- To site

2. SVC00701 In-Transit Line table

a. You will have one line for each item line on the in-transit document

b. Important columns

ORDDOCID- In-transit document number

STATUS- same as svc00700

TRNSFQTY-transfer quantity

QTYSHPPD- What has been shipped

QTYRECVD- this is the quantity that has been received by PO receipt

3. SVC00702-Transit Lot/Serial work.

a. You will have a line for each serial/lot line on the in-transit document

What happens during entering and posting an in-transit document.

1. Create an in-transit document in the In-transit Transaction Entry window

Tables that will be updated when the in-transit document is saved but not picked.

1. 1. 1. SVC00700- header record with a status of 0

      2.  SVC00701- one record for each line with a status if zero 0

         SVC00702- one line for each serial number line or one line for each lot tracked line

2.  Pick you items from the From site in the In-transit Transaction Entry window.

1. It will update the status in the SVC00700, SVC00701 tables to a 2 and allocate the items in inventory and in the Lot/Serial tables.

    

2. Ship your items to the Via site from the From site-updates status to 3 (partially shipped) or 4 (fully shipped)

   1.   Svc00700- header record- updates Status to 4 and updates QTYSHPPD column

    

1. SVC00701- one record for each line updates Status of 3 or 4 status

2. SVC00702- updates Status to 3 or 4 for each line shipped.

3. IV30200- one line added to table where BACHNUMB and SRCRFRNCNMBR will be in-transit document number. The docnumbr is the next iv transfer number.

    

1. IV30300- Line is added for each line in the in-transit document. TRXSORCE will be SCIITXXXX, DOCTYPE will be 3, DOCNUMBR will be the next inventory transfer number

    

2. IV10201-one line added with the TRXLOCTN is the From site and the ORIGINDOCID will be the next inventory transfer number.

1. IV10200-one line for the via site is added but the RCPTSOLD=1, there will be an amount in the quantity received, nothing in the QTYSOLD, and a quantity in the QTYRESERVED.

    

2. IV10200-One line will be updated for the issue From site. It will update the QTYSOLD for this site. The SRCRCTSEQNM column in the IV10201 will indicate what line (RCTSEQNM) in the IV10200 for the item will be updated.

    

3. SEE30303- There will be two line. One line for the From site that to will remove the quantity from the from site. A second line will be added the quantity arriving at the Via site. The DOCNUMBR will be the IV transfer document number and the DOCTYPE will be 3.

    

4. IV00200 or IV00300- The line will be allocated and the LTNUMSLD will be marked as sold but the QTYSOLD column will not be updated at this point.

    

1. Enter the PO In-Transit Receipt and saved in a batch

1. POP10500-a line will be added for each line on the PO In-transit shipment. The PONUMBER column will be the in-transit document number.

    

2. POP10300- Receipt header -One line will be added with the POPTYPE of 8 and the VENDORID will be blank.

    

3. POP10310 Receipt Line-lines will be added for each line on the receipt.

4. POP10330- Receipt Serial Lot-lines will be added for each serial/lot numbered line on the receipt.

1. Post the PO In-transit Receipt

1. POP10500 updates Status

2. Updates POP history tables as when any receipt is posted

3. IV10200-a new line will be added to bring the items into the To site. QTYSOLD will be updated with the receipt quantity and QTYRESERVED will be zeroed out for the Via site layers. (North is the Via site and South is the To site)

4. IV10201 -A new line is added for each line on the receipt for the Via site showing the items are sold. It will have a DOCTYPE of 4.

5. IV30300- Lines are added for the items received on the In-transit POP receipt. They will have the Via site in the TRXLOCTN column and the To site in the TRNSTLOC column.

6. SEE30303 There will be two line. One line to remove the quantity from the Via site and the second line to add the quantity into the To site. The DOCNUMBR=4 which is a POP Receipt document number.

    

1. Close the In-Transit Transfer

   1. When all the line have a been fully received and all the lines have a status of 6, the In-transit document will be updated with a status of 6 and will automatically update move the document from the open tables to the history tables. The history tables are the SVC30700, SVC30701, and SVC30702.

   2. If the document has a status of 6 in the SVC00700 and did not move to history there are no utilities to move it.

Scripts to use

SELECT * from IV10200 where RCPTNMBR='Enter your in-transit doc number   '

SELECT * from IV10201 where origindocid in (select docnumbr from IV30200 where BACHNUMB='Enter your in-transit doc number   ')

select * from SVC00700 where ORDDOCID = 'Enter your in-transit doc number       '

select * from SVC00701 where ORDDOCID = 'Enter your in-transit doc number       '

select * from SVC00702 where ORDDOCID = 'Enter your in-transit doc number       '

select * from SVC30700 where ORDDOCID = 'Enter your in-transit doc number       '

select * from SVC30701 where ORDDOCID = 'Enter your in-transit doc number       '

select * from SVC30702 where ORDDOCID = 'Enter your in-transit doc number       '

select * from POP10300 where POPRCTNM in (select POPRCTNM from POP10500 where PONUMBER = 'Enter your in-transit doc number       ')

Select * from POP10310 where PONUMBER = 'Enter your in-transit doc number       '

select * from POP30300 where POPRCTNM in (select poprctnm from POP30310 where PONUMBER = 'Enter your in-transit doc number       ')

select * from POP30310 where PONUMBER = 'Enter your in-transit doc number       '

select * from POP10500 where PONUMBER = 'Enter your in-transit doc number     '

select * from iv00300 where itemnmbr in (Select itemnmbr from svc00702 where ORDDOCID = 'Enter your in-transit doc number       ')

select * from iv10200 b, iv00300 a where a. itemnmbr=b. itemnmbr and a. rctseqnm=b. rctseqnm and b. rcptnmbr='Enter your in-transit doc number   '

select * from iv00300 a, svc00702 b where a. itemnmbr=b.itemnmbr and a.DATERECD=b.daterecd and a. DTSEQNUM=b.DTSEQNUM and b. orddocid='Enter your in-transit doc number   ' and a.lotnumbr=b. SERLTNUM

select * from iv00200 a, svc00702 b where a. itemnmbr=b.itemnmbr and a.DATERECD=b.daterecd and a. DTSEQNUM=b.DTSEQNUM and b. orddocid='Enter your in-transit doc number   ' and a.SERLNMBR=b. SERLTNUM

select * from iv10200 where RCPTNMBR in (select poprctnm from POP30310 where PONUMBER = 'Enter your in-transit doc number       ')

select * from iv10201 where ORIGINDOCID in (select poprctnm from POP30310 where PONUMBER = 'Enter your in-transit doc number       ')

SELECT * FROM SEE30303 A, POP30310 B WHERE A. DOCNUMBR= B. POPRCTNM AND A.ITEMNMBR=B.ITEMNMBR AND B. PONUMBER='Enter your in-transit doc number' AND VARIANCEQTY='0'

SELECT * FROM SEE30303 A, IV30200 B WHERE A. DOCNUMBR=B.DOCNUMBR AND B. BACHNUMB='Enter your in-transit doc number' AND VARIANCEQTY='0'

SELECT * FROM IV30300 A, IV30200 B WHERE A. DOCNUMBR=B.DOCNUMBR AND B. BACHNUMB='Enter your in-transit doc number'  

SELECT * FROM IV30300 A, POP30310 B WHERE A. DOCNUMBR= B. POPRCTNM AND A. ITEMNMBR=B. ITEMNMBR AND B. PONUMBER='Enter your in-transit doc number'

How to troubleshoot a failed POP receipt for an In-transit document.

1. Look at the status in the SVC tables. If the status is still a 3 or 4 it means the SVC tables do not see the POP receipt as posted. This increases the probability that you will be able to enter a new In-transit Receipt.

2. Next, I look in the IV10200 and IV10201. If the In-Transit receipt posted, I will see two lines in the IV10200 and two lines in the IV10201. If there are two lines in both tables for the In-transit document, it means it was received successfully.