I am using Sage 300 ERP 2014. When I process a customer credit note in OE, the item quantity is correctly put back into inventory control, but the associated item cost is not. Do I have a setup problem somewhere? Recently upgraded from accpac 5.4.
What's your costing method? Was the cost zero?
Costing method is FIFO. There is a standard cost for this item, but no recent cost and therefore no average cost. In old system we were using standard, but we wanted to switch to FIFO in new system. I am seeing many items now where we brought over a standard cost but nothing else, usually in a case where there was 0 qty on hand at conversion date. Which cost is system looking to when an item is returned via credit note?
It's looking at FIFO. Ignore standard and recent. It looks like you didn't convert correctly when you switched systems.
Where is the FIFO cost stored> I don't see it anywhere in the I/C location details record.
ICCOST
jwall , records in ICCOST can be viewed via the LIFO\FIFO Inquiry in I/C.
jwall , records in ICCOST can be viewed via the LIFO\FIFO Inquiry in I/C.
ICCOST is a table in inventory lcoations, correct? How can I view what is in there for each item number? It does not appear on my export file, unless I am missing something.
No, it's a separate table from ICILOC. Do what Vicente said, use the LIFO/FIFO inquiry icon.
OK I have looked at the inquiry, but after doing the inquiry on many of my items, all of which have the FIFO costing method, the only items that I have any FIFO cost for are those that I have purchased after the conversion date. We converted over from Misys, where we were using standard. So at conversion, where we had qty on hand, we input standard as recent, so that the system would calculate an average cost. Now it sounds like we have really missed something. Do I have to go in and input FIFO costs? Can I even do such a thing? It looks like the only cost we have consistently for every item is LAST COST.
Most recent cost does nothing. You should have received those items with a cost when you brought them in. Anyway you will have to do a cost adjustment to correct the costs.
At conversion, you did it wrong. "standard" and "recent" have no effect on "average". "average" is the product of totalcost/qtyonhand. Every item should have been received with a quantity and a unit cost, then the FIFO buckets would have been populated.
OK thank you. Last question - what table does UNITCOST reside in? Can I import the unit costs so I do not have to do a cost adjustment on every item affected?
No table, there is no UNITCOST field.
There is no shortcut, you need to redo your go-live receipts, or do a cost-only adjustment batch for every item.
*Community Hub is the new name for Sage City