Creating a Sales Order in NAV via PHP

joeh · 2010-11-10

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 · 2010-11-10

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);

Howdy, Stranger!

Quick Links

Categories

Creating a Sales Order in NAV via PHP

Comments