Back to connectors… Back to Sage 200...

Nominal Receipt Payment - NominalCashJournalItem Nominal Code mapping (4 replies)

David F
8 years ago
David F 8 years ago

On the NominalCashJournalItem of the Nominal Receipt Payment, if the full nominal specification is 1100-- and the columns in the file to import are Nominal (1100) , CC (blank), Dept (Blank), how should this information be mapped? 

Support
8 years ago
Support 8 years ago

David, the nominal would be:

1100-- (exactl;y how you've written it).

We parse out each segment to populate the nominal code, cost centre and department.

David F
8 years ago
David F 8 years ago

As some Nominal Receipt Payments aren't importing and based on the advice above, I have removed the Cost Centre and Department mappings and updated the Nominal Account mapping to take the full nominal specification. The only error message that I am getting is:

An error occurred whilst creating the Nominal Cash Entry. The entry could not be posted and has been discarded. 10010 - The account specified [] does not exist.

How can I find out which account does not exist given that I have set log keys for the nominal specification at line level but no line level errors are reported in the Detail Processing Results?

David F
8 years ago
David F 8 years ago

The payments that aren't importing do have a common factor - they all have a / in the second reference field. Would a / cause an issue in any way?

Support
8 years ago
Support 8 years ago

David, if you run the integration from the scheduler, you will probably see an error which has a bit more info.

If this still isn't the case can you post a screenshot of the audit report (or we can take this offline to a support ticket).

No, second reference will not be issue.

Contact

    Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

    Looking to purchase IMan, please see our resellers here.

    Realisable Software
    Ph: +44 (0) 208 123 1017

    Copyright © Realisable. All rights reserved.
    Realisable is a registered trademark

    Close

    Request Demo

      Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

      Looking to purchase IMan, please see our resellers here.

      Realisable Software
      Ph: +44 (0) 208 123 1017

      Copyright © Realisable. All rights reserved.
      Realisable is a registered trademark

      Close

      Access Downloads

        Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

        Looking to purchase IMan, please see our resellers here.

        Realisable Software
        Ph: +44 (0) 208 123 1017

        Copyright © Realisable. All rights reserved.
        Realisable is a registered trademark

        Close