Back to connectors… Back to Sage 300...

Subscript out of range: Trying to insert Misc line to shipment & create an invoice (5 replies)

Arline Welty
4 years ago
Arline Welty 4 years ago

Howdy all,

I've checked the auditlog & errors.txt but don't see anything more descriptive than "Subscript out of Range" when I try to use the Sage 300 connector to 

  1. Insert a new Misc charge line to an existing shipment; 
  2. Create an invoice from that shipment

I've tried clearing all the detail maps and just invoicing the existing shipment but I think I am missing something with my mappings. Maybe you can advise. Is it the "line match method" field? What is that meant to be set to?

Here are my existing mappings.

 

This relates to some of my earlier posts (though I do not see them on the forum any more), and also looks related to this question from a few months ago, but without the successful mapping posted I'm not sure how to proceed. Thanks for any advice.

Arline

https://www.realisable.co.uk/wp-content/uploads/2019/12/ShipInvSetup.png
Support
4 years ago
Support 4 years ago

Arline, I believe we went through this issue.

https://www.realisable.co.uk/sage-300/matching-invoice-detail-could-not-be-found/page-2/

We moved your post to the Sage300 page (as we have this one).

Arline Welty
4 years ago
Arline Welty 4 years ago

Hmmm. I think I will still need more detail please. I have based my mappings on the Invoice mappings, so what am I missing? I am indeed trying to map the detail lines (as I must insert the new Misc charge line). But you can see the mappings match those of the invoice maps we created earlier. The only exception is, for the Sage 300 Shipment connector, I've flagged "Create Invoice from Shipment" as "True." You can compare the mappings here. Ideally I would replace the Invoice connector with this Sage 300 Shipment connector that ALSO creates the invoice.

 

https://www.realisable.co.uk/wp-content/uploads/2019/12/InvSetup.png
Support
4 years ago
Support 4 years ago

Do you have anything in Errors.txt?

Arline Welty
4 years ago
Arline Welty 4 years ago

Think I mentioned that - I'm not seeing anything in Errors.txt 🙁

Arline Welty
4 years ago
Arline Welty 4 years ago

Any thoughts on this?

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