Latest Microsoft Dynamics 365 Blogs | CloudFronts - Page 3

How to use Standard Journal Feature In Business Central?

Introduction. They might be some need to copy the data from one batch to another. In Business central there are multiple ways to do so use copy & paste method or use or configuration packages or Use Standard Journal Feature. Let’s understand about the Standard Journal Feature in detail. But please note Standard Journal Function is not present in other journals apart from General Journal. Steps to achieve the goal: Go to batch where you want to move the data from. There will be action to save as a standard Journal. 5. You would be able to see the Standard Journal you have created. Click on Ok. Please note if you change the amount of the line after copying from the Standard Journal. It will not be reflected the same in Standard Journal. As it is used as Template. Conclusion: Thus we saw how we can use Standard Journal Feature in Business central. Thank you very much for reading my work. Hope you enjoyed the article!

Share Story :

Set Up Intercompany In Business Central- Part 1

Introduction: Intercompany Transaction is useful feature to track all transaction that is happening with the specific intercompany. Many organizations consist of more than one company, and these companies often engage in various intercompany transactions. It’s important for an organization to be able to track these transactions with ease, and Microsoft Dynamics 365 Business Central allows you to do just that. With Dynamics 365 Business Central, your organization can reduce errors, improve productivity, and post transactions across multiple subsidiary companies. Business Central makes it easy for your organization’s companies to engage with one another in the same way they would with external customers and vendors. Steps to achieve the goal: Intercompany setup Globally search intercompany setup Set the name and check the Boolean “Auto send Transactions” the option to auto send transactions to the intercompany partner as soon as it arrives in the intercompany outbox, and not have to manually send/receive the intercompany transaction. 3. Go to setting icon there is option to Company information. 4. Fill in the Intercompany Partner Code, Intercompany Inbox Type. and Intercompany Inbox Details fields. Conclusion: Thus we saw how we can configure Intercompany Setup and create IC customers and Vendors. Thank you very much for reading my work. Hope you enjoyed the article!

Share Story :

Restart Feature in Business central

Introduction: Administrators may need to restart a specific Business Central environment to resume normal operation in some cases as a troubleshooting step. Steps to achieve the goal: Go to your settings and select Admin Center. 4. Then click on Restart Environment Action.

Share Story :

How to Cancel Posted Purchase Credit Memo in Business Central?

Introduction: There might be a need where user wants to cancel the Posted Purchase Credit Memo which was posted by mistakenly. Ideally we cannot cancel the Posted Purchase Credit Memo if it is generated from Posted Credit Memo or Purchase return Order. But if the Posted Purchase Credit Memo is generated from cancel Posted Purchase Invoice . Steps to achieve the goal: If a Posted Purchase Invoice is cancelled then system post the Purchase Credit Memo and cancelled field is set to true in Posted Purchase Invoice. Go to its corresponding Posted Purchase Credit Memo you would be able to cancel action in the Posted Purchase Credit Memo. Cancel action Visibility code added by Microsoft. Conclusion: Thus we saw how we can cancel Posted Purchase Credit Memo in Business central. Thank you very much for reading my work. Hope you enjoyed the article!

Share Story :

How to dynamically show and hide the fields in the Request page of Business Central?

Introduction: Based on certain values dynamically show and hide the fields in the request page of the report. Ideally, we cannot directly use visible property to fields. we can do this by enabling the visibility of fields using groups. Steps to achieve the goal: Create a groups and add the fields which you want to show and hide based on selected data. For example, I have an option filed called Filter By- State, Customer, and Both. If I choose Customer then the Customer field should be visible and if I choose State then the State field should be displayed if I choose both then the Customer and State field should be visible. Create a 2 boolean variable which is of InDataset Create Customer and State field and assign it to groups in report. Then the field value which is been used to show or hide other fields write the below code OnValidate trigger So the above code will do the following if my Filter By field is State then the State field will be visible and if it is Customer then only the Customer field will be visible. If both are selected then both Customer and State fields will be visible. Note: If you want to show or hide the field based on only one value then you don’t need to use the InDataset attribute on the Boolean variable Conclusion: Thus we saw how we can dynamically show and hide the fields based on selected values on the request page in Business Central. Thank you very much for reading my work. Hope you enjoyed the article!

Share Story :

How to use Contact email and Sent email functionality on Vendor, Customer, and its Contacts?

Introduction: Contact email functionality is used in order to send emails to customers, vendors, and their contacts. Steps to achieve the goal: Go to Customers / Vendor and its Contact page there is action called as Contact By Email Then click on Contact  by Email action. You will be able to get the email based on email address specified in Customer/ Vendor page in Email field. You can see the history of mails send to Customer, Vendor and its contacts. There is action called as Sent Emails action present on list page and also in Card page You will be able to see all the mails which is been send to Customer/Vendor/Contacts You can resend the same mail which is been sent to Customer using Resend action present in Send Emails page. You can also edit the existing mail which you have send earlier and send it with updated one Conclusion: Thus we saw how we can use the Contact email and Sent email functionality in Business Central. Thank you very much for reading my work. Hope you enjoyed the article!

Share Story :

