Regarding massively apply vendor prepayment to open vendor bill

Question

Hi Everyone:

Let's say for now I have :

A.

(1) Vendor prepayment ,  $100 under Vendor X

(2) Vendor Prepayment, $200 under Vendor Y,

B.

(1) Vendor Bill, $100 under Vendor X

(2) Vendor Bill, $200 under Vendor Y.

Is there a way I can use CSV import to clear A(1) with B(1), A(2) with B(2) as a batch?

thank you!!

Angela Bayliss · Accepted Answer

Hello @Kevenale ,

You will not be able to apply vendor prepayments via CSV.  You can only apply vendor prepayments automatically when the bill is saved (when the prepayment is against a PO) or manually via the 'apply prepayment' function.

CSV doesn't support vendor prepayments.

Sorry it's not the answer you want.