Skip to Content
0
Jul 13, 2020 at 07:11 AM

SAP Business ByDesign Payment Application to both Open Items and Generel Ledger Account

69 Views Last edit Jul 14, 2020 at 12:17 AM 3 rev

Hi Experts,

We have a client which is an Insurance Broker. Upon recording of their incoming payments, two things happen simultaneously. One is the recording of Payable to the actual insurance company and second, the recording of their commission.

Example Journal entry:

Debit: Cash in bank 100,000

Credit: Payable to Insurance Company 80,000

Commission Income 10,000

Output Tax 1,200 (10,000*12%VAT)

Excess AP 8,800 (Excess payment)

A few issues here:

1. We cannot post a payment to an account and be able to compute the commission income and its VAT automatically.

2. If they opt to not compute it automatically, we cannot post the payment to the Supplier/Customer account and the GL account simultaneously.

I know how we can post the AP to the Insurance company and the excess amount but we are having a hard time in the Commission and tax postings.

Thank you and Regards,

Claudine

Attachments

capture.jpg (14.5 kB)