SQL - Get Date only from getdate

DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

Power BI - Column to calculate Type Descriptions - Convert from int option value to description

DocTypeDesc = switch(FORMAT('32ItemLedgerEntry'[Document Type],"#"),"0","",

FORMAT('32ItemLedgerEntry'[Document Type],"#"),"1","Sales Shipment",

FORMAT('32ItemLedgerEntry'[Document Type],"#"),"2","Sales Invoice",

FORMAT('32ItemLedgerEntry'[Document Type],"#"),"3","Sales Return Receipt",

FORMAT('32ItemLedgerEntry'[Document Type],"#"),"4","Sales Credit Memo",

FORMAT('32ItemLedgerEntry'[Document Type],"#"),"5","Purchase Receipt",

FORMAT('32ItemLedgerEntry'[Document Type],"#"),"6","Purchase Invoice",

FORMAT('32ItemLedgerEntry'[Document Type],"#"),"7","Purchase Return Shipment",

FORMAT('32ItemLedgerEntry'[Document Type],"#"),"8","Purchase Credit Memo",

FORMAT('32ItemLedgerEntry'[Document Type],"#"),"9","Transfer Shipment",

FORMAT('32ItemLedgerEntry'[Document Type],"#"),"10","Transfer Receipt",

FORMAT('32ItemLedgerEntry'[Document Type],"#"),"11","Service Shipment",

FORMAT('32ItemLedgerEntry'[Document Type],"#"),"12","Service Invoice",

FORMAT('32ItemLedgerEntry'[Document Type],"#"),"13","Service Credit Memo",

FORMAT('32ItemLedgerEntry'[Document Type],"#"),"14","Posted Assembly"

)

NAV Views - Stock and Sale Report with Variances

• Enter date range
• Report shows opening stock as at starting date
• All stock sales, receipts, adjustments, etc.
• Closing Stock as at ending date
• Stock on all locations as at ending date
• Total on the side to show any variance between sales and stock actual calculated and system values
• SQL views to give all required data
• Item List
• Opening Stock
• All movements
• Closing Stock
• All stock in all locations in columns (autoupdates when new locations added)

NAV Links - Custom links list that open on click - Use Recordlinks Page

Add the recordlinks page as a system part to a role center

eOne Smartconnect - Scheduler does not start

https://www.eonesolutions.com/help-article/kba-01030-t1s5g8/

• In this case, the COM+ user was wrong because econnect was previously installed as a different user

LS NAV - Mobile Devices - Trial Expired - How to get new Mobile device licenses

• Run the T99009291 MobileLicenseRegistration Table
• Or navigate to POS Terminal Card>Omni>Mobile License Registration
• Look for the values in the "Device Unique ID" column
• Submit all of these to Ls Retail license support
• They will send back license keys to be entered in the corresponding Device License Key field

EOne Smartconnect Map Migration Gotchas

• You cannot migrate the data sources
• Custom lookups will get messed up
• Bottom line, it is easier to build the map in the correct smartconnect instance to begin with. Do not rely on copying or restoring maps.