Sections in this category

Post and Export Batches

Posting a batch essentially "locks" the batch so no further items can be added to it. Typically this is done when preparing to export the batch for use with your accounting software.

1. Pre-Post & Export: Confirm that the data is correct

1.2. Select the batches you plan to export. Click the more options ('...') button and run the General Ledger Account Distribution Report.

Select the batches you plan to export and run the General Ledger Account Distribution Report from the more commands option button.

*NOTE: If you are using D365 online, the General Ledger Account Distribution Report will not be available and you should skip to section two below. We suggest setting up an Excel template from GL Account Entries to verify data instead. This article provides instructions on how to setup excel templates: Excel Templates in CRM 2016

1.3. In the pop up window set the toggle to "The selected records" and Run Report.

In the pop up window set the toggle to "The selected records" and Run Report.

1.4. Use report to confirm that amounts are correct. If not make changes and then run the report to check again.

Use report to confirm that amounts are correct. If not make changes and then run the report to check again.

The view in this example is the summary report type. For individual line items change the report type to Detail and click View Report.

2. Post the batches

2.1. If they are not already still selected, Select the same batches from the Step 1 data check.

2.2. Click Run Workflow in the more commands button and click Add in the pop up window to post the batches.

2.3. Change your view from Active Batches to Posted Batches (Not Exported) to confirm the batches in the view are the correct.

Posting the batches allows you to isolate the batches for exporting (the process of posting simply updates the Status of the batch to Inactive: Posted). If you have not followed the steps above the batches may not be in the expected view, check your steps to make sure you are exporting the right batches. You want to make sure all the batches you ran your data check on appear here, with none missing and no extras.

*Note that if the batches do not appear in the Posted Batches (Not Exported) view, you will not be able to select them from Posted Batches (Not Exported) in step 3.2.

3. Use the Account Export Wizard to Export the Batches

3.1. From the more commands button select Accounting Export

Note: Batches do not need to be selected. Depending on your environment, the Accounting Export button may not appear if the Batches are selected.

From the more commands button select Accounting Export

3.2. Select the date that should be on your accounting export file and select the view you want to export from. Usually this is Posted Batches (Not Exported). Click Export.

We have this because while the calendar date may be June 12, you may want the export date to be May 31 or June 1.

3.3. Open and/or Save the zip file that is generated. A pop up should appear at the bottom of your screen.

3.4. Click Close to end the process and select Confirm Cancellation.

This does not cancel what you have done, but simply closes the completed export process.

4. Your batches are still in the system but will appear under the Exported Batches View.