NAV/BC - Columbus ToIncrease - ADC Bin to Bin - Error when trying to place all remaining

• ADC prompts you to place all remaining? 
• However, this only applies if you were transferring a container.
• If you are transferring loose stock, you have to say no. If you say yes, you get an error
• Choose no
• Scan item again
• Enter qty

BC16 - An encryption key must be imported using Import-NAVEncryptionKey before using Sql Authentication to access the database

 

C:\ProgramData\Microsoft\Microsoft Dynamics NAV\160\Server\Keys  was not being deleted.  

On deleting the key and re-entering the database credentials for the BC instance a new key was generated automatically and the BC instance ran without issue.

NAV/BC - How to remove lot tracking from an item

You can remove the item tracking code and lot no assignment method from items after doing the following

• Ensure stock is 0
• ensure there are no outstanding transactions with the item on it
• Run calculate warehouse movements>Post
• Run adjust costs

update [CRONUS$Item] set [Item Tracking Code] = '', [Lot No_ Assignment Method] = ''  where No_ = '101261'

NAV/BC - Columbus Toincrease - How to do a warehouse stock count

• Cycle Count
• Warehouse Physical Inventory Journal>Calculate Inventory>Select Item
• Actions>Print 
• Employees execute physical count, enter on sheet or excel
• Enter count against each of the lines or paste from excel
• Register
• Full Count Manual
• Warehouse Physical Inventory Journal>Calculate Inventory>Set count to zero
• Register
• Copy and paste a single record to excel to create a template
• Employees execute physical count, enter on excel
• Enter count against each of the lines or paste from excel
• Register
• Full Count Custom ADC Mobile Scan
• Warehouse Physical Inventory Journal>Calculate Inventory>Set count to zero
• Register
• Employees execute physical count on ADC Whse. Phys. Inv.
• Register
• Full Count Custom Web Client Mobile Scan
• Add custom barcode field to Warehouse Physical Inventory Journal to allow for scanning and line population
• Add code to autocreate container if it does not exist
• Warehouse Physical Inventory Journal>Calculate Inventory>Set count to zero
• Register
• Copy and paste a single record to excel to create a template
• Employees execute physical count, scan item, bin, lot, container
• Register

LS Retail - LS Appshell Mobile POS

•  LS Central 11.2
• Appshell does not work with Android device and Bluetooth paired printer - App is unstable
• Appshell works correctly with Windows devices and hardware station - Windows appshell cannot detect bluetooth printer
•  LS Central 16
• Appshell works correctly with Android device and Bluetooth paired printer
• Appshell works correctly with Windows devices and hardware station - Windows appshell cannot detect bluetooth printer

Nav/BC - Columbus ToIncrease - Quantity(Base) Available must not be less than x in Bin Content Location Code y

Delete or complete all Warehouse Picks

Delete or complete all Warehouse Shipments

Delete or complete all Warehouse Movements

NAV/BC - Columbus To-Increase - Insufficient quantity to complete this action. The base quantity in the bin is x. 0.00001 units are not available for Bin Code y

 This can happen if large decimals are used on UofM's by mistake, causing inadvertent rounding to 5 dp in stock quantities.

• Identify the exact item, uofm and lot that is giving the problem
• In SQL, update the appropriate Qty_Base value to ensure sufficient stock is available on the line

   update [CRONUS$Warehouse Entry]

  set [Qty_ (Base)] = [Qty_ (Base)]+0.00001

       where [Item No_] = '100001' and [Unit of Measure Code] = 'LB' and [Entry No_]=9317

LS Central - SQL View - Get Latest 12-13 Digit Barcode or other barcode if no 12-13 digit barcode can be found

 SELECT ItemNo, [1213BC], [1213BCDate], OtherBC, OtherBCDate,Case when ([1213BC] > '') then [1213BC] else OtherBC end as FinalBarcode,Case when ([1213BC] > '') then [1213BCDate] else OtherBCDate end as FinalBarcodeDate

FROM     (SELECT ItemNo, MAX([1213BC]) AS [1213BC], MAX([1213BCDate]) AS [1213BCDate], MAX(OtherBC) AS OtherBC, MAX(OtherBCDate) AS OtherBCDate

                  FROM      (SELECT CASE WHEN BCLen = '1213' THEN LastDateModified ELSE '' END AS [1213BCDate], CASE WHEN BCLen = 'Other' THEN LastDateModified ELSE '' END AS OtherBCDate, ItemNo, 

                                                       CASE WHEN BCLen = '1213' THEN MAX([Barcode No_]) ELSE '' END AS [1213BC], CASE WHEN BCLen = 'Other' THEN MAX([Barcode No_]) ELSE '' END AS OtherBC

                                     FROM      (SELECT LB.LastDateModified, LB.ItemNo, LB.BCLen, LB.BCCount, BC.[Barcode No_]

                                                        FROM      (SELECT MAX([Last Date Modified]) AS LastDateModified, [Item No_] AS ItemNo, CASE WHEN LEN([Barcode No_]) BETWEEN 12 AND 13 THEN '1213' ELSE 'Other' END AS BCLen, COUNT([Barcode No_]) 

                                                                                             AS BCCount

                                                                           FROM      [Master Config$Barcodes]

                                                                           GROUP BY LEN([Barcode No_]), [Item No_]) AS LB INNER JOIN

                                                                              (SELECT [Item No_], [Barcode No_], [Last Date Modified]

                                                                               FROM      [Master Config$Barcodes] AS [Master Config$Barcodes_1]) AS BC ON LB.LastDateModified = BC.[Last Date Modified] AND LB.ItemNo = BC.[Item No_]) AS LBC

                                     GROUP BY LastDateModified, ItemNo, BCLen, BCCount) AS IBC

                  GROUP BY ItemNo) AS FLBC

