cancel
Showing results for 
Search instead for 
Did you mean: 

AP Reserve n P/L

shahidulalam_siddique
Participant
0 Kudos

Hi Experts,

I want to know how I can check the AP Reserve Invoice effect the P/L account.

Regards

Shahid

Accepted Solutions (1)

Accepted Solutions (1)

JesperB1
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

Try this query, depending on your localisation it will give you the P&L accounts that were used for the AP Reserve Invoice.

Please note that this is for version 2007.


SELECT 
T0.[TransId], T0.[CreatedBy] as 'Document Number', T0.[Account], T0.[Debit], T0.[Credit] 

FROM JDT1 T0 

WHERE 

T0.[Account] in (SELECT T0.[AcctCode] FROM OACT T0 WHERE T0.[GroupMask] > 3 and postable = 'Y') and  
T0.[TransId] in (SELECT T0.[TransId] FROM OPCH T0 where isins = 'Y') 

Please note, that if you localisation has a balance sheet of less than 3 drawers (check your Chart of account), then please change the value after t0.groupmask to 2.

It is possible to link this in a better way but maybe this will do.

Hope it helps.

Jesper

Answers (0)