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)

Power BI - Change data source with new semantic model

•  Record any filters on the data source
• Record any relationships
• Share the original semantic model with the person building the new report
• Download new report
• Get Data>Power BI Semantic Models>Select Tables
• Re-enter relationships
• Fix any graphics
• Publish

LS Retail - Replication Counters - sometimes transactions get skipped

• This can happen if the replication counter values on the records get changed in a way that causes a gap between numbers. Usually happens when a machine is repurposed, and old transactions are not fully purged, causing replication counter numbers to do unpredictable things
• Check the replication counter field in the transaction header by day by terminal and compare to the pos db to confirm if the numbers make sense

  select * FROM [GFH].[dbo].[Cronus$Scheduler Replication Counter$5ecfc871-5d82-43f1-9c54-59685e82318d]

  where [Scheduler Job ID] in ('TRANSKJB','TRANSMSQ')

SELECT [POS Terminal No_], MIN([Replication Counter]) AS FirstReplCounter, MAX([Replication Counter]) AS LastReplCounter, [Store No_]

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

GROUP BY [POS Terminal No_], [Store No_]

SELECT TOP (1000) [POS Terminal No_], MIN([Replication Counter]) AS FirstReplCounter, MAX([Replication Counter]) AS LastReplCounter, [Store No_]

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

GROUP BY [POS Terminal No_], [Store No_]

LSC Member Points

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

Move window if it's stuck off the screen

• Open task manager
• find task
• expand arrow
• right click>maximize window