We have a different practice when billing purchase...
# administration
m
We have a different practice when billing purchase orders. We modify the bill using the expense sublist instead of the item sublist in bills. So even though bill has been created, the purchase order will still have a "Pending Bill" document status. Is there a way to change this document status to "Fully Billed" without changing our bill creation practice?
n
Have you tired Closing the PO after you have done the Bill? That should indicate that the lines that no further action.
m
If we close the PO, it will change the document status to "Closed" which is similar to being cancelled. Also, we can no longer create item receipt transactions from the "Closed" PO.
n
You can set the Status via a script.
m
Have you tried changing document status via script?
n
Yes
use a PO version of this https://netsuite.custhelp.com/app/answers/detail/a_id/89367 or a scripted version.
m
This just changes the display type; you can select the field if action is set field display type but not if set field value.
n
seems we are not really connecting on this. Here is another example of setting an order status on a transaction:
newVRA.setValue({
fieldId : 'orderstatus',
value 	: 'B'
});
Here is a better SuiteAnswers link https://netsuite.custhelp.com/app/answers/detail/a_id/50165
m
On what specific transaction did this script work?
n
in my snip that is a vendor return authorization.
m
I'm trying to make it work for purchase order transactions; not working so far. Also not receiving any error messages.
f
Are there items with qty on the PO? On the final bill/ invoice you could include the full quantity of items and change the amount to zero - which should change the status to fully billed (it is based on qty or $ amount)
m
that’s the default behavior when creating the vendor bill; we change the quantity to 0 in the vendor bill because it adds to inventory count even if item is technically not yet received, we’re just making the bill.
f
But if you are looking to have the status as 'fully billed' it would imply that all the items on the PO are received. So if the PO is item: x qty 5 - $1000, You billed $500 already on bill 1, Bill 1 item subtab: item: x qty 0 amount $0 (or just removed items from the bill) Expense subtab expense: x $500. The PO will still be set as Open. On the final bill: Bill2, Bill 2 item subtab item:x qty 5 amount $0 expense subtab expense:x $500 The PO will be closed/ marked 'Fully Billed' because the full qty has been billed. Anytime there are either $ or qty left on a PO it will have a status of 'Pending Billing'