Sunday 12 June 2016

Bank Reconciliation Process

How to do the Bank Reconciliation Process

reconcile a bank statement with a bank account if any of the checks or deposit slip payments that are listed on the statement currently have a status of Pending cancellation. After a reviewer posts or rejects a check reversal or deposit slip payment cancellation, the status is no longer Pending cancellation, and you can reconcile the bank account.

  1. Click Cash and bank management > Common > Bank accounts. Double-click the bank account to reconcile with the bank statement.
  2. On the Action Pane, click Account reconciliation, and then enter information as appropriate.
    You must enter information in the Bank statement date and Bank statement fields. In the Ending balance field, you can enter the balance of the bank account as it appears on the bank statement.
  3. Click Transactions to open the Account reconciliation form. The upper pane displays the bank account transactions that have not yet been reconciled with a bank statement.
  4. For each transaction that is included on the bank statement, select the Cleared check box if the amount in Microsoft Dynamics AX corresponds to the amount on the bank statement. You can also enter or modify the value in the Bank transaction type field. This field value is important for bank transaction statistics and for some reports.
    1. To select the Cleared check box for an interval of checks that all are displayed on the bank statement, click Mark check interval, and then indicate the interval.
    2. If the amount for a bank account transaction does not correspond to the amount for the transaction on the bank statement, enter the amount of the correction in the Correction amount field, enter an offset main account for the correction amount in the Main account field, and then enter explanatory information in the Description field.
  5. Create transactions for entries, such as fees and interest, that are on the bank statement, but that are not recorded in Microsoft Dynamics AX. Enter the offset main account, description, and appropriate financial dimensions.
  6. As the transactions on the bank statement are marked as Cleared, the amount in the Unreconciled field, which is recalculated continuously as you make changes, approaches zero. When it reaches zero, click Reconcile account to post the reconciliation, and the transactions and corrections that you have created.
    After the reconciliation is posted, the transactions that have been included cannot be modified or corrected, and they are not displayed for future account reconciliation.
  7. To view bank transactions that have not yet been reconciled, use the Unreconciled bank transactions report. To view the bank statement for a bank account, use the Bank statement report.
Below is the list of Transactions in Bank Account.
Now, How to start reconciling..? Assuming that we got a statement from Bank on 30th June-2012 which is listing the transaction of USD 10,000, USD -500 and USD -1500 and also some charges levied of USD -50.
The closing balance that may appear in the bank statement shall be USD 7950.
Click the button Account reconciliation to start the reconciliation. In the “Bank statement form” that is opened, enter the Bank Statement date, Bank statement identification and the Ending balance(In this case 7950).
Click the Transactions button which will list all the un-reconciled transactions of the corresponding Bank. In the below screen, there are three highlighted fields which need to be understood to solve the Reconciliation problems.
Opening Balance – It always shows you the previous statement’s ending balance. As this is the first Reconciliation entered in the system, the opening balance shows “0”.
Ending Balance – The ending balance that is entered by the user in the current statement .
Un reconciled – The Amount of Transaction that can be included. In the other way, the sum of the transactions that are being included in the current statement should match this value.
Note: If the “Un reconciled” field shows the value “0” then only the button “Reconcile Account” will be enabled and allows you to complete the reconciliation.
In our Bank trans and the Statement that is sent by the bank, we have 3 common transactions i.e., 10000,-1500,-500. The charges that are levied by bank -50 is not appearing in bank Trans currently as we will get to know the charges only after we get the statement. So, we need to include a transaction of -50 which is not appearing in Bank Trans.
Few Transactions like Interest, Check Fees, other Fees Transactions can be directly entered during the reconciliation. Clicking the new button allows you to do that.
In the above image, highlighted in yellow is the Transaction that is newly entered by seeing the Bank statement and the offset account also can be specified which can be seen the yellow highlighted box. Highlighted in red is the total transactions that are included in the current statement which sums up to USD  7950.
Now, you can observe the Un reconciled field shows “0” and the “Reconcile Account” button enabled.
Clicking the “Reconcile Account” will reconcile the transactions that are included in the statement.
From Bank Accounts form>Click the Transactions button to see the transaction those are reconciled. The transactions that are reconciled in the statement have the checkbox “Reconciled” marked. Also, the tab “Bank Reconciliation” shows the corresponding “Bank statement” and “Statement date” . Now the Bank Reconciliation is done.
Comparing the closing balance of the Bank and the balance of the control account:
Bank Closing balance on the statement date:
To see the closing balance, click Print> bank reconciliation button from “bank Statement” form.
The closing balance that shows in the report is the sum of the Reconciled and Un reconciled  transactions till the Statement date.
Ledger Balance till the particular statement date:
From Main Accounts form, Click parameters button, remove the fiscal year and specify the “To date” as the Bank statement date that you are comparing.
Both the “Ledger Balance and Bank closing balance” should read the same value.

