Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Most recent cost

Status
Not open for further replies.

Maggied

Technical User
Jun 23, 2011
66
CA
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.
 
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?
 
There was only one receipt in the fifo bucket and it still didn't show.
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top