Outgoing Payment issue

[former_member209725]

Dear Experts,

Till now we were using Journal Entry system for Petty Cash A/c. not Outgoing or Incoming Payment. In journal Entry we are having multiple general ledger for entry.

eg.

A/c. Name                                        Dr.                    Cr.

10204005 petty cash                                                1000.00

50101001  conveyance                      1000.00

10204005 petty cash                                                3000.00

50101002  freight inward                    3000.00

10204005  petty cash                                               1000.00

50101003  accommodation                1000.00

And when we checking General Ledger A/c. for 10204005 petty cash then we can see total number of lines in there.But when we using outgoing payment system for the same and checking general ledger for 10204005 petty cash it is just showing first two lines only

eg.

A/c. NAme                                        Dr.                         Dr.

10204005 petty cash                                                5000.00

50101001  conveyance                      5000.00

We were needed the general ledger report as like in journal entry system gives us.

Any suggestion would be highly appreciated.

Regards,

Ravi

[kothandaraman_nagarajan · Accepted solution]

Hi,

If  you got the answer, please close this thread by clicking helpful or correct answer.

Thanks & Regards,

Nagarajan

[former_member209725 · Accepted solution]

Hi Naga Rajan,

Can we get opening & closing balance for the Cash Account. It would be very helpful for me.

Regards,

Ravi

[kothandaraman_nagarajan · Accepted solution]

Hi Ravi Jha,

Try this:

SELECT T0.[RefDate],
case when T0.[TransType] = 13 then 'AR'
when T0.[TransType] = 14 then 'ARCredit'
when T0.[TransType] = 15 then 'Delivery'
when T0.[TransType] = 16 then 'SalesReturn'
when T0.[TransType] = 203 then 'ARDown'
when T0.[TransType] = 20 then 'Goods Receipt'
when T0.[TransType] = 21 then 'Goods Return'
when T0.[TransType] = 204 then 'APDown'
when T0.[TransType] = 18 then 'APInvoice'
when T0.[TransType] = 13 then 'AP Credit Memo'
when T0.[TransType] = 69 then 'LandedCost'
when T0.[TransType] = 24 then 'Incoming Payment'
when T0.[TransType] = 25 then 'Deposit'
when T0.[TransType] = 46 then 'VendorPayment'
when T0.[TransType] = 57 then 'Check for Payment'
when T0.[TransType] = 76 then 'Postdated Check'
when T0.[TransType] = 58 then 'Inventory list'
when T0.[TransType] = 59 then 'Good Receipt'
when T0.[TransType] = 60 then 'Good Issue'
when T0.[TransType] = 67 then 'Inventory Transfer'
when T0.[TransType] = 68 then 'Work Instruction'
when T0.[TransType] = 162 then 'Inventory Valuation'
when T0.[TransType] = 202 then 'Production order'
when T0.[TransType] = -2 then 'Opening Balance'
when T0.[TransType] = -3 then 'Closing Balance'
when T0.[TransType] = 30 then 'Journal Entry'
when T0.[TransType] = 321 then 'Internal Reconilation'
when T0.[TransType] = 10000046 then 'Data archive'
when T0.[TransType] = 310000001 then 'Initial Qty'
when T0.[TransType] = 10000071 then 'Inventory posting' end as DocType
,T0.[TransId], T2.[U_NAME] as Creator, T3.[FormatCode] as 'G/L Acct/BP code', T1.[ShortName] as 'G/L Acct/BP Name', T3.[AcctName], T1.[Debit] as Debit, T1.[Credit] as Credit,sum(T1.[Debit] - T1.[Credit]) as Balance

FROM OJDT T0  INNER JOIN JDT1 T1 ON T0.TransId = T1.TransId inner join OUSR T2 on t0.usersign = t2.userid INNER JOIN OACT T3 ON T1.Account = T3.AcctCode

WHERE  T0.[RefDate] between [%1] and [%2]

GROUP BY T0.[RefDate],T0.[TransType],T0.[TransId], T2.[U_NAME], T3.[AcctName], T1.[ShortName], T3.[FormatCode],T1.[Debit], T1.[Credit] ORDER BY T0.[TransId]

Thanks & Regards,

Nagarajan

[former_member209725 · Accepted solution]

Hi Naga Rajan,

Above query shows me the balance for that particular account, but I was needed opening and closing balance for that account, just like general ledger report.

is that possible in query?

Your help is highly appreciated.

Regards,

Ravi

[kothandaraman_nagarajan · Accepted solution]

Hi Ravi,

No time to write query for  calculating OB and CB.

You may refer below thread to get such query.

http://scn.sap.com/thread/1425237

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi Ravi Jha,

Try this query:

