single check to be distributed to multiple customers

[Former Member]

Hi Experts,

Iam in a tough situation plzz help me out in this....

THERE IS A CUSTOMER WITH DIFFERENT LOCATIONS. WE SEND MTERIAL TO ALL LOCATIONS. WE R MAINTAINING OUR BUSINESS PARTNER MASTER DATA AS .........

SAY CUSTOMER NAME IS

"XYZ - LOCATION NAME"

XYZ - INDIA

XYZ - USA

XYZ - UAE

WE SEND MATERIAL TO THIS CUSTOMER LOCATIONS. AND WE RAISE DIFFERENT TRANSACTIONS ie., SALES ORDER, DELIVERY, A/R INVOICE FOR THIS CUSTOMER.

SAY THE CUSTOMER BALANCE IS $1000

NOW THE PROBLEM IS WE GET ONLY ONE CHEQUE FROM THIS CUSTOMER.

HOW TO DISTRIBUTE THIS CHEQUE AMOUNT FOR ALL THE INVOICES RAISED AGAINST XYZ-INDIA, XYZ-USA, XYZ-UAE.

PLZ HELP...................

THANKS IN ADVANCE.

[Former Member · Accepted solution]

You have an option called 'BPConsolidation' for Business Partners which you can use for this.

Business Partners -> Business Partner Master Data -> Accounting -> General

Consolidating BP

Use when a business partner has several branches and you want to consolidate all transactions with the head office.

Select:

● A generic business partner that can consolidate all transactions of this business partner.

● Between payments consolidation and delivery consolidation.

You can use Payments Consolidation:

Payments Consolidation

Displays invoices of business partners linked to the same consolidating business partner in the Incoming or Outgoing Payments window.

Use when the head office covers all invoices sent to its branches.

You can select the branch business partner directly in any specific payment document.

[Former Member · Accepted solution]

Hi Sridharan your solution helped me alot.

Can you plz give me step by step procedure,

plz take XYZ-INDIA, XYZ-USA, XYZ - UAE customers as example.

this will be a great help.

Thankyou.

[Former Member · Accepted solution]

Hi

Lets assume you have customers like

XYZ-INDIA,

XYZ-USA,

XYZ - UAE

Now assume Payment comes from XYZ-USA Customer.

Now goto Business Partners -> Business Partner Master Data , select XYZ-INDIA customer

Goto Accounting -> General , Check 'Payments Consolidation'.

In the 'Consolidating BP' textbox, select XYZ-USA.

Repeat the same for XYZ - UAE .

Now the Balances of XYZ - UAE and XYZ-INDIA would be posted to the account of XYZ-USA.

You can book incoming payments for XYZ-USA for all the invoices of XYZ-USA, XYZ - UAE and XYZ-INDIA .

Hope you understand this.

Now try this in Demo System for better understanding.

[Former Member]

Hi Sridharan,

Ive understood what u said about customer consolidation. ive consolidated XYZ-USA to XYZ- INDIA.

but how to consolidate the same with XYZ-UAE.

Ive tried consolidating XYZ-INDIA with XYZ-UAE. this throws error saying " cannot concentrate summary cards."

Thankyou.