Friday, February 21, 2025

LSC Member Points

  •  Redemption rate
    • Retail Currencies>Create LOY>Set exchange rate
    • Member Club>Points Setup>For each scheme, define a currency code

Tuesday, February 4, 2025

Wednesday, January 22, 2025

Business Central - SQL job to Auto Restart Error jobs in job queue

 update [Cronus$Job Queue Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

  set Status = 0

  where [Object ID to Run]<> 260 and [Recurring Job] = 1 and Status = 2 and [User ID]= 'Cronus\Administrator'

Wednesday, January 8, 2025

Power BI - How to connect to an excel file in your sharepoint or teams

  1.  Open file in sharepoint
  2. Open file in excel
  3. Go to File>Info>Copy Path
    1. It will look like this 
    2. https://mysite.sharepoint.com/sites/Shared%20Documents/myfile.csv?web=1
  4. Remove the ?web=1 so the link looks like this
    1. https://mysite.sharepoint.com/sites/Shared%20Documents/myfile.csv
  5. In power BI>Get Data>Web>Enter this address>enter your login info
  6. When you try to update the semantic model in power BI, you'll get another error saying credentials are missing
    1. Click on the semantic model>three dots>settings
    2. Data source credentials>Look for your web data sources
      1. Authentication method = OAuth2
      2. Privacy Level = Private
      3. It will prompt for your user credentials
      4. Data source will now be active

Friday, November 22, 2024

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

Wednesday, November 20, 2024

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.

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