Retail POS [AX2012] | Eliminar transacciones del punto de venta (POS).

Hola a tod@s

En esta ocasión les traemos un tema impórtate para Retail POS ya que en algún momento desearan eliminar todas las transacciones  del punto de venta y en DynamicsAx, especialmente cuando se está en etapa de implementación y pruebas de la aplicación, a continuación les indicamos las acciones a ejecutar.

      1.     Eliminar transacciones de la Dase de Datos del POS

En esta sección podemos usar dos tipos de querys según nos convenga:

I.      Query que elimina todas las transacciones.

 BEGIN TRANSACTION;  
 TRUNCATE TABLE RetailPosBatchAccountTrans  
 TRUNCATE TABLE RetailPosBatchTable  
 TRUNCATE TABLE RetailPosBatchTenderTrans  
 TRUNCATE TABLE RetailTransactionBankedTenderTrans  
 TRUNCATE TABLE RetailTransactionDiscountTrans  
 TRUNCATE TABLE RetailTransactionIncomeExpenseTrans  
 TRUNCATE TABLE RetailTransactionInfocodeTrans  
 TRUNCATE TABLE RetailTransactionLoyaltyPointsTrans  
 TRUNCATE TABLE RetailTransactionOrderInvoiceTrans  
 TRUNCATE TABLE RetailTransactionPaymentTrans  
 TRUNCATE TABLE RetailTransactionSafeTenderTrans  
 TRUNCATE TABLE RetailTransactionSalesTrans  
 TRUNCATE TABLE RetailTransactionTable  
 TRUNCATE TABLE RetailTransactionTaxTrans  
 COMMIT TRANSACTION;  

II.      Query que elimina transacciones y tiene opciones de filtro

 BEGIN TRANSACTION;  
 DELETE TABLE RetailPosBatchAccountTrans –-WHERE Columna = value  
 DELETE TABLE RetailPosBatchTable –-WHERE Columna = value  
 DELETE TABLE RetailPosBatchTenderTrans –-WHERE Columna = value  
 DELETE TABLE RetailTransactionBankedTenderTrans –-WHERE Columna = value  
 DELETE TABLE RetailTransactionDiscountTrans –-WHERE Columna = value  
 DELETE TABLE RetailTransactionIncomeExpenseTrans –-WHERE Columna = value  
 DELETE TABLE RetailTransactionInfocodeTrans –-WHERE Columna = value  
 DELETE TABLE RetailTransactionLoyaltyPointsTrans –-WHERE Columna = value  
 DELETE TABLE RetailTransactionOrderInvoiceTrans –-WHERE Columna = value  
 DELETE TABLE RetailTransactionPaymentTrans –-WHERE Columna = value  
 DELETE TABLE RetailTransactionSafeTenderTrans –-WHERE Columna = value  
 DELETE TABLE RetailTransactionSalesTrans –-WHERE Columna = value  
 DELETE TABLE RetailTransactionTable –-WHERE Columna = value  
 DELETE TABLE RetailTransactionTaxTrans –-WHERE Columna = value  
 COMMIT TRANSACTION;  

    2.     Eliminar transacciones de DynmicsAX

Para esto nos vamos al AOT nodo JOBS y creamos un nuevo JOB compitamos el código y ejecutamos.

 

   static void DeleteTransactions(Args _args)  
 {  
   RetailTransactionBankedTenderTrans        retailTransactionBankedTenderTrans;  
   RetailTransactionTenderDeclarationTrans   retailTransactionTenderDeclarationTrans;     
   RetailTransactionDiscountTrans            retailTransactionDiscountTrans;  
   RetailTransactionIncomeExpenseTrans       retailTransactionIncomeExpenseTrans ;  
   RetailTransactionInfocodeTrans            retailTransactionInfocodeTrans;  
   RetailTransactionLoyaltyPointsTrans       retailTransactionLoyaltyPointsTrans;  
   RetailTransactionOrderInvoiceTrans        retailTransactionOrderInvoiceTrans;  
   RetailTransactionPaymentTrans             retailTransactionPaymentTrans;  
   RetailTransactionSalesTrans               retailTransactionSalesTrans;  
   RetailTransactionTable                    retailTransactionTable;  
   RetailTransactionTaxTrans                 retailTransactionTaxTrans;  
   Dialog                                    dialog;  
 ;  
   dialog = new Dialog("Delete Transactions");  
   dialog.addText("Se realizara la eliminacion de transacciones");  
   dialog.run();  
   if (dialog.closedOk())  
   {  
     ttsBegin;  
       delete_from retailTransactionBankedTenderTrans;  
       delete_from retailTransactionTenderDeclarationTrans;  
       delete_from retailTransactionDiscountTrans;  
       delete_from retailTransactionIncomeExpenseTrans;  
       delete_from retailTransactionInfocodeTrans;  
       delete_from retailTransactionLoyaltyPointsTrans;  
       delete_from retailTransactionOrderInvoiceTrans;  
       delete_from retailTransactionPaymentTrans;  
       delete_from retailTransactionSalesTrans;  
       delete_from retailTransactionTable;  
       delete_from retailTransactionTaxTrans;  
     ttsCommit;  
     info('Proceso terminado');  
   }  
 }  

Después de ejecutar las acciones mencionadas tendremos un ambiente libre de transacciones de POS.

Espero les sea de gran ayuda no duden en preguntar.

  By NASIV.