Xero Tracking Categories #315

AndyTurff · 2023-02-21T15:48:33Z

AndyTurff
Feb 21, 2023

Hi, I'm struggling with sending Purchase Orders with 2 tracking categories on a line item. I'm currently sending them with with one tracking category but I can't work out the syntax for send two different tracking categories. This is what I use for sending one...

$lineItemTracking[$x] = new XeroAPI\XeroPHP\Models\Accounting\LineItemTracking;
$lineItemTracking[$x]
->setName('Dept')
->setOption($DeptX);
array_push($lineItemTrackings, $lineItemTracking[$x]);

So what I need to achieve is...

$lineItemTracking[$x] = new XeroAPI\XeroPHP\Models\Accounting\LineItemTracking;
$lineItemTracking[$x]
->setName('Dept')
->setOption($myDeptX);
->setName('Unit')
->setOption($myUnitX);
array_push($lineItemTrackings, $lineItemTracking[$x]);

Hope someone can help. It would be very much appreciated.

Answered by pumpkinball

Feb 24, 2023

Hi @AndyTurff I've just tried it on my local. With the array_push, I forgot you have to push into the array after each tracking item.
So I tried this, and it seemed to work..

             $trackingCat = new XeroAPI\XeroPHP\Models\Accounting\LineItemTracking;
	    $trackingCat->setTrackingCategoryId('xxxxxxxx-xxxx-xxxx-97a1-0e6d15b0b574')
					   ->setName('Garden')
				            ->setOption('All Gardens');

		array_push($trackingCats, $trackingCat);	

	    $trackingCat = new XeroAPI\XeroPHP\Models\Accounting\LineItemTracking;
	    $trackingCat->setTrackingCategoryId('xxxxxxxx-xxxx-xxxx-8dcb-9405d571b614')
					   ->setName('Unit')
				            ->setOption('All Units');

	    array_pu…

View full answer

pumpkinball · 2023-02-21T16:42:49Z

pumpkinball
Feb 21, 2023
Maintainer

Hi Andy,
Off the top of my head, have you tried instantiating the LineItemTracking object again?
So for each LineItemTracking you would need to do

$lineItemTracking[1] = new XeroAPI\XeroPHP\Models\Accounting\LineItemTracking;
blah blah ...
$lineItemTracking[2] = new XeroAPI\XeroPHP\Models\Accounting\LineItemTracking;
blah blah
And then at the end
array_push($lineItemTrackings, $lineItemTracking);

0 replies

AndyTurff · 2023-02-21T21:43:26Z

AndyTurff
Feb 21, 2023
Author

Hi pumpkinball. Thank you for your quick reply. I tried something similar which didn't work but I'll give what you suggest in the morning. Thank you again. Andy

…

On Tue, 21 Feb 2023 at 16:43, pumpkinball ***@***.***> wrote: Hi Andy, Off the top of my head, have you tried instantiating the LineItemTracking object again? So for each LineItemTracking you would need to do $lineItemTracking[1] = new XeroAPI\XeroPHP\Models\Accounting\LineItemTracking; blah blah ... $lineItemTracking[2] = new XeroAPI\XeroPHP\Models\Accounting\LineItemTracking; blah blah And then at the end array_push($lineItemTrackings, $lineItemTracking); — Reply to this email directly, view it on GitHub <#315 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALFZ7BVPEBTIEPS3XE4YY5LWYTWBJANCNFSM6AAAAAAVDG2CMU> . You are receiving this because you authored the thread.Message ID: ***@***.***>

2 replies

AndyTurff Feb 23, 2023
Author

