Wednesday, November 6, 2024

LS One License Activation Errors

 Related Errors:

License will expire

License Activation Failed

Issue:

An old or demo license may get stuck in the local windows folder, and is unable to be automatically deleted.

Manually deleting the license file allows a new license to be downloaded to the machine.

Standard procedure:

  1. Go to the licensing portal
    1. Disable then enable the licence
  2. On the local machine, navigate to C:\ProgramData\LS Retail\LS POS
    1. Delete the License file
  3. Launch the POS
    1. Enable the license from the POS
    2. https://help.ls-one.com/Content/HelpTopics/General/POSLicenses.htm
  4. Select License>Next

Thursday, October 17, 2024

Enable RCSI on BC SQL to improve database locking issues (ADR and Optimized Locking)

Advice here

https://demiliani.com/2023/11/23/dynamics-365-business-central-sql-server-and-read-committed-snapshot-isolation-impact/


Check if RCSI is enabled

SELECT name,

       is_read_committed_snapshot_on

FROM sys.databases

WHERE name = DB_NAME();


 Enable RCSI 

ALTER DATABASE YOURDATABASE SET READ_COMMITTED_SNAPSHOT ON GO 

 

Do a full index rebuild on everything after enabling it 




--------------------------------------

Related

------------------------------------

Also consider enabling ADR, and Optimized locking if you are on SQL 2019+


https://learn.microsoft.com/en-us/sql/relational-databases/performance/optimized-locking?view=azuresqldb-current&viewFallbackFrom=sql-server-ver16#is-optimized-locking-enabled

Tuesday, June 4, 2024

SSRS Add parameter to Data Set

 Create your parameter @MyParameter

add it to Text data source as Select * from Mytable where myvalue = (@MyParameter)

Thursday, November 2, 2023

SSRS Convert text to Date

 =Format(CDATE(First(Fields!DueDate_SalesInvcHeader.Value, "DataSet_Result")),"dd-MMM-yyyy")

Thursday, April 6, 2023

How to access data form Pervasive SQL in SQL Management Studio

Create Linked Server PERVASIVE using OLEDB Provider for ODBC 


 SELECT * FROM OPENQUERY(PERVASIVE,'SELECT * FROM mytable')

Friday, September 9, 2022

Business Central - EXEID Buffer index out of range

 Rebuild your package, re-export a new excel

Check your data and confirm it's all valid data for each field you're trying to import


Disable the table triggers in the config package

LS Statements

Create missing accounting periods. This can prevent posting from completing.

Problem originates from too many transaction existing in the buffer entry.

Split up the statement into smaller time periods and post each out separately, every hour or 15 mins.

Try Post sales first, then post statement after

Try Disable cost posting, then post costs after