NAV - User cannot save ribbon or screen customizations on full client

To resolve, create a permission set that gives explicit access to the 2000000075 User Metadata table

Assign this to all users.

In some cases, even SUPER does not give appropriate permissions.

LS NAV/ BC - How to stop a job that is currently running

 Open the development environment

Debug the session

Stop the job

NAV/BC - View Locked Tables

Useful for identifying if a specific routine is locking up tables

 select distinct TableName from(

SELECT OBJECT_NAME(p.OBJECT_ID) AS TableName,

resource_type, resource_description

FROM sys.dm_tran_locks as l

JOIN sys.partitions as p ON l.resource_associated_entity_id = p.hobt_id) as locks

Columbus - ADC Error when picking loose stock - Qty to handle cannot exceed outstanding quantity

 

• This error occurs on the ADC whenever there are multiple units of measure for the same item in the same bin.
• For now, the easiest workaround to fulfil eaches for a sales order is to move a single case into a separate bin, then break the entire quantity so it only has eaches in that bin, and not a mixture of eaches and cases. The ADC should work correctly as long as there are no mixed UofM’s within the same bin.

Zoom Whiteboard and annotations do not work on Chromebook

 Zoom whiteboard and annotations do not work on Chromebook when using the regular Zoom, or the Zoom web client.

You must install and use the Zoom Cloud Meetings app or the Zoom Rooms app (not sure what it's called now..there's a bunch of them on the chrome store) to get the whiteboard functionality to work.

However, the interface is not as nice or as responsive, and there are lag and freezing issues.

But the whiteboard works.

I hate you zoom. Fix your garbage.

Seesaw Classes App on Chromebook - Voice Recording - Feedback problem

 This is a problem specific to the Seesaw app in the Google store for the Chromebook.

When recording anything, it immediately plays the output through the speakers and causes feedback.

Solution:

Delete the Seesaw app, it's a piece of garbage. Use the Seesaw website and scan the login code instead.

Bookmark it once you get into your class.

Recording works just fine.

Seesaw, fix your chromebook app. No one can use it for their kids in it's current state.

NAV / BC - Hide Purchase Order Header based on Page Count - Only show header on first page

• There is no way to get the page numbers  from SSRS
• We have to put a line counter in the Purchase Order Report Code to calculate the number of lines per page
• then we use SSRS functions on the lines to hide based on the value of the Line Count
• We reset the line count for every PO

• Create Pagecount Global variable 
• Added to Data source to make it available to the report
• Added Pagecount := 0 in Copyloop Onpredataitem after Purchase Header
• Added Pagecount := Pagecount + 1 in Roundloop Onaftergetrecord after Purchase Line
• Our count ended up being max 18 records on the first page
• Added visibility function on SSRS row
• IIF(Pagecount <10,false,true)