Skip to main content
Solved

GL reversing entries


Forum|alt.badge.img+8

Hello to all the Accounting members, we are tying to configure IFS to automatically reverse a GL voucher entry after the first of the month.  This is the classic accrual type of GL entry whereby we make a GL voucher transaction entry in one month and auto reverse it the next month after the actual charges post to the balance sheet.  

When creating a manual voucher entry, we do not see anywhere we can set a reversal.  We are on IFS APPS9, UPD16.  

How can this be achieved in IFS?  There has to be a way as this is Accounting 101.

Thanks!

Mark

Best answer by Xavier Fernando

@svrmhuebner ,

Your requirement of automatically reversing on next month could be easily achieved through a Simulation voucher.

Here when you enable simulation voucher for Voucher type function M and R, M voucher enters on a specific month will be automatically removed in next month using voucher type R ( Here both M and R are enabled for Simulation voucher functionality)

Voucher Type R
 


Voucher Type M
 

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

AkilaR
Hero (Partner)
Forum|alt.badge.img+11
  • Hero (Partner)
  • February 17, 2021

Hi @svrmhuebner ,

I believe you are looking for Interim Voucher option in Voucher Entry level. Create the JV as usual and once, Saved RMB on the header and select Interim Voucher option. This will pop up a dialog box to enter voucher reversing period. Update those information and click OK

Then Application will create the Reversing Voucher for mentioned period.

 

Hope this will help!

Regards,

Akila 


MKG019
Hero (Partner)
Forum|alt.badge.img+13
  • Hero (Partner)
  • February 17, 2021

Hi ,

On the Voucher entry screen once the Manual Voucher is approved, RMB on header and select Interim voucher options and enter the user details and voucher type R .

Regards,

Mukesh Gupta


Forum|alt.badge.img+8
  • Do Gooder (Customer)
  • February 17, 2021

Thank you for the quick responses, is there only certain types of vouchers this works for?  I asked my accounting team to try the steps above and the “interim voucher” menu items is greyed out and does not allow them to open the dialog box…

Please advise.


AkilaR
Hero (Partner)
Forum|alt.badge.img+11
  • Hero (Partner)
  • February 17, 2021

Hi @svrmhuebner ,

Yes, Interim Voucher option works only with Voucher types that have M function group since Interim voucher creation is only allowed for Manual entries.

Hope this will help.

 

Regards,

Akila


Forum|alt.badge.img+10
  • Hero (Customer)
  • June 4, 2021

Interim voucher also doesn’t apply for voucher type Q when you need to post to a ledger account.  Does this get changed in version 10 or Cloud?   Not sure why only “M” types are only allowed to be reversed in that manner. 

 

Thank you


Forum|alt.badge.img+20

@svrmhuebner ,

Your requirement of automatically reversing on next month could be easily achieved through a Simulation voucher.

Here when you enable simulation voucher for Voucher type function M and R, M voucher enters on a specific month will be automatically removed in next month using voucher type R ( Here both M and R are enabled for Simulation voucher functionality)

Voucher Type R
 


Voucher Type M
 

 


Forum|alt.badge.img+10
  • Hero (Customer)
  • June 4, 2021

thank you @svrmhuebner !  I do see this as convenient at time of entry for M type however if it’s a Q type voucher they want reversed, I can’t set up as reversing it looks like.

 

I didn’t realize what simulation voucher meant so I can see this being useful to record normal reversing entries.  Thank you


Forum|alt.badge.img+16

Why do you use Q vouchers at all? It should be forbidden to touch ledger accounts with non-ledger entries, otherwise you will not be able to reconcile your subledger information...


Forum|alt.badge.img+10
  • Hero (Customer)
  • June 8, 2021

IFS makes accounts ledger accounts used in posting controls that are not necessarily true ledger accounts the way the accountants use them.  ie: project management accounts, error suspense as examples.    We do not touch the AP / AR subledger accounts 


Forum|alt.badge.img+9
Xavier Fernando wrote:

@svrmhuebner,

Your requirement of automatically reversing on next month could be easily achieved through a Simulation voucher.

Here when you enable simulation voucher for Voucher type function M and R, M voucher enters on a specific month will be automatically removed in next month using voucher type R ( Here both M and R are enabled for Simulation voucher functionality)

Voucher Type R
 


Voucher Type M
 

 

Xavier

I wasn’t aware of what a ‘Simulation’ Voucher did either.  We have 10 or so different companies in IFS and mainly upload external vouchers instead of typing them in.  I added an M and R function group voucher type ticked as Simulation Vouchers as shown here.  I see that the “R” function group voucher is automatically created when the M function group voucher is saved in Voucher Entry.  When I upload using (from your example) and MX voucher, an XR voucher is not created.  Is there a way to get that to work, or will Simulation Vouchers only work through the Voucher Entry screen?

thx,

Cynthia


Forum|alt.badge.img+20
cynthia.wilson wrote:
Xavier Fernando wrote:

@svrmhuebner,

Your requirement of automatically reversing on next month could be easily achieved through a Simulation voucher.

Here when you enable simulation voucher for Voucher type function M and R, M voucher enters on a specific month will be automatically removed in next month using voucher type R ( Here both M and R are enabled for Simulation voucher functionality)

Voucher Type R
 


Voucher Type M
 

 

Xavier

I wasn’t aware of what a ‘Simulation’ Voucher did either.  We have 10 or so different companies in IFS and mainly upload external vouchers instead of typing them in.  I added an M and R function group voucher type ticked as Simulation Vouchers as shown here.  I see that the “R” function group voucher is automatically created when the M function group voucher is saved in Voucher Entry.  When I upload using (from your example) and MX voucher, an XR voucher is not created.  Is there a way to get that to work, or will Simulation Vouchers only work through the Voucher Entry screen?

thx,

Cynthia



Hi Cynthia ,

In my screenshot MX and XR voucher types was created by me as lieu for M and R respectively ( Please observe the function group at line level ) .  Since R created automatically for you in next period. Your process work fine.


cperdue
Hero (Partner)
Forum|alt.badge.img+14
  • Hero (Partner)
  • June 23, 2021
Xavier Fernando wrote:

@svrmhuebner,

Your requirement of automatically reversing on next month could be easily achieved through a Simulation voucher.

Here when you enable simulation voucher for Voucher type function M and R, M voucher enters on a specific month will be automatically removed in next month using voucher type R ( Here both M and R are enabled for Simulation voucher functionality)

Voucher Type R
 


Voucher Type M
 

 

What does this look like in Aurena?

 

Thank you!

Christy


Forum|alt.badge.img+10
  • Hero (Customer)
  • July 27, 2021

when you go to GL Balance Analysis you need to always check off “Simulation” so you see those vouchers as well.   Is there a way to have this checked off automatically so users do not forget?  It took me by surprise that we had to do this.

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings