web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : 















 





 





    
     
    
    
     











 




















    
        
        
 



 







 


	
	
	
 



















 





 







    

        

            

                

                    

                        

                            

Dynamics 365 Community / Forums / 
                                     /   
                            

                        

                        
 
                                                    
                            





 





 


















                         
                        

                    

                

            

        

    





    

        

            

                

                    

                        
 
                            
                                 
                            
                            






 





 






                        


                        

                            
                            
                            
                        

                        

                            
  

                            
                            

                                
                                
                                

                                
                                




 





 

 
                                

                                
                                    











 





 






    
    
    
    

            
                
                
                
            

    


 

                                
                                
                                
                                
                                      
                                     (0)
                                
                                
                                    ShareShare
                                
                                

 






























    



 



 





ReportReport

                                
                                    

                                
                            
 
                            
                        

                    

                    

                    
 Posted on   by
                        










 



 










 





 












 





 


  











 





 












 





 









     

  


     Community member 


  
                    

                    

                        

                            
  

                            






Categories:
 

Purchasing

 

Development / Customization / SDK

 

Inventory and warehouse management

 

Sales







                        


                        
                        

                            





 





 










 





 






    
    
    
    

        
    

    


                        

                        

                        
                        

                            
                                
                            

                             
                        

                        
                    


                    

                        
 
                                                                                       
                        

                    


                     
                     
                     
                     
                     
                     
                     

                    
                    

                    
                    

                    
                     
                     

                                                              
                                                              
                                                              



















 





 










 





 










 





 










 





 











                       
                    

                    
                    

                        
                        
 
                            











 













































 





 














 

  


 
    
            
            
        
         
        
  • 
          
    
            
    
              
    
                
    
                  
    

                    
    
                    
    
                        
                        
                           
    Suggested answer
    
                        
                        

                      
    

                      
    
                     
    
                        






 
    



      Profile Picture
  
                        
    
                            










 











 





 












 





 


  











 





 












 





 








 
    

  


     Community member 


 on  at 
                        
    
                    
    
                        
    
                        
    
                        
                          
                        
                      
    
                    
    
                  
    
                
    
              
    
              
    
                
    
                  
    
                    
    
                      
     RE: Deleting 'wrongly' made Reservation Entries with reservation status Surplus
    
                    
    
                    
    
                      
    
                        
    Jeroen,
    

    You will not be the first person who needed clean-up help in the Reservation table. I highly recommend you contact your Partner and DO NOT DO THIS YOURSELF. This is not a table to be playing in. Your Partner can develop a one-time routine to delete the bad entries you have. You will supply either the entry records in the table or how to filter and locate the records to delete based on a criteria.
    

    One last thing, make a backup and have your Partner test everything in this backup before deploying to LIVE.
    

    Hope this helps.
    

    Thanks,
    

    Steve
    

                      
    
                    
    
                        
                        
    
                            





 





 










 





 






    
    
    
    
    
        
    
    
    


                        
    
                         
                      
                          
                       
                        
                        
     
                          
                        
    
                        
                  
    
                
    
              
    
            
    
          
    
        
    • 
        
            
            
        
         
        
  • 
          
    
            
    
              
    
                
    
                  
    

                    
    
                    
    
                        
                        
                           
    Suggested answer
    
                        
                        

                      
    

                      
    
                     
    
                        






 
    



      Profile Picture
  
                        
    
                            










 











 





 












 





 


  











 





 












 





 








 
    

  


     Community member 


 on  at 
                        
    
                    
    
                        
    
                        
    
                        
                          
                        
                      
    
                    
    
                  
    
                
    
              
    
              
    
                
    
                  
    
                    
    
                      
     RE: Deleting 'wrongly' made Reservation Entries with reservation status Surplus
    
                    
    
                    
    
                      
    
                        
    Hi, As you might know, there are many ways to delete data in NAV. The following are some examples from BC.
    

    https://navinsights.net/2020/10/27/4-ways-to-delete-records-from-a-table/
    

    But as Inge suggested, it's not as simple as deleting the data, below is a diagram of the Reservation Entry.
    

    https://dynamicsdocs.com/nav/2016/w1/table/reservation-entry
    

    But I'm not sure if there is any other functionality affected in that customization you mentioned. 
    

    So I think It is recommended to contact the development partner to deal with this data problem.
    

    

    Hope this helps.
    

    Thanks.
    

    ZHU
    

                      
    
                    
    
                        
                        
    
                            





 





 










 





 






    
    
    
    
    
        
    
    
    


                        
    
                         
                      
                          
                       
                        
                        
     
                          
                        
    
                        
                  
    
                
    
              
    
            
    
          
    
        
    • 
        
            
            
        
         
        
  • 
          
    
            
    
              
    
                
    
                  
    

                    
    
                    
    
                        
                        
                           
    Suggested answer
    
                        
                        

                      
    

                      
    
                     
    
                        






 
    



      Profile Picture
  
                        
    
                            










 











 





 












 





 


  











 





 












 





 








 
    

  


     Community member 


 on  at 
                        
    
                    
    
                        
    
                        
    
                        
                          
                        
                      
    
                    
    
                  
    
                
    
              
    
              
    
                
    
                  
    
                    
    
                      
     RE: Deleting 'wrongly' made Reservation Entries with reservation status Surplus
    
                    
    
                    
    
                      
    
                        
    In order to make sure you do not harm the integrity of your system i advice you to seek advice from you Dynamics NAV / BC partner to solve this. They can help you analyse the situation and suggest a way to clean your data.
    

                      
    
                    
    
                        
                        
    
                            





 





 










 





 






    
    
    
    
    
        
    
    
    


                        
    
                         
                      
                          
                       
                        
                        
     
                          
                        
    
                        
                  
    
                
    
              
    
            
    
          
    
        
    • 
        
      







 
                              
                            

                                

                                    

                                        
Under review

                                        
                                    

                                    

                                        
 
                                            
                                            

                                                
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

                                            

                                            
                                            

                                                    
                                            

                                       

                                    

                                 
                                

                             
  
                            
                        

                        
 

                    

                    
                

                

                    
                        







 





 


















   
       
        
   

    

        

            
Helpful resources

        

        
        





 





 








    
    

 
















    
    
    

    
        
    



        
            
        


        
        




 





 


        

         
            
                











 





 






    
    
    
    

            
            
            

    


 

            
        

          
        
             
              
            
            
                
              
             
              

                        
Leaderboard > test 12 sep 
 
                        
 
                         









 





 










 





 






 
























 





 










  
                         

                            Last month
                            Overall leaderboard 
                        

              

               
            
        

        

    






    
    

        
Featured topics

    

    

  

        

            
Product updates
 
            

            Dynamics 365 release plans