Tuesday 31 January 2017

Error Offline Database Retail 'SetClrFeatureSwitchMap' in DLL 'SqlServerSpatial110.dll'

I have Face issue after deploy patch KB3031055 and windows update, Offline database not working \syncing and giving error as below

The type initializer for 'ExtentPlaceholderCreator' threw an exception.: System.TypeInitializationException: The type initializer for 'ExtentPlaceholderCreator' threw an exception. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.EntryPointNotFoundException: Unable to find an entry point named 'SetClrFeatureSwitchMap' in DLL 'SqlServerSpatial110.dll'.
   at Microsoft.SqlServer.Types.GLNativeMethods.SetClrFeatureSwitchMap(Int32 clrFeatureSwitchMap)
   at Microsoft.SqlServer.Types.SqlGeometry.IsValidExpensive()
   at Microsoft.SqlServer.Types.SqlGeometry.Construct(GeoData g, Int32 srid)
   at Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType type, SqlChars text, Int32 srid)
   at Microsoft.SqlServer.Types.SqlGeometry.STGeomFromText(SqlChars geometryTaggedText, Int32 srid)
   at Microsoft.SqlServer.Types.SqlGeometry.Parse(SqlString s)
   --- End of inner exception stack trace ---
   

Using Server 2012 R2 with SQLSERVER 2014.

Solution 

 adding the following lines to the pos.exe.config 
<runtime>
  <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
    <dependentAssembly>
      <assemblyIdentity name="Microsoft.SqlServer.Types" publicKeyToken="89845dcd8080cc91" />
      <bindingRedirect oldVersion="1.0.0.0-11.0.0.0" newVersion="10.0.0.0" />
    </dependentAssembly>
  </assemblyBinding>
</runtime>
This forces the EntityFramework to use the version 10 of the SqlServer.Types.dll, which doesn't have the Geometry type apparently.


And works fine.........................!!!

Saturday 7 January 2017

AX 2012 Retail POS Default Operations List