How To Correct Free Text Invoice

Easily correct any free text invoice which was posted with the wrong amount.

After going through the correction process, the system cancels the incorrect one 

and posts a new one linked with the old one to meet the audit requirements.


Process

Let us start with an example where you posted a free text invoice amount for USD $2,500 to Customer 1301-Whale Wholesales – but the amount should really be USD $3,000. You realize your mistake, and you want to quickly correct the free text invoice.
Posted free text Invoice with the wrong amount
Fig 2: Posted free text Invoice with the wrong amount.
The process for correcting a free text invoice involves the following steps:
  1. The user clicks Correct on the Free text invoice form.
    To correct a free text invoice, first click Correct Invoice
    Fig 3: To correct a free text invoice, first click Correct Invoice.
  2. Select the error code as “ERROR”, enter the invoice cancelling date and then click Create Corrected Invoice.
    Enter a reason code and a cancelling Invoice date to create  a corrected free text invoice
    Fig 4: Enter a reason code and a cancelling Invoice date to create a corrected free text invoice.
  3. The system then creates a copy of the original free text invoice.
    Created copy of the free text invoice after entering a reason code and a cancelling invoice date
    Fig 5: Created copy of the free text invoice after entering a reason code and a cancelling invoice date.
  4. Make the desired changes to the copied free text invoice.
    Make changes in the free text invoice copy
    Fig 6: Make changes in the free text invoice copy.
  5. Post the changed free text invoice.
    Post the changed free text invoice
    Fig 7: Post the changed free text invoice
  6. The system creates a credit note and all the original settlements are reversed and reapplied to the new credit note. An Infolog appears to show the successful completion of the process.
    Infolog showing the successful completion of the process
    Fig 8: Infolog showing the successful completion of the process
  7. The system creates a link between the Corrected, Credited (Canceling), and Original customer invoice for a clear audit trail.
    The previous free text invoice, credit note, and the corrected invoice are created during the process
    Fig 9: The previous free text invoice, credit note, and the corrected invoice are created during the process.
    Invoice corrections created during the process
    Fig 10: Invoice corrections created during the process.
    The original free text invoice that was corrected
    Fig 11: The original free text invoice that was corrected.
    The credit note automatically created during the correction process
    Fig 12: The credit note automatically created during the correction process.
    The new free text invoice created during the correction process
    Fig 13: The new free text invoice created during the correction process.

How To Create Purchase Order Credit Note to Reverse Invoiced PO

If you want to create a credit note for a vendor, create a new purchase order for that vendor and then click on the credit note button, select the invoice you want to credit and the lines of the original purchase order are added to your new purchase order with inverted quantities. In this way you can credit a previously invoiced purchase order.

An important note to remember is that we cannot create the credit note directly in the same invoice after invoicing a PO as the Credit note button is not active. To create a credit note we have to do it in a new PO. 

Steps

Credit note creation: To create a Purchase Credit Note follow below process, this is a easy way to do a credit note.

Just follow below simple steps after creating and invoicing a purchase order:

Navigation:

Procurement and sourcing > Common > Purchase order > All Purchase orders > New purchase order 


Fill Mandatory Fields 




Before adding new lines to the PO go to the Purchase tab and click Credit Note in Create Section as shown in the screen shot below. 