How to get whiteboards to work on Zoom when using a Chromebook

• How to connect to zoom
• Using the web client at https://zoom.us/signin
• Download Zoom Rooms from the Google Play Store
• Download Zoom Cloud Meetings from the Google Play Store
• By default, using the regular web client, or Zoom Rooms client, whiteboard and annotation features are not available
• https://support.zoom.us/hc/en-us/articles/360023994532-Zoom-Rooms-for-Chrome-OS-Features
•  However, you can use the Zoom Cloud Meetings app to get the whiteboard and annotation functionality
• When entering the room passcode, the chrome password manager hijacks the screen, and you have to select a password, clear it, then enter the proper room code

NAV / BC - How to modify R7390 Calculate Warehouse Inventory for Warehouse Physical Journal to allow item card filters

The first table in the default report is Bin Content.

Add item level above bin content

• Item (Item2)
• Bin Content (Bin Content)

Linked on item number for each level

This allow you to use the item filters on the report.

Enable network drives in SQL Management Studio

 https://vandijk.cloud/restore-sql-backup-from-a-network-share/

use Master;

EXEC sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

EXEC sp_configure 'xp_cmdshell',1

GO

RECONFIGURE

GO

EXEC XP_CMDSHELL 'net use H: \\RemoteServerName\ShareName'

If the specific share has authentication enabled you might have the change the last command to:

EXEC XP_CMDSHELL 'net use H: \\RemoteServerName\ShareName' /user:domain\username ThePassword

NAV/BC Columbus Foods - Must not have less than 0 in Bin

 This error occurs when a warehouse movement has been halfway done on ADC.

A Take without a place.

Go to Bin Status

Find the item

Check all of the outbound transactions holding stock

Delete any half-done movements

NAV/BC Columbus Foods - Breakbulk does not work with Containers, ADC and Warehouse Picking

 Automatic breakbulk does not work with Columbus Foods ADC Picking

You must manually break the stock to make it available in smaller UofM's for picking before you pick

Bluetooth devices do not connect to laptop. Forever detecting.

 Task Manager>Services

Set all bluetooth services to automatic

Restart machine

Camera does not work, or is not detected by Teams, Zoom, etc.

https://support.microsoft.com/en-us/help/13753/windows-10-camera-does-not-work#:~:text=Camera%20doesn't%20work%20in%20Windows%2010&text=When%20your%20camera%20isn't,app%20you%20want%20to%20use.

Run camera app

If you have disabled gps tracking on your camera, the entire camera is disabled

There are a number of issues with the latest versions of windows and camera drivers.

Update to the latest drivers if they exist

OR

Go to system restore, and restore your machine back to an earlier version before the latest update when the camera was working

I was never able to get my dell xps camera to function consistently. Sometimes it would detect, sometimes it would not. Ended up getting a chromebook instead. Haven't had any issues since.

NAV / BC - Change Exchange rates per transaction

 Click on the three dots next to the currency to change the rate for that specific transaction

LS Central - Barcode Import Error - Does not exist in item

 You get this error when trying to config package import barcodes to the barcode table

There is a bug in the barcode table meant to handle barcode entry via the page which causes the import to fail.

Disabling the validation in the package has no effect.

Solution: Import to table directly using SQL, or use the item import tool for just the barcode data

LS Central - Device "VIRTUAL_P1" of type "Printer" has not been loaded into POS.

• Run Virtual Printer (on desktop) as administrator
• C:\Program Files (x86)\LS Retail\LSHardwareStation\LSVirtualstation.exe
• Open Web client > run pos > Login
• Go to services.msc and restart the LS Hardware Station
• Proceed to cash
• 
  

To automate the restart, Create a batch file to restart the LS Hardware service

net stop "LS Hardware Station"

net start "LS Hardware Station"

pause
 

If this does not work, or you get the error "Could not accept control messages" or "could not be controlled" 

 

Manually run 

 

Sc queryex 

 

Get the PID, eg. 6123 

 

Then run  

 

taskkill /PID 6123 /F