I'm trying to make sure that I'm understanding my average cost #s correctly, but I believe that I'm missing something. I took 1 item with a relatively small # of transactions to test this, and I can't figure out where the # is coming from.
I ran a report showing me all of my bills and inventory worksheets for my test item (there was only a single worksheet with a QTY of 1), then divided the total amount by the total qty ordered, but I'm not able to match what NS is giving me for an average cost. I'm just trying to figure out what other factors are going into this which I have to account for.
Thanks in advance,
Mike