@garrett-occhipinti that is strange, I'm afraid I'm no help. Very interesting it would pull data for negative inventory adjustments but not positive.

Are you certain that the Unit Cost is a calculated field? Have you checked your 2nd line item to be sure the cost is not set to zero?

@wyatt-erp That worked! I was getting close, was already working with the switch and datediff functions. Thank you!

@timrodman Tim I dropped your name and augforums.com in a video shoot for Acumatica's keynote presentation on Monday morning of the Summit. Hopefully...

@nperez you are the greatest! Thank you so much! That worked perfectly! Now if I could only change 01 -12 to display as the month names. But that'...

@nperez because I want the years to overlay over the top of eachother. I wish this would work, thanks for the post.

My name is Jacob Anderson, I am the CFO/CIO/Purchasing Officer/Tech Executive, etc. of a manufacturing company in American Fork, UT TRA Snow & Su...

Tim, I love what you have built! Thank you for your work. My name is Jacob Anderson, I am the CFO/CIO/Purchasing Officer/Tech Executive, etc. of a m...

Good suggestion, I would use CDec instead of CInt, unless you are only working with whole numbers. Cint will round your figure to the nearest whole n...

Kelly, thank you for the input. That did not work either. But I found the problem. Sometimes you just need a break and some shuteye for the old tic...