Skip to main content

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

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 ship 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 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.

Comments

Popular posts from this blog

How to Run Reports when report processing takes long to cause Session Time-out.

Introduction:
I've observed that when NAV is used for a very long time, the report which needs heavy processing takes long enough to cause Session Time-out. So, fetching reports becomes tedious by manually querying the table.

Pre-requisites:
Microsoft Dynamics NAV
Microsoft Dynamics Business Central

Solution:
The solution is simple, export the Report as an Excel or PDF depending on the data and send Email to the User as an attachment after the processing is complete.

Code:
1. Create the Report in Excel Using Excel Buffer.


2. Export the Excel Buffer contents to an XLSX file.


3. Email the Exported Files to appropriate User. In this case, I have hard coded the user email to my email.


Output:


Conclusion:
Thus adding a piece of code to send email to the User, can save a lot of hassle. In Business Central, however, it is not possible to modify an existing report. So, you need to export the existing report and merge it in AL using Text-To-Al.

How to use Forms - Flows - Business Central integration to build your masters in Business Central

Problem Statement: Few months ago on a client requirement gathering session for Business Central, I realized that the client is asking for portal where the Vendors / Customers can fill in their basic data so that the data is correct and it saves our time to prepare the master.  The easiest way of doing this was by using Microsoft Forms. In this case, I need it for Vendors, so let's see how we can use Forms, Flow and Business Central and integrate them together.

Pre- Requisites:
Microsoft Flow
Microsoft Office Forms
Microsoft Dynamics Business Central

Solution:
The solution I found was creating Form and using Flow integrate the data from the Form into Business Central
1. Create Form with fields which you want to set on the Vendors



2. Create Flow to take each record inserted in Form and integrate this record to Business Central



Output:
After inserting the data into Forms, automatically MS Flow runs to integrate this record into Business Central.





Conclusion:
Thus using MS forms, you can on…

Managing with Multiple Legal Entity Data in Microsoft Dynamics NAV / Business Central

Problem Statement:
Well, my client is a Trader of Oils & Fatty Acids and has multiple legal entities to perform various sets of operation on the TRUCK-LOAD(a.k.a. Load). One legal entity creates the Load and schedules it, while another manages with the freight requirements. The information is not shared between both the legal entities. Thus, we need to store the data separately.

Pre-requisites:
For Microsoft Dynamics NAV:
- C/Side Development Environment
- Multiple legal entity(Company) setup

For Microsoft Dynamics Business Central:
- Visual Studio Code
- AL Language Extension
- Multiple legal entity(Company) setup

Solution Design:
1. Create two Tables say LoadCompany1 and LoadCompany2 with same fields
2. Set DataPerCompany property is to TRUE on both the tables.
3. In NAV/ BC, there are common tables but the data into the tables are different. Thus, the system has to manage different version for a single table based on an entity that you're currently working on.
In this case, I n…