Based on the selected vendor in the header level all the Invoiced PO’s are listed.

Now select the Invoiced PO which you would like to create the Credit Note for from the list.

Just remember that multiple invoiced PO’s cannot be selected from the list as the Credit Note can be created only for one at a time.

Click OK



As in the next screen shot once the OK button is clicked,
under purchase order line a new –ve line is added, then follow the normal PO process 
and Click Confirm



After the confirmation the status is changed to Confirmed



Then go to the Receive Tab, click Product Receipt button enter the product receipt number (as it is mandatory) then click OK.



After completing the Product Receipt the purchase order status changed as a Received.



Then go to the Invoice tab click on invoice button give the invoice number then post the Invoice/order.



After completing the invoice the purchase order status changed to Invoiced.

This is the complete Purchase Order Credit note Process.

Friday 10 June 2016

Import Assets using Data Import framework Add-Ins

How to import Assets using the data import framework in Dynamics AX 2012 R3. We are going to import some of the asset info you can add or remove fields as needed

1- Go to Data import export framework --> Setup --> Data import / export framework Parameters.

2- Click browse to select shared working directory then click Validate button then close the form.

3- Go to Data import export framework --> Setup --> Source Data format, Create new source name and make sure to chose File in the Type then Change the Column delimiter if needed.

4- Go to Data import export framework --> Common --> Processing Group, Create New Group then Click the Entities Button.

5- in the entities form select the asset Entity, CSV in the Sources data format, then Click the generate source file button.

6- in the wizerd make sure to select the following fields:
BookId (Value Model)
AssetGroup (Asset Group)
AssetId (Asset Code)
Name (Asset Name) (For some reason the name field does not exist in the wizard you have add this field manually )
AcquisitionDate (Acquisition Date)
AcquisitionPrice (Acquisition Price)
LastDepreciationDate (Last Depreciation Date)
Depreciation (Allow Depreciation )
PostingProfile (Posting Profile)
Model
ModelYear (Model Year)
then click Generate sample file.

07-Save the file in the shared folder you specified in step 2.

08-Open the file using MS Excel, fill the data then save the file.

09-Go back to the processing group --> entities---> Select the Sample file path then click the generate source mapping button.

10- if the mapping done successfully Click the Preview source file button to preview the data note that the asset name is not exists.

11- To fix this issue click the modify Source mapping button

12- Map the the field name manually ( just drag the field from source to the name field in the staging) then save and close the form.

13- Click preview again to make sure that asset names have been added and mapped. then close the form

14- in the processing group select the group name then click the Get staging data button to copy the file data to staging table.

15-Click OK to create job.

16-Click Run in the staging data execution form.

17-Click OK.

18-The records will be inserted in the staging.

19-In the processing group select the group name then click Copy Data to target button.

20-Select the Job ID that we created in step 15 then click OK.

21- Click Run to import data.

22-Click OK.

23-The data will be written to target.

24-Go to the Assets list form you will found that the Assets was imported successfully.


Thursday 9 June 2016

Advance Bank Reconciliation

