Setting Up Automatic Cost Types for Miscellaneous Receipts

By | June 29, 2026
0 Comment
  1. Navigate to Setup > Stock > Valuation Methods (Function: GESTCM).

New Stuff: Creating a Custom Sequence Number in Sage X3 Using a Function

Figure 1
Figure 1
  1. Once you select one of the valuation methods for your products, find the “Primary method” field and click on the magnifying glass for “Non-Standard Setup”.
Figure 2
Figure 2
  1. Here is where you can set up an exception rule for the movement type Miscellaneous Receipt.You have the same options for the primary and alternate sources for costing:Standard cost,Revised standard, Last cost, Cumulative AUC, Lot AUC, Order cost,and Last purchase price.
Figure 3
Figure 3
  1. In the example below, I’ve entered the following:
    • Valuation Source = Lot AUC
    • Valuation Alternate = Lot AUC
    • Receipt source = Order cost
    • Receipt alternate = Order cost
    • Negative quantity variance = Lot AUC
    • Negative alternate = Lot AUC
    • Positive quantity variance = Cumulative AUC
    • Positive alternate = Cumulative AUC
    • Adjust receipt cost = checked
    • Movement type = Miscellaneous receipt
    • Valuation source = Last purchase price
    • Valuation alternate = Cumulative AUC
    • Cost adjustment = Yes
    • Allow null cost = No
Figure 4
Figure 4

5. On the Miscellaneous Receipts screen, you may wish to hide the price and order price fields. They will NOT show the costing that will be used. Rather, they will remain blank, which can be confusing to see.

Figure 5
Figure 5
Figure 6
Figure 6
  1. When you examine the stock transactions, you can see the cost used for the miscellaneous receipts.
Figure 7
Figure 7