great! it works using internalid instead of date also.

Anyone know why viewing the xml of an item record stops at the “Sales/Pricing” tab? I’m trying to find the xml fields of the inventory detail tab but it doesn’t even show that section when I change the url to &xml=t.

Question: PO is £100 - Status = Pending Approval. You generate a Bill from this PO at £50. The PO status becomes Full Billed

shouldn't the status become 'Partially Billed' ?

Depends on the item. If it’s an item that has “1 each” or something like that for £100 and you bill that one at £50 it shows that entire line billed, regardless of the amount you billed it for.

It is based off of item quantity, not amount.

ah i see...i was just testing with one line item and regardless of the amount being paid the PO status is always Fully Billed.

thanks @jokell

No problem 😊

find it a bit strange, though that it doesn't work on the amount.

it allows you flexibility @mg2017, so you can enter a bill at a different cost than the PO, in case the PO had incorrect data

the data on the Bill is what is important from the AP/GL perspective

then there is also the 'match bill to receipt' functionality

and the associated variance accounts you can set up

fair enough

If you don't really care about quantities, you could enable the expenses sublist of the PO and then it's just straight dollars.

but that's what i was filling in...the expense sublist of the PO

i can't seem to create a purchase request unless i switch role to employee centre...there must be a way of doing this in other roles?

a link sits in an employee portlet - again, it seems the portlet is only for this role

@User uploaded a file:

surely we're not expected to switch role each time we wish to create a purchase request?

Purchase request is the same as a purchase order in a non-employee center setting. You create a purchase request, it shows up as a PO in "regular" (non-EE Center) NetSuite.

but the purpose of the purchase request is when you want to add an additional level of approval and if you wish to use this it means those wanting to create PR would have to switch roles

Hi all, I am working on a purchase order search and trying to return the numbers for the below formula but there is nothing returned currently.

CASE WHEN ((({item.locationquantityonorder}) + ({item.locationquantityavailable}) - ({item.locationquantitybackordered})) < 0) THEN (({item.locationquantityonorder}) + ({item.locationquantityavailable}) - ({item.locationquantitybackordered})) END

I have tried returning the individual field's values and they get returned as expected. For e.g. if I just try to return {item.locationquantityavailable}, I get the expected value

So, I am thinking there is something wrong in the format of the formula

Thoughts?

You have a lot of parentheses in there. Try this:

CASE WHEN ({item.locationquantityonorder} + {item.locationquantityavailable} - {item.locationquantitybackordered}) < 0 THEN {item.locationquantityonorder} + {item.locationquantityavailable} - {item.locationquantitybackordered} END

You could also add

ELSE 0

before the end, just to see if the case statement is working.