Advance Bank Reconciliation allows for the import of bank statements that can be automatically reconciled from within AX2012. How to perform an advanced bank reconciliation and assumes that AX has been setup correctly as below.


  1. Ctrl+D to open the AOT. Expand Resources and locate “BAI2CSV_to_BAI2XML_xslt”, and then right-click and click “Open”.
  2. On the form that opens, change “Resource type” to “XML document”. Click “Export”. 
  3. Export the file to a directory on your machine.
  4. Repeat steps 1-3, this time for the “BAI2XML_to_Reconciliation_xslt”.
  5. Go to Tools | Application Integration Framework | Manage transforms. Click “New”, and enter “CSV to XML”. Click “Load”. Change the file extension to “XSLT files” to ensure you can see the files exported earlier. Select the “BAI2CSV-to-BAI2XML.xslt” file, and click “Open”.
  6. Click “New”, and enter “XML to Reconciliation”. Click “Load”. Change the file extension to “XSLT files” to ensure you can see the files exported earlier. Select the “BAI2XML-to-Reconciliation.xslt” file, and click “Open”.
  7. Close the “Manage transforms” form and close the AOT.
  8. Go to System administration | Setup | Services and Application Integration Framework | Inbound ports. Click “New”, enter “AdvancedBankReconciliation” for the “Port name” and “Description”. Change the “Adapter” to “File system adapter”. Click the drop-menu for “URI” and click the location of the bank transform files.
  9. On the “Service contract customizations” fast tab, click “Service operations”. Select BankStmtService.create, BankStmtService.delete, BankStmtService.find, BankStmtService.getChangedKeys, BankStmtService.getKeys, and BankStmtService.read, and move them to the “Selected service operations” section. Close the “Select service operations” form.
  10. On the “Processing options” fast tab, check the box for “Transform all requests” and click “Inbound transforms”.
  11. On the “Inbound transforms form, click “New”. Select “XML to Reconciliation” for the “Transform name”. Click “New”, and click “Yes” to the warning box. Select “CSV to XML” for the “Transform name” and Ctrl+S to save, and click “Yes” again to the warning box. 
    **Be sure that “CSV to XML” is the first line and “XML to Reconciliation” is the second record to have the correct order for the transforms. Close the “Inbound transforms” form.
  12. In the “Troubleshooting” fast tab, change the “Logging mode” to “Original document”. In the “Security” fast tab, select “initial” for the “Restrict to partition”.
  13. Lastly, click “Activate” to activate the new inbound port.
  14. Go to Cash and bank management | Common | Bank accounts. Select the “USA OPER” account and click “Edit”.  Expand the “Reconciliation” fast tab, and check the box for “Advanced bank reconciliation”. Click “OK” to confirm. 
  15. In the same section, right-click the drop-menu for “Statement format” and click “View details”. On the “Bank statement format” form, click “New”. Enter “BAI2” for the “Statement format” and “Name”. Select “AdvancedBankReconciliation” for the “Inbound port” and close the form. 
  16. On the “Bank accounts” form, select the drop menu for “Statement format”, and select “BAI2” that was just created. Close the “Bank accounts” form.
  17. Go to Cash and bank management | Setup | Cash and bank management parameters. Click the “Number sequences” tab, and select a number sequence for “Reconcile ID”, “Statement ID”, and “Download ID”. Close the form.
  18. Go to Cash and bank management | Common | Bank statements. Click “Import statement” in the action pane. Change the “Bank account” to “USA OPER”, select “BAI2” for the “Statement format”, and navigate to the location of the .txt file from the bank in the “File folder” line. Select the bank file, and click “OK”. 
  19. Click “Refresh” on the bank statements list page. Select the imported bank statement, and click “Validate” on the action pane.

NOTE: If you’re having issues getting your statement to import, we have updated the CSV->XML transform XSLT file to handle certain scenarios. This fix can be downloaded from PartnerSource or Lifecycle Services by searching for KB 2964064, or by opening a support request.



Steps


Advanced bank reconciliation is a new feature of AX2012, available from R2 onwards.


This new feature allows for the import of bank statements that can be automatically reconciled from within AX2012. This blog shows how to setup the InBound port to import and transform a BAI2 bank statement file.

BAI2 Format – File Layout:

  • Record Type: 01 – File Header – indicating the beginning of the file
  • Record Type: 02 – Group Header – identifying the group of accounts – a file may contain multiple groups, and would be followed by a 03 record
  • Record Type: 03 – Account Identifier & Summary Status – indicating the account number, activity summary and account status information
  • Record Type: 16 – Transaction Detail – as it says! Transaction detail information such as generic reference information is indicated in this record type (optional record)
  • Record Type: 49 – Account Trailer – indicating account control totals
  • Record Type: 98 – Group Trailer – indicating group control totals
  • Record Type: 99 – File Trailer – end of file indicator

BAI2 file:

  • Will only ever contain 1 record header (record type 01) and file trailer (record type 99)
  • Can contain multiple groups, where this happens the record type 02, 03, 16, 49, 98 would be repeated