How to unapply/reverse payments from vendors in Business Central?

 There are certain scenarios where you have mistakenly applied the payment to the wrong vendor or you need to refund the vendor. There are two methods in order to resolve these issues. Steps to achieve the goal: Method 1: Globally search vendors. Select the vendor in which payment is applied incorrect. Go to Vendor Tab-> Ledger Entries tab. Open the Ledger entries of that vendor and then select the payment which you want to unapply. Go to Process tab and Unapply Entries. A Unapply Vendor Entries page gets open select the payment line and then click on Unapply action and click on OK. Once you click Ok the payment line in vendor ledger entries its remaining amount will not be 0. In order to balance the G/L entries we need to post the refund entry. Go to payment journal-> select the document type Refund Posting date must be same as Payment Posting Date or actual refund date. Assign the Account type as Vendor and assign the Vendor number. Select the Applies to Doc Type as Payment and in Applies to Doc No assign the Payment Document Number. Select the payment method code of return. Select the balance account number appropriately. Post the entry. If you go and check the vendor ledger entries it will be nullified against the refund.                                                                      OR Method 2: Repeat above step number 1,2,3,4,5 and 6 from Method 1 Go to Process tab-> Reverse transaction. Reverse Transaction entries page is open and in which there is action called as Reverse Transaction click on it and entries will be reversed. Conclusion: Thus we saw how we can reverse/unapply the payment mistakenly applied to the wrong vendor in Business Central. Thank you very much for reading my work. Hope you enjoyed the article!

Share Story :

How to work with Drop Shipments in Business Central?

Introduction: Drop shipment is used when the shipping on the items is done from the vendor directly to the customer without the item coming back home to your warehouse and you delivering them. Steps to achieve the goal: To do so first create sales order and then add field drop shipment which is of boolean type using personalize features in business central Add item in sales order line and mark drop shipment if you want that item to be transported directly from vendor to customer Then create purchase order assign vendor to it and then don’t add any purchase lines instead of that go to shipment and payment tab in Ship-to field select customer and then add that customer which you want And go to action tab in purchase order page -> Drop shipment -> Sales Order ->Sales order list window Select the item that you want to get shipped directly and that item will be added in purchase orders line  In order to check the link is established between sales and purchase order. Go to Sales order then in sales order line -> Order -> Drop Shipment -> Purchase orders It will open the corresponding purchase orders which you created And post the Sales order. Conclusion: Thus we saw how we can use Drop shipments in Business Central. Thank you very much for reading my work. Hope you enjoyed the article!

Share Story :

Inventory Adjustments in Business central using Inventory Documents

Introduction: To adjust your inventory there is another ability provided by Business central using Inventory Documents. We can do positive and negative adjustments using Inventory Receipts and Inventory shipments respectively. Steps to achieve the goal: First, we need to set up the number series for Inventory Receipts and Inventory Shipments and Posted Inventory Receipts and Posted Inventory Shipments on Inventory setup. 2. Go to Purchase Receipts and assign the Item in line, fill all the required details. You can reopen and release documents, but it is not required. Once you have filled in the necessary information you can post the Inventory Receipts. The item will be adjusted and you can see it in Item ledger entries. Same we can do it by Inventory Shipments when the item is damaged or needs to be return Fill in the necessary details in Inventory Shipments and post them. You can also print the Inventory Receipts, Inventory Shipments, and Posted Inventory Receipts and Posted Inventory Shipments. But the base application doesn’t include any layouts. So you can create your own report and assign it in Report Selections-Inventory according to usage. Posted Inventory Receipts and Posted Inventory Shipments are nonsearchable in order to print the posted documents you need to visit Item Ledger entries -> Document type=Inventory Receipts -> Find entries-> Item Receipt Header and then you can print the Posted Inventory Receipts. 10. Same for the Posted Inventory Shipments go to Item Ledger entries-> Document Type= Inventory Shipments-> Find entries-> Inventory Shipment Header and then you can print the Posted Inventory Shipments. Conclusion:    Thus we saw how we adjust the Inventory using Inventory documents.    Thank you very much for reading my work. Hope you enjoyed the article!

Share Story :

How to Export Text file from Business Central?

Introduction: Business Central provides you the feature to export the data in Excel in General Ledger entries, Customer Ledger entries, etc. But we can export data in a text file. In this blog, we will see how we can export data in the form of a text file. Steps to achieve the goal: Create a codeunit that will export the data in text. We will be needing Temp Blob Codeunit, Instream, and OutStream to read and write the data in the file. Below is the code which will read and write the data in the text file. You can use dynamic filename also by assigning a field value in the FileName variable; FileName: Rec_ComapanyInformation.FileNameText // FileNameText is the field present in the Company Information Page which will be used as Filename of the exported text file. We will be also using an action that will call the Codeunit function (GenerateTextFile) The output of the above code is To avoid using multiple times Write Text function if there is a lot of data that needs to be pulled from multiple fields. You can use a variable and store all the values in that variable and then assign that variable in the WriteText function. 9. The output of the above code is Conclusion:    Thus we saw how we can export data from Business Central in a text file.    Thank you very much for reading my work. Hope you enjoyed the article!

Share Story :

SEARCH BLOGS:

FOLLOW CLOUDFRONTS BLOG :


Secured By miniOrange