D365 Business Central Archives - Page 19 of 34 - - Page 19

Category Archives: D365 Business Central

Inventory Posting Group and Inventory Posting Setup in Dynamics 365 Business Central

Inventory Posting Group: Use to specify the type of Inventory or group the item. Inventory Posting setup: Use to combine Inventory Posting group with location codes. Each combination is then mapped to the inventory accounts, WIP account, and other variance accounts relating to inventory in the chart of accounts. Steps: Set up Inventory Posting Group In the search option, enter the Inventory Posting Group and then choose the related link. Select New. In the Code field, type a unique identifier. In the Description field, type description of Inventory Posting Group.   Steps: Set up Inventory Posting Setup In the search option, enter Inventory Posting Setup and then choose the related link. Select New to insert a new line. In Location Code Field, select the relevant location to combine with the inventory posting group. Select the relevant inventory posting group in the Inventory Posting Group Code field. In each relevant account field, enter the G/L accounts that will be used to post transactions to: Inventory Account: Specifies the number of the G/L account that item transactions with this combination of Location and Inventory Posting group posted to. Inventory Account (Interim): Specifies the number of the G/L account to which to post the transactions with the expected cost for items in this combination. WIP Account: Specifies the general ledger account number to which to post transactions for items in WIP inventory in this combination. Material Variance Account: Specifies the number of general ledger account to which Material variance transactions for items in this combination. Capacity Variance Account: Specifies the number of general ledger account to which to post capacity variance transactions for items in this combination. Subcontracted Variance Account: Specifies the number of general ledger account to which to post subcontracted variance transactions for items in this combination. Overhead Variance Account: Specifies the number of general ledger account to which to post capacity overhead variance transactions for items in this combination. Overhead Variance Account: Specifies the number of general ledger account to which to post Manufacturing overhead variance transactions for items in this combination.   Steps: Assign Inventory Posting group to Item In the search option, enter Items and then choose the related link. Open the Item card Expand the Cost & Posting FastTab, in the Inventory Posting Group field, enter the appropriate posting group. Conclusion: Inventory posting group and setup use to posts entry to the G/L account specified for the combination of inventory posting group and location code linked to the item line entry.

Share Story :

Business Central Wave 2 Features – Section 3

1. Saving and personalizing list views. Suppose we want to switch between pages and we want to add filters, so to achieve this we have to add filters every time we come back to that page, this feature was not available in the previous version of Business Central but now it has been added by the developers. We can save a combination of filters as our view and access it again and again.   2. Personalize actions and navigation on your Home page With the Business Central Wave 2 Release users can easily add their desired pages to their Role centers, making these pages easily accessible to the user. 3. Design for Extensibility. Users can adjust actions and action groups on their Role Center. Adjust the navigation menu items and grouping on a Role Center. Customize user profiles by designing page changes that will apply only to a specific profile in your extension.

Share Story :

Business Central Wave 2 Features – Section 2

1. Lock-free number series (Allow gaps in Number Series). Users can choose to mark number series to allow gaps in the series. These number series will be non-blocking, which will boost performance. Add notes and links to data Users can quickly add a note to the data they are currently viewing on the Business Central, these notes can be used if a user needs to add some note to the specific page. 3. Customize a user profile without writing code. (New fields have been added, Caption, Description, Use as Default Profile, Promoted). Users need not have to write code to change a user profile, instead, they can make changes to a user profile from Profile only.

Share Story :

General Journal Views in Microsoft Dynamics Business Central

Introduction: Recently In Business Central, I have observed the format for General Journals where the unnecessary fields are hidden in order to avoid confusion. Pre-requisites: Microsoft Dynamics Business Central Demonstration: There are 2 Views of General Journal in Business Central. 1. Limited field view: Limited Column View 2. All field view: Full Column View 3. Switching to Limited Field View: Switching to Limited Field View 4. Switching to All Field View: Conclusion: Thus, this limited view from all field view is helpful to avoid confusion during data entering but it has drawback. If you are entering Account No. as G/L Account and want to switch the Customer as Account Type, there is no way of doing it from Limited field view.This is because in General Journal functionality, Business Central automatically selects the Account Type from previous entry causing this drawback.

Share Story :

Setup Dockers

