LSC Member Management

•  Member scheme must have min and max points set. The range between is what will keep the member in the current level
• When a member qualifies for an upgrade or downgrade, this is triggered from the POS, and will create an upgrade entry that only triggers on the next day.
• You would have to adjust the next check date to get it to detect immediately when running the upgrade/downgrade routine
• Old member accounts may not pick up points if they were incorrectly imported, try creating a new account and using that
• Go to contact>Assign Card>Select Active Card

BC Print Separate Remittance

•  Payment Journal>Related>Payments>Send Remittance Advice>Printer>Default Printer
• You can connect this report to the check printing if required.

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

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

SSRS Add parameter to Data Set

 Create your parameter @MyParameter

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

SSRS Convert text to Date

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

Format of the initialization string does not conform to the OLE DB specification

Use  OLE DB Provider for SQL Server