Reposting this since the #CBQ338ZE0 channel looks fairly empty - Question for the masses - I'm looking to build a CSV import file to record Customer Payments and want to include Credit Card Processing Fees on it - Do I need to look at the Sublists or is that more problematic? (client uses Stripe for Credit Card processing and wants to batch process the payments without having to go customer-by-customer)

HI SCOTT. YOU NEED TO SET THE ITEM ON THE FEE IF IT IS AN INVOICE. SO YOU WILL NEED SUBLIST. FROM INVOICE ITEMS, MAP THE ITEM ASSOCIATED WITH THE INVOICE. IF YOU WANT A MEMO TO BE DISPLAYED ON THE ITEM, YOU CAN ALSO ADD THE DESCRIPTION FIELD

@Aria Ghahari Let me make sure I understand what you are saying - when you receive a Customer Payment, you need to add a line item for the fee to the Invoice and then process it through?

@Scott I MIGHT HAVE MISUNDERSTOOD YOU. EXAMPLE: CHARGING CUSTOMER 500 WITH A 5 PROCESSING FEE. ARE EITHER OF THESE INVOICES IN THE SYSTEM OR ARE YOU CREATING THEM AT THE TIME OF PROCESSING THE PAYMENT?

Invoices are created and then subsequently the Invoice is paid via credit card - Using a 3rd party processor (NOT integrated in Netsuite) so I'm looking at using the Customer Payment CSV and just adding in the processing fee. So the accounting treatment would be the following on a $1000 invoice - Credit A/R $1000, Debit Cash $970, Debit CC Fees $30

@Scott I SEE. ALL YOU NEED TO SPECIFY IS THE AMOUNT AND EVERYTHING ELSE ON THE MAINLINE. YOU SHOULD HAVE A SCRIPT THAT RUNS THROUGH EACH INVOICE (IDENTIFIES SUBLINE ITEMS IF MULTIPLE) AND APPLIES ACCORDINGLY. NO NEED TO DO ANYTHING FOR THE UPLOAD IF YOU TAKE CARE OF IT WITH SCRIPT.