Creating a Sales Order in NAV via PHP

joehjoeh Member Posts: 32
edited 2010-11-10 in NAV Three Tier
Hi everyone
I'm trying to create a Sales Order in NAV2009 SP1 via WS and I manage to be able to successfully control the order headers however I can't seem to get sales order lines to be inputted.

Here is a snippet of the code below

I have tried different solutions such as making order lines an individual action away from headers where the order would be called and updated, I've tried different layouts of Arrays and so far no sucess.

Any guidance is greatly appreciated.
$pageURL = $baseURL.rawurlencode($cur).'/Page/Sales_Order'; 


// Initialize Page Soap Client 
$page = new NTLMSoapClient($pageURL);

$params = array( 'Sales_Order' => '' );




$result = $page->Create($params);

$key = $result->Sales_Order->Key;

echo $key;

$params = array( 'Sales_Order' => array (
										 'Key' => $key, 
										 'Sell_to_Customer_No' => '01905902',
										 'Order_Date' => date('Y-m-d'),
										 'Customer_Order_No' => 'RAZA HELLO',
										 'Prices_Including_VAT' => 0
										),
				'Sales_Order_Line' => array (
											  'Type' => 'Item',
											  'No' => '1001',
											  'Unit_Price' => '555',
											  'Quantity' => '1'

											  )

										  												
			  										
				);


//print_r ($params);
		
		 $result = $page->Update($params);
Joeh Chan,
HostLive Limited

Comments

  • joehjoeh Member Posts: 32
    I've tried this stance as well, but it tells me that the Sales Order Line already exists!:
    $pageURL = $baseURL.rawurlencode($cur).'/Page/Sales_Order'; 
    
    
    // Initialize Page Soap Client 
    $page = new NTLMSoapClient($pageURL);
    
    $params = array( 'Sales_Order' => '' );
    
    
    
    
    $result = $page->Create($params);
    
    $key = $result->Sales_Order->Key;
    
    //echo $key;
    
    $params = array( 'Sales_Order' => array (
    										 'Key' => $key, 
    										 'Sell_to_Customer_No' => '01905902',
    										 'Order_Date' => date('Y-m-d'),
    										 'Customer_Order_No' => 'RAZA HELLO',
    										 'Prices_Including_VAT' => 0,
    										 'SalesLines' => array ( 
    																'Sales_Order_Line' => array (
    																							 array( 'Type' => 'Item', 'No' => '1001', 'Quantity' => '1' )
    																							)
    																	
    																							
    											 			)
    									)
    			);
    				
    
    echo "<br/><b>Bellow please find the Array processed:</b><br/>";
    print_r ($params);
    		
    		 $result = $page->Update($params);
    
    Joeh Chan,
    HostLive Limited
Sign In or Register to comment.