So I tried as listed below (the xxxx's are mine)

$lineitemsX[$x] = new XeroAPI\XeroPHP\Models\Accounting\LineItem;
$lineItemTracking[1] = new XeroAPI\XeroPHP\Models\Accounting\LineItemTracking;
	$lineItemTracking[1]
		->setTrackingCategoryID('xxxxxxxx-xxxx-xxxx-947d-0234e5de3833')
		->setTrackingOptionID('xxxxxxxx-xxxx-xxxx-b847-c55637fef858')
		->setName('Dept')
		->setOption('09 - General');

$lineItemTracking[2] = new XeroAPI\XeroPHP\Models\Accounting\LineItemTracking;
	$lineItemTracking[2]
		->setTrackingCategoryID('xxxxxxxx-xxxx-xxxx-21630393aea2')
		->setTrackingOptionID('xxxxxxxx-xxxx-xxxx-b4bb-860c184f3b84')
		->setName('Unit')
		->setOption('All Units');
array_push($lineItemTrackings, $lineItemTracking);

	$lineitemsX[$x]
		->setDescription($partNumX[$x])
		->setQuantity($qtyX[$x])
		->setUnitAmount($unitX[$x])
		->setAccountCode($codeX[$x])
		->setDiscountRate($discountX[$x])
		->setTaxType($taxXero[$x])
		->setTracking($lineItemTrackings);
		array_push($lineitems, $lineitemsX[$x]);

This a print_r of the relevant part of my $PurchaseOrder, which gets no syntax errors but when I print_r the $result I get the bottom 2 paragraphs. So it seems to not be sending the value through and I'm still only getting 1 set of tracking category. I'm sure I must still be getting the syntax wrong but I can't work out the solution.

[tracking] => Array ( [0] => Array ( [1] => XeroAPI\XeroPHP\Models\Accounting\LineItemTracking Object ( [container:protected] => Array ( [tracking_category_id] => xxxxxxxx-xxxx-xxxx-947d-0234e5de3833 [tracking_option_id] => 9a4bbdf9-ca2d-4427-b847-c55637fef858 [name] => Dept [option] => 14 - SC - General ) ) [2] => XeroAPI\XeroPHP\Models\Accounting\LineItemTracking Object ( [container:protected] => Array ( [tracking_category_id] => xxxxxxxx-eddc-xxxx-xxxx-21630393aea2 [tracking_option_id] => xxxxxxxx-xxxx-xxxx-xxxx-860c184f3b84 [name] => Unit [option] => All Units ) ) ) )

[tracking] => Array ( [0] => XeroAPI\XeroPHP\Models\Accounting\LineItemTracking Object ( [container:protected] => Array ( [tracking_category_id] => 00000000-0000-0000-0000-000000000000 [tracking_option_id] => [name] => [option] => ) ) )

ERROR [validation_errors] => Array ( [0] => XeroAPI\XeroPHP\Models\Accounting\ValidationError Object ( [container:protected] => Array ( [message] => Unknown tracking details. A Tracking Category did not match a known Active TrackingCategory ) ) )

Any ideas?

Thank you

AndyTurff Feb 23, 2023
Author

I also tried this, with a similar result...

/*Standard line items*/
$lineitemsX[$x] = new XeroAPI\XeroPHP\Models\Accounting\LineItem;

$lineItemTracking[1] = new XeroAPI\XeroPHP\Models\Accounting\LineItemTracking;
	$lineItemTracking[1]
		->setName('Dept')
		->setOption($DeptX[$x]);

	$lineItemTracking[2]
		->setName('Unit')
		->setOption($xeroUnit[$x]);
array_push($lineItemTrackings, $lineItemTracking);

[tracking] => Array ( [0] => Array ( [1] => XeroAPI\XeroPHP\Models\Accounting\LineItemTracking Object ( [container:protected] => Array ( [tracking_category_id] => xxxxxxxx-xxxx-xxxx-947d-0234e5de3833 [tracking_option_id] => xxxxxxxx-xxxx-xxxx-b847-c55637fef858 [name] => Dept [option] => 14 - SC - General ) ) [2] => XeroAPI\XeroPHP\Models\Accounting\LineItemTracking Object ( [container:protected] => Array ( [tracking_category_id] => xxxxxxxx-xxxx-xxxx-21630393aea2 [tracking_option_id] => xxxxxxxx-xxxx-xxxx-b4bb-860c184f3b84 [name] => Unit [option] => All Units ) ) ) )

[tracking] => Array ( [0] => XeroAPI\XeroPHP\Models\Accounting\LineItemTracking Object ( [container:protected] => Array ( [tracking_category_id] => 00000000-0000-0000-0000-000000000000 [tracking_option_id] => [name] => [option] => ) ) )

pumpkinball · 2023-02-23T09:38:58Z

pumpkinball
Feb 23, 2023
Maintainer

Hi @AndyTurff I know it seems a daft question, but the error suggests that the tracking categories you are sending across are not active.. ?
If you give me you clientID, I can look in the logs for you.

1 reply

AndyTurff Feb 24, 2023
Author

Hi, thanks for your continued help. I know its not that because if I send a purchase order through with either just Unit or Dept it works fine just not with them both.

the $result looks like this when there is just one...

[tracking] => Array ( [0] => XeroAPI\XeroPHP\Models\Accounting\LineItemTracking Object ( [container:protected] => Array ( [tracking_category_id] => xxxxxxxx-xxxx-xxxx-af54-21630393aea2 [tracking_option_id] => xxxxxxxx-xxxx-xxxx-b4bb-860c184f3b84 [name] => Unit [option] => All Units ) ) )

And like this when there is 2 categories (it does't even show the second array)

[tracking] => Array ( [0] => XeroAPI\XeroPHP\Models\Accounting\LineItemTracking Object ( [container:protected] => Array ( [tracking_category_id] => 00000000-0000-0000-0000-000000000000 [tracking_option_id] => [name] => [option] => ) ) )

All the variables are mising and I think that's why it says "A Tracking Category did not match a known Active TrackingCategory"

I still think it's because the syntax is wrong but I've tried so many different ways and I am stumped!

pumpkinball · 2023-02-24T12:11:16Z

pumpkinball
Feb 24, 2023
Maintainer

Hi @AndyTurff I've just tried it on my local. With the array_push, I forgot you have to push into the array after each tracking item.
So I tried this, and it seemed to work..

             $trackingCat = new XeroAPI\XeroPHP\Models\Accounting\LineItemTracking;
	    $trackingCat->setTrackingCategoryId('xxxxxxxx-xxxx-xxxx-97a1-0e6d15b0b574')
					   ->setName('Garden')
				            ->setOption('All Gardens');

		array_push($trackingCats, $trackingCat);	

	    $trackingCat = new XeroAPI\XeroPHP\Models\Accounting\LineItemTracking;
	    $trackingCat->setTrackingCategoryId('xxxxxxxx-xxxx-xxxx-8dcb-9405d571b614')
					   ->setName('Unit')
				            ->setOption('All Units');

	    array_push($trackingCats, $trackingCat);	
	
		$lineitems = [];		

		$lineitem = new XeroAPI\XeroPHP\Models\Accounting\LineItem;
		$lineitem->setDescription('Item 123')
			->setQuantity(1)
			->setUnitAmount(32)
			->setAccountCode("400")
			->setTracking($trackingCats);

		array_push($lineitems, $lineitem);

0 replies

AndyTurff · 2023-02-24T14:18:42Z

AndyTurff
Feb 24, 2023
Author

That worked! Thank you so much for all your help. It's very much appreciated. Have a great weekend. I will now! 🤓 Andy

…

On Fri, 24 Feb 2023 at 12:11, pumpkinball ***@***.***> wrote: Hi @AndyTurff <https://github.com/AndyTurff> I've just tried it on my local. WIth the array_push, I forgot you have to push after each tracking item. So I tried this, and it seemed to work.. ` $trackingCat = new XeroAPI\XeroPHP\Models\Accounting\LineItemTracking; $trackingCat->setTrackingCategoryId('xxxxxxxx-xxxx-xxxx-97a1-0e6d15b0b574') ->setName('Garden') ->setOption('All Gardens'); array_push($trackingCats, $trackingCat); $trackingCat = new XeroAPI\XeroPHP\Models\Accounting\LineItemTracking; $trackingCat->setTrackingCategoryId('xxxxxxxx-xxxx-xxxx-8dcb-9405d571b614') ->setName('Unit') ->setOption('All Units'); array_push($trackingCats, $trackingCat); $lineitems = []; $lineitem = new XeroAPI\XeroPHP\Models\Accounting\LineItem; $lineitem->setDescription('Item 123') ->setQuantity(1) ->setUnitAmount(32) ->setAccountCode("400") ->setTracking($trackingCats); array_push($lineitems, $lineitem); ` — Reply to this email directly, view it on GitHub <#315 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALFZ7BXHD7SLYAXTKMBW7YDWZCQPBANCNFSM6AAAAAAVDG2CMU> . You are receiving this because you were mentioned.Message ID: ***@***.***>

1 reply

pumpkinball Feb 24, 2023
Maintainer

Good to hear! Enjoy!!

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Xero Tracking Categories #315

{{title}}

Replies: 5 comments 4 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

Select a reply

Xero Tracking Categories #315

AndyTurff Feb 21, 2023

Replies: 5 comments · 4 replies

pumpkinball Feb 21, 2023 Maintainer

AndyTurff Feb 21, 2023 Author

AndyTurff Feb 23, 2023 Author

AndyTurff Feb 23, 2023 Author

pumpkinball Feb 23, 2023 Maintainer

AndyTurff Feb 24, 2023 Author

pumpkinball Feb 24, 2023 Maintainer

AndyTurff Feb 24, 2023 Author

pumpkinball Feb 24, 2023 Maintainer

AndyTurff
Feb 21, 2023

Replies: 5 comments 4 replies

pumpkinball
Feb 21, 2023
Maintainer

AndyTurff
Feb 21, 2023
Author

AndyTurff Feb 23, 2023
Author

AndyTurff Feb 23, 2023
Author

pumpkinball
Feb 23, 2023
Maintainer

AndyTurff Feb 24, 2023
Author

pumpkinball
Feb 24, 2023
Maintainer

AndyTurff
Feb 24, 2023
Author

pumpkinball Feb 24, 2023
Maintainer