Dynamics AX: Vendor & Customer Name Change History

This post will help you view Dynamics AX name change history. Business partners (vendors & customers) occasionally change names which can generate questions internally on how to handle, either changing the name in the existing vendor and maintain history, or create a new vendor with the new account and start fresh. If you choose the former option you might be concerned about losing history with the vendor’s prior name.  You should note that Dynamics AX does have the ability to see the history of business partner names changes.

You can inquire on the history by:

  1. Navigating to the master file, either Customer or Vendor
    • Accounts payable/Common/Vendors/All vendors
    • Accounts receivable/Common/Customers/All customers
  2. Select and open a particular business partner record. Note, it is not necessary to “Edit” the record.
  3. In the form, right click on the name field and choose “History”.

Dynamics AX Name Change History

The screen that opens provides a name history for the record in addition to providing the name of the user who made the change and the date of the change.

Dynamics AX Name Change History

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

 

 

 

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