You can calculate it.  First, for AR_CashReceiptDeposit, right after you assigns/run time assign for batch, bank code, deposit no and date put in a Temp001 numeric field that points to your line payment amount column that assigns on Standard Records and clear on each record.  Then for CashDepositAmt, do a calculated operation where the calculation is {AR_CashReceiptsDeposit.CashDepositAmt}+Temp001.  Next, for CashBalanceAmt make a calculated operation where the calc. is {AR_CashReceiptsDeposit.CashDepositAmt}.

Similar for the Header posting, but create a Temp001 for the payment amount and again calculate H.PostingAmt using {AR_CashReceiptsHeader.PostingAmt}+Temp001 on Header Record only and again clear on each record.  This will build up the check amount received for each customer and check.

Good Luck!

It's two years later and I'm faced with this task again but this time I'm importing several invoices that have the It's two years later and faced with similar issue. The import job is for AR_CashReceipts header. Created Temp001 numeric field that points to line payment amount column that assigns on Standard Records and clear on each record.

The H.Posting amount is calculation using {AR_CashReceiptsHeader.PostingAmt}+Temp001 on Header Record only and again clear on each record.  The lines import fine but the H.Posting fails. I think it's because I have several invoices that have the same dollar amount. If I change the amount posted to be different dollar amount per invoice everything imports fine.

I ran into this issue in the past too.  Add a new Temp field and map it to the Invoice# column.  You don't have to use the Temp field in anything else, that just tells the import job that the line is unique, even if the amount is the same.

THANK YOU!! That worked perfectly!!

Thank you! I was having a very similar issue importing into PR_TimeTrack and adding a temp field to a unique field in my source file solved the problem.

Great info, thanks!!  Also note the 'Require Deposit Amount' setting in A/R Options needs to be enabled, otherwise the deposit amount doubles-up (see kb), at least on my v2023 system. 

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.

That's true, it's been that way for quite a few years!