Docker is an independent container platform that enables organizations to seamlessly build, share and run any application, anywhere from hybrid cloud to the edge. Docker provides the ability to package and run an application in a loosely isolated environment called a container. The following steps shall help you to get Docker in place on your system. Steps: Visit the link- https://www.docker.com/products/docker-desktop, which will direct you to the Dockers website, after opening the link choose the “Download Desktop for Mac and Windows”. Now Create an Account for Docker or Login with credentials if you have an Account. After that go with “Download Docker desktop for Windows” and your download shall start soon. Install the downloaded “.exe” file and you are good to go with Dockers. Now look for “Docker Desktop is running”on your TaskBar with  Docker Icon. Open Powershell, and execute the command “docker info” and you shall see the docker information as below: Hope this helps!

Share Story :

Business Central Wave 2 Features – Section 1

1.Power-full filtering of Reports When running reports on Business Central, Users see a request page where they can add filters, this addition of filters was achieved by customization and coding. With the new Business Central Wave 2 Release users do not have to worry about customizing from the back end. Business Central Wave 2 comes up with hassle-free filtering of reports which is achieved before the report is run. Thus making it more efficient to use. The snapshot shown below is an example of previous report filters. This is how the business central wave has added filters. You just have to click the filters button and you can have multiple combinations of simple and complex filters. 2. Resize columns with fewer clicks. Columns play a major role in Business Central because the data to be displayed is dependent on how much visible that particular column is, In the earlier version of business central it was not possible to increase the width of a column to be displayed. With the new Business Central Wave 2 release, the developers have made it convenient for the users to increase the size of columns just with a single click and mouse drag.   Below is the snapshot of the previous Business Central. This picture shows how the column “Contact” has been increased. Hope this helps!

Share Story :

Visual Studio Tip

Finance and operations departments in a company are quite crucial as they help the business to flourish and reach heights. Companies, therefore, should do everything from their end to better the processes in these departments. Using an ERP solution is one of the wisest and best ways to do this job. Dynamics 365 for finance and operations is one of the best enterprise resource planning solutions that you can find in the market. It is one of the best products that Microsoft has created.  They offer some of the best features which you cannot find any other ERP software that you find in the market. But, if you want to enjoy the benefits that come from using this system, you should first learn how to use this software. Here is one more tip that will help you become efficient.  Many of us use Visual Studio for development whether we are developing it Using physical machines or virtual machines. While making any changes to existing code or to save your changes we must have to run VS with administration permission. So every time you right-click on file shortcut and select Run as administrator. So I came up with an inbuilt option in Microsoft Windows operating system after which you don’t have to repeat the steps which are mentioned above. Steps are as follows:- Right-click on your Visual Studio shortcut and select properties. Select the ” Advanced”  option. Tick on Check-Box for Run as Administrator and click on ok button. Click on the “Apply” button. And Then click on the “Ok” button. Now you are all set, Every time you open Visual Studio it will open with administrator permissions.

Share Story :

How to Undo and then Redo Quantity Posting on a Posted Return Shipments in Microsoft Dynamics 365 Business Central

There are so many different ERP systems in the world. ERP simply means an enterprise resource planning system. While there is stiff competition, Microsoft Dynamics NAV integration is one of the best ERP systems that companies love using. It is because of numerous features that it offers to its clients. One of the reasons why people like it is because this ERP system allows you to sync their ERP with all other systems out there with ease. There is no need to touch any buttons to make this happen. The other name for Microsoft Dynamics NAV is Microsoft Dynamics 365 Business Central. Now, this is one of the many products that are part of the vast Microsoft Dynamics family. Introduction: In this blog, I will demonstrate how to Undo and then Redo Quantity Posting on a Posted Return Shipments in Microsoft Dynamics NAV / Business Central. This functionality is useful if user ships the wrong quantity or selected the wrong item for Purchase Return Order. Pre-requisites: Microsoft Dynamics NAV Microsoft Dynamics Business Central Demonstration: NOTE: You cannot undo a posting if purchase credit memo is posted. 1. In the search option, enter Posted Purchase Return Shipment and then choose the related link. 2. Open the Posted Purchase Return Shipment that you want to undo. 3. Select the Posted Purchase Return Shipment Lines that you want to undo.   4. In Lines, click on Function button and choose to Undo return shipment action. 5. Choose Yes in pop up box. 6. A corrective line inserted under the selected Return Shipment Line. 7. The Return Quantity Shipped field on the related Purchase Order will be set blank once undo receipts. 8. Open the return order in question, and then choose the Reopen action. 9. Correct the entry in the Quantity field and Post the Purchase Return Order again. Conclusion: The functionality helps the user to reverse the Purchase return shipment so the user can Post Purchase Return Order with correction.

