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)

  }

}

Excel - Auto fit row height does not work

• Autofit Row heights will not work properly if
• Merge cells are used
• Bullets are used within cells
• Data is in a table 
• Resolution
• Select Cells>Clear format
• Reformat your document to allow the autofit to work properly
• Format your document to use word wrap cells
• No merge cells
• No Tables

LS NAV / LS Central - Custom Windows POS Receipt prints extra lines, white space, blank lines

• Report Layout
• Page size is a little smaller than actual print size eg. 3 inch = 2.8 inch page
• Field padding set to 0 for all fields
• Row - Increase Height or HeightCanGrow = False
• Font size 8
• Font Type courier
• Tablix must be all left and exact same size as page, no white space on sides 
• Barcode font must be installed on machine
• POS Print Utility - PrintToWindowsPrint
• Changed report number to custom report
• Local Variable POS Receipt - Changed to custom report number

Columbus - ToIncrease - Unit of Measure tables - Define KG to LB conversion rate

• T37002000 - Measuring System
• T204 - Unit of Measure - Base per unit of measure
• CheckforBase
• T5404 - Item Unit of Measure
• C37002005 - Process 800 UoM functions - ModifyItemUoM