single check to be distributed to multiple customers

This question is answered

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.

Correct Answer

October 16, 2008 at 07:40 AM

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.

0 Likes 0 View this answer in context