cancel
Showing results for 
Search instead for 
Did you mean: 

Stock Transfer table?

Former Member
0 Kudos

Experts,

I am in need of trying to find out how I can get a detailed list of all "ST" transactions with line details for a certain date range. Is this a table that I can query against? I am thinking that the transaction type is "67" but not 100% percent sure. I have tried looking at the OINM table, but I am not seeing some of the transactions there that are on the Inventory Posting list.

To give you an idea of what I am working on, the Inventory manager needs a report to show him all Goods Issues, Goods Receipts, and ST transactions for a certain date range. I have the first two parts but I am missing the ST transactions.

Any help would be appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

ST stands for Stock Taking. It is not for Stock Transfer. They are available through OINM. Post your query if you still have trouble.

Thanks,

Gordon

Former Member
0 Kudos

Gordon,

Here is the basic query I am using just to find any ST transactions in the OINM table.

Select * 
from OINM
Where  Warehouse LIKE 'TC%' AND  TransType = 58

But I do not get any results..... I go and look at the Inventory posting list and see quite a few transactions there. What is it I am doing wrong?

Former Member
0 Kudos

Try this first:

Select *

from OINM

Where TransType = 58

Former Member
0 Kudos

Returns 0 results...

I was searching around and tried using this query

SELECT     OIQR.DocEntry AS Expr1, IQR1.DocLineNum, IQR1.ItemCode, OITM.ItemName, IQR1.Price, IQR1.Quantity, IQR1.OcrCode, IQR1.WhsCode, 
                      IQR1.DocTotal, OIQR.DocDate
FROM         IQR1 INNER JOIN
                      OIQR ON IQR1.DocEntry = OIQR.DocEntry LEFT OUTER JOIN
                      OITM ON IQR1.ItemCode = OITM.ItemCode
WHERE     (IQR1.WhsCode LIKE 'TC%')

Inventory Stock Posting Table.... Would it be wise to use this table to get the same results?

Former Member
0 Kudos

You need to omit this first:

WHERE (IQR1.WhsCode LIKE 'TC%')

Former Member
0 Kudos

I get all sorts of items when I omit the TC part. I added that just to cut down on all the results. Now that I have added it, it seems to be returning the correct results, but I am not sure this is the correct table I can use for ST transactions?

Former Member
0 Kudos

Yes. For 8.8 version and above, this is the one. OINM is only a view for the new version. It got data from this table for Inventory Posting.

Former Member
0 Kudos

GREAT!

Thank you so much Gordon, as usual you have solved the issue!

I will use this query to get the results that are needed.

Answers (0)