I was migrating the database which was on 8th April database to 10th April database. In this upgrade AD_Field_V view was updated. But this view was not migrated to my database. I need to re create the view.
Also the CurrencyBase, CurrencyConversion and CurrencyRate Functions were also not compiled. I had to recreate them as well. (After firing following queries
update C_CONVERSION_RATE set C_CURRENCY_TO_ID = 100 where C_CURRENCY_ID <> 100;
update C_CONVERSION_RATE set C_CURRENCY_TO_ID = 102 where C_CURRENCY_ID = 100;
update c_invoice set C_Invoice_id=109,C_currency_id=102 where documentno=100000
update c_invoice set C_Invoice_id=102,C_currency_id=100 where documentno=10000000
update c_invoice set C_Invoice_id=104,C_currency_id=100 where documentno=10000001
update c_invoice set C_Invoice_id=105,C_currency_id=100 where documentno=10000002
update c_invoice set C_Invoice_id=106,C_currency_id=100 where documentno=10000003
update c_invoice set C_Invoice_id=101,C_currency_id=100 where documentno=200001
update c_invoice set C_Invoice_id=103,C_currency_id=100 where documentno=200002
I need to fire these queries may be because my garden world data is not updated.
Log in to post a comment.