cancel
Showing results for 
Search instead for 
Did you mean: 

List of Stock Transfers waiting to be generate the AR & AP invoices - GST India

former_member418241
Active Participant
0 Kudos

Hi Experts, How to find those stock transfer documents where i haven't generated yet the target documents A/R Invoice or A/P Invoice ? This is related to GST Invoices generation from stock transfer incase of inter depot transfer to a different state in India. I checked all the WTR tables it seems i cannot find any field which is storing such information. Please let me know.

Regards

Venkat

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member418241
Active Participant
0 Kudos

managed to get the report using the following query

SELECT T0.[DocNum] 'STN', T0.[DocDate] 'STNDate', T0.[DocTotal] 'STN Value', T0.[Filler] 'From Wh', T3.[WhsName], T3.[State] 'From State', T0.[ToWhsCode] 'To Wh', T2.[WhsName], T2.[State] 'To State', T1.[DocNum] 'AP Invoice', T0.[JrnlMemo], T0.[DocStatus] FROM [dbo].[OWTR] T0 LEFT JOIN [dbo].[OPCH] T1 ON T0.[DocEntry]=T1.[BaseEntry] INNER JOIN OWHS T2 ON T0.[ToWhsCode]=T2.[WhsCode] INNER JOIN OWHS T3 ON T0.[Filler]=T3.[WhsCode] WHERE T0.[DocDate]>=[%0] and T0.[DocDate]<=[%1] and T2.[State]<> T3.[State] order by T0.[DocDate] DESC