Hi,
Recently a we added a new set of price lists. Price List Inquiry now shows the current price list at the bottom of the TreeView where as previously in all other years the new price list shows at the top. I am trying to understand how the tree view sorts, but yet I am unable to understand it. I have looked at indexes in SQL to see if there is any correlation, but I can’t see any correlation. It does not appear to be alphabetic on the description of the price list id.
Mark,
Thanks for the information. In this instance I don’t think it applies.
We are on 9.05.701 The form has bindings to PriceListInquiry which I am assuming is a dataset created in the assembly, There appears to be no physical table involved. Our CustomerPriceLst table has no records as we do all our price lists via customer groups.
the treeview is usually bound to a dataview - I had to do this customization to the “New PO Suggestions” screen for out buyers:
// Custom code for POSuggEntryForm
// Created: 5/4/2015 9:29:10 AM
// **************************************************
using System;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Windows.Forms;
using Erp.UI;
using Ice.Lib.Customization;
using Ice.Lib.ExtendedProps;
using Ice.Lib.Framework;
using Ice.Lib.Searches;
using Ice.UI.FormFunctions;
public class Script
{
// ** Wizard Insert Location - Do Not Remove ‘Begin/End Wizard Added Module Level Variables’ Comments! **
// Begin Wizard Added Module Level Variables **
private EpiDataView edvSugPoDtl;
private EpiDataView edvMtlSug;
// End Wizard Added Module Level Variables **
// Add Custom Module Level Variables Here **
public void InitializeCustomCode()
{
// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **
// Begin Wizard Added Variable Initialization
this.edvSugPoDtl = ((EpiDataView)(this.oTrans.EpiDataViews["SugPoDtl"]));
this.edvMtlSug = ((EpiDataView)(this.oTrans.EpiDataViews["MtlSug"]));
edvSugPoDtl.dataView.Sort = "Name, PartNum, OrderByDate";
edvMtlSug.dataView.Sort = "Name, PartNum, OrderByDate";
// End Wizard Added Variable Initialization
// Begin Wizard Added Custom Method Calls
// End Wizard Added Custom Method Calls
}
public void DestroyCustomCode()
{
// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Object Disposal' lines **
// Begin Wizard Added Object Disposal
// End Wizard Added Object Disposal
this.edvSugPoDtl = null;
this.edvMtlSug = null;
// Begin Custom Code Disposal
// End Custom Code Disposal
}
private void POSuggEntryForm_Load(object sender, EventArgs args)
{
// Add Event Handler Code
edvSugPoDtl.dataView.Sort = "Name, PartNum, OrderByDate";
edvMtlSug.dataView.Sort = "Name, PartNum, OrderByDate";
}
So revisiting this it appears that in E9 and E10 you can change the order of the price list in the group, by using the Move Up and Down buttons. I obviously was going blind. This affects the display in price list inquiry.
I have picked up a couple of different things between E9 and E10:
In E9 price list inquiry it will show ALL price lists the part is on, based on the customer and the price defaults to the part price in the price list (try saying that fast a few times!) which is at the top of the list in the Customer Group Maintenance Price lists tab (see above). E10 only shows the active price list based on the current date of the client. So the only price list will show will be the one the client date is between the Start and End date of the price list. If the client date is outside all available price lists then the Part Master shows.
In both cases the price master never gets shown if the part exists on a price list. It only shows if the part is not on any price list. I would have though that you would want that to display by default as it is an inquiry form so the user can perform some what if analysis.
Another thing in E10 (at least in the education db 10.1.600.6), If you try using Addison as the customer and 00M1 as the part you will find that the base price for BX gets calculated to 239.99 even though the price of a BC is 10 and there are 24 EA in a BX. Not really sure what is going on there, but I am going to log a case.
Any feedback appreciated. Do many people use Price list Inquiry? As always I hope someone finds the information useful.
Sometimes it’s the obvious things Simon. I was so sure you’d already checked the Customer Maintenance list I too didn’t even consider it something to ask you.