Adeel Rehman's Blog

All about what's going around me…

Bank Reconciliation

leave a comment »

Bank Account Reconciliation

Following steps needs to be performed to reconcile a bank account.

  • Go to Cash and bank management module, click Common > Bank accounts.
  • Select bank account to reconcile.
  • Click the Account reconciliation button on the Action Pane
  • In the Bank statement date field, enter the date from the bank account statement.
  • In the Bank statement field, enter the number of the bank account statement.
  • In the Ending Balance field, enter the total ending balance on the bank account statement.

Perform following steps to review transactions.

  • Click the Transactions
  • Select the transactions to include in the reconciliation by selecting the Cleared check box.

There may be few transactions that appear on bank statement but have not been recorded in the system. Perform following steps to create such transactions.

  • Click New
  • Select the correct transaction type in the Bank Transaction Type
  • Enter the date of the transaction in the Date
  • In the Amount in transaction currency field, enter the transaction amount in the specified currency.
  • In the Main Account field, indicate which ledger account the system should offset when you create the new transactions during reconciliation. The corrections post when you update the reconciliation.
  • In the Description field, enter information that describes the transaction.
  • On the Financial dimensions tab, enter any required dimensions for the transaction.

After you have reconciled the transactions, click the Reconcile account button (it enables only when Un-reconciled box shows 0.00) to perform the reconciliation of the Bank Account.

To print the reconciliation report:

1- Click Print > Reconciliation summary: This is to print a bank reconciliation report. In the Bank reconciliation form, select the fields to include in the report.

2- Click the Print > Bank reconciliation to print a report that takes non-reconciled transactions into account and shows transactions after the reconciliation date

 

Written by Adeel Rehman

March 1, 2016 at 4:39 PM

Posted in Dynamics AX

Dynamics AX – Post Dated Checks

leave a comment »

Post Dated Checks – Setup & Steps

Dynamics AX 2012 R2

Here we are going to have a look on how to Setup postdated checks (PDC) in MS Dynamics AX 2012 and what would be the Steps that needs to be followed by end user for posting them.

Setup:

First we need to enable it from Cash and bank management module

  • Go to Cash and Bank management
  • Go to Setup > Cash and bank management parameters
  • Select Postdated checks
  • Check on Enable postdated checks, once this check is enable postdated checks to vendor and from customers can be tracked.
  • If user would like to post financial transaction of postdated checks to clearing accounts then enable “Post journal entries for postdated checks”. Rest of the fields gets enabled with this one.
  • Mention account number in Clearing account for issued checks (for checks issued to vendor) and Clearing account for received checks (for checks received from customers).
  • Select journal in General Journal for clearing entries which would be used to settle postdated checks transactions. (To set it up Go to GL > Setup > Journals > Journal names)
  • Select vendor payment journal to transfer postdated checks transactions in Transfer postdated checks to this vendor payment journal
  • To post withholding tax on vendor payments, select a clearing account in Withholding tax clearing account

PDC1

Secondly we have to create PDC Payment methods in Accounts Payable and Accounts Receivable for vendor and customer payments respectively.

Accounts Payable

  • Go to Accounts Payable
  • Go to Setup > Payment > Methods of payment
  • Create New method for PDC, enter values in required fields as desired.
  • In General > Posting select Bank in Account type
  • Enable Bridging posting and then enable Postdated check clearing posting
  • Bridging account should automatically pick the account from Clearing account for issued checks from Bank and management setup.
  • In Payment control please confirm that Offset account has the type bank is not enabled.

PDC2

Accounts Receivable

Steps remain same in Accounts Receivable PDC payment method, only Bridging account would be picked from Clearing account for received checks from Cash and bank management module.

PDC3

Steps

Now we are done with all the necessary setup, let us look at the steps for posting postdated checks.

Account Payable

  • Create New Payment Journal and open lines form.
  • Enter necessary details and select PDC-Vendor in Method of payment.
  • In Offset account system should automatically pick the account defined in Bridging account field.

