Description |
* Issue
** No Records
* Requirements
** Reviewed vyuSTItemsToRegister and found the following changes
*** Adjust tblICItemSpecialPricing from an INNER join to a LEFT join.
**** Not all UPCs will have Special Prices (Sale Prices)
*** May need adjusted in other places
** Confirm pricing from what field goes into price export
*** When Special Price does not exist or is not in effect
*** When Special Price does exist and is in effect
** Review Performance of vyuSTItemsToRegister
*** Took 5:27 to run view directly via SQL on less than 7k records.
**** Took < 1 second to run for everything but the where time stamps.
*** Expect Pricebooks to be 10k per store, and it would be common for records to exceed 100k for mid size customers.
|