How to do reverse entry? v5sp1

nikeman77

Hi all,

Anyone know how to do reverse entry?

Where to go? How to Do?

version: v5sp1

mohana_cse06

For which entry you want to do reverse?

GRIZZLY

Have you tried Reverse Register function from G/L Register?
Note that you could only reverse those transactions, that were posted through the G/L Journal Batch.

nikeman77

mohana_cse06 wrote:

For which entry you want to do reverse?

hi mohana,

i would like to reverse bank entry, i am handling some issues where user are reversing via g/l> account> ledger entries> select entry> navigate> select bank> reverse.

i suspect there is some issue here as user reported instead of having a neagtive value, it give positive value which is similar to the original ones. (eg:original value:$100, an expected reverse i presume would get -$100, but user get $100 instead)

nikeman77

GRIZZLY wrote:

Have you tried Reverse Register function from G/L Register?

How do I do that?

GRIZZLY wrote:

Note that you could only reverse those transactions, that were posted through the G/L Journal Batch.

How can i find out what are the transactions that are posted through g/l journal batch?

PS:i am still learning finance aspects of navision, pardon me for the not so intelligent qs.

GRIZZLY

Financial Management > General Ledger > History > Registers.
Find out your register. Then Functions > Reverse Register.
That function reverse all entries in register.
I think, that function is similar to reversal of special entries from Navigate > Entry > Reversal.

nikeman77 wrote:

How can i find out what are the transactions that are posted through g/l journal batch?

It means you cannot reverse registers, that were posted, for example by Posted Sales Invoice, or Posted Purchase Invoice. I think if you are talking about Bank Entries, they should be posted from G/L Ledger or from Bank Statement.

nikeman77

hi GRIZZLY,

how come when user are reversing via g/l> account> ledger entries> select entry> navigate> select bank> reverse.

User reported instead of having a negative value, it give positive value which is similar to the original ones. (eg:original value:$100, an expected reverse i presume would get -$100, but user get $100 instead)

GRIZZLY

It seems to be a bug, have you modified the reversal function (or G/L posting routines) by yourself?
Ok, the next solution is to create line in G/L Journal, which is copy of original one with the next differences:
Correction = TRUE
and a negative Amount value (if the original was positive)
and to post this line.

nikeman77

hi Grizzly,

what happen when user post a journal (J哦urn-11-0191, amount -$100) with empty document type?
and they reverse this transaction (Journ-11-0191,amount becomes -$100 too)

mohana_cse06

Did you check this in base database?

I tried this in Cronus India database..it is working fine..

nikeman77

Hi Mohana

what happen when user post a journal (J哦urn-11-0191, amount -$100) with empty document type?

mohana_cse06

I didn't post any entry

I have 2 bank ledger entries with amounts (-8,054,014.39) and 185,448.90
When I Click reverse transaction it created 2 new entries with 8,054,014.39 and (-185,448.90).

You can try this this in Base Database..

nikeman77

hi mohana,

thanks for replying, think the user trying to reverse customer ledger entries, but not sure why they start from
chart of account>
search customer account>
filter by the transactions entries>
navigate>
choose bank account>
reverse entry

thought the proper method would be via
customer card>
ledger entries>
search for entries>
unapply>
then do a reverse for the payment?