BAI2 Record Formats:

Note: All of the below fields within a specific record are comma separated
BAI2 Format – File Header – 01
  • Record code - 01
  • Sender Id – alphanumeric value
  • Receiver Id – alphanumeric value
  • File Creation Date – YYMMDD format
  • File Identification Number – Unique value to distinguish files sent on the same date
  • Physical Record length – optional
  • Block Size – optional
  • Version Number – 2
BAI2 Format – Group Header – 02
Note: A group header highlights accounts from the same originator with the same as-of date
  • Record Code – 02
  • Ultimate Receiver Notification – optional, normally banks put the same value as in Receiver Id from the Header Record
  • Originator Identification – bank code or SWIFT BIC where the account being reported (in record 3) is held
  • Group Status:
    • 1 – Update – most commonly used for previous day reporting and same day reporting
    • 2 – Deletion
    • 3 – Correction
    • 4 – Test Only
  • As of Date – YYMMDD – as of date of all accounts with the group
  • As of Time – HHMM – in military format i.e. from 0000 – 2359
  • Currency Code
  • As of Date Modifier:
    • 1 – Interim previous day data
    • 2 – Final previous day – most commonly used for prior day reporting
    • 3 – Interim same day – most commonly used for intra-day reporting
    • 4 – Final same day
BAI2 Format – Account Identifier & Summary Status – 03
  • Record Code – 03
  • Customer Account Number – at the originator financial institution
  • Currency Code – optional
  • Type Code – optional* – indicates the type of balance (Summary/Transaction) being reported. - in this record type Account Status &  Activity Summary codes are used
  • Amount – optional
  • Item Count – optional*
  • Funds Type – optional*
BAI2 Format – Transaction Detail – 16
  • Record Code – 16
  • Type Code – details data type* – indicates the type of balance (Summary/Transaction) being reported. - in this record type Transaction Detail codes only are used
  • Amount
  • Funds Type*
  • Bank Reference - bank assigned reference to help identify the transaction
  • Customer Reference – as corporates, this is the field we’re interested in. It should contain our reference for reconciliation purposes
  • Text
BAI2 Format – Continuation Record – 88
If the data in any record type exceeds the physical record size, or if required for any other reason the 88 record type can be used to continue the previous record. A record type 88 can only follow a record type 03 (Account Identifier), 16 (Transaction Detail) 0r 88 (Continuation Record)
  • Record Code - 88
  • Next field
BAI2 Format – Account Trailer – 49
  • Record Code – 49
  • Account Control Total – Sum of all the Amount fields in the preceding 03 (Account Identifier) and all 16 (Transaction Detail) records
  • Number of Records – Total number of records for the account – including the 03, all 16 and 88 records and this 49 record
BAI2 Format – Group Trailer – 98
  • Record Code – 98
  • Group Control Total – Sum of all control totals in this group
  • Number of Accounts – The number of 03 records in this group
  • Number of records – The number of records in this group – including the 02, all 03, 16, 49 and 88 records, and this 98 record
BAI2 Format – File Trailer – 99
  • Record Code – 99
  • File Control Total – Sum of all control totals in the file
  • Number of Groups – The number of 02 records in this file
  • Number of Records – Total number of records in this file, including this 99 record


BAI2 File Format




The Bank Administration Institute (BAI) file format is used to electronically transmit transaction data from a bank to an organisation. Bank Administration Institute version 2 (BAI2) splits the payment amount into separate invoice references and corresponding payments. 

Note : BAI2 files are the file formats not always provided by some banking corporations, and as such bank file formats may need to be developed to suit the customer’s needs. The BAI2 file format is used here for demonstration purposes only.

The BAI2 file format is a structure text file with headers, lines and footer records. Each field is separated by a comma similar to a CSV file. 

With a multi date file format, each date must be contained within its own section, with a header and line for each section.

Sample file can be found here : Download Sample File 

Example 1 – Single date file


Example 2 – Multi date file

AIF Setup




