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.

NAV - Reverse Purchase Invoice Item Charges

• Departments/Financial Management/Payables/Purchase Credit Memos
• Create new Credit Memo
• Enter Vendor
• Get Posted Document Lines to reverse
• Select Lines to reverse
• Click Line>Item Charge Assignment
• Get Receipt Lines
• Select the lines to apply the credit to
• Post Credit
• Now you can redo a new purchase invoice for the correct amount, and redo your item charges
• Be sure to run your adjust costs afterwards

NAV - Jet Reports - How to build a report

• Install Jet
• Launch Excel
• Jet>Data Source Settings>Define Jet Data source
• Connecting to the Cube will enable different tools than connecting to a regular ODBC
• Use these tools to build parts or all of your report
• Row 1 and Column A are restricted and designated for Jet system functions, do not enter values here
• A2 - Keyword Option will display value as an option in report
• B1 - Keyword Title will display value as title in report
• B2 - Keyword Value will display value as an editable field in report
• From B2 onward, you can enter values and labels that can be referenced in formulas
• Formulas (JfX)
• Jet reference
• https://support.jetglobal.com/hc/en-us/articles/218953168-NL-Function-Reference
• Other References
• https://community.dynamics.com/nav/b/technicaltipsandtricksfordynamicsnav/posts/creating-report-in-jet-using-nl-nf-np-amp-gl-amp-excel-formulas
• NF
• NL
• NP
• GL
• Report Wizard
• Select Table
• Select Filter, group, sort options
• Generate simple report off of a single table, similar to a standard pivot table report, but using Jet function syntax
• Direct Query off of Database takes very long
• Generally useless
• Table Builder
• Allows you to build views to join tables and add function logic
• Same as using Excel Query builder
• Slightly less useless
• Pivot Table (Cube Only)
• Will generate pivot table off of cube
• Same functionality as connecting directly to cube from Excel

• Scheduler
• Schedule report to email