Solved

Currency row is mandatory for pay accounting row

  • 28 February 2024
  • 6 replies
  • 71 views

Userlevel 2
Badge +8

Hi Team

 

Greetings

 

When we are trying to link advance invoice in manual supplier invoice to create an offset. We are getting a following error 

 

 

On analysis, in Posting IP3, it is taking null value. 

If we add new posting control in IP3 with code part as currency, control type as country code. Still it does not work.

Have any one seen such issues earlier?

icon

Best answer by Adam Bereda 4 April 2024, 16:18

View original

6 replies

Userlevel 7
Badge +16

Hi, Pratik, long time no see.

IP3 is rule for tax. Do you use tax-specific currency rates in this company? 
I can see that invoice is in EUR with rate 1, is the advance in same currency? 

I am not sure what currency rate type is used in this process, but you should make sure that, if EUR is accounting currency of the company, line with EUR rate 1 is present in all currency rate types definition based on EUR currency.

Userlevel 2
Badge +8

Hi Adam

Thanks for remembering me. I hope you are doing good.

Currently, we do not use tax specific currency in posting control.

Also, Rate EUR is 1 everywhere in advance invoice, final invoice, payment and all currency types.

Below is Server Trace which is stopping invoice to be posted.

Just for you information: If there is no advance invoice linked than we are able to post manual supplier invoice successfully. It is when we link the advance invoice to offset it, the issue specifically arises.  

  

Thanks & Regards

Pratik Shah

Userlevel 7
Badge +16

Looking at this, it seems automatic offset (advance amortization) did not fetch currency rate for some reason. I suspect that you have default currency rate type indicated for company with EUR rate valid, so this issue looks like a bug. I think support should look at it.

Userlevel 2
Badge +8

Hi Adam

Greetings

We have one more observation here, if we use 0% tax code and tax method as “Payment” than we get the error mentioned above.

 

But, opposite to it, if we use 0% tax and tax method as “Invoice Entry” than we do not get the error mentioned above.

 

Does IFS has any restriction for 0% that tax method must always be “Invoice Entry”?

 

Thanks & Regards

Pratik Shah

 

Userlevel 7
Badge +16

I do not think it is restriction, it is rather defect of the IFS code. That’s why I suggested raising support case.

Userlevel 2
Badge +8

Hi Adam

Thanks for all your valuable inputs.

Regards

Reply