Cash Journal transaction FBCJ

[Former Member]

Good Day All,

When we posted Cash Journal transaction FBCJ and do a split transaction of 7 lines on the cash receipt. The system only posted the first 4 line items, but with the amount of the total transaction. The other three transactions were not posted and the system showed that the transaction is not completed. Therefor we cannot revers the transaction via FBCJ.

Kindly see example

Split transaction the way the user split the money.

1) Customer receipt 5.383,18 Customer Account

2) Customer receipt 5.960,05 Customer Account

3) Customer receipt 25.798,85 Customer Account

4) Customer receipt 32.070,27 Customer Account

5) Unallocated receipt 44.142,49 General Ledger Account

6) Unallocated receipt 2.348,52 General Ledger Account

7) Unallocated receipt 247,21 General Ledger Account

Total Amount R 15 000,00

SAP post as follow.

1)Customer receipt R 15 000,00 15 Customer Account 40 Cash Journal

2)Customer receipt R 15 000,00 15 Customer Account 40 Cash Journal

3)Customer receipt R 15 000,00 15 Customer Account 40 Cash Journal

4)Customer receipt R 15 000,00 15 Customer Account 40 Cash Journal

Please Help

Martie

[Marssel700]

Martie,

There are four line items because you have 4 customers invoices posted.

Are these 3 line items changing account balance? Please, check it and take a look on customers invoices posted. In these Invoices check if offsets G/L accounts are your Cash Journal posted G/L accounts.

I Hope your reply.

[Former Member]

Good Morning Marssell,

Thank You very much for your reply. Sorry for the long explanation, but hope this will give you a better understanding of my problem.

I do not understand you question. Are these 3 line items changing account balance?

The system did post to the offsets G/L accounts (Cash Journal posted G/L accounts) for the customer accounts.

I did the same scenario in the QA client and its working fine see transaction below.

The splitting was entered as follow.

1)Customer receipt 5.383,18 Customer Account

2) Customer receipt 5.960,05 Customer Account

3) Customer receipt 25.798,85 Customer Account

4) Customer receipt 32.070,27 Customer Account

5) Unallocated receipt 44.142,49 General Ledger Account

6) Unallocated receipt 2.348,52 General Ledger Account

7) Unallocated receipt 247,21 General Ledger Account

The total amount of all the line items is R 115.950,57

The system posted the transaction as follow

1 40 115122 5.383,18 Petty Cash Account

2 40 115122 5.960,05 Petty Cash Account

3 40 115122 25.798,85 Petty Cash Account

4 40 115122 32.070,27 Petty Cash Account

5 40 115122 44.142,49 Petty Cash Account

6 40 115122 2.348,52 Petty Cash Account

7 40 115122 247,21 Petty Cash Account

8 15 80930051 5.383,18- Customer Account

9 15 80930033 5.960,05- Customer Account

10 15 80930037 25.798,85- Customer Account

11 15 80930065 32.070,27- Customer Account

12 50 800030 38.721,49- GL account

13 50 805550 2.060,10- GL account

14 50 805120 216,85- GL account

15 50 175000 5.739,78- Vat Output Account

But in the production it’s posting the transaction incorrect see transaction below.

The splitting was the same as above but the system did not post the GL lines, and it used the Total amount of the splitting. In other words the system post a total of R 463 802,28 into the Petty Cash account instead of a total of R 115.950,57

1 40 115122 115.950,57 Petty Cash Account

2 15 80930051 115.950,57 Customer Account

1 40 115122 115.950,57 Petty Cash Account

2 15 80930033 115.950,57 Customer Account

1 40 115122 115.950,57 Petty Cash Account

2 15 80930037 115.950,57 Customer Account

1 40 115122 115.950,57 Petty Cash Account

2 15 80930065 115.950,57 Customer Account