Specify all nominal codes in the form:

--

In your example the nominal code would be as is:

1100-TS1-AFA

If you have an empty Cost Centre or Department, just leave an empty value i.e.

1100-TS1-

Or 

1100--AFA

Or

1100--

I am already specifying the nominal codes in this way. I am trying to import the following:

Line Type : 1

Description

Quantity : 1

Unit Selling Price : negative amount

Nominal Specification: as advised

Please can you advise further

David, it should work (this is a common pattern for handling discounts).

I have attached a screenshot of the preview indicating the mapping of the fields and the values.

You may want to see if the 'Allow amendment of: Nominal Codes' is enabled in SOP Settings.

If you have changed this latter setting you may need to restart the Realisable Data Service.

Thanks

The nominal specifications are of the format: 1234-ABC-DEF

In SOP Settings, Allow amendment of Nominal Codes is already checked and the Realisable Data Service restarted through the admin console.

I am still getting the error. The first order header has been written to sage but none of the lines. Interestingly, the order has an amount equivalent to the amount of discount. I am wondering if the Sage 200c connector cannot submit a free text order line with an amount and nominal specification to Sage 200. Could this be a fault with the connector? 

I have carried out further testing. The outcomes are as follows:

Action on Transform Error           Outcome

Abort                                            The Nominal Account specified does not exist

Reject Record                              Object Reference not set to an instance of an object

Continue                                       All orders submitted but with no nominal code on free text line

What and where in Sage 200c does the connector check for the existence of a nominal code/specification?

Please can you advise me

Issue related to having the SOP Settings to take Nominal Account from Customer, but the default Nominal Code on the Customer was not set.