How do you find a history of trade agreement price changes

(0) Share

Report

Posted on by Sue Glass

Hi all, I am brand new to Dynamics AX and the community. I have been using a training module of AX to learn how to create and modify trade agreements for purchasing. I have found some very useful information on the forum, but here is my specific question:

After I post changes to the price of a product in a trade agreement, when I look at the purchase price for the product in the Product Information Management page, it just shows the latest price that I just added. If the trade agreement price is changed every month, then how can I look at the history of the prices at some later date?

On a possibly related note, when entering a new journal, is it helpful to make the description very specific, i.e., Item GR0002 General Electric 8-23-2013; or is it ok to leave it rather vague, i.e., GE price update? In other words, are the descriptions ever useful?

Thank you for whatever help you can provide on this topic. If there is already a thread on this topic, please let me know.

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Brandon Wiese 17,788 on at

Like (0)

Report

Hi Sue,

First, you should always consider the potential use of Database Logging as a means of tracking the insert, delete, and update of any record type in the system. For example, once activated for the Trade agreement table (PriceDiscTable), any change to a specific record in that table will leave an excellent audit trail, showing each individual field that was changed (before and after values), and who made the change. Of course you can always activate the "last modified when and by" fields on any table, but Database Logging obviously shows a more complete trail than just the last operation. Since they work system-wide, they are features to consider and understand as general tools, to be tempered with their potential performance impact on highly active tables (InventTrans, for example, would not be a good idea).

However, in the specific case of Trade agreements, you can use the built-in effective/expiration date nature of the records themselves to accomplish a similar form of audit trail, and in a more useful way. For example, when you pull a set of existing records into a Price/discount journal to post an update, you can expire the original records as of a given date, and then copy those records into the journal, make those newly copied records effective the day after the other ones expire, and then alter the prices as needed (or even in one operation, as in add 5%). Then posting the price/discount journal leaves the original records in place now expired and creates the new records, all in one action. Some companies simply re-use the same records over and over, but using trade agreements in the way I have described offers some advantages. First, the audit trail is automatic and complete (as long as you never delete records except to eliminate true mistakes), and second you can post changes to become effective at a future date without any future effort. When entering orders (both sales and purchase), the date which is used to find effective trade agreements can either be the order date or the delivery date, as controlled by sales and purchase parameters respectively.

In terms of inquiry, from the released product you can go directly to sales and purchase trade agreements, and see the entire collection of records which form the audit trail. I would recommend not trusting or even using the last purchase price field on the released product.

You can, of course, be as descriptive or brief with your journal descriptions as you like. They either will or won't help you to locate a journal you might be interested in later depending. I usually recommend once a journal is posted that any physical paperwork (price increase notice or schedule from the vendor) be scanned and attached directly to the journal header using Document handling. There's simply no better way to justify what and why a journal is posted than to see the original piece of paper that was in hand at the time you did it.

Good luck. Hope this helps!

Was this reply helpful? Yes No
Sue Glass 70 on at

Like (0)

Report

Thank you Brandon,

Your answer certainly did help, and it conjures up more questions.

Let me ask you this, if you pull an existing record into a journal and do not make a copy of the line but make changes directly to the line, including dates and prices, and then post it, that is not the proper way to do it if you want to have an audit trail? You would follow this procedure if there was a mistake in that particular posting? This example would be what you consider re-using "the same records over and over"?

I get from what you are saying that I want to expire the current post by just changing the end date, copy it and update the copy with new price and dates. In this way, when I look at the trade agreements for a particular item, I will see all of the past postings. In the example above, I will only see one posting because I would keep overwriting it each time?

This brings up another question. Some of our suppliers give us a price list with starting dates, but no end dates. The price stays the same until we receive a notice from the supplier that an item is changing price. In this type of circumstance, is it best to leave the end date open when posting the original price, or the newly updated price, since I will have to give it an expiration date when the change comes in? And then if the price remains the same for months, I don't run the risk of arbitrarily choosing an end date that comes to soon? Also, this would make it easier, when viewing the trade agreements for the product, to know which one is the current price as it would have a blank end date and that would stand out on the list.

Thanks again.

Was this reply helpful? Yes No

Community site session details

How do you find a history of trade agreement price changes

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

How do you find a history of trade agreement price changes

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates