I'm also wondering if anyone has any bright ideas for how to have the import calc the deposit amount 'when the invoice payment amounts are not present in the csv source'.  Basically, the customer is essentially paying all open invoices for a given range, so we don't have the individual invoice payment amounts, just a list of invoices.  For the step 2 import I'm able to pull the invoice balances from the open invoice file, but not sure if there's a way to do that on the step 1 deposit import.

Unfortunately I think you only have two options.

1. Turn back off "Require Deposit Amount" then modify your step 1 import job so that the deposit amount is not imported, that way the cash receipts business object will automatically calculate it for you.
2. Write custom perform logic to loop through the import file, read the invoice number, go look it up in AR_OpenInvoice, grab the balance and keep a running total.

Thanks!!  Re: #1, that worked when pointing Temp field to payment column in csv, but it's not properly calculating the header Posting Amt when pointing Temp to Balance field in Open Invoice file.  I'm thinking that may be related to 'when' it's reading the open invoice file during the import.  Re: #2, I was initially leaning toward running the invoices thru MS Access against the open invoice file to grab the balances, but PL may be a better path.

Are your CR lines getting a good value?  I don't think you need a temp field for this:

I'd assume your file must have a header total (for how much the customer is paying).

You're welcome! I think the Posting Amt issue is most likely because it is writing the header record prior to reading through the lines and writing line records, and I don't know of a way to make VI job back and update the header record after working with the line objects.

Since Cash Receipts is designed around the user knowing the total check/payment amount prior to inputting it,  pre-processing the data so you have that info is probably the best option, whether that be via perform logic or some other method.

I've seen at least one instance where perform logic was used to read the .csv file, calculate values needed by the VI job, and then write them back to the .csv file.

You're welcome! I think the Posting Amt issue is most likely because it is writing the header record prior to reading through the lines and writing line records, and I don't know of a way to make VI job back and update the header record after working with the line objects.

Since Cash Receipts is designed around the user knowing the total check/payment amount prior to inputting it,  pre-processing the data so you have that info is probably the best option, whether that be via perform logic or some other method.

I've seen at least one instance where perform logic was used to read the .csv file, calculate values needed by the VI job, and then write them back to the .csv file.