ByD Data migration - financials

[Former Member]

Hi Experts,

I understand that data migration for financials is run on a specific date and you can only run one source file for a specific key date.

This particular client has their financial year starting in April and they want to journal in all the opening balances from April until the migration key date.

Is that going to affect migration?

What would be the correct approach in this case?

Sebastian

[lokesh2 · Accepted solution]

Hi Sebastian,

Firstly, there are two important dates here, 1. Posting date for Initial Migration 2. Posting date for Migration

For the first time migration usually both dates will be same.

For subsequent migration later during the year, You can change the 2. Posting date for migration from the General ledger work center > Companies view

Now are you referring to how to proceed with followup migrations during the year ? wheither it is possible to still migrate to 'Posting date for initial Migration' ?

If that is the case, If you keep the periods & posting control profile available for migration postings you should be able to post the migrations.

Do you want to post the migration for fiscal year 1st period onwards or from the last year 12th period onwards ?

Please refer to the general guidelines under 'Cut-off Date in the Source System' & 'Set posting date' from the help document 'Migration of Financial Accounting Data'

If you encounter any errors during the migration, Please share so that it also helps to understand what exactly you are trying to do as per your proble description

Please let me know if you have further questions.

Thanks

Lokesh Sharma

[Former Member · Accepted solution]

Hi Lokesh,

Thank you for your reply.

I think my question was more around how to proceed in the given scenario. We will set a migration date based on the project timeline and the availability of the migration data.

I am more interested to know if I can journal in the GL movements before the migration takes place (open items, opening balance at migration key date, fixed assets etc) - will this affect the migration in any way? Is this an accepted solution to have movements journals together with migrated open items at a certain date?

Can you follow me so I can contact you directly in the future?

Thank you,

Sebastian

[former_member131434 · Accepted solution]

Hello Sebastian,

the primary objective of the accounting migration is to ensure and document the completeness and consistency of the migrated data. This is being achieved using auxiliary migration reconciliation accounts (by default 99... G/L accounts, the actual IDs can be choosen).

Both the migration of G/L account balances and the migration of the various subledger objects (Fixed Assets, Open Items,....) post to these reconciliation accounts, with the expected target that at the end these postings even out, leaving the recon accounts with balance 0.

Migrating the subledger accounts without the corresponding G/L account balances would leave you with non-zero balances on these reconciliation accounts, and will jeoparidize the reconciliation of subledger migrations, making it very difficult to ensure (and document, e.g. for later auditions), the completeness and consistency of the migrated accounting data.

We recommend to migrate the G/L account balances together with the subledger account objects, making full use of the embedded reconciliation logic.

This does not necessarily collide with the additional requirement to have, e.g. for month end comparisons, some month end balances in the system for certain months prior to the migration date (which is, if I understand correctly, also the request here) ....

[former_member131434 · Accepted solution]

... Lets take this separately:

- fIrst migrate G/L account balances + all subledger objects per migration date

- then, in a post golive activity, journal (1) the expected month end balances for the precedent months into the system, plus (2) the opposite postings always on the next days, so that in total the journal posting do not change the balance of the affected accounts. Depending on the constellation of your inital migration posting date (see Lokesh's descriptions above) you might need to request support via incident to overcome a posting date check for this specific purpose.

Hope this answers your question.

Best regards

Michael

[Former Member · Accepted solution]

Hi Lokesh,

I am currently cross-checking the balances for 4 templates: GL account balances, balances of bank accounts, fixed assets and open items payable.

In the GL account balances I am using 2 tax accounts on debit (company is to receive refund from tax authorities): GST and resident withholding tax.

During cross-balance check, ByDesign matches them with the balances of bank accounts and expects the same amount to be debited there (increase of cash). As the refund is still not processed, what is the solution to this? I am thinking of using Input/Output tax as I know this is how ByDesign calculates GST payable/refund. Not sure about resident withholding tax.

Has anyone seen this before, solved it maybe?

Regards,
Sebastian

[Weerakhan · Accepted solution]

Dear Michael,

Please help suggest.

We experience issue in migrating financial data using G/L account balance template.

It throws the error like

"Error detected in source record 12000000, SET1,....., 2170300,

Account Migration Clearing Account for Tax in CoA XXX not permitted for posting using journal entry voucher".

2170300 is our OUTPUT Value Added Tax account (which we set GL account type = TAX).

Shall we set GL 2170300 to the type of "Other Liability" for migration and then set back to TAX?

In GL migration template should we fill-in with GL 2110100 Account Payable Trade Domestics

or should we fill-in the template with GL 9xxxxxx migration for AP?

We experienced the same error when inputing with 2110100. The system does not allow us to post to this account as GL account type = AP.

Kindly suggest.

[lokesh2 · Accepted solution]

Hi Weerakhan,

Request you to please go through the blog

This explains the logic

Addtionally, Please check for the GL account you selected there must be a restriction on the G/L Account Posting block.

Also check those G/L which are migration offsettings settings even for migration clearing accounts, G/L account posting block needs to be removed if any.

AP G/L will also go through if you remove restrictions.

Thanks

Lokesh Sharma