Microsoft Dynamics GP Recurring Journal Entries

 Do you find yourself entering and posting the same general journal entry month after month? You can save these entries in a recurring batch and post the batch each month. Or even post them out into the future (as long as the Financial module is Open for those Fiscal Periods).

Here is how to create a recurring journal entry in Dynamics GP:


  1. Create a batch in Financial > Transaction > Batches
  2. Give the batch a meaningful name and change the Frequency to how often you want the recurring entries to post.
  3. If you enter data in the Recurring Posting field, the batch will automatically be deleted after it’s posted that many times. If you leave it set to zero, the batch will never go away (unless manually deleted).
  4. If you choose Monthly for the Frequency, the posting date of the recurring transaction(s) will increment up by one month each time you post the batch. If you choose Weekly the transaction will increment up by 7 days, etc. If you select Misc you can choose how many days to increment it up by.
  5. You can edit the journal entries at any time
  6. You can see in the Batch Entry window the Last Date Posted and the number of Times Posted

Note: You can also set up a recurring batch for payables and receivables transactions.

Frequently asked questions about Revenue/Expense Deferrals in Microsoft Dynamics GP

This article contains answers to frequently asked questions about Revenue/Expense Deferrals (RED) in Microsoft Dynamics GP.

Question 1: I installed Revenue/Expense Deferrals in Microsoft Dynamics GP. However, I can't see the commands on the menus.

Answer 1: After you install this module, you must initialize Revenue/Expense Deferrals.

Question 2: My deferral has been posted. How can I correct the GL accounts or amounts used on the remaining deferral entries? Or How do I do a partial void for the remaining entries left on my deferral?

Answer 2: You aren't able to edit the GL accounts or amounts on existing deferral transactions or partially void the remaining deferral entries not yet posted. To remedy this, you can void the entire deferral transaction and reenter it correctly. Use one of the following methods:

  • VOID DEFERRAL ONLY: In the Void Deferral Transactions window, you can void the deferral transactions only. To open this window, select Financial on the Transactions menu, select Financial Deferral > Void Deferral Transactions. In this window, select the module in which the original transaction was entered. Select the transaction that you want to void, and than select Void. Than use the Sales or Purchasing Retroactive Deferral window to set up the deferral entries again as needed.

  • VOID ORIGINAL TRANSACTION AND DEFERRAL: In the Deferral Setup window, select Void Deferrals with Original Transactions. When you select this option, the deferral transactions are voided when you void the original transaction. To open the Deferral Setup window, select Setup on the Tools menu, select Financials > Deferral. Now you can void the original transaction in the module it was entered in, and the deferral entries will be deleted along with it. Rekey the original transaction back in and set up the deferral for it again.

  • KEY OFFSETTING JE'S: Post the Deferral entry as is, and then key offsetting GL transactions to correct the accounts or offset the remaining entries not needed. To do this, select Transactions > Financial > General and enter the adjusting journal entry and respective Transaction Date, accounts, etc. For audit trail purposes, be sure to write a good Reference that indicates the original JE it is offsetting. Post the offsetting entry.

Question 3: Why do the deferral transactions post to periods that are closed in the Fiscal Period Setup window?

Answer 3: The deferral transactions post to periods that are closed because the Auto Post into Closed Previous GL Periods setting or the Auto Post into Closed Future GL Periods setting is enabled in the Deferral Setup window. These settings work only when Automatically Post Through GL is selected in the Deferral Setup window.

To open the Deferral Setup window, select Setup on the Tools menu, select Financials > Deferral.

Question 4: How can I post transactions to future periods in Revenue/Expense Deferrals when I am registered for Multicurrency in Microsoft Dynamics GP, and the exchange rates on the future transactions aren't yet entered?

Answer 4: Revenue/Expense Deferrals don't have multicurrency functionality. You can see only the functional currency. The exchange rate isn't considered for the transactions.

