Back to connectors… Back to Sage 300...

System Company AR Invoices (1 reply)

Jaime
4 years ago
Jaime 4 years ago

The AR Invoice is not allowing me to link the OrgId to System Company. How do I resolve this?

https://www.realisable.co.uk/wp-content/uploads/2019/12/AR-Invoice-Header.jpg
Support
4 years ago
Support 4 years ago

Jaime, the A/P Invoice Batch is the only Batch Type Import which allows you to map the Company at the Invoice/Header level.

In order to map the OrgId/System Company you would need to have a three level hierarchy: Batch, Header, Detail; the Batch level specifies the System Connector.

To achieve this you will need to add a hierarchy transform into your existing integration. I recommend creating a brand new branch of processing, and once you're happy with the results delete the old one.

Below is a set of screenshots which describe how to do this.

0 - Design Setup with corresponding numbers for the screenshots.

  1. The existing two level hierarchy.
  2. Add a new Hierarchy transform, click the Field Mapping, then press the Edit button.
  3. Deselect all the fields to remove the invoice related fields, leaving on the batch related fields. Specify the OrgiD field as the only key.
  4. Create a new transaction (Invoice), set the parent property to the top most transaction, and the Copy Child transactions to the newly created transaction (Invoice). Press the Edit button.
  5. Setup the Fields on the new Header transaction and set the Keys accordingly.
  6. Press Refresh...you should now have the data grouped by OrgId/System Connector Id.
  7. Add the Sage300 Connector, click the Field Mapping. Associate the top most transaction to Invoice Batches. You will see the System Connector field.
  8. The newly created transaction (Invoice) will be sorted to the bottom, despite it logically sorting to the middle transaction.
  9. Select it, and map it to the Invoices level.

I hope this describes the steps.

https://www.realisable.co.uk/wp-content/uploads/2019/12/9-Sage300-InvoiceHeaderEntryMapping.png
https://www.realisable.co.uk/wp-content/uploads/2019/12/8-Sage300-NewTransaction-Gotcha.png
https://www.realisable.co.uk/wp-content/uploads/2019/12/7-Sage300-InvoiceMap.png
https://www.realisable.co.uk/wp-content/uploads/2019/12/6-3-LevelHierarchyPreview.png
https://www.realisable.co.uk/wp-content/uploads/2019/12/5-FieldAndKeySetupForNewTransaction.png
https://www.realisable.co.uk/wp-content/uploads/2019/12/4-NewTransactionForEntry.png
https://www.realisable.co.uk/wp-content/uploads/2019/12/3-BatchLevelSetup.png
https://www.realisable.co.uk/wp-content/uploads/2019/12/2-HierarchySetupInitial.png
https://www.realisable.co.uk/wp-content/uploads/2019/12/1-ExistingHierarchy.png
https://www.realisable.co.uk/wp-content/uploads/2019/12/0-DesignSetup.png

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