Business Central, LS Central - Could not connect to localhost

User account needs to be set to login as a service

OR

KB5066835 is installed

 It has come to our attention that Windows 11, October 2025 Cumulative Update (KB5066835) can cause localhost connections to fail. This might affect Hardware Station (HWST) and LS Central connections if hosted locally.

While Microsoft is investigating the underlying cause for this, they have provided two workarounds:

1. Workaround #1: 

1.     In the registry keys, navigate to: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\HTTP\Parameters

2.     Under the Parameters folder, right-click in the right-hand pane and select New > DWORD (32-bit) Value.

3.     Name the value EnableHttp2Tls and set its data to 0 (zero).

4.     Repeat the process to add another value named EnableHttp2Cleartext and set its data to 0.

2. Workaround #2: Uninstall KB5066835.

Business central - Purchase Return - Nothing to Handle - Entries applied to an outbound transfer cannot be unapplied

•  Problem: Trying to do a purchase return for items that have already been transferred out of the original receiving location, which is causing the error because the system cannot reverse the costs on a transfer
• Solution: Turn off exact cost reversing in Purchase Setup. Redo purchase return without using Get Lines. Just type the quantity in to return

BC SAAS Barcodes

 procedure MakeCode128Barcode(Input: Code[20]): Text

    var

        BarcodeFontProvider: Interface "Barcode Font Provider";

        BarcodeSymbology: Enum "Barcode Symbology";

        EncodedText: Text;

    begin

        // Initialize the barcode provider

        BarcodeFontProvider := Enum::"Barcode Font Provider"::IDAutomation1D;

        // Set the barcode symbology to Code128

        BarcodeSymbology := Enum::"Barcode Symbology"::Code128;

        // Validate the input string

        BarcodeFontProvider.ValidateInput(Input, BarcodeSymbology);

        // Encode the input string to barcode font

        EncodedText := BarcodeFontProvider.EncodeFont(Input, BarcodeSymbology);

        //Set the field in your report to one of these fonts

        //fonts do not have to be installed on your local computer if using saas

        //Check codes here https://www.idautomation.com/barcode-fonts/code-128/user-manual/

        //Type this directly into the font for the field, do not use the dropdown

        // IDAutomationC128S

        // IDAutomationHbC128M

        exit(EncodedText);

    end;

    procedure Make3of9Barcode(Input: Code[20]): Text

    var

        BarcodeFontProvider: Interface "Barcode Font Provider";

        BarcodeSymbology: Enum "Barcode Symbology";

        EncodedText: Text;

    begin

        // Initialize the barcode provider

        BarcodeFontProvider := Enum::"Barcode Font Provider"::IDAutomation1D;

        // Set the barcode symbology to Code128

        BarcodeSymbology := Enum::"Barcode Symbology"::Code39;

        // Validate the input string

        BarcodeFontProvider.ValidateInput(Input, BarcodeSymbology);

        // Encode the input string to barcode font

        EncodedText := BarcodeFontProvider.EncodeFont(Input, BarcodeSymbology);

        //Set the field in your report to one of these fonts

        //fonts do not have to be installed on your local computer if using saas

        //Check codes here https://www.idautomation.com/barcode-fonts/code-128/user-manual/

        //Type this directly into the font for the field, do not use the dropdown

        // IDAutomationHC39S

        // IDAutomationHC39M

        exit(EncodedText);

    end;

LS Retail - POS shows database error. Out of space. Truncate.

 Database is full from Job queue entry bug filling up the logs and maxing out the database size.

Truncate the Job queue entries and logs

truncate table [CRONUS$Job Queue Log Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

truncate table [CRONUS$Job Queue Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

LS Central - Post Statement - Customer does Not Exist

 If the customer is not a real customer, you can remove it from the following tables to allow the statement to post

       select * FROM [Cronus].[dbo].[Cronus$Transaction Status$5ecfc871-5d82-43f1-9c54-59685e82318d]

  where [Transaction No_] = 188996 and [Statement No_] = 'S030010087'

  select * FROM [Cronus].[dbo].[Cronus$Transaction Status$5ecfc871-5d82-43f1-9c54-59685e82318d]

  where [Customer No_] >'' and [Statement No_] = 'S030010087'

    select * FROM [Cronus].[dbo].[Cronus$Transaction Status$5ecfc871-5d82-43f1-9c54-59685e82318d]

  where [Statement No_] = 'S030010087'

select [Customer No_], * FROM [Cronus].[dbo].[Cronus$Transaction Header$5ecfc871-5d82-43f1-9c54-59685e82318d]

  where [Transaction No_]=188996 and [Receipt No_] = '000030-003000189010'

    select * FROM [Cronus].[dbo].[Cronus$Trans_ Sales Entry$5ecfc871-5d82-43f1-9c54-59685e82318d]

  where [Transaction No_] = 188996 and [Receipt No_] = '000030-003000189010'

    select * FROM [Cronus].[dbo].[Cronus$Trans_ Payment Entry$5ecfc871-5d82-43f1-9c54-59685e82318d]

  where [Transaction No_] = 188996 and [Receipt No_] = '000030-003000189010'

    select [Customer No_],* FROM [Cronus].[dbo].[Cronus$Transaction Header$5ecfc871-5d82-43f1-9c54-59685e82318d]

  where Date >= '2025-05-28 00:00:00.000' and [Customer No_] not in (select [No_] FROM [Cronus].[dbo].[Cronus$Customer$5ecfc871-5d82-43f1-9c54-59685e82318d] )

    update [Cronus].[dbo].[Cronus$Transaction Header$5ecfc871-5d82-43f1-9c54-59685e82318d]

set [Customer No_] = '03', [To Account] = 0, [Amount to Account] = 0

where [Transaction No_] = 188996 and [Receipt No_] = '000030-003000189010'

         update [Cronus].[dbo].[Cronus$Transaction Status$5ecfc871-5d82-43f1-9c54-59685e82318d]

set [Customer No_] = ''

  where [Customer No_]='21647'

    update [Cronus].[dbo].[Cronus$Trans_ Sales Entry$5ecfc871-5d82-43f1-9c54-59685e82318d]

set [Customer No_] = ''

  where [Customer No_]='21647'

  Delete and Recalculate statement

Power BI Dax - New Column that shows text after a character or delimiter

Right click dataset> new column

Column name = Path

Source data = Area Path

 Path = right([Area Path], len([Area Path]) - search("\",[Area Path],,0))

Business Central - Financial Report - Formula to correctly compare periods including leap year day in filter

•  Use Comparison Date formula CM-1Y to correctly compare the entire month to month regardless of filter details
• -1Y will use exact dates