Sage 100

I have a CR import that is calculating the amount received using a temp field  on the line distribution amounts. 

This works great EXCEPT if the source file has 2 line amounts that are the same.  The temp calculation doesn't recognize it as a new record and the VI job fails the header and subsequent lines for "distribution out of balance".  

I believe I've ran into this before. See Sage City post: https://communityhub.sage.com/us/sage100/f/personalization-customization-and-productivity-tools/166685/using-vi-to-import-cash-receipts

Thank you!  The tip on that thread was to add a temp field on the header pointed to the invoice# so the import sees a different value for the header and it worked!!  thank you again!