I've scoured the internet for info on this, but struck out for the most part. First let me say I do not know SQL so please no answers with code as it is all gibberish to me. Second I know the reason why the default smartlist is not working is because we do not run Year-End Close on our purchasing module each year.
I am just trying to find a quick easy way to build a smartlist that will help me find our YTD spend with each vendor. Since we do not close our purchasing module each year the default currently only pulls the LIFE spend even though it says YTD. They only place I have found that I can easily find this info is in the Vendor Yearly Summary Inquiry, but this only pulls for one vendor at a time. I need it for every vendor.
If I could get some help finding a relationship key that will reference fiscal years compared to vendors paid amounts. That way I can input the FY to be searched and it will generate the FYTD spend for each vendor. Basically if someone could tell me how the Vendor Yearly Summary Inquiry pulls the correct information for one vendor and apply that same logic to a smartlist, I will be so appreciative. This will ultimately prevent me from having to run each of our 5,218 vendors through this inquiry feature.