Since this is my first time to implement BAAN IV project.
So would someone please advice how to delete AR/AP opening balance from GL? Since the GL opening balance would be entried perviously.

Thanks!
Anthony

Hi,

I assume that you are dealing with a conversion from another system. What I do in general is:

Post open invoices from the old system to an interim account, e.g. a sales invoice:

Customer Account
To/ Interim Customer Opening Account

This Interim account would total up to the old balance from the previous system.

On your first opening balance of the system you post the customer balance to this Interim account, that will thus be in balance (i.e. 0).

Same way with the purchase side of course.

In other words: You may not delete the GLD postings. There is no ACR/ACP bookkeeping done in Baan that is "aside" of the general ledger. Any transactions in ACR/ACP are basically transactions in GLD which are ALSO logged in ACR/ACP. The data in this areas is linked, and you cannot delete a part of it without creating an inconsistency. So you have to find a posting scheme for your opening data as described above.

Uli

ulrich and Guzzisto,

Thanks for your kind advice.... We i implmented other ERP system before. I always first entry GL balance, then entry AR/AP opening balance, and delete the AR/AP transactions posted to GL.

So according to your advice, first i should entry GL opening balance, but use AR interim account for AR OB;
Then entry AR opening balance by customer in ACP module, and use AR interim account as the sales account. Therefore then interim AR account would be balance.
Am I right?
I think this could be a good solution.

Thanks,
Anthony

Yep, that's the correct procedure!

Good luck

The other reason that you pretty much have to do it that way (at least in Baan IV) is that once you have defined a ledger account as a Control Account in your set up of AR/AP, you can no longer enter an Opening Balance transaction type against that account.

Scott

Nice to see you again! Scott.
Ye, do agree with you.
Actually for other system, should be the same - there won't be any entry for control account in GL level.
When i implemented Scala before, we will first setup AR account as normal account, entry the OB. Then link with AR module, entry the AR OB by customers.
Before posting, we would copy the GL datafiles (differ from AR files). And then restore the GL datafiles after posting...

Baan also slaps you on the wrist before you can enter the open items if you try that approach.

If the account is first set as a "normal" account and you enter an opening balance transaction, when you attempt to set it as a control account in ACR or ACP you are prevented from doing so because the account has a non-zero balance.

Scott

Controlled Conversion
I have been through this many times with different ERP's and the following approach is always best:
example : A/R
1. Never convert G/L balances into control accounts.
2. Set up a temporary G/L account just for the G/L conversion
3. Load G/L balance for receivables into that account
4. Load A/R open items into ACR
5. Populate A/R control account automatically via the A/R conversion (if using Baan exchange this can be part of exchange scheme)
6. Offsetting entry (the debit) to the A/R load is the temporary account
7. The temporary account has two entries - a credit from the G/L conversion and a debit from the receivables load
8. If the balance of the temporary account is not equal to 0, there is a reconciling difference on your old system - it is nothing to do with Baan. Blame your finance department!
9. Write off any difference and block the temporary account.