Sunday, January 31, 2021

VSCode does not debug properly

 On BC Instance, set the web client address in the Client Services>Web Client Base URL


It should look like

http://demomachine01:8080/CRONUS/?company=CRONUS&dc=0

Wednesday, January 27, 2021

Business Central - Install LSC17 and localizations

  • Install BC17 Core
  • Install Data Director
  • Install LS Central Service Components 17
  • Restart Instance 
  • Install LS Retail LS Central 17.app
OPTIONAL
  • Request localization extensions from ls retail
  • Install LS Retail Ls Central NA Languages.app
  • Install LS Retail LLS Central NA.app

Friday, January 22, 2021

NAV BC - Pick Ticket Print Option when generating from "Create Pick" uses hardcoded report instead of defined picking report

 R7318


Line 34 is hardcoded to Pick List Report. Change this to your custom Report.


Add this global

Name DataType Subtype Length

WhseActPrint Codeunit Warehouse Document-Print

Change this code 

IF NOT IsHandled THEN

      REPORT.RUN(REPORT::"Picking List",FALSE,FALSE,WhseActivHeader);

  END;


To this code

IF NOT IsHandled THEN

      //REPORT.RUN(REPORT::"Picking List",FALSE,FALSE,WhseActivHeader); MOD

      WhseActPrint.PrintPickHeader(WhseActivHeader);     //MOD  

  END;

Thursday, January 21, 2021

NAV BC Inventory Journal Post + Print prints blank Warehouse Register after posting

  • C242 Rem out the lines shown

 IF ItemReg.GET(ItemJnlPostBatch.GetItemRegNo) THEN BEGIN
        ItemReg.SETRECFILTER;
          REPORT.RUN(ItemJnlTemplate."Posting Report ID",FALSE,FALSE,ItemReg);
          END;
            {
              IF WhseReg.GET(ItemJnlPostBatch.GetWhseRegNo) THEN BEGIN
                  WhseReg.SETRECFILTER;
                    REPORT.RUN(ItemJnlTemplate."Whse. Register Report ID",FALSE,FALSE,WhseReg);
                    END;
                      }
                     

                    LS NAV - Does Floating Cashier require you to do a z-report and end of day at one terminal before moving to a new terminal?

                     No

                    BC NAV - Demand Forecasting and Production

                    • Demand Forecast Overview - Define demand forecast for a period
                      • This is used in addition to demand from sales orders and production orders 
                    • Requisition Worksheet or Planning Worksheet

                    Tuesday, January 19, 2021

                    NAV / BC Limitations of Variants - LS Retail

                     

                    What are the limitations of Variants?


                    NAV Variants
                    • Variants will work for Purchasing and Inventory
                    • However, they will not work for Stock Counts, Retail Transfers, or Bin Movements.
                    • You can enable the Variant columns in Transfers in the W1 under Inventory Management Setup
                    • NA does not have this option.
                    LS NAV Variant Framework
                    • LS Central supports Variants for transfers, but not bins

                    Wednesday, January 6, 2021

                    Business Central View - GL Distributions - Find matching balacing accounts

                     SELECT DISTINCT GLE2.[G_L Account No_], GLE.[G_L Account No_] AS BalAccount, GLE.[Source Code]

                    FROM            dbo.[CRONUS$G_L Entry] AS GLE INNER JOIN

                                                 (SELECT DISTINCT [G_L Account No_], [Document No_]

                                                   FROM            dbo.[CRONUS$G_L Entry]) AS GLE2 ON GLE.[Document No_] = GLE2.[Document No_]

                    GROUP BY GLE2.[G_L Account No_], GLE.[G_L Account No_], GLE.[Source Code]

                    HAVING        (GLE2.[G_L Account No_] IN (N'5420', N'5410')) AND (NOT (GLE.[Source Code] IN (N'REVERSAL', N'PAYMENTJNL', N'CASHRECJNL')))