Congress Proposes PPP Changes

It’s hard to tell exactly what Congress will be able to pass, but it seems that there is bipartisan support for helpful revisions to the Paycheck Protection Program. Since the PPP loans had different disbursement dates, the conservative answer is to plan using the currently available program parameters. Here’s a recent Forbes article on proposals in Congress.

https://www.forbes.com/sites/sarahhansen/2020/05/20/good-news-for-small-businesses-congress-could-extend-ppp-loan-forgiveness-period/#74236ebc2613

E-commerce Site Sales Increase by Double Digits

According to a New York Times article, Amazon sales are up 26% from a year ago in the First Quarter of 2020. Motley Fool’s stock recommendation service doubled down on their Image from shopping site - view cart icon.recommendation of Amazon as a buy. Etsy, a marketplace for small handicraft and other sellers, also reported a 34.7% increase in marketplace revenue. eBay is pretty much even for the 1st Quarter, with a 1% decline in marketplace revenue.

As large as these companies may seem, they have one thing in common: many of the sales made on these platforms are made and fulfilled by small companies. The anecdotal information we have is also encouraging: a $5 million retail distribution company is up 40% this year over last, with most of the increase coming from online. Another small retailer client reported a 49% increase in online sales.

Coronavirus is devastating sectors of the economy, but it may also offer an opportunity. If your business is not currently online, now might be a good time to test the water. Let us know if you would like some suggestions.

 

PPP Loan Forgiveness Application Out — Watch for Gotchas!

Checking calculations on a spreadsheet.You can download the PPP Forgiveness Application form here. Here are a few things we see (this isn’t professional advice, just a few points to think about):

  • The period over which you collect expenses (payroll and allowed expenses) is 8 weeks, starting either from the date you received the funds, or the first day of the following pay period (Alternate Payroll Covered Period). Whichever you choose (and it can make a difference, so you need to do the calculation with both dates), you can include expenses paid or incurred. You’ll have to study the rules for the difference, but you can’t count expenses twice.
  • Since you based the amount of the loan of the average monthly payroll cost times 2.5, many businesses will not get forgiveness of the entire loan amount. Example: suppose you have a payroll of $20,000 per month, all salaries paid on the 15th and end of month ($10,000 per payroll). You request $50,000 in PPP loan (2.5 x $20,000). Now you calcuate 8 weeks of salary. You’ll probably have only 3 actual payroll dates in the 56 day (8 week) period. If you hold one period of salary, you have (apparently) incurred another payroll worth of expense. That means you have payroll expense of $40,000, but you have to come up with $10,000 of rent, mortgage interest, etc. during that 8 weeks.
  • Owing money isn’t really an issue. The interest rate is 1%.
  • Be careful what you spend the money on. If you deposit it into your general operating account and pay bills, you may not be using it for “covered expenses,” but you agreed (and signed) that you would only use it for “covered expenses.”
  • One last item: there’s this nasty little signoff on the last page: “does not exceed eight weeks’ worth of 2019 compensation for any owner-employee or self-employed individual/general partner, capped at $15,385 per individual.” This may further limit the compensation you are allowed to include.

Lastly, all of this is changing. Several organizations including the AICPA and NFIB are pointing out that this math doesn’t work for all businesses. So expect to see some changes.

Fines and Jail Time for Unneeded PPP Loans

In the wake of several large and public companies getting PPP loans, the SBA is talking tough about audits of the “necessary” certification in the PPP application. The documentation necessary for loan forgiveness is also getting a large amount of press among CPAs and other professionals. If you applied for a PPP at the direction of a banker or other professional, and you had cash assets or lines of credit available, you might want to read the article below and have another conversation.

https://www.forbes.com/sites/alangassman/2020/05/04/was-your-ppp-loan-necessaryif-not-there-could-be-horrific-repercussions/#255041a150e1

Dynamics 365 Business Central April 2020 Enhancements

Continuing the schedule of significant releases, Microsoft has announced several new features for Business Central. Some have already been released, and others are scheduled for later in April (or perhaps May). Three significant new features are:Upgrade Upgrading Software Program Icon Symbol On Computer Keybo

  • Extended price calculations. Microsoft continues to increase the number of options for advanced price calculations. For companies that need more complex calculations, see the documentation here. Note the information box on this page with the following key information: “The new price calculation capabilities in 2020 release wave 1 exist in code only, and do not include any user experience. We will provide that in an upcoming release. For now, to use the new capability you must create your own page.” In other words, the pricing calculation features have been developed, but you will need a developer at this point to use them. Contact us at Data Guidance Group if you need assistance with this new feature.
  • Improved Bank Account Reconciliation. The look of this page, and the ability to match statement activity with accounting record activity has been improved in this release.
  • Receive more items than ordered. Several clients have asked about this feature over the years. In practice, sometimes the vendor ships overages (this is quite common in the printing industry, for example). This feature allows businesses to receive more than the quantity ordered in cases where this is more economical, or part of the agreement with the vendor.

