single check to be distributed to multiple customers
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 replied
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.