Share Story :

How to Undo a Quantity Posting on a Posted Purchase Receipt in Microsoft Dynamics 365 Business Central

Introduction: In this blog, I will demonstrate how to undo a Quantity Posting on a Posted Purchase Receipt in Microsoft Dynamics NAV / Business Central. This functionality is useful if the user receives the wrong quantity or selected the wrong item for the Purchase order. Pre-requisites: Microsoft Dynamics NAV Microsoft Dynamics Business Central Demonstration: NOTE: You cannot undo a posting if the purchase invoice is posted. 1.    In the search option, enter Posted Purchase Receipts and then choose the related link. 2.    Open the Posted Purchase Receipts that you want to undo. 3.    Select the Posted Purchase Receipt Lines that you want to undo. 4.    In Lines, click on Function button and choose Undo receipt action. 5.    Choose Yes in pop up box. 6.    A corrective line inserted under the selected receipt line. 7.  The Quantity Received field on the related Purchase Order will be set blank once you undo the receipts. Conclusion: The functionality helps the user to reverse the Purchase receipts so the user can post purchase order with correction.

Share Story :

Applying Default / Mandatory Dimension in NAV / Business Central

Introduction: In this blog, I aim to provide how to set Mandatory Dimensions on Items, Customers, Vendors, and G/L Accounts and how to optimize this process using Configuration package. Pre-requisites: Microsoft Dynamics NAV. Microsoft Dynamics Business Central. Understanding of Dimensions in NAV / BC Theory: Automatic Dimensions can be added for the G/L Accounts, Customers, Vendor, and Items. The Value Posting can be selected as per the below Table. Value Posting Explanation Blank No posting restriction.Transactions can be posted with any dimension value or without a dimension value. Code Mandatory Any dimension value for the given dimension can be added. If dimension value is blank then NAV / BC will throw an error Same Code Only a single dimension value defined in Default Dimension can be used while posting. No Code Dimensions must not be specified on the transactions.   This also implies that you can add the Default Dimension, No-Dimension, Mandatory Dimension and Manual Dimension only when needed using the Default Dimension functionality.   Solution: 1. Apply Mandatory Dimension on Items: Go to Items > Select the Item and Open Card Page > Click on Dimensions Action. In the Default Dimension Table, Table No. for Items Table is 27 which is automatically selected. The value posting is also selected in the table based upon what option is selected. 2. Apply Mandatory Dimension on Customers: Go to Customers > Select Customer and Open Card Page > Click on Dimensions Action In the Default Dimension Table, Table No. for Customer Table is 18 which is automatically selected. The value posting is also selected in the table based upon what option is selected. 3. Apply Mandatory Dimension on Vendors: Go to Vendors > Select Vendor and Open Card Page > Click on Dimensions Action In the Default Dimension Table, Table No. for Vendor Table is 23 which is automatically selected. The value posting is also selected in the table based upon what option is selected. 4. Apply Mandatory Dimension on G/L Accounts: Goto Chart of Accounts > Select the G/L Account and Open the Card Page > Click on  Dimensions Action. In the Default Dimension Table, Table No. for Chart of Accounts Table is 15 which is automatically selected. The value posting is also selected in the table based upon what option is selected. NOTE: You can give multiple Mandatory Dimensions as well 5. Using Configuration Package: In Configuration Package, add the Table 352 Default Dimension and Export the Excel. You can add the dimensions referring to the points 1-4 and insert you data in the Excel. Import the Excel Package and Apply Data. Conclusion: Applying manually for each Master Record can be tedious and time consuming. In this blog I tried to add few sample records so that we can take help of this samples to create our conditions and insert data into Excel and apply it on all the Master Records.

Share Story :

SEARCH BLOGS:

FOLLOW CLOUDFRONTS BLOG :


Secured By miniOrange