Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 16, 2008 at 05:13 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

  • avatar image
    Former Member
    Oct 16, 2008 at 08:36 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded