How do I Find the Table and Field ID in Business Central?
Business Central Tables and Fields Information
In Dynamics 365 Business Central (BC), while you are on a window or a section of a window, you can display table and field information related to that window by selecting Inspect pages and data. There are a few ways to find the table and fields:
- Select “?”
- Select “Help & Support”
- Select “Inspect Pages and data”
Page Inspection will display table and field data related to the page (and section) that you are displaying & have selected.
Also, table information can be found in Business Central by searching for:
- Configuration Worksheet
- Table Information can be filtered and exported to Excel.
Jet Reports Browser
In Jet Reports, the Browser can be used to view table and field information. Select “Show Details” to see more information about the selected tables and fields. As you can see in the following, the Jet Browser Details show the same information as the Business Central Page Inspection, above.
In the table details, view the table number, drill down to view table data and view Keys.
View field details and sample values.
Additional Jet Browser Features include the Drilldown to view table data from Business Central. Also, use the ability to drag and drop selected fields from the Browser into your report. Use Rows and Records Drag & Drop Output to define the dropped field formulae.
For more information about Jet Reports and to see if it is the right fit for your company, contact Support@BondConsultingServices.com or Schedule a Free Consultation with one of our experts here.
How can I Defer Revenue and Expenses in Business Central?
Business Central has built in capability to track deferred revenues and expenses, eliminating the need to evaluate deferrals by hand and automatically spreading the expenses/revenues across multiple periods. This is especially useful if you have an annual fee for something that you don’t want to recognize at the time you pay for the entire year. Business Central can simply spread the expense out over a specified time period by using the correct Deferral Code.
First select the account for the expense/revenue.
Next, setup or select the appropriate Deferral Code according to your deferral needs (equal per period, straight-line deferral, etc.) You can also specify the number of periods you would like to defer the amount and when you would like the deferral to begin.
Now once you assign the deferral template code to the line, you can review the breakdown of the deferral through different periods to confirm the deferral is as needed.
For any questions on this process or concerning any Dynamics 365 product, please reach out at Support@BondConsultingServices.com or schedule a free consultation with one of our experts here.
How Can I Track Headcount Using Statistical Accounts?
Statistical or Unit accounts can be included in the Chart of Accounts to record and report statistical information such as Headcount. Such accounts should be assigned a numbering convention outside of the normal G/L Account numbering to segregate the accounts and allow for filtering and sorting.
Dimension requirements and defaults can be assigned like any other account.
Setup:
- Accounts beginning with an alpha character will sort to the bottom of the Chart of Accounts and can easily be filtered in or out for reporting.
- Accounts are increased or decreased through journal entries.
- Balance Sheet vs Income Statement type: Create separate statistical account offsets for each account type used. Use an offset account with the same Income/Balance type coding as the statistical account. All balance sheet and income statement accounts, with associated offsets, should net to zero by type.
- Balance Sheet type: Continues across years and will not close to Retained Earnings year end Close Income Statement process.
- Income Statement type: Closes to Retained Earnings during the year end Close Income Statement process.
Budget
Statistical Accounts can be included on budgets or assigned their own budget.
Transactions
Transactions can be entered though General Journals (GJ) with the appropriate offset account as a Bal Account.
Optionally, can create a Document No. Series to assign to statistical general journal transactions.
- To reduce errors, advisable to create separate General Journal batches for Balance Sheet and Income Statement Bal. Account Nos.
Statistical account transactions can, also, be added to Purchase Orders, Purchase Invoices, and Sales Invoices, etc. if tracking a measure directly related to the document – like quantities. However, the process must include lines for both the statistical account and the offsetting reversal to avoid changing the value of the document. Without intervention, these line items will appear on your outward facing documents (customer invoices.)
Year End Close Income Statement
Income Statement type accounts will close with the Close Income Statement process. The statistical accounts, with the offsets, should net to zero.
Results
Balance Sheet accounts continue to accumulate across years and Income Statement accounts clear through the Year End process.
For any questions about Microsoft Dynamics products please reach out to us at Support@BondConsultingServices.com or Schedule a Free Consultation here!
How Can I Undo a Drop Shipment in Business Central
When a product is sent back by a customer because of some defect or issue with the product, it needs to be documented appropriately. In Business Central the normal way to undo these shipments comes standard, however there is no standard for Undoing Drop Shipments. Drop Shipments are timely shipments scheduled to ship the product directly to the end customer after the purchase order is completed. If your business uses the Drop Shipment method then it is necessary to understand how to Undo a Drop Shipped Product if some defect is present in the product.
When you complete a Drop Shipment in Business Central and post the sales shipment, the Purchase Receipts are posted automatically in the backend. When the shipped part needs to be Undone, the default Undo shipment method will not work for Drop Shipped parts because the Sales shipment is linked to Purchase Order and Purchase Receipt is linked to a Sales Order. Because of this, BC will not allow you to UNDO Shipment. Follow these steps to remedy the problem.
This comprehensive walkthrough begins from the creation of the Drop Ship Sales Order. Skip to Step 6 to begin the Undo process for Drop Shipped Products.
Step 1: Drop Ship Sales Order is Created.
Step 2: Search for "Requisition Worksheet."
Step 3: Select Drop Shipment > Get Sales Orders...
Select "Ok" to get all the Sales Orders that need to be Drop Shipped.
Now you can see the suggested lines in Purchase Requisition for the Order that need to be Drop Shipped.
Step 4: Select Carry Out Action Message to create the Purchase Order.
Now you can view the created purchase order.
Step 5: Post the Sales Shipment.
Here is the Shipment that was just posted.
At the same time you can see that the Purchase Receipt is posted automatically.
Step 6: Undoing the Drop Shipment
Search for Sales Return Order in the main search bar.
Select the appropriate link to open the desired Sales Return Order. Select the Customer.
Select Functions > Copy Document.
Make sure that the Document Type = Posted Shipment and Document No. = Undo.
Post the Sales Return Order.
You only need to select Receive and then click Ok to post the Sales Return Receipt.
You can see an Item Ledger Entry where the remaining quantity is 1.
Step 7: Search for Purchase Return Order and select the corresponding order.
Select Vendor.
Select Functions > Copy Document.
Select "Document Type = Posted Receipt" and select the appropriate document to complete the desired return.
Select "Appl. to Item Entry."
Select "Ship" to post the Purchase Return Order
Step 8: Verify the return by selecting the Item Ledger entry and checking that the remaining quantity is nullified.
For additional guidance on this process or any of your Dynamics needs, you can always reach out to us through Support@BondConsultingServices.com.
How-To Update Dynamics 365 Data in Bulk Using Excel
Here is an easy way to make bulk updates and corrections to any entity or record in Dynamics 365 Sales without having to export massive files to Excel. Using this trick, you will be able to edit records using Excel Online which saves you time and storage by eliminating the need to download and reupload large worksheets and workbooks.
We have set up an example case for the “My Active Accounts” view.
- Search the view for which you would like to make a bulk update
- Within the Export to Excel drop-down select “Open in Excel Online”
- Now you can update the information as needed with your changes saved online in real time. This example below depicts the “My Active Accounts” view with the capability to edit the data in each record or cell.
Be careful when entering data. Some fields have text character limit or other specific requirements which are typically outlined when hovering over a cell – make sure the data inputted matches the data requirement of the cell.
- Make sure to Save the changes. Tracking the Progress will trace those changes back into Dynamics 365 Sales automatically without uploading any large Excel files.
Helpful Tools for the A/P Check Run in Business Central
Upon trying to conduct an A/P check run in Business Central’s Payment Journal, a mistake within just one vendor’s data prevents processing the check run.
Sure, you could cut checks for one vendor at a time at that point as an alternative to conducting a check run for multiple vendors. But, doing so prevents you from taking advantage of the full breadth of Microsoft Dynamics technology.
Rather than cutting checks one vendor at a time, you can use two very useful tools. These tools will help you determine which documents in the batch require fixing.
As shown in the screenshot below, navigating to Actions > Posting produces two reports – the Vendor Pre-Payment Journal and the Test Report.
Examples of both reports are below:
The Test Report alerts you to errors that will prevent you from processing the batch, such as whether the “Check Printed” box is checked.
The Vendor Pre-Payment Journal displays data that you would see in the Apply Vendor Entries window, such as Payment Discounts and Payment Tolerances. This report lets you know whether you need to access Apply Vendor Entries to correct discount amounts or dates.
(The term “Pre-Payment” is a misnomer, as you may utilize the Vendor Pre-Payment Journal even if no prepayment amounts are involved in the check run.)
For those of you who are familiar with Microsoft Dynamics GP, you’ll notice that these two reports in essence are the equivalent of the Batch Edit List used in correcting mistakes prior to processing a batch of transactions.
If you have any questions about these tools or other Microsoft Dynamics products, please reach out to us at Support@BondConsultingServices.com or fill out a Free Consultation form.
How-To Change the Default Printer in Dynamics GP
A common inquiry we receive from our clients is how to change the default printer in Dynamics Great Plains (GP). In order to change the default printer, you simply need to go to Dynamics GP, click on the main GP drop-down menu and select Print Setup.
Within the Print Setup window, you may go ahead and select a different printer from the drop-down options and then click Ok.
After clicking Ok, the next time you print any report, it will default to the printer selected in that Print Setup Window.
If the printer selected is Adobe PDF and you encounter the below error. The error occurs because some characters in the original file are unreadable when converted.
Follow these steps to configure the system appropriately.
- Open a PDF in Acrobat
- Navigate to File > Print
- Select Adobe PDF from the list of Printers and click Properties
- Uncheck the option called “Rely on system fonts only; do not use document fonts”
- Reprint the errored file.
If you encounter further errors or need clarification on any of these steps, please reach out to Support@BondConsultingServices.com
How-To Fix Inventory Values Using an Item Revaluation Journal
A recent inquiry was brought to our attention around duplicate cost of goods sold and inventory account postings for the same amount in Dynamics 365 Business Central.
Please follow the instructions below to guide you through resolving this issue.
BACKGROUND: In a test company a sales invoice was posted. The image below shows the resulting General Ledger Entries.
5000 is Cost of Goods Sold, while 1200 is Inventory. FIFO is the inventory valuation method.
It would appear that posting both increased and decreased Cost of Goods Sold and Inventory and for the same amount, as if the transaction shows a "wash" for these two accounts.
Why?
RESOLUTION: Through review of the Item Ledger Entries, we determined that the reversal of cost was due to an Item Journal Entry posted with the Purchase Entry Type for 100 units mistakenly with a $0.00 Unit Cost. The Preview Posting showed a default Cost of Goods Sold based on the Item Unit Cost, when the Sales Order line was entered. But, with the Automatic Cost Adjustment setting of Always in Inventory Setup, the processing immediately adjusted the cost to zero.
To correct the wrongly posted $0.00 value, we utilized the Item Revaluation Journal and set the “Applies to Entry No.” to revalue the inventory valuation layer for the full 100 PCS at $85.00 per 100 units. This adjusted the cost of the sold inventory to an $85.00 per unit cost and eliminated the issue caused when the per unit cost was originally and mistakenly entered for $0.00 instead of $85.00. 
This shows the entries to Cost of Goods Sold and Inventory for the Item Revaluation:
The General Ledger Entries in the following screenshot show how the correct Unit Cost of $85.00 is being retroactively updated -- in all previously posted and affected sales invoices. In other words, the inventory valuation cost is being corrected automatically:
The following Posting Preview window shows that Cost of Goods Sold and Inventory accounts are being hit twice, however, the amounts are different. So, Item Revaluation corrected the inventory valuation layer and ensured that posting to Cost of Goods Sold and Inventory does not result in a “wash”.
For any further inquiries, please contact us at support@lime-falcon-860444.hostingersite.com
How-To Close a Year in Dynamics GP
In order to ensure you have followed the correct closing procedures please read this article from Microsoft with the steps of each procedure, detailed information on each step, and also some frequently asked questions about Year End Closing Procedures.
KB -Year-end closing procedures for General Ledger in Microsoft Dynamics GP
At a glance, this checklist will help you keep on track your closing progress and each step is a link to a more detailed description directly from Microsoft.
- Complete the posting procedures and the closing procedures for other modules.
Note: This step is only required if General Ledger is integrated with other modules. - Post the final adjusting entries in General Ledger.
- Print an account list to verify the posting type of each account.
- Close the last period of the fiscal year.
Note: This step is optional. - Optional: Perform file maintenance on the Financial series group of modules.
- Verify the settings in the General Ledger Setup window.
- Make a backup.
- Print a final Detailed Trial Balance report.
- Print the year-end financial statements.
- Set up a new fiscal year.
- Close the fiscal year.
- Close all the fiscal periods for all the series.
Note: This step is optional. - Adjust the budget figures for the new year, and then print the financial statements.
- Make a backup.
After completion of this checklist you should be all set for the new fiscal year.
If you have any further questions or concerns, please reach out at Support@BondConsultingServices.com
How-To Show Multiple Budgets in the Account Schedule Reports
Customizing your financial reports allows for increased understanding of your business processes and can provide actionable insights necessary for growth. Business Central has numerous options useful for managing the displayed columns, rows, and values for your most sensitive reports.
When managing account schedules on the financial reports, the system used to only allow one budget for the entire report. There is now a new option within the Column Layout setup to have different budgets in different columns of the report, making it easier to compare and track progress on connected budgets or projections.
Go to the account schedule you would like to edit and select “Process” > “Edit Column Layout Setup” to view the current column settings and customize them to your preferences.
You will now find a new column named “Budget Name” where you can specify a different budget per Account Schedule column.
For further inquiries about this subject, please contact Support@BondConsultingServices.com to speak with one of our experts.