How do you enter beginning balances in entered currency for GP

(0) Share

Report

Posted on by greencomig

120

I'm setting up some new GP companies that we are converting from Dynamics SL. I will be entering beginning balances by journal entry for all of 2014. I want to enter the currency balances by GL account so we can utilize the revaluation process from the go-live date forward. Anyone have any ideas on how to do this? Thanks

*This post is locked for comments

All responses (3)

Answers (0)

soma 24,410 on at

Like (0)

Report

RE: How do you enter beginning balances in entered currency for GP

Greencomig,

What you mean by the currency balance? Can you elaborate your question as more details?
Suggested answer

Community Member on at

Like (0)

Report

RE: How do you enter beginning balances in entered currency for GP

Hi Greencomig,

Please find the below steps that can help you to forward.

1) In SL, run the TB report as particular date\year

2) Export the trail balance report to excel.

3) If the transaction entry contains other currency, then please make sure the associated currency is configured in GP.

4) Account segment need to be configured in GP as of SL if it is a fresh installation of GP.

5) Import the Account segment using Integration Manager or GP macro(Mail Merge).

6) Once the Account get imported, you can load the Opening balance from Excel using Integration Manager or GP Macro(Mail Merge)

Note: if you are using GP 2013 R2, you can directly import/paste excel in journal entry screen.
greencomig 120 on at

Like (0)

Report

RE: How do you enter beginning balances in entered currency for GP

One more piece of info. I'm importing in the base currency in Detail which I know how to do . Is there a way to after this import to add in the non functional currency balance by currency by GL account as of go-live date?.