I'm creating a VI job for cash receipts import of credit card deposits on SO that were initially posted via SO into a clearing GL. I created a Crystal Report to read the AR History Header and pick up the deposit amounts. That seems to work well. I import out to CSV to serve as the source for a CR import (much easier than doing one-by-one) and the customer wants to see the total cash receipts by the customer so I think I have to do a detailed import vs lump sum.
I created the VI import which works (although it really should be easier to import cash receipts ) and I think my remaining question is how important is it for the deposit # field to be unique for subsequent imports (I know it has to be unique for the set of data entry being posted)
From what I can tell when I chain the two CR imports the tie between them on the import is that deposit # field.
What I'd like to do is have Crystal just plug in the ""Group #"" which is a consecutive number starting at 1. I could easily re-use this on each cash receipt but I'm not sure whether that causes issues down the road to have duplicate cash receipt #?
Or is there an easier way to do this to minimize any manual data entry by the customer prior to import?