Skip to main content

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

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

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

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 ?

Hi PRODQ,

thank you, found the issue was in the baseprofile

Kind Regards

Mick

Reply


Terms & ConditionsCookie settings