Need multiple customers and vendors to select in incoming and outgoing payment

[Former Member]

Hi,

I know this is not possible in standard SAP B1, but still I am asking this, if anyone can come up with new idea.

My client has following scenario.

they do incoming payment for multiple customers in one single entry. so they want in SAP incoming payment should allow them to select multiple customers.

similar case for venodr.

can we do anything for it? what can be the solution???????

please dont send me the old therads, i have already  cheked those/

[former_member719912]

Dear Rahul,

                        We can use Payment Wizard.

[K_Pauquet]

Hi Rahul,

this is a strange request, an accountant may not approve of this practise.

Technically this is easy to solve:

Create an incoming/outgoing payment from a dummy customer/vendor.

Go to Business Partners -> Internal Reconciliations -> Reconciliation

Select 'Multiple BPs'

Enter the BP codes of your customers/vendors, include the dummy & click on reconcile

Select the dummy payment & manually select the invoices that are being paid.

Check out this document as well, the principle is the same:

All the best,

Kerstin

[Former Member]

Hi Rahul,

Same need here and easily solved

What has been done:

• Create a "dumb" customer,
• Post all payments on this "dumb" customer,
• Reconciliate the real customers to the "dumb" one.

Our case is a bit more complicated than this and we automatized the full thing in an addon I developped, but basically that's it.

Regards,

Eric

[rajesh_khater]

Hi Eric,

Can you share your addon?

Thanks.

[former_member221220]

Hi Rahul,

Yes, it is possible to select multiple customers for Incoming Payment is F-28

                      &                multiple vendors for Outgoing Payment in F-53

1. Open F-28 / F-53

2. In the Open Item Selection, instead of selecting a Customer or Vendor directly, check the Other Accounts option and go to Process Open Items

3. First enter the Company Code and then check Standard Open Items option & Enter K / D in the account type

4. Then go to list of possible values and select the Customers / Vendors.

5. If there are any differences in the amounts, it can be edited in the Charge off diff.

Please find the screenshots below.

Regards,

Sravan

[Former Member]

Are you using sap business one Sravan?

[Former Member]

Hi,

The best way to run a consolidated payment is by using the Payment Wizard.

In the second step, you can define incoming/outgoing payments and they will bring up respectively the customers or suppliers, and then step through to allocate the amounts per transaction per BP.

Regards,

Kiran

[Former Member]

Hi,

I agree with Gordon Du, This can be achieve through consolidate BP option.

If it is not possible you can check below option

1. Create a Single customer and book the payment through payment on account to this customer
2. Go to business partner manual reconciliation, select multiple business partners including above customer and reconcile the records which has to be reconciled.

Regards,

Kiran

[Former Member]

Hi,

I think it is impossible.

Because one original document is related to a business partner only. This is real and logic.

In your case, I suggest to create transaction through Journal Entry.

Hope this helps,

TVSon.

[Former Member]

Hi,

Have you checked consolidate BP function? You may create a new BP as a consolidate BP include all those BP for payments.

Thanks,

Gordon

[Former Member]

Hi Rahul,

           I have some idea,  You will create a customize screen based on your requirements