Update Beginning Inventour with Ending Inventory from previous Record

• stevenplee

  SSCommitted

  Points: 1626

  More actions

  September 1, 2010 at 2:10 pm

  #223297

  Here's my senario,

  I have a table that is updated everyhour with the previous hours data..

  Anyway We have Beginning Inv and Ending Inv

  What I need to be able to do is to update the current records Beginning Inv value with the ending inventory value from the previous record.

  Thanks

• Dan.Humphries

  SSChampion

  Points: 12125

  More actions

  September 1, 2010 at 2:27 pm

  #1215287

  How does the current record get entered? Why can't the ending balance get populated when the record is built?

  Dan

  If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.