You’re offline. This is a read only version of the page.
22,782
Why would the unit cost stored in SOP30300 be different to that on SEE30303 (Historical Inventory Trial Balance)?
For reference, SEE30303 matches the Standard Cost on IV00101.
The following SQL returns me 1400 rows since the start of April:
SELECT
SOP.SOPNUMBE
,SOP.ITEMNMBR
,SOP.LOCNCODE
,SEE.UNITCOST
,SOP.UNITCOST
FROM
SOP30300 SOP
INNER JOIN
SEE30303 SEE
ON SEE.DOCNUMBR = SOP.SOPNUMBE
AND SEE.ITEMNMBR = SOP.ITEMNMBR
AND SEE.LOCNCODE = SOP.LOCNCODE
AND SEE.UNITCOST <> SOP.UNITCOST
Thanks.
*This post is locked for comments
Bingo. The valuation method for service items should be blank. Probably these items were originally Sales Inventory items and changed programmatically to Service. Using FIFO means a FIFO stack is maintained and costs work like I originally stated.
Use SQL to set the valuation method for all service items to 0
No, the Valuation Method is FIFO Perpetual.
Is the item valuation method for the items blank?
Hi Richard,
My apologies, I meant to say it matches Current Cost on the Item card.
The items in question are mainly Service Items which have had the same Current Cost since before the start of April.
Ian
Read "historical". Here is how GP costs SOP documents. This all depends on your valuation method for the item. I would suggest you get a copy of our Understanding Sales Order Processing book available on our web site.
OK, when an order is first entered, the system, depending on the valuation method, the cost is taken to the SOP Document. Then, when the invoice is posted, the cost is evaluated again as it might have changed (new standards for standard cost, other receipts for LIFO, presold layers for FIFO, et cetera. The cost shown on the Item master card is only for reference and is not put into the actual transaction unless the firm is using standard cost and cost have not been revalued. Then, actually, cost components from the ICIV0232 table are used in the GL transactions but they add up to the cost on the Item Master Card.
Visit our web site at www.AccoladePublications.com for the Understanding Sales Order Processing book.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (