Year-End Closing Webinar for Dynamics AX

Tridea Partners will move you forward with year-end closing in Microsoft Dynamics AX.

Proper planning and understanding is key to enable a successful year-end close process. Please join our webinar as we go through the general steps of the year end close process and discuss key items that will be required to setup the next fiscal year.

Presenters: Matthew Caffrey & Thomas Nguyen – Tridea Partners

Event Details: January 19, 2016 at 10:00 AM PST

This is one of our most popular webinars. Don’t miss it!

register here

Dynamics AX 2012 – Hold Payment on Individual Invoice

When processing vendor invoices for purchase orders, you may want to delay payment on a specific vendor invoice but still need to post the invoice to capture the liability to the vendor. If you do not want to place the vendor on hold for all payments, only for a specific invoice, Microsoft Dynamics AX 2012 allows you to enter an ‘Invoice payment release date’ on the vendor invoice before or after posting of the invoice. This will prevent the payment from being processed until the Payment release date specified for the invoice.

Place a vendor invoice on hold for payment before posting

Create the vendor invoice for a purchase order using the standard procedure

On the Vendor invoice tab on the Action pane, click Header view

Expand the Approval fasttab

Enter the Invoice payment release date

(Optional) Enter a Release date comment

AX 2012 Hold payment on individual vendor invoice for a purchase order

Submit the vendor invoice to a workflow for approval or post the invoice. Once the vendor invoice is posted, an Invoice payment release date can be added or updated on an invoice by navigating to the Vendor transactions form.

Place a vendor invoice on hold for payment or update payment release date after posting

Navigate to the vendor record [Accounts payable>Common>Vendors>All vendors]

Select the vendor record

On the Vendor tab on the Action pane, click Transactions

On the Vendor transactions form, select the Invoice line

Click the General tab

Enter or update the Invoice payment release date

AX 2012 Hold payment on individual vendor invoice for a purchase order

When a payment proposal is generated, the invoice will not appear for processing if the date range of the payment proposal only includes the Due date and not the Invoice payment release date.

AX 2012 Hold payment on individual vendor invoice for a purchase order

As an example, the Invoice posting date is 10/15/2015 with Payment terms Net30. The Due date is calculated as 11/14/2015. An Invoice payment release date of 11/30/2015 was entered for the invoice.

If a payment proposal is generated with ‘To date’ = 11/14/2015, the invoice will not appear in the payment proposal form as the Invoice payment release date is not within the payment proposal date range.

If a payment proposal is generated with ‘To date’ = 11/30/2015, the invoice will appear in the payment proposal form for processing.

Additionally, if a payment journal is created using the ‘Settlement’ function, the Invoice cannot be selected (marked) for settlement if the posting date for the payment is before the Invoice payment release date. The Invoice payment release date would need to be modified on the Vendor transactions form before a payment can be processed for that vendor invoice.

AX 2012 Hold payment on individual vendor invoice for a purchase order

This post was written by Robin Ellsworth, AX Application Consultant at Tridea Partners. Tridea is a leading Microsoft Dynamics provider.

 

Microsoft Dynamics AX – “Fixed Asset Statement”

The “Fixed Asset Statement” report in Dynamics AX  is actually a roll-forward report. It’s a good report, but in my opinion it has one limitation in that there is no way to run it with asset detail.  With that said, it’s very easy to setup and run and is still a valuable report.

The report is setup by defining the rows. There are 2 types of rows:

  • A “Header” row which is a free text field that appears on the report.
  • A “Total” row is a range of assets that will be totaled on the report with a free text description. These will be your asset groups, computers, machinery and equipment, etc.

Something to seriously consider when setting up your fixed assets is using a unique number sequence for each fixed asset group. I think most AX implantations are done this way anyway, but without it you will not be able to define your asset groups into a row.  If this is not clear why this is important, it will become apparent as we setup the report.

Defining the rows

Navigate to Fixed assets> Setup> Fixed asset statement rows

  1. To enter a new row, click “New” and enter a description in the “Row name” column and then select the “Row type” by clicking on the drop down. Continue this process until your report rows have all been entered.

Fixed Asset Statement

2. For the “Row types” you entered as “Total”, you will now need to define the assets to be totaled in those rows.

  • Click on the row to define and click “Totals”.
  • A new window will open with columns that define the “From“ and “To” range of assets. Use the drop down arrows to select the asset numbers to be included in the range. To add multiple ranges, click the “New” button. This is why a number sequence by asset group is important!

AX Fixed Asset Statement

 

Checking the report content

Although this report cannot be run by asset, there are a couple of built-in reports that are helpful to ensure that the report rows you’ve defined are complete.

Navigate to Fixed assets> Reports> Base data> Fixed assets in fixed asset statement rows

This report will provide a listing of all assets included in the selected row of the fixed asset statement report.

  1. At the reports parameters screen, click the drop down menu on the “Fixed asset statement row” line and select the row to include in the report.

AX Fixed Asset Statement

Here’s a sample of the “Fixed assets in fixed asset statement rows” report.

AX Fixed Asset Statement

Navigate to Fixed assets> Reports> Base data> Fixed asset statement rows

This report will provide a summary listing of the rows included in the report. It will also provide a list of assets not covered in the report.

  1. At the reports parameters screen, click the check box “Show fixed assets not included” and then click “Ok” to run.

AX Fixed Asset Statement

Here’s a sample of the “Fixed asset statement rows” report.

 AX Fixed Asset Statement

Run the Fixed Asset Statement

Navigate to Fixed Assets>Reports>External>Fixed asset statement

  1. At the parameters screen enter the fiscal period start date (must be the first day of a fiscal period) and the end date. The end date can be any date in the fiscal period i.e. the end of a quarter.
    • Under the “Value models” section, you can filter for specific value model or posting layer if desired.

AX Fixed Asset Statement

Here’s a sample of the “Fixed asset statement” report. (This is a landscape report so I’m going to post it in 2 screen shots.)

AX Fixed Asset Statement

AX Fixed Asset Statement

This post was written by Matthew Caffrey, AX Application Consultant at Tridea Partners. Tridea is a leading Microsoft Dynamics provider. www.trideapartners.com

 

Upcoming Tridea Webinar with Solver’s BI360!

Overview: BI360
The Complete Business Intelligence Suite for Dynamics

Wed, October 28, 2015 10:00AM – 11:00 AM PT

  • Do you struggle with creating Dynamics GP or Dynamics AX reports easily?
  • Would you like your Reporting solution to be both Excel and web-based?
  • Are there more data sources you would like to report on that seem out of reach? (payroll, legacy systems etc.)
  • Is your budgeting process time-consuming and reliant on static spreadsheets?
  • And would you like to streamline your budgeting process?

If you answered YES to any/all of the questions above, join us for our October webinar for a demonstration on improving your Reporting and Budgeting with BI360. Learn how you can help your organization make informed decisions and simplify your Business Intelligence needs with BI360.
http://www.solverusa.com/products/

Presenter: Alex Geller, Solver, Inc.

Webinar Date & Time: 
Wed, Oct 28, 2015
10:00 AM – 11:00 AM PT

Please register for this event by October 26th

register here