CONSOLIDATION

[Former Member]

Hi

I have two questions

1)While creating customer master in the accounting tab, in general tab there is consolidation bp, having again two options

a. payments consolidation

b. delivery consolidation

My question is where & how we use these

2) Can we do consolidation for B1 companies like R3, if yes How ?

Srinivas.

[Former Member · Accepted solution]

In answer to your first question:

Payment Consolidation scenario is where you have 3 customer records (each seperate BPs in SAP and NOT Shipping Addresses), 1 is Tesco's London, 2 is Tesco's Manchester and 3 is Tesco's Head Office. For Tesco's London and Manchester you check Payments Consolidation and in the Consolidating BP field you put in the BP Code of Tescos Head Office. Now when you receive an Incoming Payment from Tescos Head Office you can see the Invoices from both tesco branches in the screen and the headoffice can pay them.

Delivery Consolidation is very similar, however when creating an Invoice for the Tesco Head Office BP you can base it on open delivery notes sent to both Tescos London and Tescos Manchester.

The help screen does give good information on this, so if you are in the BP form, click F1 to launch the help.

In answer to your second question:

I too am a little unsure of your requirement, do you mean can you consolidate a SAP Business One database into SAP R3? If so then the answer is yes, SAP Netweaver can be used to achieve this. If you want to consolidate a SAP Business One database into another SAP Business One database then the answer to this is also yes, there are a few tools that you can use, iBolt from Magic Software, RELs from Balloon One, or maybe another middleware applicataion such as Scribe, there are multiple options.

I hope this helps,

Adrian

[Former Member · Accepted solution]

Hi Adrian,

I am too looking for SAP B1 Database consolidations, please tell me what are the different options available for financial consolidations apart from thrid party add-ons solutions.

Thanks in advance.

[former_member418241]

Hi Srinivas,

I am not sure about your question on R/3 but for the consolidation part please go through this,

Imagine that there is a business partner of type customer. If he is ordering items through two different sales orders and they are due for delivery, when you come to the delivery stage of the items. You can combine these two sales orders in to a single delivery document because of he is a single customer having a common delivery address for two different sales orders. And for the payment part he can make a single payment for the two or more deliveries either using a cheque or cash or in any other form.