Most recent cost

[Maggied]

Hi,

One of our branches along time ago received items (2014/2015) at the wrong unit price. We now know and we need these items at the correct unit price in ACCPAC. Because every time they make a SHP, the locations (workshop/projects / etc.) are supporting extra costs on these items received.

They want to be able to fix this so when they do a shipment or a shipment return it will have the correct most recent cost showing. One option could be to make an SHP for all the units for each item and then a SRT at the correct unit price. In the following SHP ACCPAC takes the correct unit price, but, It doesn’t work with the SRT.
Because (I think) in the SRT ACCPAC takes the unit cost from the last RCP (receipt).

What is the best way to correct the cost to some of these items so when a person does a shipment or shipment return the correct cost will show up for them. We need ACCPAC to show the correct prices in (Most recent cost (Cost calculation unit) / Last unit cost (Cost calculation unit). We use sage 300 2014 the fifo costing method.
Hope this makes sense.

 

[Jay Converse]

Do a new receipt, or an adjustment.

Sage 300 Whisperer

 

[Maggied]

Hi Jay,
We did an adjustment just to the cost and didn't work. What should we be choosing in the adjustment to correct this?

 

[Jay Converse]

You didn't pick the right FIFO bucket.

Sage 300 Whisperer

 

[Maggied]

There was only one receipt in the fifo bucket and it still didn't show.

 

[Jay Converse]

Then I don't know.

Sage 300 Whisperer

 

[Jay Converse]

BTW, ICILOC.RECENTCOST isn't updated when you do an adjustment. But when you ship FIFO, it will use the bucket's cost.

Sage 300 Whisperer

 

[ettienne]

Go to I/C Items and Price Lists, Location Details and enter the item.
Scroll over to teh right and you will see Most Recent Cost, edit it and enter the correct value.

Sage 300 Certified Consultant