We will have more information about the 2020 Wave 1 release in future posts. You can find the full list of enhancements here.

Paycheck Protection Program Details

We have mentioned to some of our clients that the US CARES Act included the Paycheck Protection Program. The Program functions as an SBA loan that is forgivable under certain circumstances. Here is a Forbes article on it:

https://fortune.com/2020/03/31/sba-small-business-loans-paycheck-protection-program-who-qualifies-when-how-to-apply-how-much-pay-back-ppp-coronavirus-stimulus-faq/

And here is the application (as of today) on the Treasury website:

https://home.treasury.gov/system/files/136/Paycheck-Protection-Program-Application-3-30-2020-v3.pdf

It may be just the shot in the arm your small business needs to make it through these turbulent waters.

Business Central: Modifying Reports

One of the things you notice when getting started with Business Central extensions is the sample first App walk-through includes Table Extensions and Page Extensions. It does not include extensions for reports. Likewise, the documentation for reports does not include a report extension object. There’s a good reason for this: report extensions don’t exist, at least as of the October 2019 Wave 2 Release. It has been added to the request list by several.

So what if you need to add something to a report? I’d suggest this approach.

If the data you want to add to the report is standard Business Central data such as the External Document Number, start with this first approach. If the data you want to add is not standard Business Central data, for example if it comes from a table extensions that you created, go directly to the second approach.

First Approach To Report Customization

First, go to Report Layouts in Business Central; select the report you want to update. Also notice whether the default report is Word or RDLC. Now choose Process > Custom Layouts. You will see the screen below.

On the Custom Layouts page, select New, then click the New… menu item. This report is an RDLC layout, so select the RDLC layout as shown.

Copying a Business Central Report built-in layout.

Press OK, and you will see a list view, with report 9 added. On this list view, select the report, then select Layout > Export Layout. This will export the RDLC layout, which you can open with Microsoft Report Builder.

If you do not have this loaded on your system already, you can download it from the Microsoft website.

On the left-hand side of the report, expand the dataset until you can see column names. Look through these column names to see if the data you want to add to the report is present. Examining an RDLC report's dataset in Microsoft Report Builder.Note that as I mentioned above, if you have added data to Business Central, it will not be shown here. If you find the field that you are trying to add, use Microsoft report builder to add it.

Once you have made the modification, go back into Business Central. On the Custom Report Layouts Page, choose Layout > Import. Once you have done this, choose Update Layout from the same layout menu. You should now be able to run the report with the new layout. This is also the method that you would use to change fonts or other styles in a report.

Business Central Report Modification When Easy Does Not Work

If this method does not work because you are trying to add data to report that is not on the dataset list, will have to use the VS Code development environment configured for AL as described here.

If you are using Business Central 14 or Dynamics NAV 2018, you will need to export the report object from the database and convert it to AL. That process is described here.

If you are using Business Central 15 (October 2019, Wave 2), take a look at the on-premise installation ISO. In the Application directory, you will find the code for the BaseApp reports in the BaseApp directory. There are also some other interesting source files in this directory.

To find the report we have been working on, you will need to unzip the BaseApp source code and find the report file which in this case is called TrialBalanceBudget.Report.al. If you copy this into your own AL project (recommended), you will also want the report layout file TrialBalanceBudget.rdlc. You will have to change both the name and the report number, and I recommend that you change the caption (in the AL file) to reflect the fact that the report has been customized.

Applying the New Report In Business Central

You can use this technique of copying and changing the source code for any report in the base application. Then publish these as extensions, and use Page Extensions to place them on any pages where the reports appear. To find these pages, you can open the full AL BaseApp code in the development environment and do a text search. Of course, the most common things will be changing are probably things like Sales Orders and Purchase Orders, and these can simply be changed on the report selection set up for the appropriate module.

Let us know if we can help you with this, and have fun customizing Business Central.

 

 

 

 

Upgrading Microsoft Dynamics Business Central