Question 5: Is there a way to have Microsoft Dynamics GP prompt a user to enter a deferral on a transaction when the transaction is being entered?

Answer 5: Currently, Microsoft Dynamics GP can't automatically prompt a user to enter a deferral. The user must know to enter the deferral.

Question 6: Is the Batch Approvals process available for Revenue/Expense Deferrals batches?

Answer 6: There's no available method for using the Batch Approvals process in Revenue/Expense Deferrals. The Require Batch Approval check box is in the Posting Setup window for each module. Revenue/Expense Deferrals are not part of the core Microsoft Dynamics GP dictionary. Therefore, the Require Batch Approval check box isn't included in this window.

Question 7: I am able to post a deferral transaction even though the deferred amount doesn't match the distribution amount. Is this correct?

Answer 7: You can defer only part of a distribution. You don't have to defer the total distribution. Microsoft Dynamics GP lets you post the transaction even if the deferral isn't equal to the distribution amount.

Question 8: What is the difference between the Balance Sheet posting method and the Profit/Loss posting method?

Answer 8: When you use the Balance Sheet posting method, you identify two posting accounts:

  • A profit-and-loss recognition account that you use together with the deferral transaction of each period. You use this account for recognition of the expense or of the revenue.

  • A balance-sheet deferral account that you use together with the initial transaction for the deferred revenue or for the deferred expense.

When you use the Profit/Loss posting method, you can identify up to five accounts. This allows for greater detail in financial reporting. These accounts include three profit-and-loss accounts and two balance-sheet accounts.

The profit-and-loss accounts include the following:

  • An account that you use for the initial posting of the full amount of the original revenue or of the original expense.

  • An account that you use to reverse the deferred revenue or the deferred expense. This account can be the same account as the original account.

  • An account that you use to recognize the deferred revenue or the deferred expense. This account can be the same account as the original account. The balance-sheet accounts include the following:

  • A deferral account that you use to record the full deferred balance that was transferred from the original revenue account or from the original expense account.

  • A deferrals transfer account. This account can be the same account as the deferrals account.

Question 9: Is it possible to change the deferral posting method?

Answer 9: After you select a deferral posting method for a series and then post a deferral transaction, we recommend that you not change the deferral posting method. If you must change the deferral posting method, you must first post all the unposted deferral transactions. Then, you can change the method in the Deferral Setup window. This change doesn't affect the deferral transactions that you already posted.

Question 10: What is a retroactive deferral?

Answer 10: A retroactive deferral lets you create distribution deferrals that apply to previously posted transactions that were created in the Sales series or in the Purchasing series. Retroactive deferral transactions should use the Profit/Loss posting method. This posting method lets you reverse the posted amount from the profit-and-loss account to which the amount was originally posted and then transfer that amount to a deferrals account.

Question 11: Is it possible to enter a deferral on a journal entry in General Ledger in Microsoft Dynamics GP?

Answer 11: You can't enter a deferral on a journal entry in General Ledger. You must use the Deferral Document Entry window to enter a deferral in General Ledger. In this window, you specify the following information:

  • The deferral account that you want to use
  • The recognition account that you want to use
  • The start date and the end date for the deferral
  • The method that you want to use to calculate the deferred amounts

Question 12: Which modules allow for Revenue/Expense Deferrals transactions?

Answer 12:

  • General Ledger
  • Receivables Management
  • Payables Management
  • Sales Order Processing
  • Purchase Order Processing
  • Invoicing

Question 13: Is it possible to enter deferrals for transactions in a recurring batch?

Answer 13: Currently, Revenue/Expense Deferrals can't save transactions in a recurring batch.

Question 14: Does RED integrate with Analytical Accounting?

