AP Reserve n P/L

[shahidulalam_siddique]

Hi Experts,

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

Regards

Shahid

[JesperB1 · Accepted solution]

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