Requires Exchange Rate while choosing Item in AR Invoice

[Former Member]

Dear All,

We have an Integration with SAP B1 8.81. Through DI API we are creating AR Invoices and Purchase orders. Our system was working fine since 1 month but suddenly the SAP is asking for exchange rate of different currencies while we are choosing Item on AR Invoice even the chosen Business Partner are in Local currency.  SAP is asking exchange rate only for a particular item not for all items. And this occurs only on Sales documents and Purchase documents are working fine. We are facing this problem in both through DI API and also on front end. The main concerns is that system requires exchnage rate only for a particular item which has maximum no. of AR Invoices. Rest all items are fine. This error start suddenly. I think there is no Item wise exchange rate configuration. Can you please help us on this?

[Former Member · Accepted solution]

Thankz all,

Problem has solved to change the base price origin setting under document setting -> general tab

[kothandaraman_nagarajan]

Hi,

Please check exchange rates and indexes under administration.

Thanks & Regards,

Nagarajan

[Former Member]

Dear Naga Rajan,

I have already checked this. The main problem is that system requires EX Rate while choosing the line item. I know there is no exchange rate in exchange table but it is not required as I am using system currency not the FC.

[Former Member]

Hi Anup

Can you run this query and give me a screenshot of the result?

SELECT T0.ItemCode, T0.EvalSystem, T0.GLMethod, T0.MngMethod, T0.IssueMthd, T0.AvgPrice, T0.LastPurPrc, T0.LastPurCur, T0.ExitPrice, T0.ExitCur

FROM OITM T0

WHERE T0.ItemCode IN ('ItemCode1','ItemCode2')

Replace ItemCode1 with the code of the item given the error and ItemCode2 with any item that does not have the error.

Kind regards

Peter Juby

[Former Member]

Hi Peter,

Ignore the first one ,I am sending the detail query output you required for both items.

in case of HTL is EX rate is required and in case of AIR EX rate is not required by system.

ItemCode	EvalSystem	GLMethod	MngMethod	IssueMthd	AvgPrice	LastPurPrc	LastPurCur	ExitPrice	ExitCur
AIR	F	C	R	B	0	0	NULL	0	NULL
HTL	F	C	R	B	0	86	EUR	0	NULL

[Former Member]

Hi Anup

Which currency is the cursor on when the exchange rate table opens?

Kind regards

Peter Juby

[Former Member]

EUR is the currency