Error: Error Creating Sales Record

Error Creating Sales Record appears in the NetSuite integration log when NetSuite rejects an API request sent by Zoey. Zoey reports the rejection as-is, so the text after Message: comes from NetSuite, not from Zoey.

The most common cause is a required field arriving empty. When a Zoey Payment Method, Shipping Method, Currency, or custom field is not mapped to its NetSuite counterpart, Zoey omits that value from the API request. If NetSuite requires the field on the record being created, it refuses to save the record and returns an error naming the fields it expected.

Read the Message: portion of the log entry to identify which fields NetSuite rejected, then map those fields in the Zoey NetSuite Integration.

Message: Please enter value(s) for: Payment Method, Payment #

This error occurs when Zoey attempts to sync a Customer Payment to a NetSuite Invoice, and NetSuite requires both the Payment Method and Payment # fields on that Customer Payment record.

Why it happens

Two settings in the Zoey NetSuite Integration determine this behavior:

• Apply Payment when Invoices are Paid by Customer
  When set to Yes, Zoey creates a Customer Payment in NetSuite and applies it to the associated NetSuite Invoice each time a customer pays a Zoey Invoice.

• Payment Mapping
  Links each Zoey Payment Method to its NetSuite counterpart. If the Payment Method used to pay is not mapped, no payment method is included in the request and NetSuite returns an error.

For example, Zoey Invoice was paid with the Credit Card payment method. Zoey attempted to apply that payment to the NetSuite Invoice.

But because Credit Card was not mapped to a NetSuite Payment Method, the request contained no payment method and NetSuite returned Please enter value(s) for: Payment Method, Payment #.

Resolve Payment Method

Map the Zoey Credit Card payment method to a NetSuite Payment Method:

1. Open the Zoey NetSuite Integration and go to Payment Mapping.
2. Locate Credit Card in the list of Zoey Payment Methods.
3. Select the NetSuite Payment Method to map it to.
4. Save the integration settings.

For full details on this screen, including Net Terms and Payment Option mapping, see Mapping Currencies, Payments, and Shipments with NetSuite.

Resolve Missing Payment Field

Any field NetSuite requires on a payment transaction can be mapped from Zoey, but the field has to be identified first. Internal field IDs vary between NetSuite accounts, particularly for custom fields, so an ID that works in one account will not necessarily match another.

This applies to Payment # and to any other field named in the Message: text of the error.

Contact Zoey Support with the following:

• Field name
  The field as it appears in the NetSuite error message, such as Payment #.

• Internal ID
  The Internal ID of an existing NetSuite payment transaction where that field already holds a value.

• Field Value
  The value held in that field on that transaction.

Zoey Support looks the record up through the API to determine the underlying field ID. Once identified, the field can be mapped through Payment Field Mapping in the Zoey NetSuite Integration.

Confirm the fix

After mapping is saved, pay a Zoey Invoice on an Order that has an associated NetSuite Invoice, then confirm:

• The Customer Payment record is created in NetSuite and applied to the expected Invoice.

• Error Creating Sales Record no longer appears in the integration log for that Order.

To reconcile payments that failed while the mapping was missing, see Manually Sync to NetSuite.