Skip to Content

is it ok to create a single control account for each bp??

i have a customer who wants to create a single control account in his chart of accounts for each single business partner

ex. bp 1 has his own control account 001

bp 2 acc 002

bp3 acc 003 and so on

does it has bad effect on data base ??

does this might make troubles during generating reports ??

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 21 at 06:06 AM

    Hi Mahmoud,

    This sounds like your customer wants to make B1 work the same way as their legacy system. This is a common problem, when they do not understand how B1 works, and/or are afraid to learn new ways of working.

    Instead of having a single account per BP, as it used to be, B1 earmarks transactions with the BP number, through the same control account. In a sense it does exactly what the customer wants, except that they can use the actual BP number instead of having to know what account number belongs to what BP.

    The old method of using individual control accounts per BP, is perpendicular to the way B1 works, and will in practice mean that the customer does not benefit from B1's system. To put it bluntly, the customer would then be better off, if they kept using their old system. This is a matter of consultancy, you need to explain to the customer that B1 works differently, that it provides the same information in more efficient way. The main difference is that sales and purchase reports are now generated by the system through the Sales and Purchase modules, instead of the old way, through the general ledger.

    "does it has bad effect on data base ??"

    Not much, except that you are in a sense doubling all BP data.

    "does this might make troubles during generating reports ??"

    Your chart of accounts will grow with each new business partner, and financial reports will become more and more difficult to read. Sales and purchase analysis will be anywhere between difficult and impossible to generate. Queries that will be easy to build around the OCRD table, will be very difficult to build around the OJDT and JDT1 tables.

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

  • May 21 at 06:29 PM

    Hi Johan

    Do you think that the data base or the system might breakdown because of that ?

    Add comment
    10|10000 characters needed characters exceeded