Hello,
I have a scenario that searches Salesforce for newly created or modified products that then is meant to push this info into Xero and either create or update the item in Xero.
It works for the most part - it pulls through the Product name, Product code, the sales price and the purchase price from Xero. However, it will not pull through the sales and purchase codes (GL codes) and I can’t figure out why.
The SOQL we have created is as follows:
SELECT ID, Name, productcode, Buy_Price__c, Sell_price__c, Purchase_Account__c, Sales_Account__c
FROM Product2
WHERE IsActive = True
AND productcode != ‘’
AND LastModifiedDate = TODAY
I can see the bundles being created when Make searches the records within Salesforce but then somehow all this gets lost as we match the product (via Product code) in Xero. I’ve attached a few snips in case this helps. Has anyone had a similar experience?
