Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Kristen Hosman]

Does anyone know what table the highlighted information below is in?  The rest of the information in this window are in tables IC10401 & IV10402 but I really need the as of date information.

——————————
Kristen Hosman
Accounting Manager
PlatinumCode
Pine CO
——————————

[Andrew Collins]

Kristen,

This is what the GP documentation has to say on the fields in the “Base Adjusted Price On” section of that window.

This selection will not be saved; it is for inquiry purposes only. For example, you might want to see a value off the base price at a future date, or you might want to see prices for a customer who receives discounts from a price book other than the base book.

I’m not 100% sure exactly how this functions, but I would guess it is used in some temp table that populates the Adjusted Price field in the grid just below that section in the window.  At any rate, it is definitely not stored anywhere once you close the window, and I notice it keeps populating with the GP System Date each time the window is opened.

——————————
Andrew Collins
Senior Consultant
Socius
Dublin OH
——————————
——————————————-

[Frank Heslin]

Hi ,

FWIW, the only table that I could find “As of Date”, related to inventory, was in IV70500, which is the Inventory Report Options table.  So it sounds like idea of a temp table is most likely what is happening.

Just curious, what is it you’re trying to report on?

——————————
Frank Heslin
Financial Systems Administrator
ExamWorks, Inc.
Atlanta GA

Member, GPUG Advisory Committee
Chairman, Georgia Regional GPUG Chapter
Summit Track Leader
GPUG All Star 2016

GP2015 R2
MR CU14

Follow me on Twitter: @Automate_It

GPUGGA – http://www.gpug.com/Atlanta

*** Help Us, Help You…provide enough info so that we don’t have to ask for more:) ***
*** If you solve your issue please share the solution to assist others! ***
——————————
——————————————-

[Kristen Hosman]

Hi Frank.

Sales Manager would like to be able to pull a report with the items on a price sheet that would show this date.  Our theory would be that this date would tell us when that item was added to the price sheet.  Since the price sheet may have a different start date this was one way I was thinking of getting this information. ..but maybe I can’t. 🙁

——————————
Kristen Hosman
Accounting Manager
PlatinumCode
Pine CO
——————————
——————————————-

[Windi Epperson]

Kristen,
This one peaked my interest so I did some digging.  I found this in the help manual:

6. Use the Base Adjusted Price On options to verify the effects of price adjustment.

This selection will not be saved; it is for inquiry purposes only. For example, you might want to see a value off the base price at a future date, or you might want to see prices for a customer who receives discounts from a price book other than the base book.

So the fields in that entire box are not saved, just used for “what if” type inquires.  
But… I added a window note and was able to create a SmartList to pull it (from table SY0700).  Only problem is that since it’s a window note, it’s not price sheet specific.  I did add 2 lines of notes to reflect different price sheets, but that could be cumbersome if you have a lot of sheets – and tough to parse.

So I really don’t have a good answer – other than confirmation that what you want to report on isn’t saved – just some interesting digging.  If by chance you’re an eOne customer, you could use their Extender product to add an extra field to that window for easy reporting.
Thanks
Windi

——————————
Windi Epperson
President/GP Senior Consultant
Advanced Integrators, Inc.
Norman OK
405-946-1774 Ext 102
——————————
——————————————-

[Andrew Collins]

Kristen,

One final thought from me on this, based on what you are trying to accomplish.  I have in the past used a SQL Trigger to track INSERT, UPDATE, and DELETE actions on a specific table.  You definitely want to be sure this isn’t something that is going to hurt performance.  I think you should be okay in this case because these aren’t daily transactions you are tracking, just price setup changes being made as needed.

——————————
Andrew Collins
Senior Consultant
Socius
Dublin OH
——————————
——————————————-

[Kristen Hosman]

Thank you all for your input.

we are an eOne customer for SmartConnect but I will looking into Extender for sure.  That may solve all our problems.

——————————
Kristen Hosman
Accounting Manager
PlatinumCode
Pine CO
——————————
——————————————-