Microsoft Dynamics 365 Business Central Self-Help Place

Suppose there is an invoice capture in foreign currency for USD1,200 in Apr’22, the system posted Local Currency of MYR5,064 using the exchange rate in Apr’22. When come to the payment period in May’22, the USD rate charged by the bank for the payment is MYR4.60, which equivalents to MYR5,520. Page: Payment Journals                1.        The Bank Exchange Rate can be entered in the Edit – Change Exchange Rate option button which just next to the Currency Code field.               2 .        Apply the foreign currency payment to invoice via Apply Entries .               3 .        Select Preview Posting > Detailed Vendor Ledger Entry to view the converted amount in Local Currency.               4 .        ...

A laptop is purchased at $4,800 on 1 st March 2020. The depreciation method is Straight-line for over 4 years. On 31 March 2020, the depreciation was calculated as: - (Asset Cost/Useful Life)/Monthly Depr. (4800/4)/12=100 Run the Projected Value report to view the calculated future depreciation and book value. On 12 th April 2020, an invoice was posted for upgrading the laptop spec with additional RAM, the invoice amount is $480. 12 Days of depreciation ( from 1/4/2020 to 12/4/2020 ) for the existing asset is calculated as: - (Monthly Depr./30 Days)*Number of Depreciation Days (100/30)*12=40 12 Days of depreciation ( from 1/4/2020 to 12/4/2020 ) for the additional cost on existing asset is calculated as: - (Monthly Depr./30 Days)*Number of Depreciation Days (10/30)*12=4 To account the depreciation for the additional asset cost into the 1 st depreciation in March’20, you will need to select Depr until FA Posting Date and Depr. Acquisition Cost check box together on the Fixed ...

There are certain routine entries that need to be recorded in the book, the transaction frequency can be by months, weeks or even by days. Some the transaction amount will be fixed through out the month like rental expenses, some amount might change all the time like utilities expenses such as electricity bill. With Microsoft Dynamics 365 Business Central (BC), all these conditions can be handled by different method such as: - i.                      Using Microsoft Excel Copy and Paste function ii.                    Using BC’s Recurring General Journal function Most users will prefer using Recurring General Journal function to handle recurring entries, as it not only handles the above-mentioned conditions, but it also has additional feature such as Allocation which helps allocate the amount to di...

Microsoft Dynamics 365 Business Central (BC) allow users to account for foreign currency transactions. BC also able to translate the registered foreign currency amount into functional currency that setup in the entity using the conversion rates which setup in Exchange Table.   Due to the exchange rates fluctuate constantly, as a dollar worth in foreign currency today might not equivalent to the same foreign currency worth the next day. Hence, users are required to adjust the open documents that transact in foreign currency which include open invoices, credit memos, and advance payments. Once the open documents transacted in foreign currency is revalued, the gain and loss which calculate after comparing the closing rates at the period end will be posted to profit and loss as unrealised gain and loss, ensuring that the subledgers and general ledger can be reconciled.   This process can be done using Adjust Exchange Rate in BC, a batch job to adjust the exchange rates fo...

To make sure the bank statement’s listed transactions are same with records that registered in Microsoft Dynamics 365 Business Central (BC), you can perform Bank Account Reconciliation to ensure the accuracy. Page: Bank Account Reconciliation 1.        Enter the Bank Account Statement Date and the Bank Account Statement Balance for the bank account that you need to reconcile. ( Take note that the Balance Last Statement will auto reflect the last posted bank reconciliation, do not apply anything into this field. ) 2.        To get the system to replicate the posted bank ledger entries in BC into Bank Statement Lines, you can select Suggest Lines options to do so. 3.        In this Suggest Bank Acc. Recon. Lines option, you can filter the bank ledgers entries from the Starting Date and Ending Date options. To make sure all open entries are included, you can leave the Starting Date field blank, while ...