AnsweredAssumed Answered

Reconciliation

Question asked by krystalm on Feb 25, 2015
Latest reply on Apr 13, 2015 by krystalm

Title

Reconciliation

Post

Hello,

I currently have a fuel database with 3 tables. Which tracks fuel we receive (Diesel and Gasoline) as well as fuel consumed.

Shop Fuel

Shop Fuel_Odometer (copy of Shop Fuel)

Equipment

I recently added a new filed labeled "Fuel In Tank" which is used when the tank is measured for the amount of fuel left in it for reconciliation.  I am trying to create a reconciliation which takes the last "fuel in tank" entry - sBalance (which is a balance of what we show should be in the tank) and the result would be the difference from the two. 

 

I have tried using ''Fuel In Tank'' - sBalance  in a Summary by Fuel Type Part but it isnt resulting in what I need. 

 

Any help on this matter?

 

Outcomes