PDC4

  • Move to Postdated checks tab, notice that fields on this tab are enabled.
  • Enter Maturity date, Received date, Check number and any other information if required.

PDC5

Following would be the voucher entry when we post it. Notice the posting on clearing account.

PDC6

Now postdated checks are posted and resting in clearing account until maturity date reaches and user settle them. User can go to Accounts Payable > Common > Postdate Checks > Vendor Postdated checks to check the list of all postdated checks.

PDC7

Look at the Maturity date column, user can click Filer button Checks to send to bank, to filter the list and to show only checks that reaches maturity date. It helps user to quickly find and process checks.

When Maturity date reaches, click Settle clearing entries, this will update the check status from Posted to Paid and posts a General journal for this clearing entry.

Account Payable

  • Create New Payment Journal and open lines form.
  • Enter necessary details and select PDC-CSTMR in Method of payment.
  • In Offset account system should automatically pick the account defined in Bridging account
  • Move to Postdated checks tab, notice that fields on this tab are enabled.
  • Enter Maturity date, Received date, Check number and any other information if required.

Now postdated checks are posted and resting in clearing account until maturity date reaches and user settle them. User can go to Accounts Receivable > Common > Postdate Checks > Customer Postdated checks to check the list of all postdated checks.

Look at the Maturity date column, user can click Filer button Checks to send to bank, to filter the list and to show only checks that reaches maturity date. It helps user to quickly find and process checks.

When Maturity date reaches, click Settle clearing entries, this will update the check status from Posted to Paid and posts a General journal for this clearing entry.

Written by Adeel Rehman

February 26, 2016 at 12:13 PM

Posted in Dynamics AX

Tagged with , ,

Haleji Lake – Bird Watch

leave a comment »

jheel3 Haleji – An Introduction

Once named Asia’s largest bird sanctuary ‘Haleji Lake’ is situated 70 Km from Karachi in Thatta district of Sindh. Total area of the lake is about 19 Km with main water reservoir of about 11 Km2. The Government of Sindh provided a legal cover to preserve ecology of the region and declared Haleji as wildlife sanctuary.

In winter, between November to February thousands of Siberian migratory birds visit this place, making it a paradise for bird lovers / bird watchers. This lake is home of divers, dabblers, surface, deep water and fresh water lover birds, around 200 bird species has been recorded in surrounding of Haleji Lake. Some crocodiles, snakes and wild cats are also available in the area.

jheel4
Activities

Pakistan Avicultural Foundation planned a day out trip of Haleji Lake with an objective of watching the native and migratory birds. The visit was only possible with the great help from The Wildlife Department of Sindh, we really appreciate their efforts despite various socio political pressures and thank full for giving us the permission for the visit.

 

We a team of enthusiasts start our Journey at 3:45 Am to reach the site before sun rise so that we can capture early morning bird’s activities that just started fleeing and the ones swimming in the Right Bank Outfall Drain (RBOD). Moon3
 

We explored the lake, RBOD and surrounding area after having breakfast and found various species of migratory birds that were captured beautifully by the well-equipped photographers accompanied us.

Bird32
 

Booting facility was also available our team capture mangrove and birds activity with in them while boating.

ppl7
 

Followed by Lunch we watch captive breeding area where different species of birds as well as crocodile were present.

CapDuck15
 

Team also got a chance to release wild birds recovered from poachers by wild life department from adjacent areas.

birdfly8
 

A short lecture by a wild life personal was received to create awareness about captive breeding, issues they are facing, history and future plans.

SindBird4
 

Findings

We learn that the water in/out flow in lake is almost negligible which leaves worst impact on the flora and fauna resulting decrease in the population of birds and other species.

 

Shortage of fund was also found that can be utilized for the maintenance and new development.

 

Found large number of trees with hollow trunks that were used as fireplaces.

 

A project of improvement and rehabilitation of Haleji lake is in progress by Sindh wildlife department with the financial support of partnership fund.

bird9

fly4

greenbird6

TreeBird2  

Final Note

Ecosystem of Pakistan is facing a great danger and threat due to various human acts. Now is the time to take action at our part being rational civic mind to Preserve, Conserve and maintain that specific part of ecosystem, flora and fauna within the ecosystem.

 

