AF
HomeTagSubmit NotesAsk AnythingLoginSubscribe Us
AF
1. Feel Free to ask and submit anything on Anyforum.in and get satisfactory answer
2. Registration is not compulsory, you can directly login via google or facebook
3. Our Experts are looking for yours ?.



java-netsuite: Need to get Pending Receipt purchase orders only

Hi,

I have done integration(java) with NS and need to get purchase orders which are having status "Pending Receipt" how to set status to transaction search??currently i am getting all pos based on tran dates.

java x 211
netsuite x 18
Posted On : 2014-09-30 10:22:35.0
profile venky - anyforum.in venky
700
up-rate
4
down-rate

Answers


Field Name: status- This is a read-only field. Defaults to the value set up on the Company Preference page. If your company uses the approval process for sales orders, Pending Approval is the default. If your company does not use the approval process, Pending Fulfillment is the default.

Field Name: pending- A read-only field that returns the sum of unapproved credit card payments for the customer.

Sample code to set the status and transaction date:
-------------------------------------------------------------------------------------------
// set the transaction date and status
so.tranDate = new System.DateTime();
so.orderStatus = SalesOrderOrderStatus._pendingApproval;

OR

// set the transaction date and status
so.setTranDate(Calendar.getInstance());
so.setOrderStatus(SalesOrderOrderStatus._pendingApproval);

Posted On : 2014-09-30 15:44:11
Satisfied : 1 Yes  0 No
profile Rishi Kumar - anyforum.in Rishi Kumar
523188250042
Reply This Thread
up-rate
3
down-rate
Comments
Hi Raj,

I was tried like this,but can get records tell me if i´m wrong

TransactionSearchBasic tsb=new TransactionSearchBasic();
SearchStringField ssf=new SearchStringField("purchaseOrder",SearchStringFieldOperator.is);
tsb.setRecordType(ssf);
String[] status={PurchaseOrderOrderStatus.__pendingReceipt};
tsb.setStatus(status);
profile venky - anyforum.in venky
7  0  0
Posted On :2014-09-30 23:50:02.0
Leave a Comment
To apply filter on search you can use following code. Below is the search filter to apply when trying to find Pending Fulfillment Sales Orders.

new nlobjSearchFilter(´status´,null,´is´,´SalesOrd:B´)

and to set the status of a sales order as pending approval

nlapiSubmitField(´salesorder´,soID,´orderstatus´,´A´,false);


and code for purchase order pending receipt is:
Purchase Order:Pending Receipt=PurchOrd:B
profile Rishi Kumar - anyforum.in Rishi Kumar
523  1882  50042
Posted On :2014-10-01 12:22:50.0
Leave a Comment



Post Answer
Please Login First to Post Answer: Login login with facebook - anyforum.in