Answer 14: At this time, there's limited compatibility between RED and AA. To assign AA codes to RED deferral entries, your options are:

  • Option 1 - Post the batch to GL and add/edit the AA dimension codes in the GL Work batch before posting.

  • Option 2 - Post the batch in GL and than use the Edit Analysis window to add/edit the AA dimension codes. (To open this window, select Transactions > Financial > Analytical Accounting > Edit Analysis.)

  • Option 3 - Enter default AA dimension codes on the Accounting Class in Analytical Accounting, so these default codes get assigned to the deferral entries. However, you would still need to use one of the two options above to make any changes to the AA data, if desired. (To open this window, select Cards > Financial > Analytical Accounting > Accounting Class.)

Question 15: Does Red integrate with Intercompany functionality?

Answer 15: Red isn't fully compatible with processing intercompany transactions. The deferral allocation will be recorded in the originating company, however, only the due to/due from accounts set up for intercompany processing are used in the destination company. The deferral entries don't flow to the destination company.

Question 16: Deferral Inquiry window pulls up Customers and Prospects when trying to pull up Vendors for Purchase Order Processing module

Answer 16: This happens when we're using RED, Revenue Expense Deferral. When you go to look up Vendors in the Deferral Inquiry window (Inquiry > Financial > Deferral) with the Purchase Order Processing Module selected, the window pulls up the Customers and Prospects window instead of the list of available Vendors in the company. To work around this, Select the Payables Management Module from the dropdown first, than the Vendor option for the filter and than select the Vendors desired in the From and To fields. Than change the Module dropdown back to Purchase Order Processing and select Redisplay.

Using Flow to Integrate Dynamics CRM and SharePoint

A manufacturing company's sales staff visits a client, they are required to fill out a “Visit Report” so that others in the company can review their information. The client wanted to store these reports in SharePoint because Dynamics 365 licenses are more expensive than the general Office 365 licenses, which SharePoint is a part of.

Visit Reports were created as an entity related to accounts in the Dynamics 365 system.

Steps performed:

  1. Set up Document Management sync between Dynamics 365 and SharePoint Online.
  2. Create a content type in SharePoint and associate a Word template with it.
  3. Go into Microsoft Flow and create a blank flow.
  4. Add a “trigger” from Dynamics 365 which will launch the flow whenever a record is created or updated in Visit Reports.
  5. Add an “action” from Dynamics 365 to get a record from the Account entity.
  6. Select the correct organization name (i.e. your company’s main tenant; ours is “MRS Company Limited”), select “Accounts”, and for the Item Identifier, we chose “Customer” from the list of dynamic content.

  7. Add an action to “Get file content” from SharePoint library Visit Report. This will be the blank template for Visit Report.
  8. The flow will prompt you for the site address and file identifier. Under site address, select/enter the URL for the SharePoint site. For File Identifier, select the template from the library location.
  9. Add another action step to create the file in the SharePoint library “Visit Reports”.
  10. Under site address, enter the URL for the document’s destination location in SharePoint. For the folder path, select the exact library. In this case, it is “/sti_visitreports”. For File Name, select Account Name from the Get Record step (see above) and Visit Date from the date the location was created/updated. For File Content, select File Content from the Get File Content step. See the screenshot below:
  11. The final step is to add an action to update file properties. From here, select the URL and SharePoint document library, and then enter the ItemID from the Create File step. At this point, you can add any metadata that is required via the dynamic content tab.
  12. Click save and start testing!

Learn Oracle E-Suite

https://learn.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=904&get_params=cloudId:243,objectId:23306

LEJ Knowledge Hub

LEJ Knowledge Hub

Instance Segmentation Algorithm

https://www.youtube.com/watch?v=yt1RSUw0YO4

Artificial Intelligence 101: How to get started

https://www.hackerearth.com/blog/artificial-intelligence/artificial-intelligence-101-how-to-get-started/

Learn Python 2

https://www.codecademy.com/courses/learn-python

7 steps to learn Artificial Intelligence

1. Pick a problem you’re interested in.


Starting with a problem you want to solve makes it a lot easier to stay focused and motivated to learn, instead of starting with an intimidating, disconnected list of topics (you’re a Google search away from many of lists of machine learning resources, I’m not providing another one here). Solving a problem also forces you to deeply engage with machine learning, instead of passively reading about it.

