Skip to main content
Question

Cloud Receipt RMA conversion rate

  • August 21, 2026
  • 8 replies
  • 52 views

Forum|alt.badge.img+16

Community,

any idea where Receipt RMA saved the conversion rate? see the screenshot attached.

when the arrival qty CS is entered, system automatically multiply by 20 in the inventory UOM CS, there must be the old rate is being captured somewhere in the system, though we already correct them all in Sales Part, and Supplier for Purchase Part.

 

Thank you.

 

8 replies

PRODQ
Superhero (Customer)
Forum|alt.badge.img+18
  • Superhero (Customer)
  • August 21, 2026

Could be Sales Part or Inventory Part/Unit of Measure section?

 

 


Forum|alt.badge.img+16
  • Author
  • Hero (Customer)
  • August 21, 2026

@PRODQ thank you for your reply.

We did fix the sales part rate ( we run a script) from Demand site and Supply site, also the customer order line level rate we all fixed for those old orders.

 

but when doing RMA, the receipt RMA (at supply site) still can see this rate populated. it must be somewhere hide at back scene.

Thank you.

 


PRODQ
Superhero (Customer)
Forum|alt.badge.img+18
  • Superhero (Customer)
  • August 21, 2026

Presumably there was a conversion rate set at the time the parts were shipped?  I would expect that same conversion to be in place at the point of being returned to be honest.  If you shipped qty one (which was one box of 20) on that order and you are returning qty one you are still returning the same box of 20…

 

I think?

Linda


Forum|alt.badge.img+16
  • Author
  • Hero (Customer)
  • August 21, 2026

@PRODQ Thank you for your reply.

 

these are old orders that are messed up with the conversion rate. though we fixed conversion rate right now. it should be consistent 1 to 1 as the same UOM. 

current system behavior feels like inventory UOM is EA, then sale in UOM CS, 1CS =20EA. it is kept somewhere and brought forward from demand site RMA and return to the supplier site of the Receipt RMA.

 

 


PRODQ
Superhero (Customer)
Forum|alt.badge.img+18
  • Superhero (Customer)
  • August 21, 2026

Your 1/20 conversion will be set against the Sales Part record.  Even if you have updated that now, the rate on the original order will still be 1/20.  You’ll see on the Customer Order Lines...

 

 


Forum|alt.badge.img+16
  • Author
  • Hero (Customer)
  • August 21, 2026

@PRODQ Thank you for your reply.

 

We do fix the customer order lines via technical script. but i believe the RMA is created before the script executed. 

so there must be another place to save these rate in the RMA side.


Piyal Perera
Hero (Partner)
Forum|alt.badge.img+12
  • Hero (Partner)
  • August 22, 2026

Hi ​@ronhu 

Please check following pages:

1. RMA Line Level

On the RMA line itself (which defines the return and the relationship between the sales unit of measure and the inventory unit of measure):

  • Database Table: RETURN_MATERIAL_LINE_TAB

2. Receipt Header / Receipt Info Level

When the RMA items are received through the receipt flow (Register Arrivals / Receipt Handling), IFS creates a receipt record referencing the RMA line:

  • Database Table: RECEIPT_INFO_TAB

regards,

Piyal


Forum|alt.badge.img+16
  • Author
  • Hero (Customer)
  • August 27, 2026

@Piyal Perera appreciate your feedback.