Solved

GRNI not fully reversed and has remaining balance in Parallel Currency

  • 11 August 2020
  • 9 replies
  • 588 views

Userlevel 2
Badge +6

We use transaction based parallel currency where accounting currency is in GBP and parallel currency is in USD. Currency rates for both accounting and parallel currency are updated monthly. In this scenario, transaction and accounting currency are the same (GBP). When posting receipt of goods in Month1, Inventory is debited and GRNI is credited.  In Month2, the supplier invoice debits GRNI and credits AP, however, the GRNI amount in parallel currency is different due to a new currency rate, thus the amount in the GRNI account is not fully reversed in parallel currency.  What is the recommended solution to manage these balances when this can potentially affect thousands of transactions?  A gross month-end adjustment? There is concern this creates another set of books to reconcile every month, adding more work for the users.

icon

Best answer by VCook 30 September 2020, 17:38

View original

9 replies

Userlevel 4
Badge +7

Hi, what is the version of IFS Application?

Userlevel 2
Badge +6

Apps 10 UPD 6.

Userlevel 4
Badge +7

I believe there is correction through bug fixes on this, however I cannot remember the UPD either 5 or 6. Certainly after 7 it has been corrected. Hope it helps.

Userlevel 2
Badge +6

Where can I search for the potential bug fix?

Userlevel 4
Badge +7

hmmm that I don’t know. if you contact your local IFS Support, they may be able to help.

Userlevel 4
Badge +7

Hi, this is patch in UPD 7, see solution  274137  if you have access, otherwise inform the local IFS Support. Hope this help.

Userlevel 2
Badge +6

Thanks, I’ll have our Tech take a look and report back if it resolves this issue.

Userlevel 2
Badge +6

Just an update on our investigation into solution 274137 and whether this addresses the issue regarding GRNI not reversing properly in parallel currency.  Solution 274137 addresses a different issue regarding purchase price variance and currency rates not calculating correctly due to some rates being inverted rates and others not.  In our case, parallel currency rate is calculating correctly, but reversing amount for GRNI should reverse the entire original amount, not the calculated amount in the next period’s parallel currency rate.  Otherwise, balances remain in the GRNI account in parallel currency. We will submit a support ticket with IFS.

Userlevel 2
Badge +6

To close the loop on this, IFS Support said that there is no existing solution to this problem.  The response provided:

“In CORE, there is no such support to handle balancing of the GRNI account in parallel currency.

 

As you may know, before Apps 10 there was no support to handle anything else than accounting currency from a GRNI perspective, since the whole basis to be able to handle the reconciliation is that we actually have posted amounts in other currency than accounting currency already in our inventory transaction history for all the transactions that post against GRNI, typically ARRIVAL using M10. But before Apps 10 it was only possible to post accounting currency amounts for GRNI. I.e. even if you have a Purchase Order in a different currency than accounting currency, when the postings are created during receipt, posting M10, the system would post the same amount in both accounting currency and transaction currency. So if you query in Inventory Transaction History in Apps 9 or earlier releases, the only columns displayed in the Accounting tab is Debit and Credit Amount columns.

 

Then during the Apps 10 project an implementation was done to handle also posting transaction currency amounts for GRNI, i.e. that we will use the currency from the PO and actually calculate the transaction currency amount using that currency. So that is why you now also see the new columns for Debit Amount Curr and Credit Amount Curr if you query in Inventory Transaction History and check the Accounting tab.

 

But there is no similar handling for Paralllel currency. The amounts in Paralllel currency are not calcualated during any Purchase receipt, nor in any context in Supply Chain. The Paralllel currency amounts are only calcualted by Finance once the postings are transferred to Finance, and they create the MPL voucher,

 

So when you say in step 3 that the amount in paralllel currency for M10 in CAD is 1176,47, then there is no place in Supply Chain that this value is known. And to be able to handle reconciling GRNI during invoice matching, it is necessary that all information exists on the inventory transaction, since that is the basis for calculating price differences or currency rate differences and create the necessary diff postings in the supplier invoice.

 

Supporting balancing the GRNI account in Parallel currency therefore would require some similar implementation as was done during the Apps 10 project to handle balancing Transaction currency, and which we spent appr 5 months dealing with.

 

So there is no bug to be qualfied in this context, as assumed here, since this requires some new design to handle.”  End of IFS response.

However, as a workaround I was able to resolve the problem when creating the Manual Supplier Invoice by first changing the voucher date in the header to a date in the same currency rate period as the receipt date, doing the PO matching and then changing the voucher date to the correct date in the current period, save then post.  The AP user must be mindful of this potential problem when entering the invoice.

Reply