HOW TO CREATE INVERTORY TRANSFER REPORT??

[karthick_s8]

I WANT INV TRANSFER  REPORT AS PER BELOW REQUIREMNT(OWTR,WTR1,OITW)

DOCNUM:

DOCDATE:

FILLER AS FROM WHSE:

ITEMCODE:

DSCRIPTION:

QUANTITY:

WHSCODE

COMMENTS:

WHERE WHSCODE='[%0]'

               OITW.ONHAND > 0

[former_member197621]

Hi Karthick,

Try below method,

In inventory transfer, Press Ctrl + Tab in the Itemcode field.

Choose Document type as "Inventory Transfer", and select warehouse and click ok

you can see the inventory which is post previously.

Select the appropriate inventory transfer and post the entry.

Once you follow these steps, you can see pending stock report using Ctrl + Tab

Please refer below link for more details

[karthick_s8]

HI Prasanna,

its nice, but it showing full report.it wont show what are the items still pending in that warehose

[former_member197621]

Hi ,

You have to select the appropriate warehouse , then it will show only pending quantity .

Note: you have to follow the procedure .

For example: transfer 5 quantity from whs1 to whs2

Then using ctrl+tab , take back 3 quantity from whs2 to whs1.

Now if you press Ctrl+ tab and select the warehouse 2 and click ok

now you can see only 2 quantity pending.

[former_member212181]

Hi Karthick,

Give where condition (OITW.Onhand >0) is not looks like correct parameter to filter.

Please describe your exact requirement

Regards

Unnikrishnan

[karthick_s8]

hi unni Krishnan,

Im doing inv tr from one whse to another whse.

I want a report of stock is pending in which whse and docnum and date for inv tr

[former_member212181]

HI Karthick,

Please try below query

SELECT A.DOCNUM, A.DocDate, A.Filler, B.ItemCode, B.Dscription, B.Quantity, B.WhsCode, A.JrnlMemo [COMMENTS]

FROM OWTR A

INNER JOIN WTR1 B ON A.DocEntry=B.DocEntry

Inner JOIN OITW C ON C.WhsCode=B.WhsCode and B.ItemCode = C.ItemCode

WHERE B.WhsCode=[%0]

AND C.OnHand>0

and A.DocDate>=[%1]

and A.DocDate<=[%2]

Group By A.DOCNUM,A.DocDate,A.Filler,B.ItemCode,B.Dscription,B.Quantity,B.WhsCode,A.JrnlMemo

Thanks

Unnikrishnan

[karthick_s8]

IT IS HELPFUL,IT SHOWS FULL REPORT BUT MY REQUIREMENT IS

IF I TRANSFER 500 NOS TO ONE WHSE .AMONG 500,100 RETURNED AND REMAINING 400 AS PENDING. IN THAT PARTICULAR WHSE..I WANT REPORT AS WHSE WISE PENDING LIKE THIS

[former_member184146]

Hi,

Try this

SELECT A.DOCNUM,A.DocDate,A.Filler,B.ItemCode,B.Dscription,B.Quantity,B.WhsCode,A.JrnlMemo AS COMMENTS

FROM OWTR A INNER JOIN WTR1 B ON A.DocEntry=B.DocEntry

LEFT JOIN OITW C ON C.WhsCode=B.WhsCode

WHERE B.WhsCode=[%0] AND C.OnHand>0

--Manish

[karthick_s8]

hi Manish,

thanks for your quick response, im using the same query what u post here,it shows same item and docnum multiple times...

see d attacment

[former_member184146]

USE DISTINCT

TRY THIS

SELECT DISTINCT A.DOCNUM,A.DocDate,A.Filler,B.ItemCode,B.Dscription,B.Quantity,B.WhsCode,A.JrnlMemo AS COMMENTS

FROM OWTR A INNER JOIN WTR1 B ON A.DocEntry=B.DocEntry

LEFT JOIN OITW C ON C.WhsCode=B.WhsCode

WHERE  C.OnHand>0 AND B.WhsCode=[%0]

ORDER BY A.DocNum