What's the problem? Well in Axapta 3.0 SP4 KR2 there is a field on both the CRM quotations form and on the Sales Order form that is used to fix the exchange rate for the quotation / sales order. At least that's what the what's this info box indicates.
Unfortunately the only time the system actually uses the exchange rate that is entered into the fixed exchange rate field is when posting the invoice for a sales order the rest of the time this field is ignored and the default exchange rate for currency is used instead.
In order to get the system to take notice of this field involves modifying, 1 Map (SalesPurchLine), 1 Class (PriceDisc), 2 Tables (smmQuotationLine, SalesLine)
First off a new field is added to the smmQuotationLine and SalesLine tables of type SalesFixedExchRate called FixedExchRate.
We now need to make sure this is populated correctly. I've modified the initFromSmmQuoationTable method of the smmQuotationLine table to add the following line of code:
this.FixedExchRate = _smmQuotationTable.FixedExchRate;
The same piece of code will need to be added to the initFromSalesTable method of the SalesLine table.
this.FixedExchRate = _salesLine.FixedExchRate;
Ok, now that we've got a place to store the data we now need to modify the SalesPurchLine map to include the fixed exchange rate field into the map. So we first add the new field FixedExchRate to the fields in the map and then modify the mapping lines for the SalesLine and smmQuotationLine tables to include this new field.
Now we need to modify the PriceDisc class to use the new fixed exchange rate field, to do this we need to modify the following:
classDeclaration
Add the following variable declaration:
SalesFixedExchRate fixedExchRate;
newFromSalesPurchLine method should be changed as below:
static PriceDisc newFromSalesPurchLine( SalesPurchLine _salesPurchLine,InventDim _inventDim = _salesPurchLine.inventDim())
{
return new PriceDisc(_salesPurchLine.moduleType(),
_salesPurchLine.itemId,
_inventDim,
_salesPurchLine.purchSalesUnit,
systemdateGet(),
_salesPurchLine.salesPurchQty,
_salesPurchLine.orderAccount(),
_salesPurchLine.currencyCode,
_salesPurchLine.FixedExchRate);
}
new method should be changed as below:
void new(ModuleInventPurchSales _moduleType,ItemId _itemId,inventDim _inventDim,
UnitID _unitID,TransDate _discDate,Qty _qty, CustVendAC _accountId,
CurrencyCode _currency = Companyinfo::standardCurrency(),
SalesFixedExchRate _exchRate = 0)
{
moduleType = _moduleType;
itemId = _itemId;
unitID = _unitID;
inventDim = _inventDim;
discDate = _discDate;
qty = _qty;
accountId = _accountId;
currency = _currency;
fixedExchRate = _exchRate;
priceParameters = PriceParameters::find();
}
findItemPrice method should be changed as follows:
the calls to Currency:curPrice and Currency:curAmount before return (price!=0);
should be changed from
price = Currency::curPrice(price,currency,discDate);
markup = Currency::curAmount(markup,currency,discDate);
to
price = Currency::curPrice(price,currency,discDate,UnknownNoYes::Unknown,fixedExchRate);
markup = Currency::curAmount(markup,currency,discDate,UnknownNoYes::Unknown,fixedExchRate);
Now try a CRM quotation or Sales Order in a currency other than your company's base currency and Axapta should now respect the fixed exchange rate field.
