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

Business Central - New Sales Price List Functionality

• Item with no prices setup. 0 Price on Item Card. - $0 price appears on sales order
• Item with no prices setup. $10 price on item card - $10 appears on order for base UofM
• Item with All Price List of $100, no discount, blank dates, draft - $10 appears on order for base UofM
• Item with All Price List of $100, no discount, blank dates, active - $100 appears on order for base UofM
• Item with All Price List of $100, 10 discount, blank dates, active, allow line discount - $90 appears on order for base UofM with %10 line discount
• Item with All Price List of $101, no discount, starting date only, active - $100 appears on order for base UofM

Price Logic

• Customer Should be assigned to a specific group or specific price sheet that contains only the special prices for him, or his group
• Do not create an "All Customers" price list
• Use Item Card as Base Pricing
• Ignores dates for priority
• Customer will get Lowest price in all price lists assigned to all customer, or customer group

LSC View to identify replication counters for transaction headers with missing lines

SELECT TH.Date, TH.[POS Terminal No_], TH.[Entry Status], COUNT(TSE.[Line No_]) AS Lines, TH.[Replication Counter] AS FirstReplCounter, TH.[Net Amount]

FROM     dbo.[Cronus$Transaction Header$5ecfc871-5d82-43f1-9c54-59685e82318d] AS TH LEFT OUTER JOIN

                  dbo.[Cronus$Trans_ Sales Entry$5ecfc871-5d82-43f1-9c54-59685e82318d] AS TSE ON TH.[Store No_] = TSE.[Store No_] AND TH.[POS Terminal No_] = TSE.[POS Terminal No_] AND TH.[Transaction No_] = TSE.[Transaction No_]

GROUP BY TH.[Entry Status], TH.[POS Terminal No_], TH.Date, TH.[Replication Counter], TH.[Net Amount]

HAVING (COUNT(TSE.[Line No_]) < 1) AND (TH.[Entry Status] <> 3) AND (TH.Date > CONVERT(DATETIME, '2025-03-20 00:00:00', 102)) AND (TH.[Net Amount] <> 0)