unbalanced journal- shipment

SOLVED

we are receiving unbalanced journals on shipments posted for material that was received from production tracking.  We don't have issues with the WIP posting - all is fine however we are having an unbalanced journal when we post the shipment for these goods.   Below is example- the 1853.36 is the labor cost.  Now I see a penny discrepancy in the wip cost inquiry Total vs Total posted.   as mentioned we didn't have an issue with the wip posting but could this be causing the issue with the shipment posting?  Anyone have an idea on how to resolve? 

thanks

Christine

Parents Reply Children
  • 0 in reply to AH3

    we added the ar2 function before the table.field and it appears to have resolved the issue.  thanks for your help.

  • 0 in reply to Christine T.

    well - thought this issue was resolved by adding the ar2 function but we are still receiving unbalanced journal errors posting the shipments.  It doesn't appear to be consistent by product and some shipments have posted from MFT material.  I am looking at the stojoutval table and I don't understand why on most transactions there is a second line that is deducting or adding the labor cost from the same MFT.  Would anyone know why this happens?  This is so frustrating .  Thanks!  Christine

  • 0 in reply to Christine T.

    Its over two months as we are still having this issue with unbalanced journal of the shipments.  I did narrow the issue down to be the labor costs.  the stojouval totals for the labor are 3559.19 for the shipment however the system is trying to post value of 3559.11.   It seems the table is housing 82.7718 for 43 batch lines which = 3559.1874 but only calculating 82.77 x 43 = 3559.11.    I really could use some help with this if anyone has any other suggestions.   Would it be something I need to change in the work order setup? Has anyone else had this type of issue?  thanks c