Please see below the issues we encountered when creating a test invoice in the production environment. Note that these payloads have been working in Sandbox since July.
Invalid currency reference key
Error Message:
{'type': 'https://www.rfc-editor.org/rfc/rfc9110.html#section-15.5.1', 'title': 'Bad Request', 'status': 400, 'o:errorDetails': [{'detail': 'Error while accessing a resource. Invalid currency reference key Philippine Peso.', 'o:errorCode': 'USER_ERROR'}]}
JSON Payload:
{'externalId': 'Shopee_230815PHDHAUEU_staging_schedule', 'entity': {'id': '86862', 'entityId': 'Shopee_230815PHDHAUEU'}, 'class': {'refName': "Managed Services : Outright : Non-FMCG : Levi's"}, 'currency': {'refName': 'Philippine Peso'}, 'custbody19': {'refName': 'Sales Invoice'}, 'custbody4': {'refName': '4 Charlie Rose Hernandez'}, 'location': {'refName': 'Warehouse'}, 'terms': {'refName': 'Due on receipt'}, 'custbody_customer_first_name': 'Shopee', 'custbody_customer_last_name': 'Customer 230815PHDHAUEU', 'custbody_brand': 'Levis', 'item': {'items': [{'amount': 2312.5, 'custcol_4601_witaxapplies': False, 'quantity': 1, 'orderLine': 1, 'price': {'id': '1', 'refName': 'Base Price'}, 'item': {'refName': '2950710617476'}}]}}
Tax Code Value Requirement
Notes:
- We removed the 'currency': {'refName': 'Philippine Peso'} part of the payload since we noticed in prod that the default currency is Philippine Peso as well just to try to continue with the release. However, we're not sure if removing this will affect the invoice creation so we need your help to clarify the currency issue as well as the payload was working in the sandbox environment for weeks already.
- We do not include tax code values in our payloads since they should be automatically mapped upon invoice creation.
Error Message:
{'type': 'https://www.rfc-editor.org/rfc/rfc9110.html#section-15.5.1', 'title': 'Bad Request', 'status': 400, 'o:errorDetails': [{'detail': 'Error while accessing a resource. Please enter value(s) for: Tax Code.', 'o:errorPath': 'item.items[?(@.orderLine==1)]', 'o:errorCode': 'USER_ERROR'}]}
JSON Payload:
{'externalId': 'Shopee_230815PHDHAUEU', 'entity': {'id': '86862', 'entityId': 'Shopee_230815PHDHAUEU'}, 'class': {'refName': "Managed Services : Outright : Non-FMCG : Levi's"}, 'custbody19': {'refName': 'Sales Invoice'}, 'custbody4': {'refName': '4 Charlie Rose Hernandez'}, 'location': {'refName': 'Warehouse'}, 'terms': {'refName': 'Due on receipt'}, 'custbody_customer_first_name': 'Shopee', 'custbody_customer_last_name': 'Customer 230815PHDHAUEU', 'custbody_brand': 'Levis', 'item': {'items': [{'amount': 2312.5, 'custcol_4601_witaxapplies': False, 'quantity': 1, 'orderLine': 1, 'price': {'id': '1', 'refName': 'Base Price'}, 'item': {'refName': '2950710617476'}}]}}