SELECT T0.[RefDate],
case when T0.[TransType] = 13 then 'AR'
when T0.[TransType] = 14 then 'ARCredit'
when T0.[TransType] = 15 then 'Delivery'
when T0.[TransType] = 16 then 'SalesReturn'
when T0.[TransType] = 203 then 'ARDown'
when T0.[TransType] = 20 then 'Goods Receipt'
when T0.[TransType] = 21 then 'Goods Return'
when T0.[TransType] = 204 then 'APDown'
when T0.[TransType] = 18 then 'APInvoice'
when T0.[TransType] = 13 then 'AP Credit Memo'
when T0.[TransType] = 69 then 'LandedCost'
when T0.[TransType] = 24 then 'Incoming Payment'
when T0.[TransType] = 25 then 'Deposit'
when T0.[TransType] = 46 then 'VendorPayment'
when T0.[TransType] = 57 then 'Check for Payment'
when T0.[TransType] = 76 then 'Postdated Check'
when T0.[TransType] = 58 then 'Inventory list'
when T0.[TransType] = 59 then 'Good Receipt'
when T0.[TransType] = 60 then 'Good Issue'
when T0.[TransType] = 67 then 'Inventory Transfer'
when T0.[TransType] = 68 then 'Work Instruction'
when T0.[TransType] = 162 then 'Inventory Valuation'
when T0.[TransType] = 202 then 'Production order'
when T0.[TransType] = -2 then 'Opening Balance'
when T0.[TransType] = -3 then 'Closing Balance'
when T0.[TransType] = 30 then 'Journal Entry'
when T0.[TransType] = 321 then 'Internal Reconilation'
when T0.[TransType] = 10000046 then 'Data archive'
when T0.[TransType] = 310000001 then 'Initial Qty'
when T0.[TransType] = 10000071 then 'Inventory posting' end as DocType
,T0.[TransId], T2.[U_NAME] as Creator, T3.[FormatCode] as 'G/L Acct/BP code', T1.[ShortName] as 'G/L Acct/BP Name', T3.[AcctName], T1.[Debit] as Debit, T1.[Credit] as Credit

FROM OJDT T0  INNER JOIN JDT1 T1 ON T0.TransId = T1.TransId inner join OUSR T2 on t0.usersign = t2.userid INNER JOIN OACT T3 ON T1.Account = T3.AcctCode

WHERE  T0.[RefDate] between [%1] and [%2]

GROUP BY T0.[RefDate],T0.[TransType],T0.[TransId], T2.[U_NAME], T3.[AcctName], T1.[Debit], T1.[Credit], T1.[ShortName], T3.[FormatCode] ORDER BY T0.[TransId]

Hope helpful.

Thanks & Regards,

Nagarajan

[former_member209725]

Hi Nagarajan,

Also needed opening and closing for the cash account.

I tried this query, opening and closing for the cash account is not showing in results.

Regards,

Ravi

[Former Member]

Raviraj is correct. To get to such detail you want, you have to created your own query report.

[Former Member]

Hi Ravi,

SAP only shows one offset account in ledger report.

You have to create query report for detail ledger.

regards,

raviraj

[former_member209725]

Hi Raviraj,

Thanx for the reply.

Ok I got it.

Can I have such query report?

Regards,

Ravi

[Former Member]

Hi Ravi......

Can you please paste a screen shot for this particular Outgoing Payment Entry?

Regards,

Rahul

[former_member209725]

Hi Rahul,

Glad to see you on my thread.

Here is the screenshot for the same.

[Former Member]

And Journal Entry for the same Outgoing Payment screen shot?

Regards,

Rahul

[former_member209725]

Hi Rahul,

JE for the same payment entry.

Regards,

Ravi

[Former Member]

Hi Ravi,

The screenshot has shown no problem for the outgoing payment and JE. Where is the issue for your 1st question?

Thanks,

Gordon

[former_member209725]

H iGordon Sir,

Thans for the reply.

Yes, You're absolutely right that JE shown no problem, but the problem is when checking the Petty Cash Account ledger. Hereunder the screen shot attached of general ledger for Petty Cash A/c.

Ledger shows total amt(670.00) cr with only one account as Job work Labour Exp., but there are 4 general accounts in actual entry.

You check with the all three screen shots and you'll get to know the actual issue is with general ledger report.

Hope, you can now understand my problem.

Regards,

Ravi

[kothandaraman_nagarajan]

Hi Ravi Jha,

How did you made the outgoing payment?

Thanks & Regards,

Nagarajan

[former_member209725]

Hi Nagaraj,

Thanx for prompt reply.

In Outgoing Payment, selected Account from top then selected GL's, go to payment means and there selected cash account and posted it.

Front line entry showing as following :

G/L Account                                   Amt.

50101001  conveyance                      1000.00

50101002  freight inward                   3000.00

50101003  accommodation               1000.00

Thanx & Regards,

Ravi

[Former Member]

Hi Ravi,

While doing outgoing payment,you have given only 'Conveyance' in G/L account.

Thats why its showing in two lines.

If you want it to include freight inward,accomodation you need to give this account in the outgoing payment.

So your JE will look like,

A/c. NAme                                        Dr.                         Dr.

10204005 petty cash                                                5000.00

50101001  conveyance                      1000.00

50101002  freight inward                   3000.00

50101003  accommodation                1000.00

Revert me for any clarification

[former_member209725]

hi Kambadasn,

Thanx for your prompt reply.

The entry is as following

In Outgoing Payment, selected Account from top then selected GL's, go to payment means and there selected cash account and posted it.

Front line entry showing as following :

G/L Account                                   Amt.

50101001  conveyance                      1000.00

50101002  freight inward                   3000.00

50101003  accommodation               1000.00

and when check 10204005 petty cash then report showing only 50101001  conveyance A/c with 5000.00 paid.

Thanx & Regards,

Ravi

[Former Member]

Hi Ravi,

Please post a screenshot so that we can see ,how you are seeing the balance