to fix reserved item in D365 FO x++ (Recalculate Inventory)

i mistakenly delete some SO line from sales order through SSMS but lines item are reserved .

now what happened they do not going to unreserve 

what i did is to delete related record from inventTrans and inventtransOrigin 
than run the script below to fix it.
Now it works.

 

static void InventSum_Recalculate(Args _args)  

 {  
   InventSumRecalcItem           InventSumRecalcItem;  
   InventTable               _InventTable;  
   while select * from _InventTable where _InventTable.ItemId == 'DPID0000040'  
   {  
     ttsBegin;  
     InventSumRecalcItem = new InventSumRecalcItem(_InventTable.ItemId, true, checkfix::fix);  
     InventSumRecalcItem.updatenow();  
     ttsCommit;  
   }  
   info("Done");  
 }

Comments

Post a Comment

Popular posts from this blog

step 20 Update script for service model: AOSService on machine: CR-VM-Test-1

  Hi, Cause: This can be either happening because of timeout or files being temporarily blocked. A general approach to resolve this issue would be the following: 1. Restart the Environment and try deploying the package again. 2. If that doesn't work, restart the Services and try deploying the package again.  3. If that doesn't work and if you see the below-mentioned error in the Log file: The process cannot access the file 'K:\AosService\WebRoot\bin\Microsoft.Dynamics.ApplicationPlatform.XppServices.Instrumentation.dll' because it is being used by another process,  following the below mentioned Action Plan should resolve the issue. Action Plan: 1. Open a PowerShell prompt as Administrator 2. Navigate to <Services drive>\DeployablePackages\<Runbook ID>\AOSService\Scripts 3. Create a temporary directory for log files 4. Execute: .\AutoUpdateAOSService.ps1 -LogDir <Log directory from step 3>. (Will likely take 75-100 minutes to complete) 5. Once the manua...
Read more

How to Bypass Next in COC in D365 X++

 To Skip the next call use try catch    protected void addPurchaseLines(int _line) { try { throw Exception::Error; next addPurchaseLines(_line); } catch(Exception::Error) {          // write your logic here      } } if want to skip the code between ttsbegin/ ttscommit than use throw Exception::UpdateConflict; instead of throw Exception::Error; protected void addPurchaseLines(int _line) { try { throw Exception::UpdateConflict; next addPurchaseLines(_line); } catch(E xception::UpdateConflict; ) {         // write your logic here     } } Regards  Muhammad Farraz email: farazjaved01@gmail.com
Read more