In AX 2012 for Retail POS, you have the flexibility to add/change functionality behind buttons that the users can access from the Retail>>Setup>>POS>>Profile>Operations.
Operation ID
Operation name
Permission ID
Permission ID2
Check user access
User operation
Action lookup
100
Product sale
0
0
Yes
Yes
Retail product
101
Price check
0
0
Yes
Yes
None
102
Void product
1002
0
Yes
Yes
None
103
Product comment
0
0
Yes
Yes
None
104
Price override
0
0
No
Yes
None
105
Set quantity
0
0
Yes
Yes
None
106
Clear quantity
0
0
Yes
Yes
None
108
Product search
0
0
Yes
Yes
None
109
Return product
1017
0
Yes
Yes
None
110
Weigh product
0
0
No
No
None
112
Linked products add
0
0
No
No
None
113
Set dimensions
0
0
No
No
None
114
Return transaction
0
0
Yes
Yes
None
115
Show journal
1002
1002
Yes
Yes
None
117
Add loyalty card
0
0
Yes
Yes
None
121
Clear salesperson
0
0
Yes
Yes
None
122
Invoice comment
0
0
No
Yes
None
123
Change unit of measure
0
0
Yes
Yes
None
127
Override transaction tax
1018
0
Yes
Yes
None
128
Override transaction tax from list
1018
0
Yes
Yes
None
129
Override line product tax
1018
0
Yes
Yes
None
130
Override line product tax from list
1018
0
Yes
Yes
None
131
Packing slip
0
0
Yes
Yes
None
132
Deposit override
0
0
Yes
Yes
None
200
Pay cash
0
0
Yes
Yes
Payment method
201
Pay card
0
0
Yes
Yes
None
202
Pay customer account
0
0
Yes
Yes
Payment method
203
Pay currency
0
0
Yes
Yes
Payment method
204
Pay check
0
0
Yes
Yes
Payment method
206
Pay cash quick
0
0
Yes
Yes
Payment method
207
Pay loyalty
0
0
Yes
No
None
208
Pay corporate card
0
0
Yes
Yes
Payment method
210
Change back
0
0
Yes
No
None
211
Void payment
1002
0
Yes
Yes
None
212
Get fleet card information
0
0
No
No
None
213
Pay credit memo
0
0
Yes
Yes
Payment method
214
Pay gift card
0
0
Yes
Yes
Payment method
300
Line discount amount
0
0
Yes
Yes
None
301
Line discount percent
0
0
Yes
Yes
None
302
Total discount amount
0
0
Yes
Yes
None
303
Total discount percent
0
0
Yes
Yes
None
400
Popup menu
0
0
Yes
Yes
Menu
401
Sub menu
0
0
Yes
Yes
Menu
500
Void transaction
1001
0
Yes
Yes
None
501
Transaction comment
0
0
Yes
Yes
None
502
Salesperson
0
0
Yes
No
None
503
Suspend transaction
1011
0
Yes
Yes
None
504
Recall transaction
0
0
Yes
Yes
None
505
Recall unfinished transaction
0
0
No
No
None
506
Card swipe
0
0
No
No
None
508
Pharmacy prescription cancel
0
0
Yes
Yes
None
510
Pharmacy prescriptions
0
0
Yes
Yes
None
511
Issue credit memo
0
0
Yes
Yes
None
512
Issue gift card
0
0
Yes
Yes
None
513
Display total
0
0
Yes
Yes
None
515
Recall order
1022
0
Yes
Yes
None
516
Sales invoice
0
0
Yes
Yes
None
517
Income accounts
0
0
Yes
Yes
None
518
Expense accounts
0
0
Yes
Yes
None
519
Add to gift card
0
0
Yes
Yes
None
520
Gift card balance
0
0
Yes
Yes
None
600
Customer
0
0
Yes
Yes
None
602
Customer search
0
0
Yes
Yes
None
603
Customer clear
0
0
Yes
Yes
None
609
Customer transactions
0
0
Yes
Yes
None
610
Customer transactions report
0
0
No
Yes
None
611
Customer balance report
0
0
Yes
No
None
612
Customer add
0
0
Yes
Yes
None
614
Edit customer order
1021
0
Yes
Yes
None
620
Create customer order
1020
0
Yes
Yes
None
622
Search
0
0
Yes
Yes
None
623
Edit customer
0
0
Yes
Yes
None
700
Log on
0
0
No
No
None
701
Log off
0
0
No
Yes
None
702
Change user
0
0
Yes
No
None
703
Lock register
0
0
Yes
Yes
None
704
Log off force
0
0
No
No
None
800
Negative adjustment
1002
0
Yes
No
None
801
Inventory lookup
0
0
Yes
Yes
None
802
Stock count
0
0
Yes
Yes
None
803
Picking and receiving
0
0
Yes
Yes
None
900
Application exit
1002
0
Yes
No
None
906
Print tax free
0
0
Yes
No
None
907
Print previous slip
0
0
Yes
No
None
908
Print previous invoice
0
0
Yes
No
None
909
Upload printer logo
0
0
Yes
No
None
910
Restart computer
1002
0
Yes
No
None
911
Shut down computer
1002
0
Yes
No
None
912
Design mode enable
0
0
Yes
Yes
None
913
Design mode disable
0
0
Yes
Yes
None
914
Minimize pos window
0
0
Yes
Yes
None
915
Blank operation
0
0
Yes
Yes
None
916
Windows workflow foundation
0
0
Yes
Yes
None
917
Database connection status
0
0
Yes
Yes
None
918
Show blind closed shifts
1023
0
Yes
Yes
None
919
Extended log on
1002
0
Yes
Yes
None
920
Time clock
0
0
Yes
Yes
None
921
View time clock entries
0
0
Yes
Yes
None
922
View product details
0
0
Yes
Yes
None
1000
Open drawer
1012
0
Yes
Yes
None
1052
Tender declaration
1004
0
Yes
Yes
None
1053
Blind close shift
1023
0
Yes
Yes
None
1054
Suspend shift
0
0
Yes
Yes
None
1055
Close shift
0
0
Yes
Yes
None
1056
Print X
1003
0
Yes
Yes
None
1057
Reprint Z
1005
0
Yes
Yes
None
1100
Customer account deposit
0
0
Yes
Yes
None
1200
Declare start amount
0
0
Yes
Yes
None
1201
Float entry
1007
0
Yes
Yes
None
1210
Tender removal
0
0
Yes
Yes
None
1211
Safe drop
0
0
Yes
Yes
None
1212
Bank drop
0
0
Yes
Yes
None
1213
Search shipping address
0
0
Yes
Yes
None
1214
Add shipping address
0
0
Yes
Yes
None