In the AOT, under the Resources node, locate the BAI2 files. These files translate the electronic bank statements from their original format to a format that Microsoft Dynamics AX can use. 

The files that are required are called : 

  • AOT\Resources\BAI2CSV_to_BAI2XML_xslt 
  • AOT\Resources\BAI2XML_to_Reconciliation_xlst

Right-click the BAI2CSV_to_BAI2XML_xslt file, and then click Open 


In the Preview form, select XML document in the File type field.  





Click Export to generate XSLT templates and save the template. Close the form. 

Repeat the process for the BAI2XML_to_Reconciliation_xlst file.


Whilst in the development environment, click the Tools menu option and select “Application integration framework > Manage transforms” 






Create a new record, give this a name and an appropriate description, ensure that the type = “XSL”, then click load. Load the BAI2CSV_to_BAI2XML_xslt file.
Create a second record and load the BAI2XML_to_Reconciliation_xlst file.




Close the form and close the development environment.

InBound Ports




Before you can receive the BAI2 statement electronically, you must register custom services and adapters, manage operations and inbound transforms, and activate inbound ports. 

Browse to System administration > Setup > Services and Application Integration Framework 

Click New to create a new inbound port. 

In the Port name and Description fields, enter a suitable name and description of the inbound port. In the Adapter field, select File system adapter as the adapter name. In the URL field, enter a path for receiving electronic data. 




On the Service contract customisations FastTab, click Service operations to open the Select service operations form.




Add in the following bank service operations to the “Selected service operations” section.
In the Select service operations form, select the following from Remaining service operations and move to Selected service operations:
  • BankStmtService.create
  • BankStmtService.delete
  • BankStmtService.find
  • BankStmtService.getChangedKeys
  • BankStmtService.getKeys
  • BankStmtService.read




On the Processing options FastTab, select the Transform all requests check box to include inbound transforms. Then click the “Inbound transforms” button.




Click New to create a transform. Select the first of the transforms that you have already created previously.
Create a second record and add the second transform file that you have created.






These files should be in the following order to process the BAI2 file correctly. 

  1. BAI2CSV_to_BAI2XML_xslt
  2. BAI2XML_to_Reconciliation_xlst

Close the form. 


On the Troubleshooting FastTab, set the logging mode to “Original document”. 






On the Security FastTab, select the partition and company that this Inbound port relates to.




Once complete, click the “Activate” button to finish, this may take some minutes to complete. Close the forms when finished.




This completes the InBound port setup and AX2012 R2 is now ready to import and transform a BAI2 file.
Set up matching rules
You can set up reconciliation matching rules and matching rule sets to help with the bank reconciliation process. Reconciliation matching rules are a set of criteria that are used to filter bank statement and bank document lines during the reconciliation process. Using the Reconciliation matching rules form, you can select which actions and selection criteria are used when the matching rule is run during reconciliation.
Available actions include: Match with bank document – this action allows you to create criteria for how bank document and bank statement lines are matched.
Clear reversal statement lines – this action allows you to specify how reversal statement lines should be removed.
Mark new transactions – this action allow you to specify how new transactions are handled when the reconciliation rule runs.


SETUP/CONFIGURATION OF RECONCILIATION MATCHING RULES:

1. A Reconciliation matching rule should be created for the 469 Bank Transaction code that resembles the following.
SCREENSHOT469
2. A Reconciliation matching rule should be created for the 475 Bank Transaction code that resembles the following:
SCREENSHOT475
3. A Reconciliation matching rule should be created for the 169 Bank Transaction code that resembles the following:
SCREENSHOT169
4. A Reconciliation matching rule should be created for the 301 Bank Transaction code that resembles the following:
SCREENSHOT301
5. A Reconciliation matching rule should be created for the 575 Bank Transaction code that resembles the following:
SCREENSHOT575

6. Activate the reconciliation matching rules so that the Reconciliation matching rules have the Active flag marked.

7. Assign the Reconciliation matching rules to a Reconciliation matching rule set. The Reconciliation matching rule set would them resemble the following:
SCREENSHOTSET

