GL Reverse Revaluation / GL Import

[iwells]

I mentioned this scenario before, but I'll briefly touch on it again for context:

We have foreign branches where ...

Functional Currency = USD
Local Reporting Currency = Local Currency
Company Reporting Currency = USD

So for whatever reason (whether we acquired branches this way or someone long before out time set them up this way), we have branches around the world where the local reporting currency is NOT the functional currency. In order to accommodate the local reporting what we do in Accpac via a macro is a reverse revaluation. So what happens at period end is we do company reporting, then revalue accounts and do local reporting. Basically the way this works is:

DR Cash (in source currency only) XXX
CR Gain/Loss (in source currency only) XXX

Basically this is a one sided transaction intended to adjust the source currency amounts without affecting the functional currency amounts. Currently this is done with a macro and works. What I'm trying to do is replicate the issue using a GL import, however whenever I try this the functional amount is always populated with a value even if I set TRANSAMT to 0 and SCURNAMT to the value I want. I've tried all kinds of things in the import file and it always provides a functional value. I'm assuming in the Macro that we use that PROCESSCMD is what's allowing this transaction to go through this way? Is there a way to create a one sided source only transaction?

I know the ideal solution would be to convert these companies to new databases, but due to resources and priorities that's not feasible at the moment so I'm simply attempting to replace some old macros with imports as we try to clean up some of our process.

Accpac 5.5-5.6

Ian

 

[Jay Converse]

Put these subsidiaries in their own companies, then use G/L consolidations or Insight to do your rollups. Doing "reverse revaluations" would never pass an audit, and in any case, you can't do one-sided transactions.

 

[iwells]

Yea that's a long term plan, right now I'm looking for something short term to eliminate a macro and use an Accpac import. It seems strange to me that it can be accomplished within the Macro, but not the import. TRANSAMT = 0 actually sets the functional amounts to 0 in the macro, but in the import it creates the values for functional amounts even if I specify 0.

 

[ettienne]

It's because importing TRANSAMT=0 makes no sense. You can get away with some things in macros that are not possible in imports - you may have discovered another one. Imports suck BTW, I always avoid them and rather do macros.
You need to make the new databases a priority and not waste time on fickle imports.