need to ask about if anyone knows if applicable to create script to auto apply vendor prepayment to the bill automatically

Yes, it is possible by script

did you make it before ?

What's the error message you have?

You cannot create standalone prepayment applications.

Indeed prepayment can't be standalone, it should be created based on the Vendor Prepayment. Can you share the code you wrote to create a prepayment application?