Date of Price not Working in AX 2012

(0) Share

Report

Posted on by Amir Niaz

Hi
Some one can help me when I am change base sale price its not working suppose an item(barcode AX25486) I update its price from Rs.1099 to Rs.2099 and change its date of price from 3/4/2019 to 7/30/2021 and close foam but when our IT Department Sync All Store Job in last of the day this price got update for store its not work according to given date

688636.Capture.PNG

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Xusheng on at

Like (0)

Report

Hi

Have you check the sync job upload status?

If it applied, I suggest you run below SQL to check it from the channel DB. You need replace some parameters.

ELECT * FROM crt.PRICEPARAMETERSVIEW WHERE CHANNELID = 5637144592

SELECT * FROM crt.PRICEGROUPSVIEW WHERE CHANNELID = 5637144592

SELECT * FROM crt.ITEMSPRICEVIEW WHERE DATAAREAID =N'usrt'

and ITEMID = N'0006'

declare @p2 crt.PRICEACCOUNTRELATIONSTABLETYPE

insert into @p2 values(N'Mall')

insert into @p2 values(N'RP-Houston')

declare @p3 crt.STRINGIDTABLETYPE

insert into @p3 values(N'0006')

exec [crt].GETALLPRICETRADEAGREEMENTS @bi_ChannelId=5637144592,@PriceGroups=@p2,@ItemIds=@p3,@Customer=N'',@MinDate='2021-07-28 00:00:00',@MaxDate='2021-07-28 00:00:00',@nvc_CurrencyCode=N'USD'

Hope this can help you. Another suggest is log a service request to double check with Microsoft support team.

If you have no more questions, please mark as "Verified" if the answer is helpful. Thanks in advance.

Was this reply helpful? Yes No