Hi everyone have you ever implemented a solution that is able to match open vendor bills / customer invoices when the entity is both a customer/vendor so that is possible to close AP with AR before making payments?

I’d imagine you need to link the two transactions records by some unique identifier. A possible challenge is if you have multiple vendor bills and multiple customer invoices- somehow you need to sum up before your compare the two. But in a happy use case, 1:1, you should be able to create a saved search comparing the twk transactions since you have a unique identifier connecting the two.

I guess you will have to script by yourself. I didn't find anything about that. The offsetting of mutual debts is very common and widely used transaction (at least in Europe) and Netsuite even doesn't have manual convenient method of doing such type of transaction. Because you need 3 steps: you have to create journal entry, then make fake bill payment and then make fake customer payment to close the open amounts.

Thank you so much for your confirmation