Microsoft Business Central platform updates
This release rolls out the following Microsoft Business Central platform updates:
- Business Central 2023 Wave 1
- Business Central 2023 Wave 2.
The following features are included in these releases but you can find more information about other features here.
Intercompany posting provides a one-stop-shop setup experience
Intercompany posting has a new Intercompany Setup page that gives you an improved overview of your setup. The new setup page gives you fast access to various setup and task pages. The new setup page also will help you validate your intercompany posting setup to determine whether you've missed any settings across companies.
The intercompany posting has been improved in the following ways:
-
Manage your intercompany setup on one page that includes intercompany partners, an intercompany chart of accounts, and intercompany dimensions.
-
Handle bank transactions on the IC General Journals page.
-
IC general journals are included on the G/L Register page.
-
The experience when working with the intercompany inbox and outbox is smoother, and the Handled Inbox now lets you open documents.
-
Role Center cues have been added added to give an overview.
Read more: Intercompany posting provides a one-stop-shop setup experience
Usability improvements to Financial Reporting pages
Use financial reports to do custom reporting on your general ledger.
Improvements on the Financial Reports page, and related pages, include:
-
The Financial Reports list is extended to show row and column analysis views. In most cases, the two analysis views must be identical for the row and column for the report to work. If you don't use analysis views, you can hide these columns.
-
The Financial Report page has a Show action that lets you show or hide the Options and Dimensions FastTabs, which leaves more space for the report.
-
You can directly access the row and column definitions. You'll be notified that your changes will affect the use of the financial for all users.
-
When you're working on a financial report, you can access default settings directly by using the Edit Defaults action. Editing defaults is the same as opening the report in edit mode, and your changes will affect all users.
Read more here: Usability Improvements to Financial Reporting pages
Use statistical accounts to collect data for financial reports
Businesses can significantly improve their analyses on G/L data by using additional statistical metrics. You can define statistical values and register them in a separate ledger so that you can analyse the data.
When posting G/L transactions, the Quantity field alone doesn't provide much data for statistics and data analysis for the transactions. More data is often needed to increase the relevance of reports.
Statistical accounts improve analyses and progress tracking by letting you add a number-based statistical value to a separate ledger. For example, you might want to add the following information to clarify values on reports:
-
Square meters in your building for tracking rental expenses.
-
Number of full-time employees.
-
Customers served for a given marketing spend.
You register the values for the statistical account in Statistical Accounts Journals and then find the values in the statistical accounts ledger entries page or by going to the ledger entries for an account from the Statistical Accounts list.
Read more here: Use statistical accounts to collect data for financial reports
Add more columns to pages for better insight
This feature adds more fields and columns on several pages, allowing you to better customise your documents.
On select sales and purchase documents, you can now add the Gen. Bus. Posting Group, Gen. Prod. Posting Group, GST Bus. Posting Group, and GST Prod. Posting Group fields can be added by personalising the Lines FastTab.
Read more: Add more columns to pages for better insight
Avoid document number errors with the Renumber Document Numbers action
To avoid or fix errors related to the order of document numbers when you post item journals, you can use the Renumber Document Numbers action before you post.
On the Item Journals page, the Document No. field is editable so that you can specify different document numbers for different journal lines or the same document number for related journal lines.
Read more: Avoid document number errors when you post item journals
Bin Code and Zone Code fields dynamically shown on warehouse documents
When you require bins, your warehouse employees need access to the Bin Code and Zone Code fields on all relevant warehouse documents. Having those fields readily and consistently available makes it easier for warehouse workers to do their jobs and make fewer mistakes.
When you have Bin Mandatory turned on for a location, the following documents will include the Bin Code and Zone Code fields:
-
Warehouse receipt header
-
Warehouse receipt lines
-
Warehouse put-away lines
-
Warehouse shipment header
-
Warehouse shipment lines
-
Warehouse put-away lines
Read more: Bin Code and Zone Code fields are dynamically shown on warehouse documents
Catalog items can now be included in blanket sales orders
It's now easier for businesses to manage catalogue items in your Wiise environment. Catalogue items are items that you don't manage in Wiise until you sell them.
You can now decide how to convert the vendor item numbers to the item numbering structure that you use. The number series is defined in the item template that is assigned to a catalogue item, or use the number series defined in Item No. field on the Inventory Setup page. The number series defined on the item template takes priority.
Read more: Catalog items use standard number series, and can be included in blanket sales orders
Post multiple transfer orders at the same time
You can now select multiple transfer orders to post instead of individually posting one by one. After selecting the transfer orders you would like to post, select the posting drop-down and select which Post Batch option you require. You can also set a schedule for when the orders will be posted.
This can help your business avoid system performance issues that might happen if you post during work hours. You can complete this by setting up the Batch Post Transfer Orders report to automatically post transfer orders at a certain time.
Read more: Post multiple transfer orders at the same time
Use different general ledger accounts for payables, receivables
Sometimes businesses want to post payable and receivable transactions to a different general ledger (G/L) account than the one that is specified on the customer or vendor posting group.
You can enable alterations of default customer or vendor posting groups by choosing Allow Alteration of Posting Group on the Sales and Receivable Setup and Service Mgt. Setup pages for customer posting group changes, and the Purchases and Payables Setup page for vendor posting group changes.
On the Customer Posting Groups or Vendor Posting Groups pages, you can specify the posting groups to allow as substitutes by choosing Substitutions. Substitute posting groups can replace the default customer or vendor posting group specified for a customer or vendor.
After you set this up, you can pick among allowed substitute posting groups and change customer or vendor posting groups when posting sales or purchase documents and journals. Changed, non-default, customer or vendor posting groups are copied to posted documents and journals, and payable or receivable G/L entries are posted to the G/L accounts specified for the substitutes.
You'll also be able to run the Suggest Vendor Payments report using a vendor posting group as a criteria for suggesting payments.
Read more here: Use different general ledger accounts for payables, receivables
Manage user permissions using security groups
Security groups allow for easier management of access control, ensuring that users only have access to the resources they need.
You can use Azure Active Directory security groups to manage the permissions users have to access various parts of Wiise.
A prerequisite for using security groups in Wiise is that you create Azure Active Directory security groups and add members to them either in the Microsoft 365 admin centre or in the Azure Active Directory portal. After you create Azure Active Directory security groups, you can link them to security groups in Wiise on the Security Groups page, by choosing the New action.
Manage permission sets for security groups by choosing Permissions, and then Permission Set by Security Group on the Security Groups page.
Read more here: Manage user permissions using security groups
Reverse a customer and vendor ledger entry with a realised gain or loss entry
Microsoft has improved the features for reversing transactions to save you time when you enter data and when you validate manual postings.
You can use the Reverse transaction action to reverse payments that were applied to entries that originated in foreign currencies and were adjusted using the Exchange Rate Adjustment batch job. The feature works for both purchases and sales.
With this step (actually two because you must always un-apply entries before you can reverse them), you can easily undo mistakes that also involve currency adjustments.
Read more here: Reverse a customer and vendor ledger entry with a realized gain or loss entry
More control over general journal approvals
Some transactions require an inspection by accounting managers and require approvals before being posted. Making sure transactions remain unchanged after approval ensures compliance with your company policies.
When you send a general journal batch or specific general journal lines for approval, Wiise ensures that people can't change them before or after they're approved. Changing the G/L account will show an inline validation error message that offers two actions that can help the accounting manager fix the mistake, or return the general journal batch to the submitter. The accounting manager can document the change they're requesting by choosing Show Comments, or reject the batch by choosing Reject Approval.
Read more here: More control over general journal approvals
Block item variants
Over time, you might have some item variants that you no longer need. Wiise will allow you to block item variants from being chosen on sales or purchase lines, and you can block them from being posted in transactions.
The following table describes the new toggles added to the Item Variant page.
Option |
Description |
Sales Blocked |
You can't choose the item variant on a sales document or in a sales item journal. |
Purchasing Blocked |
You can't choose the item variant on a purchase document, in a purchase item journal, or in purchase planning processes. |
Blocked |
You can't include the item variant in transactions. |
Suggest the next step for sales and production orders
Value to customers: Improve customer satisfaction by delivering on sales and production orders faster. Wiise monitors the inventory status of the items on orders for you and suggests the next step accordingly.
New Feature: Wiise offers a reservation worksheet that can help you reserve and allocate incoming goods in bulk, so you can be sure that quantities are available for your sales and production orders.
Based on the quantities you’ve reserved in inventory, Wiise displays the status on the documents so that you’re quickly aware of the next step. For example, Wiise will indicate that you can ship a sales order or start to work on a job, assembly, or production order. The status also helps reduce the risk of accidental partial shipments or hold-ups due to missing stock for production and assembly orders.
Read more here: Suggest the next step for sales and production orders
More features:
-
Navigate more easily between warehouse and inventory documents
-
Include approvals for intercompany general journals in your workflows
Read more about these features and other features in these major platform upgrades, here and here.
Wiise feature enhancements
Updates to Charts of Accounts
The naming of some Charts of Accounts has been adjusted to be clearer for customers.
Name |
Updated accounts |
Construction & Manufacturing |
3520 |
Construction, FPServices, Manufacturing, Product, ProductServices, Services |
4390 |
Construction, FPServices, Manufacturing, Product, ProductServices, Services |
4080, 4190, 7710 |
GL Account Category Linking
Customers will now be able to create their Account Categories, allowing for more detailed reporting options.
Application areas renamed to KBIZ prefix
It is now easier to locate which application area you are after while developing extensions.
All application areas have been renamed to include KBIZ as the prefix with Wiise added in the caption. This will allow for easier recognition of what is the purpose of each application area.
eCommerce and POS forms have been refactored
Set up eCommerce and POS integrations with Wiise faster with no API calls needed.
The Shopify, Square, Chargebee and Wiisedom wizards now run without API calls. The setup wizards have now been hardcoded into Wiise.
Enter up to 100 characters for more detailed purchase line descriptions
Customers can now add more details to item descriptions in purchase lines when splitting.
Purchase lines can now split with 100 characters in the item description. This allows users to add more detail to lines when completing purchase orders in landed cost.
Bug fixes
Bug name |
Description of fix |
Wiise permission sets update |
Alignment to updated Microsoft permission sets. When new users are assigned, the default permission set will be assigned. |
Variant code errors with Landed Cost |
Variant codes were producing errors when trying to post purchase invoices with item charges. This has now been fixed. |
Locations in landed cost |
When a Warehouse Employee of a location created a Landed Cost Receipt for the location, they could not see it in the list of Landed Cost Receipts. This has now been fixed. |
User-defined field values not copied from the Sales Line to the Service Item |
User-defined fields were not syncing when Sales Lines were converted to Service Lines after posting a Sales Order. This has now been fixed. |
Incorrect information populated when selecting Item Charge Assignment Qty to Handle |
When you click on the 'Suggest Item Charge Assignment' function, the field now automatically populate with item charge distribution. |
Calculated cost displayed when splitting purchase line in landed cost |
When a PO line is split, both lines retain the price that has been entered. |
UDF SyncSalesRecord Procedure |
The SyncSalesRecord procedure has been made global |
Notice about pending deprecated fields
In this release, there are no pages or fields removed or deprecated from the Wiise platform. The below lists are the pages and fields that will be removed in our April release.
Pending updates to fields
Object type |
Field ID |
Field name |
To be removed or deprecated |
Table |
16034611 |
KBIZ Extension |
To be deprecated |
Table |
16034618 |
Kentico Content |
To be deprecated |
Table |
16034637 |
KBIZ Favourite Reports |
Moved to Wiise Base App from Wiise AU |
Table |
16034638 |
KBIZ Favourite Category Setup |
Moved to Wiise Base App from Wiise AU |
Table |
16034643 |
KBIZ Reporting Buffer |
Moved to Wiise Base App from Wiise AU |
Table |
16034644 |
KBIZ Synchronisation Setup |
To be deprecated |
Table |
16034645 |
KBIZ Standard Reports |
Moved to Wiise Base App from Wiise AU |
Table |
16034646 |
KBIZ Custom Reports |
Moved to Wiise Base App from Wiise AU |
Table |
16034671 |
KBIZ Power BI Item |
To be deprecated |
Page |
16034752 |
KBIZ Items API |
To be deprecated |
Page |
16034635 |
KBIZ Extension Management |
To be deprecated |
Page |
16034627 |
KBIZ Wiise Mgt. Assisted Setup |
To be deprecated |
Page |
16034618 |
KBIZ Setup Management |
To be deprecated |
Field |
16034639 |
KBIZ Synch. Setup Object Type |
Moved to Wiise Base App from Wiise AU |
Field |
16034638 |
KBIZ Report Categories |
Moved to Wiise Base App from Wiise AU |
The following fields will be removed from these pages in the next release after this one. The reason for this is Microsoft introduced standard functionality to allow the addition of any field back to a page. These removals will ensure no compatibility problems in future.
Page ID |
Page name |
Field name |
To be removed or deprecated |
16034601 |
Company Information |
ABN |
To be removed |
16034600 |
Customer Ledger Entries |
Sell-to Customer No. |
To be removed |
16034625 |
Vendor List |
ABN |
To be removed |
16034698 |
Vendor Ledger Entries |
Buy-from Vendor No. |
To be removed |
16034601 |
Sales Invoice Subform |
Shipment Date |
To be removed |
16034681 |
Job Ledger Entries |
Description 2 |
To be removed |
16034636 |
Job Journal |
Description 2 |
To be removed |
16034606 |
Apply Customer Entries |
Sell-to Customer No. |
To be removed |
16034697 |
Apply Vendor Entries |
Buy-from Vendor No. |
To be removed |
16034614 |
VAT Posting Setup |
Unrealized VAT Type |
To be removed |
16034614 |
VAT Posting Setup |
Sales VAT Unreal. Account |
To be removed |
16034614 |
VAT Posting Setup |
Purch. VAT Unreal. Account |
To be removed |
16034679 |
Stockkeeping Unit List |
Qty. on Purch. Order |
To be removed |
16034679 |
Stockkeeping Unit List |
Qty. on Sales Order |
To be removed |
16034635 |
General Ledger Setup |
Shortcut Dimension 3, 4, 5, 6, 7, & 8 |
To be removed |
16034418 |
Purchase Order Subform |
Budgeted FA No. |
To be removed |
16034418 |
Purchase Order Subform |
FA Posting Type |
To be removed |
16034418 |
Purchase Order Subform |
Depreciation Book Code |
To be removed |
16034418 |
Purchase Order Subform |
Depr. until FA Posting Date |
To be removed |
16034418 |
Purchase Order Subform |
Depr. Acquisition Cost |
To be removed |
16034418 |
Purchase Order Subform |
Duplicate in Depreciation Book |
To be removed |
16034418 |
Purchase Order Subform |
Use Duplication List |
To be removed |
16034519 |
Job Ledger Entries |
Currency Code |
To be removed |
16034519 |
Job Ledger Entries |
Currency factor |
To be removed |
16034515 |
Sales Quote Subform |
Purchasing Code |
To be removed |
16034594 |
Sales Cr. Memo Subform |
Document No. |
To be removed |
16034594 |
Sales Cr. Memo Subform |
Purchasing Code |
To be removed |
16034594 |
Sales Cr. Memo Subform |
Line No. |
To be removed |
16034425 |
Posted Sales Invoice |
Your Reference |
To be removed |
16034490 |
Purchase Invoices |
Amount including VAT |
To be removed |
16034489 |
Purchase Order List |
Vendor Invoice No. |
To be removed |
16034490 |
Amount Including VAT |
Sales Invoice List |
To be removed |
16034507 |
Posted Whse. Receipt List |
Vendor Shipment No. |
To be removed |
16034455 |
Apply Vendor Entries |
Buy-from Vendor Name |
To be removed |
16034434 |
Posted Purchase Receipts |
Vendor Shipment No. |
To be removed |
16034509 |
Posted Sales Credit Memos |
Your Reference |
To be removed |
16034509 |
Posted Sales Credit Memos |
External Document No. |
To be removed |
16034426 |
Posted Sales Credit Memo |
Your Reference |
To be removed |
16034509 |
Purchasing Code |
Posted Sales Invoice Subform |
To be removed |
16034635 |
General Ledger Setup |
Shortcut Dimension Codes |
To be removed |
16034509 |
Posted Sales Invoice Subform |
Purchasing Code |
To be removed |
If you have any questions, please reach out to our support team at support@wiise.com.