GL Revaluation and Population of Optional Fields not working

SOLVED

S300 = V2014

The revaluation optional fields are not populating

 

1.             GL Revaluation with Optional fields

a.             We have set up revaluation code

b.             We have set up optional fields that default to a code and is also auto-insert (GL Transactions)

c.             We have set up the revaluation GL account code with this in optional fields

d.             We have set up currency and have placed the currency and stated to revalue and the revaluation code

e.             When I add the revaluation it does not create the optional fields like it does in a normal JE !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

f.             If you see below - it states that the optional field will change to YES and at that time I assume it should populate the optional fields with the required information - (As it does with a JE)

g.             At this stage it is a NO and when you enter it, the two section are BLANK - nothing has been filled in - NOTHING - BLANK - Not like a normal JE

 

Has anybody got a solution for this problem - much appreciated

 

 This is something I found in a Forum:

Create Revaluation Batch

The Optional Fields column on the Create Revaluation Batch form indicates whether optional transaction details fields have been defined for either the exchange gain account or the exchange loss account for a selected revaluation code. If at least one optional transaction field is defined, Yes appears in the field.

You cannot change the entry for this field, but, if the Optional Fields indicator field shows Yes, you can add or delete optional fields for a revaluation batch.

To view or edit the optional fields used for a revaluation code, select the detail line on the grid, then click the zoom button or press SHIFT+F9 to display the Create Revaluation Optional Fields form. The form shows the optional transaction fields and optional field values assigned to the unrealized exchange gain and unrealized exchange loss account for the revaluation code. You can delete optional field codes used in the revaluation batch, if necessary.

You can add only optional transaction fields that are defined for the unrealized exchange gain and unrealized exchange loss accounts assigned to the revaluation code.

  • 0
    verified answer
    Hi Jay & Ettienne.
    You guys normally jump at these problems with instant replies.
    Have you not come across this before as it is not a common thing
    Have you any reply / suggestions
    Thanks
  • 0 in reply to IDLSystems
    I now have it working with the assistance of Sage:
    It would appear that you have to have at least TWO revaluation codes setup.
    As soon as the second one has been created it will then flag the optional field column as YES and would then automatically populated the optional fields for you (as it should do)
    - I then remove the old revaluation code, and it stopped working, but as soon as I put the second one back again it all worked fine again.
    - So the moral of the story is - Keep Two revaluation codes setup !!!!!.