amount and balances without changes

Gon_M.

Hello people:

I have a rare scenario. I need to post some G/L movements, but I do not want that movements affects the Amounts and balance in Chart of Account. these movements have to be part of historical register.

Is this posible?

any suggestion?

thanks in advance

Alex_Chow

What do you mean by "G/L movement"?

How can you post something in the G/L and have it not affect the balance? Unless you debit and credit the same account.

Gon_M.

hello deadlizard:

thanks to post.

I talk about journals entries that normally change the G/L account balances.

I think that this is imposible, but I need to be sure.

saludos

Kowa

You can post into a prior fiscal year, if your "Allow Posting From" in the User setup table allows it. The G/L entries have a boolean field "Prior-Year Entry" which is automatically checked in this case.

Gon_M.

Hello Kowa:

Thanks to post.

I tried it, but this changed the balances in my G/L accounts.

I need to remake old entries but this dont has to interfer with the new entries and balances. these old entries have to stay in the system like a log of movements.

Saludos

Waldo

Indeed a rare situation.

Can't you just post the movement, and an application entry, which applies the entire amount? Amount-Amount=0, so the balance should be the same ... .

Just a thought.

Miklos_Hollender

Why don't you do it the usual way people generally close the years? Post these old entries, make a closing balance statement, post it against the the closing balance statement account, transfer it to the opening balance statement account, open your new year against the opening balance statement account and there you go.

Waldo

So, you mean posting 2 lines without application? ('cause year end is not the issue here ...).

I think all they want is importing the history.

Gon M. ?

Gon_M.

that's correct, I only want to have the history of past movements.

Saludos

Waldo

Well, all history items should have been applied by a payment or something. That's why it's a 0-movement, and that's why you'll have to post an application as well.

Gon_M.

Hello Waldo:

I hope not to be too much insistent. ](*,)

But, can you give me an example of how can i do this?

Thanks in advance

Waldo

Hm, an exemple .. #-o

Here are some ground rules:

For the first entry:
Fill the Gen. Journal Line with your doc. No, Amount and everything else to an account, with a balancing account.

For the second entry:
Fill the Gen. Journal Line with a different doc. No., same (opposite) amount, and use the fields Apply to Document No and Apply to Document Type to apply the two entries to each other.

It COULD be possible to have to run this in 2 times (first the first entries, then the second ones).

Application is important for closing the entries!

ssingla

I wonder there is any functionality in Navision which can apply transactions relating only to G/L (Not of customer & vendor), If the answer is Yes please let it known on the forum, my lot of clients will be happy to get it implemented.

Gon_M.

Hello again:

ssingla is correct, navision apply transactions only to vendor or customers movements. So, I think that this solution could not be applied to G/L accounts

I let you know if I get an other solution

Thanks

ssingla

Dear Friend,

If you can let us know which type of historic transactions you want to import in Navision, we might help you. there are lot of ways to import historic information ,but all depends on the specific requirement.

Alex_Chow

I would recommend importing the historical data in a separate table if you do not want your production G/L to be affected.

Either that, or just post your transactions so it balances itself out. In another words, debit and credit to the same accounts. This way, you can see the entries without affecting the balances.

Waldo

wonder there is any functionality in Navision which can apply transactions relating only to G/L (Not of customer & vendor), If the answer is Yes please let it known on the forum, my lot of clients will be happy to get it implemented.

Sorry, I forgot about the G/L thing... :oops:

Either that, or just post your transactions so it balances itself out. In another words, debit and credit to the same accounts. This way, you can see the entries without affecting the balances.

I would go for that one ... makes it easier on the reports.

David_Cox

Gon M. wrote:

Hello people:

I have a rare scenario. I need to post some G/L movements, but I do not want that movements affects the Amounts and balance in Chart of Account. these movements have to be part of historical register.

Is this posible?

any suggestion?

thanks in advance

The only way is to post both sides to the same Account same Document No. and posting date.

What is it that you are trying to do?

Are you talking about Customer and Vendor History, after posting an Opening G/L Balance, in the Control Accounts?

We need better information really.