cancel
Showing results for 
Search instead for 
Did you mean: 

inventory Transfer Query Reports

dineshkumar_k
Participant
0 Kudos

Hi experts

Stock Transfer on DEMO basis(Goods send on Demo and Retrun to office after Demo completes ) In customer Wise Reports

Our solution:

we  have created 2 warehouse .

1. physical warehouse.

2.demo warehouse.

we are using  "Inventory Transfer"

but  our client 

asking Reports is

Header 1Header 2Header 3Header 4Header 5Header 6Header 7Header 8Header 9
Doc numbercustomer NameItem Namewarehouse2warehouse1DEMO DateItem Return DateRemarks

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

How did you send and return demo items?

Thanks & Regards,

Nagarajan

dineshkumar_k
Participant
0 Kudos

Hi Naga,

Same again Same inventory Transfer same customer.

for  Example

warehouse 1 to warehouse 2-- fro Demo Item

warehouse 2 to warehouse 1-for Return demo Item

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try this query with batch number:

SELECT T0.[DocNum], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T4.[DistNumber],  case when T0.[Filler] = 'open' then T0.[DocDate] end as 'Sent date', case when T0.[Filler] = 'REJ_FG' then T0.[DocDate] end as 'Returned date' ,  T0.[Filler] as 'Warehouse 1', T1.[WhsCode] as 'Warehouse 2' FROM OWTR T0  INNER JOIN WTR1 T1 ON T0.DocEntry = T1.DocEntry left join  OITL T2 on t1.docentry = T2.[ApplyEntry] and  T1.[LineNum]  = T2.[ApplyLine] and T2.[ApplyType] = 67 INNER JOIN ITL1 T3 ON T2.LogEntry = T3.LogEntry left join  OBTN T4 on T4.[ItemCode]  =  T3.[ItemCode]  and T3.[MdAbsEntry]  =  t4.[absentry] WHERE T0.[CardCode] = [%0] GROUP BY T0.[DocNum], T0.[DocDate], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T4.[DistNumber], T0.[Filler], T1.[WhsCode]

Thanks & Regards,

Nagarajan

Answers (1)

Answers (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Did you check above query?

Thanks & Regards,

Nagarajan

dineshkumar_k
Participant
0 Kudos

Hi naga sir,

How  i can close the thread.please guide me sir