how-to Reverse the Entries, included in Bank Account Reconciliation in Business Central #reverse #generalLedger #gL #entries #d365bc

Freelancer Madhavi

💁Agenda of the Video▶️: To share the easiest steps, How-To Reverse... General Ledger Entries (Posted Voucher Entries) included in Bank Account Reconciliation in Business Central. ---------- ✅Hint 1: Use General Ledger Entries (Page) To Reverse Posted Voucher Entries (Like; Bank Receipt Voucher, Bank Payment Voucher, Cash Receipt Voucher, Cash Payment Voucher, Contra Voucher, Payment Journal, General Journal, Journal Voucher, Purchase Journal, and Sales Journal etc.). ✅Hint 2: Page Name in Business Central, Bank Acc. Reconciliation. ----------- 📍Note 1:- This is Not necessary that every time Posted Voucher Entries involved in any Bank Acc. Reconciliation, or Applied to any Posted Initial (Original) Invoice Entry. But, if Applied then Un-apply first... and after that try to Reverse. 📍Note 2: The above stated Note 1, this is Depend on the Use Case / Scenario where... Document Type = Payment (or Blank), and Voucher Type = Contra / Payment / General Journal / Payment Journal.

Transcript

00:00Welcome to Unlocking ERP, I'm your host Amrit Saini, today we will talk about a very

00:22important feature of reversing entries in Microsoft Business Central or Navasion. Today we are with ERP

00:30Consultant and Dynamics Specialist Madhavi Pandey. Hello Madhavi, welcome to the show.

00:37Hi, thank you. Okay, we won't do time-based, let's go straight ahead. My first question is,

00:47how to reverse entries in Business Central or Navasion and also show the steps of reversal of entries.

00:56Your question has two parts. What is reversal entries plus how to reverse the entries?

01:06How to reverse the entries? First, let me share my screen.

01:12This is visible to you? Yes, it's visible.

01:18It's visible. Yes, it's visible. Yes, it's visible.

01:20So, first of all, the reason is reversal of entries. Why do we reverse an entry?

01:26You can say any kind of posting mistakes, user mistakes, manual mistakes, or some kind of error.

01:34There are many errors, human errors. Now, if you've been posting values,

01:40or some kind of error, or some kind of user-related, or some kind of user-related related,

01:46or some kind of data related related, or some kind of account related,

01:50or some kind of error. So, multiple kinds of mistakes are.

01:54So, if you've made any mistake, what do you want to do?

01:58You want to search the document in general entry space,

02:02because it will be used in GL.

02:04And you can reverse it.

02:06Reverse means what does the system do?

02:08Okay, it will pass an opposite entry and reverse it.

02:12So, you can reverse it.

02:14You can filter the document number to reverse it.

02:16I've been searching for a document number.

02:20Which one is going to take? PCB.

02:22I've been searching for this.

02:25For you to show.

02:27Now, as I've done a document number filter,

02:30the document number is unique.

02:32You can filter on this basis.

02:33You can filter the posting date.

02:35You can filter the document type.

02:37But, I've done a document number based on the basis.

02:40Now, you can check the entry.

02:42You can check the entry again.

02:44What was the entry posted?

02:45And what was wrong with you.

02:47So, from different types of errors,

02:50you have done a clerkial mistake,

02:53or a value mistake.

02:55Which you can check.

02:56Or you can assign a letter wrong.

02:57Or you have done a wrong voucher.

02:59Like a Contra voucher.

03:00So, after that,

03:02you have clicked the narration.

03:04What does it matter?

03:05Why do you reverse the entry?

03:07After that,

03:08you have to do the document number.

03:11Because it is unique.

03:14If you click the document number,

03:15you will select the document number.

03:17It will be multiple lines.

03:18Multiple debit credit.

03:20Click on the process to reverse.

03:22Click on reverse transaction.

03:24The system will show you an entry once.

03:27If you want to reverse the entry,

03:29click on reverse button.

03:31The system will ask you to reverse these entries.

03:34Correcting entries will be posted.

03:36Do you want to reverse the entries?

03:37Yes.

03:38Yes.

03:39Yes.

03:40Yes.

03:41Yes.

03:42If there is any entry involved.

03:44Now,

03:45this entry is already

03:47in the bank reconciliation line.

03:49The reconciliation has not been yet posted.

03:54So,

03:55it is used in your reconciliation entries.

03:57Is it used in your reconciliation entries?

03:59Yes.

04:04Bank account ledger entry number 2921.

04:07Because the entry is included in bank reconciliation line.

04:11Okay.

04:12This is saying that

04:13it is in the bank reconciliation line.

04:16Unapply.

04:17It is not a problem with it.

