Working on Sage 100 v2016 and trying to figure out how to import cash receipts using one file when the file does not contain a Deposit Number.  I don't believe I can use the 'NEXT' operation because my Cash Receipts Header/Detail import needs to use the same Deposit Number.  Because there will only be one import per day, my thought was to use the first four characters of the Deposit Date from the import (MMDD) and tack on a "W"...the results based on a Deposit Date of Jun 21st would be W0521.

I created a temp field (Temp001$) that imports the first four of the Deposit Date field and moved it to the top of the import Data tab.  I then modified the DepositNo field so it was a calculation of "W"+Temp001$.  However, every time I test the import, the DepositNo displays as just "W".