Written by Adeel Rehman

February 20, 2016 at 12:04 AM

Posted in Birds Watch, Tafreh...

Dynamics AX 2012 – Enterprise Search

leave a comment »

Dynamics AX 2012 – Enterprise Search

MS provides this functionality to search data, metadata and documents attached to records. User can search customer name or number or phone number also user can search nouns like customer or cash flow report.

To use this search one need to deploy enterprise search, it uses the enterprise search feature of SharePoint, so one need to install and configure SharePoint first. Do check the details on: http://technet.microsoft.com/EN-US/library/gg731880.aspx

It is required to configure which data should be available for search so it is required to set the searchable property to true for those queries that should be indexed and available for search. For details: http://technet.microsoft.com/EN-US/library/hh500181.aspx

Written by Adeel Rehman

July 31, 2013 at 8:19 AM

Dynamics AX 2012 – How to import data using office Add-in

with 4 comments

Dynamics AX 2012 – How to import data using office Add-in

In AX 2012 MS provide a very easy way to import data into AX through office Add-in. Following are the step by step procedure:

Take the example of chart of accounts:

1-      In MS Excel, select Dynamics AX tab.

2-      Click Add Data > Add Tables, this will open a dialog displaying AX tables. Here you must know the table names in which you would like to import the data.

3-      In our case we select MainAccount (Chart of Accounts)

Import1

4-      Click OK.

5-      This would show MainAccount table on left side of excel sheet as mentioned below and by default added al the mandatory columns on Excel, like:

Import2

6-      User can add desired filed by drag and drop in our example we are adding Reference ID (can be seen in next screenshot) which refers to Main account category.

7-      Once done by adding columns (fields), click Fields button, this will hide the Main account fields from left and enable other links. System will refresh the form on clicking Fields button so please do not add data before clicking it.

8-      Click Refresh it will start displaying the data that already exist in AX in the selected table. Can be seen in blue circle in next screenshot, this step is not required by the way.

9-      Enter data that you would like to import, in our case we enter following values: can be seen in green circle in next screenshot.

  1. Chart of accounts: COA
  2. Main account: 110110
  3. Name: Bank Account – USD
  4. Reference ID:  1 (Note: reference id 1 is Cash in my case)

10-   Save the sheet and click Publish.

Import3

11-   It will start processing and once done user can see a sheet “Dynamics AX Status” with results, it provide the log of the import if there is an error or success.

a- Success Message

Import4

b- Failure Message

Import5

Written by Adeel Rehman

July 26, 2013 at 8:01 AM

Partition in Dynamics AX 2012 R2

leave a comment »

Partition in Dynamics AX 2012 R2

Concept:

Not to share data among partitions, a holding company having multiple subsidiaries which don’t like to share data of one subsidiary to the other can use this option.

How to Create Partition:

To create a new partition, go to System administration > Partitions, enter Partition Key & Name, close the form.

Image

Note: When the AX install first time it creates default partition with the name Initial and it opens in this partition.

How to change the Partition:

To change the partition and open AX in new partition it is required to edit client configuration and enter the name of newly created partition in the partition field on General tab. Save the changes and now open AX it open up new partition.

Image

Written by Adeel Rehman

July 22, 2013 at 11:20 AM

Posted in Dynamics AX

Tagged with , ,

Untethered a tethered 3GS iOS 5.1.1

leave a comment »

If you follow my previous blogs to upgrade to iOS 5.1.1, you must did a tethered upgrade that means when ever it is required to restart the device you have to do it with redsn0w. Now there is no need to do so, you also do not need to restore your device for this. Just follow the following steps to convert your tethered device running iOS 5.1.1 into an untethered one.

Steps:
– Open Cydia on your device.
– Go to Search tab and search for “Rocky Racoon 5.1.1 Untether” and install it.
– Now reboot your device to verify that.

Written by Adeel Rehman

June 11, 2012 at 9:06 AM

Posted in iPhone

Tagged with , ,