In this article you can find alternate solution forEnhancement576715.Currently, NetSuite system only allows Vendor Prepayment records to be applied on Open Bills.

You can offset the Deposits and Balance of the Vendor Prepayment either by creating a dummy Vendor Bill or by lowering the amount of Vendor Prepayment.

To create Dummy Vendor Bill
Note:This will only be feasible if you do not mind the movement in Accounts Payable account. But all in all, the GL impact is clear and accurate.

1. Create Dummy Vendor Bill

   1. Navigate toTransactions>Payables>Enter Bills

   2. Vendor: Populate the same vendor withthe transactions affected

   3. ClickExpenses and Items

   4. ClickExpenses

   5. Account:Select a dummy expense account
      Note:The dummy expense account to be usedcan be anything like a dummy expense account or miscellaneous account. It won't matter since its going to be reversed immediately.

   6. Amount:Enter the amount similar to the value of the Vendor Prepayment

2. Apply the Bill created to the Vendor Prepayment

   1. ClickViewon the Vendor Prepayment record

   2. ClickApplybutton

   3. ClickApplytab

   4. Apply:Check the box for the Vendor Bill created

   5. ClickSave

3. Create a Journal Entry

   1. Navigate toTransactions>Financial>Make Journal Entries

   2. ClickLines

   3. Account:

      • Debit:Cash/Bank

      • Credit:Dummy Expense account selected on the Bill created

   4. ClickSave

To Lower Vendor Prepayment Amount and create Cashback and Deposit/or use Journal Entry

1. Delete Vendor Prepayment Application for Vendor Bill

   1. ClickEdit

   2. ClickActions

   3. ClickDelete

   4. Are you sure you want to delete this transaction?:ClickOK

2. Edit Vendor Prepayment and lower amount similar to the Bill

3. Apply Bill to the Vendor Prepayment
   Note:Status becomes Fully Applied

4. Create a dummy transaction to replace the overpaid amount in original Prepayment - Deposit > Cashback subtab / or Journal Entry

5. Create aBank Deposit(Other Deposits subtab) /or Journal Entry to record the returned money and clear the GL impact with transaction from step 4

Note:Any dummy expense account can be used for the balancing account - like a holding account.