(Italy) General ledger simulations Feature | Complete guide for Setup | Operations | Report

General ledger simulations allow you to post simulated ledger transactions from the general journal and then review reports that include the simulated transactions.

This feature is available only for legal entities with a primary address in Italy.


You can post simulation transactions only for journal lines where Account type and Offset account type are equal to Ledger. You can delete the simulated ledger transactions, modify them, and move them to the real general ledger posted transactions. You can review the posted simulation ledger transactions in the reports, Trial balance and Dimension statement with simulation.

 

Setup

Create a number sequence for the simulated general journal transfer by standard way


1.    Go to General ledger > Ledger setup > General ledger parameters.

2.    On the Number sequences tab, set the sequence to Simulation general journal transfer.


 

Create a Simulation journal

1.    Go to General ledger > Journal setup > Journal name and create a new journal called 'Simulation'.

2.    Set the Journal type to Daily.

3.    In the Simulation field, select Yes.

4.    In the Simulation journal field group, set Requires validation to Yes to indicate that the journal must be validated before the simulated posting is executed.



Operations

Create and post simulation transaction

1.    Go to General Ledger > Journal Entries > Simulation journals.


2.    Create journal lines as Ledger - Ledger in the standard way, and then select Post > Post simulation to post the simulation transactions. This makes the transaction effective for simulation calculations, and the journal becomes simulation posted.


3.    Select Post > Reopen to make the posted simulation transaction editable.

4.    Select Post > Post to move the posted simulation transaction to an ordinary ledger.


 Important

The function that closes a fiscal period or a fiscal year verifies that the simulation transactions have been posted as typical transactions or have been deleted. If there are pending simulated general ledger transactions for the period, an error message appears.

Periodic operations

Post all simulation transactions

·         To post simulation transactions for all simulation journals, go to Periodic tasks > Simulations > Post simulation journals.

Transactions will be no longer include simulation transactions after all journals are posted.

Reopen all simulation journals

·         To reopen all simulation journals, go to Periodic tasks > Simulations > Reopen simulation journals.

All simulation posted simulation journals are reopened. You can edit the Simulation journals and post simulation again.

Delete all simulation journals

·         To delete all open simulation journals, go to Periodic tasks > Simulations > Delete simulation journals.


Review simulation transactions in reports

Simulation transactions can be reviewed in several ledger reports.

 Note

Simulation transactions do not appear on the Italian fiscal journal until they become real transactions.

Create a Simulation Journal name group

1.    Go to General ledger > Journal setup > Simulations > Simulation journal group.

2.    Create a simulation journal group.

3.    On the Simulation journals tab, select to include simulation journals in this group from the list of available simulation journals.



Trial balance

1.    Go to General Ledger > Inquiries and reports > Trial balance.

2.    On the Parameters FastTab of the Trial balance report header, select a value in the Simulation journal group field.

3.    Enter other parameters and calculate the balances.

4.    Verify that the report contains columns that consider simulation transactions, this includes:

·         Debit (simulation)

·         Credit (simulation)

·         Closing balance (with simulations) - This is the total of the values in the Closing balance, Debit (simulation) and Credit (simulation) columns.






 

Dimension statement with simulation

1.    Go to General Ledger > Inquiries and reports > Ledger reports > Dimension statement with simulation.

2.    Set Simulation journal transactions to Yes in the Statement by dimension dialog menu.

3.    Select a value in the Simulation journal group field, and then select OK.

4.    Verify that the report contains posted simulation transactions and standard ledger transactions.



Comments

Post a Comment

Popular posts from this blog

Automated Customer Write off Transactions from D365 F&O (Step by Step Setup & Testing Scope)

Image
Hello Microsoft Dynamics Lovers, Today I will show, how the Automated Write Off function in D365 F&O is used and how the Configuration can be done to deploy the function for usage. The Business scenario is- We sold product to customer, however due to some reason, the money can not be gained and that will be in Write-off Expense account (kind of bad debt). Pre After write off The accounting entry will be below, however this will be auto created in GL journal This setup is done with very basic configurations, Lets explore together. 1: Create a Journal Name and assign a voucher series by standard way. 2:Create a BAD debt loss in P&L expense account (If your business has a expense account for bad debt, you can use that) 3: Create reason code 4:Add the reason code & Main account for bad debt and make the same default in " Customer write-off reason codes" ( Credit & Collections->Setup-> Customer write-off reason codes) 5: Configure Credit and Collection-> S
Read more

Microsoft Edge :Web Browser can be installed as an application in your system

Image
Dear Innovation Lovers, Have you heard that, any web page you go through, can be installed as an application in your system by just a simple click? check this article for step by step setup. Pre-requisite - This feature available in Microsoft Edge version  85.0.564.51 1:First, open any web browser in Microsoft Edge( I have selected Microsoft Dynamics Community Page) 2: Select the 3 dots top of the right corner and options will come up 3: Select "Apps" option from the same form 4: One option will pop up "Install this site as an app" 5: Name it ( I have named as "D365 Community"), you can add any. 5: URA!!! The web browser is installed For more feature like this follow me on on LinkedIn  Ramit Paul Follow my Microsoft Community Blog  My Microsoft Dynamics Community Blog
Read more

Conditional Sales Tax Setup Guide for MSD365 Finance and Operations

Image
In this Blog, I will articulate how we can setup the Conditional Sales tax functionality  and how the same is paid to Govt/ statutory authority. For some of the countries, especially in Europe, the Sales tax authority allows for sales taxes and base amounts to be reported when the invoice is paid, not when that goods and service is received. Example~ On June 10 , you create an invoice of 10,000 plus 2,500 in sales tax. On July 10, you report taxes for June. The 2,500 is not included in the sales tax payment, because the invoice has not been paid. On July 15, the customer pays half of the invoice amount, 5,000, plus 1,250 in sales tax. On August 10, you report taxes for July. The 1,250 is included in the sales tax payment. When the customer settles the invoice with a second payment of 6,250, the remaining sales taxes are reported and paid. This setup will be done by~ 1.      Create separate main accounts for sales taxes on invoices that are awaiting settlement 2.     
Read more