HI guys,
When i sync a return from Magento to GP,im getting this ERROR how can i solve this ?Please do help
*This post is locked for comments
Announcements
HI guys,
When i sync a return from Magento to GP,im getting this ERROR how can i solve this ?Please do help
*This post is locked for comments
Hi Leslie,
My input string is like below.
Please see the message and verify
" {"Customer":{"AddressEntity":[{"SourceAddressId":"227501","TargetAddressId":"PRIMARY","TargetCustomerId":"50842907","Title":null,"FirstName":"David","LastName":"Garfield","Name":"","EmailAddress":"dave@garfieldsbeverage.com","City":"Norridge","AddressLine1":"4601 N Harlem Ave","AddressLine2":" ","AddressLine3":"","AddressLine4":"","StateCode":"IL","CountryCode":"US","CountryName":"United States","Zip":"60706","PhoneNumber1":"7084571000","PhoneNumber2":null,"PhoneNumber3":null,"FaxNumber":"0000000000","IsDefaultBillingAddress":true,"IsDefaultShippingAddress":true,"CompanyName":"Garfield's Beverage Warehouse","LastUpdated":"2018-02-22 18:29:58","StoreId":0,"IsSaveInAddressBook":true,"IsBilling":true,"IsShipping":true,"ValidationMessage":"","UserDefined":null,"DeliveryInstructions":null}],"CustomerGroupEntity":{"SourceCustomerGroup":"9","TargetCustomerGroup":null,"CustomerGroup":"LSC-TAXABLE","CustomerGroupDescription":"LSC-TAXABLE","SourcePriceLevel":"BASE","TargetPriceLevel":"BASE","UserDefined":null},"SourceCustomerId":"141316","TargetCustomerId":"50842907","Title":null,"FirstName":"David","MiddleName":null,"LastName":"Garfield","EmailAddress":"dave@garfieldsbeverage.com","IsGuestCustomer":false,"PriceLevel":null,"CompanyName":null,"TaxRegistrationNumber":null,"Currency":null,"IsActive":true,"CreditLimitAmount":null,"CreditLimitType":null,"CreditLimitPeriods":null,"CreditLimitPeriodAmount":null,"FinanceChargeAmount":null,"FinanceChargePercent":null,"CreatedDate":"2018-02-22","LastUpdated":"2018-02-22","ValidationMessage":null,"UserDefined":null,"SalesPerson":null,"MagentoCustomerId":null,"IsChild":false,"BusinessType":"Retail","AllowLocalDelivery":"0","POStatus":null,"PONumber":null,"Warehouse":null,"OnHold":"N"},"Items":[{"TierPrice":[],"Name":"TCP 15 Watt 48\" T8 Linear LED 3500K 1650 Lumen 82 CRI Medium Bipin (G13) Base Glass Tube (LED4T815IS35K)","SKU":"LED4T815IS35K","Description":"TCP 15 Watt 48\" T8 Linear LED 3500K 1650 Lumen 82 CRI Medium Bipin (G13) Base Glass Tube (LED4T815IS35K)","ParentSKU":null,"ShortDescription1":"TCP 15 Watt 48\" T8 Linear LED 3500K 1650 Lumen 82 CRI Medium Bipin (G13) Base Glass Tube (LED4T815IS35K)","ShortDescription2":null,"Quantity":null,"CostPrice":null,"LastUpdated":"2018-03-03 03:58:29","Notes":null,"DepartmentId":null,"CategoryId":false,"SpecialPrice":"6.9500","UnitPrice":"6.9500","SalePrice":"6.9500","SaleStartDate":null,"SaleEndDate":null,"UnitOfMeasure":"EA","ItemType":"simple","GiftType":null,"QuantityOrdered":2,"SupplierId":null,"Weight":"1.0000","TaxType":"0","DateCreated":"2016-07-11 14:56:11","IsActive":1,"Status":"1","DiscountReasonCodeId":null,"DefaultDiscountReasonCode":null,"DiscountAmount":0,"IsTierPriceApplied":true,"VoucherNumber":null,"GiftcardAmount":0,"SendTo":null,"StoreId":"0","AllowBackOrder":null,"ChildItems":null,"AttributeSet":null,"ICSPStatus":null,"ReturnableStatus":null,"CloseOut":null,"UserDefined":null,"WareHouseQuantity":null,"QtyReturned":2,"Comment":"Damaged","ReturnQuantityType":"service","OriginalPrice":null}],"Payment":[{"PaymentName":"gene_braintree_creditcard","CreditCardNumber":"9761","CVV":null,"ExpiryMonth":"01","ExpiryYear":"2021","PaymentAmount":"732.5200","CardType":"Visa","TransactionNumber":null,"UserDefined":null}],"Invoice":null,"Shipment":null,"SourceOrderId":"336557","TargetOrderId":"G0185590","SourceReturnId":"25226","TargetReturnId":"","DiscountAmount":0,"StoreId":0,"ShiptoId":null,"TransactionNumber":null,"ShippingChargeOnOrder":0,"ShippingTrackingNumber":null,"Comment":"ON: G0185590;line: LED4T815IS35K-Damaged;CT:;","SubTotal":0,"GrandTotal":0,"TaxAmount":"0.0000","OrderStatus":"New","Shippingmethod":"standardrate_standardrate","CarrierName":null,"DiscountCode":null,"Currency":null,"ValidationMessage":null,"CreatedDate":"2018-03-08","LastUpdated":"2018-03-08","IsOrderCustomWorkFlow":false,"ExternalOrderId":null,"OrderIncrementId":null,"Origin":"website","UserDefined":null,"SalesPerson":{"SalespersonId":"HOUSE","SalesTerritoryID":"NC","Email":"HOUSEAccts@LightingSupply.com","FirstName":"House","MiddleName":null,"LastName":"","CommissionApplyTo":"sales","GpOrderId":null,"Commission_Onorder":null,"GpCustomerId":null,"Inactive":1,"Percent":"0","AddressLine1":null,"AddressLine2":null,"AddressLine3":null,"AddressLine4":null,"StateCode":null,"CountryCode":null,"CountryName":null,"Zip":null,"PhoneNumber1":null,"PhoneNumber2":null,"PhoneNumber3":null,"FaxNumber":null,"AddressEntity":[{"SourceAddressId":null,"TargetAddressId":null,"TargetCustomerId":null,"Title":null,"FirstName":"House","LastName":"","Name":null,"EmailAddress":null,"City":"","AddressLine1":"","AddressLine2":"","AddressLine3":"","AddressLine4":"","StateCode":"","CountryCode":"","CountryName":null,"Zip":"","PhoneNumber1":"","PhoneNumber2":"","PhoneNumber3":"","FaxNumber":"","IsDefaultBillingAddress":false,"IsDefaultShippingAddress":false,"CompanyName":null,"LastUpdated":null,"StoreId":0,"IsSaveInAddressBook":false,"IsBilling":false,"IsShipping":false,"ValidationMessage":null,"UserDefined":null}],"CreatedDate":null},"WareHousePriority":false,"AdjustmentRefund":null,"AdjustmentFee":0.7,"CustomerbalanceReturnEnable":null,"CustomerbalanceReturn":null,"RefundGrandTotal":"13.21","RefundShippingAmount":"0.0000","CODAmount":false,"UserDefined1":null,"loggedInUser":"i95login","Batch":"Immediate"}"
Have you checked your source data? You'll need to identify the record that is trying to return more than is on the document.
Leslie
Almas Mahfooz
3
User Group Leader