After the Setup/Configuration of these Reconciliation matching rules that are now included in the single Reconciliation matching rule set, you can select this Reconciliation matching rule set on the Bank reconciliation journal after the Bank statements have been imported. By using the simple Setup/Configuration of the Reconciliation matching rules, you can use these Reconciliation matching rules in a manner that allows you to automatically match/create new adjustments for imported bank statements in AX
Reconcile a bank statement
After the bank statement has been imported into the Bank statements form, you can reconcile the bank statement by using the Bank reconciliation worksheet form.
On the bank reconciliation form, you will see the bank statement and the bank documents transactions listed. You can select transaction lines that match up to reconcile them.

Import The Bank Statement



Once a bank account has been set up to allow bank statement imports, the “Reconcile” group becomes available in the action pane. 



Click the “Bank statements” button to open the bank statements list page. 



The following form will be opened, click the “Import statement” button to continue.

Select the following : 
  • Bank account – Select the bank account that the statement will be imported into.
  • Statement format - Select the appropriate bank statement format.
  • File folder – Set the inbound folder where the files to be processed are held.
  • Import all files in this folder – Tick this is all files in the folder are to be imported.
  • Select file – Use this option to manually select a specific file. Reconcile after import – Select this to perform automatic reconciliation (Only if the rules have been set against the bank account).

Click Ok to continue.




When opened, the following will be displayed.



The “Net amount” and the “Total lines” fields will automatically populate when the “Validate” button has been clicked. 
The bank statements must be validated before a reconciliation can be performed.

Bank Reconciliation


After an electronic bank statement has been imported and validated in the Bank statements form, the bank statement can now be reconciled using the Bank reconciliation worksheet form. 



Note : The Bank reconciliation option is only available if the Advanced bank reconciliation check box is selected in the Bank accounts form on the Reconciliation FastTab. 



This can be performed in one of two ways : 



Click Cash and bank management > Journals > Bank reconciliation 



Or 

Click Cash and bank management > Common > Bank accounts. On the Action pane, in the Reconcile group, click Bank reconciliation.

Click New to create a new bank reconciliation record



Select the appropriate bank account, this will select the bank statements that have not yet been reconciled.



Note : Any previous un-reconciled balances will be added in to this bank reconciliation journal.



Click the “Lines” button


The reconciliation worksheet will be displayed, this worksheet is split into four distinct grids : 
  • Top left – Open statement lines – Imported un-reconciled bank statement lines
  • Top right – Open bank documents – Un-reconciled AX bank transactions
  • Bottom left – Matched statement lines – Matched bank statement lines Bottom right Matched bank documents – Matched AX bank transactions
 
The Line details FastTab will show additional line details for the selected statement line.



To match using the matching rules that have been set up, click the “Run matching rules” button.

Select either to run individual rules, or to run a set of rules.


Once run these match all transactions that meet the criteria set on the rules.

There is a one-to-many relationship between the “Matched statement lines” and the “Matched bank documents”.
Transactions can be manually matched by selecting the appropriate line(s) in both the Open statement lines grid and the Open bank documents grid, then clicking the “Match” button.

If there is a new transaction on the bank statement that does not yet exist in AX (eg bank charges), then mark the transaction and click “Mark as new”.


Once you have completed your matching process, click “Reconcile” to perform the reconciliation process.

If there are any transactions that you have marked as new, these will need to be posted. 



Browse to : Cash and bank management > Common > Bank statements, then edit the appropriate statement.
Select the line marked as “New”

On the line details FastTab, enter the appropriate financial details and financial dimension values

Then click “Post” to post the transaction.


The transaction will now have been posted and reconciled.

Cancel A Reconciled Transaction

 Individual “reconciled” bank transactions can have the reconciliation status set back to un-reconciled.
To do this browse to : Cash and bank management > Common > Bank document list 
Select the reconciled transaction, then click “Reconciliation relations”

From the Reconciliation details form, click the “Cancel reconciliation” button

Click OK to continue

The transactions will appear on the next reconciliation as un-reconciled items


The bank statement will have been fully reconciled now.