Skip to main content

Hi, Is it possible to change how this work in IFS.

Scenario

Customer invoice for order *434 done in May, Cost of the parts on the GL voucher has 750 USD and 702.599 EUR, using May exchange rate of 1.067464. 

Supplier invoice processed July 4th, cost 750 USD but 699.83 EUR, using July exchange rate of 1.071689
 

IFS at this point updates the inventory_transaction_cost_tab (ie actual data) from 702.599 to 699.83, using the July rate, and this is what is used by the inventory transaction history.

How do we stop this from happening. We would rather the difference just goes to a currency exchange difference code.

Instead our cost of sales for each serial are changing at a later point in time. Which is making reconciling our sales extremely difficult. We want the cost to stay as it was once the unit has been delivered and not change. No matter if the invoice comes in with a different exchange rate. We cannot have our finances moving. It must be static.

 




 

Hi, 

The inventory parts have a setting relating to what IFS calls invoice consideration. When this is set to transaction based, IFS updates the cost based on the supplier invoice. 

This is an optional feature. If that same attribute is set to ignore, then the value on the supplier invoice will no longer update the transaction cost.     The below is an older version (I was in this version testing for another client). 

Best regards, 

Thomas

Reply


Terms & ConditionsCookie settings