04:19It is not a problem with it.

04:20It is a problem with it.

04:21It is used in any reconciliation line.

04:23And,

04:25it is used in a reconciliation line.

04:27It is used in banks and it is used as a state.

04:29So,

04:30we need to find a reconciliation lineоч Spin.

04:33And,

04:38we need to check our new file.

04:39It will be divided into the filter.

04:40You need to check the document number to the filter.

04:44Yes.

04:46This line is included.

04:47The only difference between the line is included.

04:48This line is included in which the line is included here.

04:52It is included.

04:54Until it is used here,

04:56you can't delete it or reverse it.

04:59You can't reverse it.

05:01Go ahead and select this line.

05:08If I have here,

05:10Bank Laser Entries,

05:13has added statement?

05:15You have to add statement from here.

05:17You don't need to add statement from here.

05:22We will return.

05:26We will reverse it again.

05:29The entries were successfully reversed.

05:35It was not an unapplied case.

05:37It was a case that

05:39it was used in a statement.

05:41You can reverse the entry like this.

05:43You have to find which entry was wrong.

05:46What is the reason?

05:48If the entry is used,

05:51then you have to add the link.

05:53If it is applied,

05:54then you have to unapplied.

05:56And if there is a Reconciliation Bank entry,

05:59then you have to move from Reconciliation.

06:01After finding the error or information,

06:05you can reverse it.

06:07Get back to you, Amrit.

06:09Okay.

06:10Can we reverse all kinds of entries from the general ledger entries page?

06:20All kinds of entries?

06:21All kinds of entries,

06:23like you have seen,

06:25it depends on where the entries are posted.

06:29If you have an item related invoice,

06:33or an order document,

06:35or a memo or a refund,

06:38if you have posted on that document,

06:41then you can reverse it on the general ledger page.

06:44For that,

06:45we need to reverse the credit memo.

06:48So,

06:49you need to reverse it.

06:50But,

06:51if you have a voucher document,

06:55then you can reverse it from there.

06:58So,

06:59you need to reverse it from the voucher document.

07:00So,

07:01you need to reverse it from the voucher document.

07:03So,

07:04you need to post the entries from the voucher.

07:06General ledger entries,

07:07which means that

07:08you need to go to the G&L Mall.

07:10And,

07:11that entry will be shown here.

07:12And,

07:13that entry will be shown here.

07:14And,

07:15when the entry will be shown here,

07:16the voucher is posted,

07:17like you have a journal voucher,

07:18or a payment voucher,

07:19or a journal,

07:20then you can reverse it from this screen.

07:24Next question.

07:31Okay.

07:32How can we see the reverse entries list,

07:34in one page or screen?

07:39Like,

07:40you can see all the entries on this screen.

07:41As far as the entries are posted,

07:43the G&L involved,

07:45the entries will come to the page.

07:48But,

07:49if you have only reversed entries on this page,

07:52and how much the entries have reversed,

07:54then you need to assign value.

07:56First,

07:57the column in the screen,

07:59this column,

08:00if you don't see the screen on the screen,

08:02then you have to personalize it.

08:04So,

08:05when you have to personalize it,

08:07then,

08:08the field,

08:09you have to reverse search here,

08:11you have to reverse search here,

08:12which is not on the screen,

08:14it's for that.

08:15And if you already activate,

08:16it will not come.

08:17If you don't activate,

08:18then you have to reverse search,

08:20drag and drop.

08:21If you drop here,

08:22then you will add column.

08:23After you have to assign the column,

08:24you have to assign the column to the column.

08:26Here you can assign them,

08:28or here,

08:29You can assign them.

08:30Like you will assign the column of the desired listed version.

08:32If you ask the Marie listed on the column of the left,

08:35you have to say,

08:36you have to take reverse word.

08:37As you can ask the system,

08:39if you want to see what you want to see.

08:41The choice of the yes to choose,

08:42you will only show reverse entry.

08:44The choice of the no to choose,

08:46means that the not to reverse entry is not,

08:48the entry is not.

08:50When you want to see reverse.

08:51to choose yes to yes,

08:52then the system will show you all the reverse entries.

08:55And if you close this filter,

08:57then the system will show all the entries in the system.

09:00So on this page, on this screen,

09:03if you want to see the general ledger entries on the page,

09:06then you have to activate this column

09:09plus you have to add this filter

09:11and you have to take the value.

09:13So you will show the reverse entries on this list.

09:17We have talked to you, Amrit.

09:19Thank you, Madhvi.

09:21We will see you in the next episode,

09:24with a new ERP Insights.

09:26For now, keep learning and exploring.

09:29Bye-bye.

09:31Bye.

Category

Transcript

Recommended