Good problems to start with have several criteria:
  • They cover an area you’re personally interested in.
  • Data is readily available that’s well-suited to addressing the problem (otherwise 
           the bulk of your time will go here).
  • You can work with the data (or some relevant subset of it) comfortably on a single machine.
Don’t have a problem that comes to mind? No worries! We provide a nice onramp of
machine learning problems at Kaggle through our getting started competition series.
Start off on the titanic competition.

2. Make a quick, dirty, hacky, end-to-end solution to your problem.
It’s really easy to get bogged down in one implementation detail or carefully tuning the
wrong machine learning algorithm. You want to avoid this.
Your goal here is to get something super basic in place as quickly as possible that covers
the end-to-end problem, from reading in the data, processing it into a form suitable for
machine learning, training a basic model, creating a result, and evaluating its performance.
3. Evolve and improve your initial solution.
Now that you have a functional baseline, it’s time to get creative. Try improving each
component of your initial solution, and measure the impact to see where it makes sense
to spend time. Many times acquiring more data or improving data cleaning and
preprocessing steps have a higher ROI than optimizing the machine learning models
themselves.
Part of this step should include being hands-on with the data - inspecting individual rows
and visualizing distributions to have a better understanding of it's structure and oddities.
4. Write up and share your solution.
The best way to get feedback on your solution is to write it up and share it. Writing about
your solution mean you’ll engage with it in a new way and understand it better. This
enables others to understand what you’ve done and provide feedback, helping you learn.
It also kickstarts your machine learning portfolio, which will help showcase your abilities
and get a job.
Kaggle Datasets and Kaggle Kernels are an effective way to share your data and solution,
get feedback from others, and also see how others extend your problem. This starts
fleshing out your Kaggle profile as well.
5. Repeat #1-4 across a diverse set of problems.
Now that you’ve done this for a single problem that you’re interested in, do this several
more times across a different set of domains.
Did you start off with tabular data? Work on a problem that involves less structured text,
and another that solves images.
Was the machine learning problem structured for you initially? Alot of the creative and
valuable work is figuring out how to go from a loosely-defined business or research
objective to a well-defined machine learning problem in the first place. Work through this
for one problem type.
Kaggle Competitions and Kaggle Datasets provide a good starting point for both
well-defined machine learning problems and raw data sources that’d be suitable
for machine learning.
6. Seriously compete in a Kaggle competition (if you’ve not already done so).
Giving your best shot at the same problem that thousands of others are hard at work
on is a tremendous learning opportunity: it forces you to iterate on the problem over
and over again, and then exposes you to what works effectively on the problem.
The forums for an individual competition are a rich resource on how others are
approaching it and debugging issues with your approach, kernels provide exploratory
insights about the data along with an easy way to get started on a problem, and
the winning blog posts at the end showcase what ultimately worked best.
Kaggle Competitions also provide a unique opportunity to team up with others. Our
community has a diverse set of background and skills, so everyone has something to
teach and something to learn. You never know, you may meet your future colleague
on Kaggle!
7. Apply machine learning professionally.
This enables you to spend most of your time on machine learning and really helps you
level up. Deciding on the type of role you’d like to pursue and building a personal
portfolio of projects related to this is a strong starting point. If you’re not ready to start
interviewing for machine learning positions, then taking on new projects in your current
role, seeking consulting opportunities, and getting involved with civic hackathons and
data-related community service opportunities are additional ways to get a foothold.
Professional work often requires and is greatly enhanced by strong programming
abilities - improving this with focused projects yields many downstream payoffs.
Valuable opportunities for professional machine learning work include:
  • Applying machine learning in production systems.
  • Focusing on machine learning research and pushing the state of the art forward.
  • Leveraging machine learning in exploratory analyses to improve product and 
           business decisions.