Columbus - Mobile Scan guns

•  Honeywell CK65 

Kingswaysoft - Deploying SSIS Package - User cannot login error even though the package runs correctly in Visual Studi

https://docs.microsoft.com/en-us/troubleshoot/sql/integration-services/ssis-package-doesnt-run-when-called-job-step

Solution:

When deploying the project, choose "EncryptWithPassword" as the protectionlevel.

On Project>Properties - Choose "Encrypt all data with Password"

On Package>Double click to enter>Properties - Choose "Encrypt all data with Password"

Enter password in PackagePassword field

Debug>Rebuild Solution

NAV / BC - Inventory Valuation Report shows value when stock is zero

• There are two solutions.
• Solution 1
• Change average cost calculation in inventory setup to Item,Location,Variant 
• However, this will start tracking separate costs per location
• Solution 2
• https://www.navug.com/communities/community-home/digestviewer/viewthread?GroupId=49&MID=1095
• 1) Bring the inventory to zero. Physical inventory journal works well. (Lets say your using Jan 1, 2014 for your posting date)
• 2) Run the adjust cost.
• 3) Run inventory valuation.
• 4) Add 1 of your item back into stock at the opposite amount of what your inventory valuation is. If you have -0.05 as your inventory valuation make sure you add one at 0.05. Make sure your posting date is one day offset from your physical inventory date. (Use Jan 2, 2014 for your posting date).
• 5) Run the adjust cost routine and inventory valuation report.
• 6) You should have 1 in stock at 0 dollars.
• 7) Adjust your inventory out again on a different date (Use Jan 3, 2014) with a cost of zero.
• 8) Run adjust cost and inventory valuation. You should have zero on hand and zero dollar value.
• 9) Adjust your inventory back into the system at the correct quantity and dollar value. Once again use a different date. (Jan 4, 2014)
• You have to be very careful with the dates. If any transactions are posted for the items you are adjusting inside the date period you are using you will have to run this entire routine again.

NAV / Business Central - Insufficient Bin qantity when attempting to pick - CalcTotalQtyAvailToTake logic

•  Calc Negative Adjustments from warehouse lines
• Warehouse Journal may have unposted negative adjustments allocating stock
• Calc ATOQty - Warehouse Activity Lines (Pick, Take, Assemble to Order)

Business Central AL - Sequence contains no matching element

• This is happening because one of your table fields has enabled = false
•  

Business Central AL - the type or method setsumlinesfilter cannot be used for extension development

Add this line to your app.json for V3 and lower

 "target":"Internal",

Add this line to your app.json for V4 and higher

 "target":"OnPrem",

AL Snippet - Move an existing field

 pageextension 50001 PageExtension50001 extends "Warehouse Shipment List"

{

  layout

  {

    movefirst(Control1;Status)

  }

}