how to create Type 35 stock transactions creating STKUV automatic journal transactions

These types of transactions are necessary to change the cost when one of these four scenarios have taken place: 1. Adjustment of an average cost product were there a zero-stock quantity but a non-zero value. 2. Adjustment of an average cost product were there a non-zero stock quantity but a negative value. 3. Adjustment of a revised standard cost product with a back dated receipt 4. Adjustment of a revised standard cost product with a back dated shipment Revised standard cost is used, as there is a cost change part way through. Standard cost could have been used but it is easier to show using revised.

The following are worked examples that illustrate the situation in each of these scenarios.

Two products are set up to use AVC and two are set up to use Revised Standard Cost. For both costing methods make sure they are set up Adjust Issue Cost: No and Adjust Receipt cost: Yes

To test the adjustment of an average cost product were there a zero-stock quantity but a non-zero value. Create the following transactions.
1. Open stock 0
2. Raise a purchase order and receipt it, use first AVC product, Quantity: 10, Price 1
3. Raise a purchase order and receipt it, use first AVC product, Quantity: 10, Price 2
4. Check the average price is 1.5
5. Do a shipment for 10, cost should be 1.5
6. Do a return for the first receipt, Qty: 10, price 1 and Validate it.
7. Run Stock Accounting Interface (FUNSTKACC) for your Site.
8. This will result in a STKUV for 5

To test the adjustment of an average cost product were there a non-zero stock quantity but a negative value. Create the following transactions.
1. Open stock 0
2. Raise a purchase order and receipt it, use the second AVC product, Quantity: 10, Price 1
3. Raise a purchase order and receipt it, use the second AVC product, Quantity: 10, Price 2
1. Check the average price is 1.5
2. Do shipment for 10 GB005, cost 1.5 and Validate.
3. Do a return for the second receipt, Qty: 9 (not the full amount), price 2 and Validate.
4. Run Stock Accounting Interface (FUNSTKACC) for your site.
5. This will result in a STKUV for 3

To test the adjustment of a revised standard cost product with a back dated receipt. Create the following transactions.
1. For first revised standard cost product create a revised standard cost of 1.5 for first of the current month to today’s date
2. Open stock 10 (miscellaneous receipt in 10)
3. Raise a purchase order for this product, Quantity: 10 Price 1.5
4. Create a new revised standard cost of 2 for today’s date to the end of the month.
5. Receipt the purchase order, Quantity: 10, Stock cost per unit 1.6 (to create a variance) for a Receipt Date prior to today (back dated receipt)
6. Run Stock Accounting Interface (FUNSTKACC) for your site.
7. This will result in a STKUV for 5.

To test the adjustment of a revised standard cost product with a back dated shipment. Create the following transactions.
1. For second revised standard cost product create a revised standard cost of 1.5 for first of the current month to today’s date
2. Open stock 10 (miscellaneous receipt in 10)
3. Create a new revised standard cost of 2 for today’s date to the end of the month.
4. Create a shipment, Quantity: 10, for a date prior to today (back dated shipment)
5. Run Stock Accounting Interface (FUNSTKACC) for your site.
6. This will result in a STKUV for 5