Sage 100

We use FIFO and item costs can vary depending on when we buy them, I need to be able to calculate the cost of an item based on the cost tier. I looked on ARINVOICEHISTORYDETAIL and it appears this table pulls the cost from Std. Cost and not the tier it…

I'm trying to pull sales data that can be sliced and diced by customer, SKU, date, sales rep, etc. but ties exactly to the GL. So far, the reports I can get using Microsoft Query all have great data, but it won't tie to the GL. There has to be a simple…