AXForum  
Вернуться   AXForum > Microsoft Dynamics AX > DAX Blogs
All
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 05.12.2014, 19:11   #1  
Blog bot is offline
Blog bot
Участник
 
25,459 / 846 (79) +++++++
Регистрация: 28.10.2006
emeadaxsupport: Vendor invoice - A currency to convert from is required to retrieve exchange rate information when trying to access a Vendor Invoice that is linked to a Purchase Order
Источник: http://blogs.msdn.com/b/axsupport/ar...ase-order.aspx
==============

Characteristics of issue:

We have had some Dynamics AX 2012 customers run into the error: "A currency to convert from is required to retrieve exchange rate information when trying to access a Vendor Invoice that is linked to a Purchase Order" when attempting to access the vendor invoice within the client. In the cases we have seen all of these vendor invoices have been attached to a workflow.



How to validate that issue exists on your system:

You can validate whether the issue exists on your system by running the following query:

Select * from SOURCEDOCUMENTLINE a where a.RECID not in (select SOURCEDOCUMENTLINE fromVENDINVOICEINFOTABLE) and (a.SOURCERELATIONTYPE = 1425 and a.TYPEENUMNAME='SourceDocumentLIne_VendorInvoice')

If you get any results returned from the query above we then need to verify that these are associated with orphaned SOURCEDOCUMENTLINE records. You can run the following query to verify that there is an orphan SOURCEDOCUMENTLINE record associated with the Vendor Invoice Header.

Select SOURCEDOCUMENTHEADER, COUNT(*) From SOURCEDOCUMENTLINE where SOURCEDOCUMENTHEADER in (Select SOURCEDOCUMENTHEADER from SOURCEDOCUMENTLINE a where a.RECID not in (select SOURCEDOCUMENTLINE from VENDINVOICEINFOTABLE) and (a.SOURCERELATIONTYPE = 1425 and a.TYPEENUMNAME='SourceDocumentLIne_VendorInvoice')) And SOURCERELATIONTYPE = 1425 GROUP BY SOURCEDOCUMENTHEADER HAVING COUNT(*) > 1

If results exist for the above query we have verified that the issue exists in your environment.



Resolution:

Step 1:

To clean up the orphaned records:

1. Run the query below again:

Select SOURCEDOCUMENTHEADER, COUNT(*) From SOURCEDOCUMENTLINE where SOURCEDOCUMENTHEADER in (Select SOURCEDOCUMENTHEADER from SOURCEDOCUMENTLINE a where a.RECID not in (select SOURCEDOCUMENTLINE from VENDINVOICEINFOTABLE) and (a.SOURCERELATIONTYPE = 1425 and a.TYPEENUMNAME='SourceDocumentLIne_VendorInvoice')) And SOURCERELATIONTYPE = 1425 GROUP BY SOURCEDOCUMENTHEADER HAVING COUNT(*)

2. For each SOURCEDOCUMENTHEADER value returned in the result set, delete the orphaned SOURCEDOCUMENTLINE record by inserting the appropriate SOURCEDOCUMENTHEADER value in the delete statement below.

Delete from SOURCEDOCUMENTLINE where RECID not in (select SOURCEDOCUMENTLINE from VENDINVOICEINFOTABLE) and (SOURCERELATIONTYPE = 1425 and TYPEENUMNAME='SourceDocumentLIne_VendorInvoice' and SOURCEDOCUMENTHEADER = <span style="background-color: #ffff00;"ENTER YOUR SOURCEDOCUMENTHEADER VALUE/span>)

3. To prevent future occurrences of this issue install KB 3008597.












Источник: http://blogs.msdn.com/b/axsupport/ar...ase-order.aspx
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
dynamicsaxtraining: Vendor returns Blog bot DAX Blogs 0 11.10.2012 00:11
emeadaxsupport: "An exchange rate cannot be found for exchange rate type XXX between currencies YYY and ZZZ on exchange date." when you attempt to process in Microsoft Dynamics AX 2012 Blog bot DAX Blogs 0 26.09.2012 07:15
dynamicsaxtraining: Purchase Blog bot DAX Blogs 0 11.03.2012 05:25
Shekhar: Invoice journal linked with Purchase order Blog bot DAX Blogs 0 31.05.2010 22:05
dynamicsaxtraining: Create purchase order Blog bot DAX Blogs 0 14.12.2009 14:05
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 23:09.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.