Skip to main content
Solved

Recalculate Price/Currency


Forum|alt.badge.img+5
  • Do Gooder (Customer)
  • 17 replies

When trying to recalculate Price/Currency it works fine within the custom order then selecting the line and RMB recalculate Price/Currency

but when i try to do this from the customer order line view it errors.

on investigation i have found that there are 2 Currency columns in the customer order lines view

When i look at the system info one sql column is CODE_G
 

 

the other column:

 

when i query  customer order line in SQL i get the following results

select co.code_G,co.CURRENCY_CODE
from ifsapp.CUSTOMER_ORDER_JOIN co
where order_no = '12345678'

Has anyone else had this issue and if so how did you resolve please

Best answer by PRODQ

It’s part of the Company/Financials setup right at the very outset - “Code Part Values”.  You may not use it - we don’t - hence why your SQL returns null. 

 

If you have a user who can’t action the recalc, have you checked their permissions - the issue is likely unreleated to Code Part G ?

View original
Did this topic help you find an answer to your question?

4 replies

PRODQ
Superhero (Customer)
Forum|alt.badge.img+17
  • Superhero (Customer)
  • 474 replies
  • March 4, 2025

CURRENCY CODE = Code Part G is a “code part” like Account (code part A), cost centre (code part b), project (code part c) etc whereas the other ‘CURRENCY’ column is the actual currency like EUR or USD or GBP etc.  

 

Linda


Forum|alt.badge.img+5
  • Author
  • Do Gooder (Customer)
  • 17 replies
  • March 4, 2025

Hi PRODQ.

thank you for your reply. where is the code part G set?

I as an administrator can carry out the recalculate Price/Currency but user cant from the customer order lines view. I have never noticed this column Currency (Code_G) before

Kind Regards

Mick


PRODQ
Superhero (Customer)
Forum|alt.badge.img+17
  • Superhero (Customer)
  • 474 replies
  • Answer
  • March 4, 2025

It’s part of the Company/Financials setup right at the very outset - “Code Part Values”.  You may not use it - we don’t - hence why your SQL returns null. 

 

If you have a user who can’t action the recalc, have you checked their permissions - the issue is likely unreleated to Code Part G ?


Forum|alt.badge.img+5
  • Author
  • Do Gooder (Customer)
  • 17 replies
  • March 4, 2025

Hi PRODQ,

thank you, found the issue was in the baseprofile

Kind Regards

Mick


Reply


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