Microsoft Dynamics NAV has been renamed Microsoft Dynamics Business Central. Along with the name change, there are several significant changes in the software. One of the most significant is the elimination of the C/SIDE development environment and the C/AL language as of the October 2019 Wave 2 Release. These have been replaced by the Modern Development Environment, which uses VSCode, and the AL language.

How Dynamics NAV Customizations Work

Through Microsoft Dynamics NAV 2017, changes were made inside the existing program. Microsoft Dynamics NAV 2018 and following use the concept of extensions. An extension is an add-on to the existing program which adds features without requiring changes to the program code. You might think of the old method as being “inside” the program code, and the new method as being “outside” the program code.

From a practical point of view, this means that once code is converted from the old method to an extension, upgrades become more straightforward. Since they are located in one or more “projects,” they can be tested quickly against a new version. And since they use triggers or events, they are compatible with future releases as long as Microsoft does not make changes to these “hooks.”

As Microsoft makes changes to Business Central, it may still be necessary to update the extension. However, it will not be necessary to extract changes from the program code and then merge them back into new program code.

Migrating Custom Code from Prior Versions

Microsoft has provided a number of tools to assist in migration. These include tools to convert C/AL code to AL code, and tools to create extensions from the changes made in prior versions (called Delta code). The newest version includes tools to migrate a custom database to the new format without having to write code.

In some situations, customization will translate to the new version with very little re-coding. In other cases, the technique used may have been eliminated and more extensive changes may be required. In all cases, some preliminary evaluation of your database will help a developer determine how to proceed.

Options for Upgrades

Until October 2020, existing Business Central / NAV users will have access to the Windows Client. This was called the “role-tailored client”) from 2009 forward. It has been eliminated for releases after the April 2019, but existing users can license it through 10/1/2020. Since this version supports C/SIDE, it is possible to move to it without converting code to AL. But that is just delaying the inevitable.

If you want to maintain the Windows Client look and feel, however, it may be a good option to move to the April 2019 release (14) while converting the code and database to AL.

The basic evaluation process extracts your customization to DELTA files, then converts the DELTA files to AL code and uses VSCode to evaluate the result. To do this, convert your base, unmodified current version and your modified version to 2018 or 2019 April release. This isn’t a full conversion, it just involves opening the databases with the new C/SIDE development tool.

Once they are converted, follow the instructions here to produce the AL code. A few technical notes: (1) the objects need to compile in the new version in order to export correctly, (2) You need the -ExportToNewSyntax in order to use the txt2al tool that produces the AL files, and (3) if you did not customize the object, it does not need to compile.

Things To Watch For

The Txt2Al tool does a fair job in that it will save you time. However, particularly when converting older reports, you will get files with errors. Watch particularly for the “Ambiguous reference,” error. Many of these seem to be produced by the fact that the Txt2Al tool sometimes does not surround fields with double quotes.

For example, the field Document No., needs to be written “Document No.” The conversion tool often omits this punctuation, which gives errors in VSCode: not just in the places the quotes are needed, but in other code that is not in error. Start at the top of the converted file and correct obvious errors; skip items that do not seem to be errors until you reach the bottom. Then begin another pass with the same heuristic. Doing this–particularly with reports–often caused errors that were not really errors to disappear. That is particularly the case with the “Ambiguous reference” error.

Good coding, and let me know how it comes out for you!

 

 

Dynamics 365 Business Central – Full Menu

One of the things that seemed to be missing from previous versions of Business Central was a full menu. If you’re looking for a report, as an example, it might be a bit hard to find. Now there’s a way to get back to a menu similar to what we had previously. First of all, from the home screen, click the three bar menu (circled below).

 

Once you click this, the screen below opens. If you click the circled explore all, you’ll see the last screen on the page. The areas on this screen expand and contract allowing you to find features that you might otherwise miss. If you don’t know what something is called this may be an easy way to find it in the system


Microsoft Azure SQL backup update

Photo No More. Stop Gesture. Man with raised opening hand making No more gesture.I mentioned a couple of posts ago that we were having trouble backing up a database from SQL on Azure to a local machine.

One of the problems was that we didn’t have access to the Azure portal, so we asked the CSP with access to do the backup and send us the BACPAC file. We assume that backing up to Azure storage would permit the backup, and get around the issue we were having with timeout.

As it turns out, even this doesn’t work. The backup still times out. Microsoft (and the other CSP) are still working on it.

Misery loves company! At least I’m glad someone else had the trouble.

Next time you think about creating a database with 50,000+ tables on SQL Azure, think again.