inventory transfer log field, batch number and cost

Jun 05, 2006 5 Replies

I would like to know what part of the RMS application enters data into the inventory transfer log table and also appends a batch number and cost.



Via PO, Transfer, or directly changing the avail qty in item card, the table is updated, but never with a batch number or with a cost.



What part of RMS updates that table inluding the batch number and cost?



Jami


one more thing, the transfer type i am looking at is 5.

Jami,

formatting link
formatting link
Must have access to CustomerSource

BatchNumber is a foreign ID key of the Batch table

great thank you,thats closer.

what im trying to figure out is how you can have a transfer type 5 and also have a cost updated in the transfer log field. every way I make a 5 I cannot get a cost to show up in the cost field.

What would produce a cost value in that field with a transaction type of 5?

that sounds like it solves the missing cost data, now how to get a batch number to show up?

Thanks

I didnt get a complete answer to this post.

Jeff's answer helped, but it didnt answer whole question. The update to 1.3 fixes the no cost in the inventorytransferlog.

The remaining question is, what type of transaction will input a row to the inventorytransferlog table which includes data for the batch number field? The records I am looking at are a type 5, manual adjustment.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required