value adjustment entries questions

ecclectic

hi i have processed the following inventory transactions,

Inventory Setup
Expected cost posting: True
Automatic cost posting: True
Average cost calc type: Item & Location & Variant


transaction 1
Process Purchase Order - P)1
10 items BZSKFG @ 100 - location Costing
Transaction 2
Process transfer order - T01
10 items BZSKFG from location Costing to location Bond using transit location OUT
Transaction 3
Process Supplier Invoice- Item charge 250 to be applied on transfer order T01
Transaction 4
Process transfer order - T02
10 items BZSKFG from location Bond to Showroom using transit location OUT

all transactions were processed on the same date

Observation/Results
SKU - Bond - 3985
SKU - Costing - 3960
SKU - SHOWROOM - 3985
Average cost on item card 3985

Item ledger entries created

Entry Type Doc No Location Qty rem qty Cost
219 Purchase PPR22 COSTING 10 0 39,600
220 Transfer PTS33 COSTING -10 0 -39,600
221 Transfer PTS33 OUT 10 0 39,600
222 Transfer PTR33 OUT -10 0 -39,850
223 Transfer PTR33 BOND 10 0 40,100
224 Transfer PTS34 BOND -10 0 -40,100
225 Transfer PTS34 OUT 10 0 40,100
226 Transfer PTR34 OUT -10 0 -39,850
227 Transfer PTR34 SHOW 10 10 39,850

Value entries created

En Entry Doc No Cost Va Qt In Qt Ld NO
336 Pur PPI47 39600 10 10 219
337 Tra PTS33 -39600 -10 -10 220
338 Tra PTS33 39600 10 10 221
339 Tra PTR33 -39600 -10 -10 222
340 Tra PTR33 39600 10 10 223
341 Pur PPI48 250 10 0 223
342 Tra PTS34 -39850 -10 -10 224
343 Tra PTS34 39850 10 10 225
344 Tra PTR33 -250 -10 0 222
345 Tra PTR33 250 10 0 223
346 Tra PTS34 -250 -10 0 224
347 Tra PTS34 250 10 0 225
348 Tra PTR34 -39850 -10 -10 226
349 Tra PTR34 39850 10 10 227

your help would be greatly appreciated

kine

And problem is???

ecclectic

kine wrote:

And problem is???

sorry kine, forgot the important one. why when looking at the item ledger entries it seems that the item is coming out of store bond at a total cost of 40100. i mean the item were transfered to store bond at a cost of 39600. item charge of 250 were assigned to the items in store bond (using transfer receipt).

i haven't been able to work out the adjustments (reasoning) that the system made and that resulted in an amount of 40100.
it seems that the problem is arising because i used the same transit location for the same item twice during the day?????