Sage 300

When i do a materials return in PJC it is using the Most recent cost instead of the Average cost set on that item. Is there something that am doing wrong or a setting that i should change in PJC? Sage 300 2020

Client has a few items with really far out Average costs. Supposed to be $1 and shows $950 Average cost. The MRC is good and last cost is good. Is there a way to fix the average cost? There was an adjustment done a few months back that was in error…

I am trying to create a report that pulls all OE sales by month and includes standard cost, average cost, most recent cost, last cost, alt cost 1 and alt cost 2. I can't seem to find which table or view has all of these costs. It looks like they are…

1. Find below screenshot, for a particular item cost is booked while doing PO Receipt but when those items were sold it is not showing any cost for shipment entry under inventory out. 2. And for some items, it just suddenly takes some unrelated…