on 11-30-2011 1:38 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
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?
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.