Sale Price Formulation
The generic inquiry link to get the customer pricing is really helpful. I had a try following the scripts in the GI, however, i got this error when running the query.
'Index(zero based) must be greater than or equal to zero and less than the size of the argument list'.
I suspected few things:
1. Date in DB = dd/mm/yyyy -> thus i have changed to this format -31/12/2020
2. Not using location for 'shipto' - thus i have removed the relationship
3. I am wondering how to get this condition into the script (as per attached). for table relation between InventoryItem Left PriceCustomerPriceClass
*Unable to find Location.CPriceClassID (as not within the table relationship?).
Thank you so much in advance.
Actually, I didn't realize that's what you were asking, but, as far as I know, it doesn't store it. But I would think that would be a really light customization if you want to capture it.
I'm just not sure though that you could cleanly drill into the Sales Price Worksheets screen. My impression has always been that the Sales Price Worksheets screen dumps everything into the Sales Prices screen which isn't really aware of the Sales Price Worksheet at the end of the day.
Hard to tell why you are getting that error.
One thing you might try though which I find useful when troubleshooting a Generic Inquiry, go to HELP -> Trace in the upper right-hand corner. It should show you the SQL that is being used. If you take that SQL and paste it into SQL Management Studio, the error message might make more sense and it will be easier to troubleshoot the SQL query. Then you can take what you learn and apply it to the Generic Inquiry.