#TipADay: Updating Price in AX 2012

Now we will discuss a small but yet an important concept of AX 2012 that is ‘updating price with maintaining history of all prices’ . The purpose of using trade agreement over base price is to record and update pricing items including both product and product masters, for transactions.

For this create a new trade agreement for selling price from navigating through Sales and marketing > Journal > Price/ discount agreement journal.

now create a new journal

Add lines, validate and post the journal.

Capture1

User can update price of any particular item number of times. Now perform following steps:

1. Create another trade agreement for updating prices, go to lines go to Select option.

Capture2

2. Mark Prices in relations, select either All in customers/ vendors or select table to select customer/vendor from the drop down or select group to select price group against which trade agreement was previously created, then click on Select at bottom.

Capture3

3. Previously created line will appear in the trade agreement lines, copy line from the menu, another line will appear, close your previous line by providing To Date, to expire that price.Capture4
Now provide From Date and provide new price in Amount in Currency field in your newly copied line.

Validate all lines, post the journal, run jobs and check new price at POS or Sales order, further view Trade agreement or sales prices in sell tab of particular item, which provides complete history of previous and new priceCapture5

I hope this short tip will help you :)

 

About the author

Yumna Rehman Khan is a young and bright business analyst, aspiring to become a consultant for Microsoft Dynamics AX. Professionally, Yumna (often called Yum) has six months of experience working on Oracle EBS including financial modules like General Ledger, Account Payable and Accounts Receivables. An ACCA Finalist, her keen areas of interest are Supply Chain and Retail, other than completing her formal studies.

Leave a Comment

Name (required)
Email (required)
Comment (required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>