[mark.james.daqri]

I’m exporting POs from another system into NetSuite, all going well except for the Approval Status which is stuck on Rejected

The main problem is there seems to be no documentation about the type of RecordRef for this field, or it’s possible values.

In netsuite i can see the field and edit it and on the PurchaseOrder object I have a setApprovalStatus method but have to pass it the generic “RecordRef”

I can’t see a relevant RecordType….

So 2 questions:

* What are the correct RecordType and InternalValue(s) for setting this Approved?

* Where do i find this information in the help center?

Thanks in advance,

Mark
This is a cached copy. Click here to see the original post.

[mark.james.daqri]

I’ll answer question 1 myself: the correct RecordType is CUSTOM_LIST and the value 2 for Approved (1 for Rejected, 3 for Pending Approval) though I’d still love to know where that’s documented? wasting several hours on what should have been a 2 minute thing not fun!

[rnedelkow]

Have you looked at the SuiteTalk Schema Browser? Each object is displayed as a series of tables, both for ease of browsing and to provide additional details compared with what is available in the WSDL – See Answer Id 11017 for details – https://netsuite.custhelp.com/app/an…ail/a_id/11017

[mark.james.daqri]

i can see the purchase order in the schema browser here https://system.netsuite.com/help/hel…haseorder.html and this is the relevant bit for approvalstatus:

approvalStatus
RecordRef
0..1
Approval Status
F

RecordRef is just a pointer to ANY RecordType (including “CustomList”) where in the documentation does it say this SHOULD be a CustomList and the Values are 1:Rejected, 2:Approved, … ?

Thanks in advance,

Mark

[Author]

Posts