Offline database creation steps for Dynamic AX 2012 R3 POS


We can have offline database for the retail stores in case the channel database is offline, or the network is down. Below are the steps to follow for offline database to create in Dynamics AX 2012 R3 version.

  • If there is an existing offline Database in fault status or not syncing, then we can re-create the offline DB by de-provision the database. If it is new offline DB creation the skip to step of running the Retail Channel Configuration Utility.
  • Stop the offline sync service in the POS machine and delete the offline DB from SQL Server.
  • Open the channel database system and follow below steps to de-provision the channel database.
  • Backup Channel database.
  • Open command prompt with elevated privilege and run the following command line: C:\Program Files (x86)\Microsoft Dynamics AX\60\Retail Database Utility>RetailDbUtilityCmd.exe DeprovisionChannelDB                  /StoreServername:<YourStoreServerName> /StoreDatabaseName:<YourStoreDatabaseName>
  • Check if all the _tracking tables are successfully deleted in your Channel database.
  • Run the “Retail Channel Configuration Utility” as administrator and select create offline database option as below.
  • Test connection of channel database and don’t test connection of offline DB as DB is not yet created.
  • Click on Apply to create the offline DB and wait for the messages of confirmation.
  • Now select Config Retail POS option as below.
          
  • Test connections of channel and offline DB and give the username and password to start the offline sync service.
  • Wait for the offline sync service to get synchronized with channel database.
  • Login to POS and click on database connection button to switch to offline DB and see it is successful. 
  • Once POS is in offline it doesn’t switch to online automatically. User explicitly needs to click on Database connection button to switch to online channel database.





Comments

Post a Comment

Popular posts from this blog

Sales order invoice posting using X++ with custom SalesParmLine fields

private boolean postSOInvoice(SalesTable salesTable) {     SalesFormLetter     letter      = SalesFormLetter::construct(DocumentStatus::Invoice);     CustInvoiceTrans    custInvoiceTransFrom;     SalesParmLine       salesParmLine;     SalesParmUpdate     salesParmUpdate;     SalesLine           salesLineLocal;          boolean             ret = true;         letter.salesTable(salesTable);         letter.initParmDefault();         letter.transDate          (systemDateGet());         letter.specQty            (SalesUpdate::All);         letter.proforma           (false);       ...
Read more

Create a custom lookup with multiple data sources on form using X++

Open the form on which you want to create a custom lookup. Go the data source - fields, select field and override the lookup method. Following code will help you in creating custom lookup using SysTableLookup with multiple data sources.  public void lookup(FormControl _formControl, str _filterStr) {      SysTableLookup            sysTableLookup;      Query                          query;      QueryBuildDataSource  qbds1, qbds2;      ;      sysTableLookup = SysTableLookup::newParameters(tablenum(table1),_formcontrol);      query = new Query();      qbds1 = query.addDataSource(tablenum(table1));    ...
Read more

SalesTable2Line custom field update prompt on Sales order in AX 2012

Image
 Dynamics AX has standard functionality to show a prompt for any common fields on Sales Header & Lines are being updated on header. This prompt is based on the setup done on the AR Parameters form -> Updates -> Update order lines button If we want to have our custom field to behave in same manner, then we need to do following steps. 1. Create your new field on the SalesTable & SalesLine tables. Here for I am going to use field as "AS_TitleTransfer" 2. Add the  AS_TitleTransfer field to SalesTable field group HeaderToLineUpdate. 3. Add the new field on the Header & Lines section on SalesTable form like on General Tab. 4. In the AxSalesTable class add parm & set methods for new field. public <<your EDT>> parmAS_TitleTransfer( <<your EDT>>  _Id = '') {     if (!prmisDefault(_Id))     {         this.setField(fieldNum(SalesTable, AS_Ti...
Read more