Показать сообщение отдельно
Старый 24.07.2012, 21:12   #1  
Blog bot is offline
Blog bot
Участник
 
25,644 / 848 (80) +++++++
Регистрация: 28.10.2006
ax-erp: Delete lines from purch line table based on specific criteria
Источник: http://microsoft-dynamics-ax-erp.blo...ine-table.html
==============

Delete lines from purch line table based on specific criteria we will write this code inside function or event for example clicked :

void clicked()
{
PurchLine _purchline;
int Counter=0;
;
try
{
ttsbegin;
while select forupdate _purchline where(_purchline.PurchReceivedNow==0 && _purchline.DIST==noyes::No)
{
if(_purchline.receivedInTotal()==0 && substr(_purchline.PurchId,5,-5)!='ERSDX')
{
_purchline.delete(); Counter++;
}
}
ttscommit;
info(strfmt("Number of Lines Deleted : %1",Counter));
}
catch
{
info(_purchline.PurchId);
}
}



Источник: http://microsoft-dynamics-ax-erp.blo...ine-table.html
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.