Announcements
No record found.
Here is something I have never been asked to do before. For some reason the client's import program imported 1,200 invoices as returns. The import process cannot be run a second time. Would it be possible to change the SOPTYPE to 3 and then adjust the quantities on these returns and then finish the process by running IV Reconcile? I would also have to flip the distributions. Is there any hope this might be successful?
Hey Richard,
This not something that has ever been tested. You can certainly give it a try in test and see what happens. This would be the only way to determine what would happen if with this process.
Personally, I would contact the owner of the Import Program and see if they have a process to let them redo the Import. I would assume there would be some type of process for this as stuff can fail at times and has to be rerun.
Hopefully someone in the community was creative previously and had tried something like this and can provide their experience.
Thank you!
Brandon | Microsoft Support Engineer.
This import has per running for decades and this is the first time this ever happened. I could ask if there was a reason why this happened. It is an extremely complex import coming in from Shopify via eConnect.
If they have Integration Manager (IM), you could export the Returns and Import using IM as Invoices.
I will create SQL scripts. Much quicker than IM.
Yes, it is possible to change the SOPTYPE to 3 and adjust the quantities on the returns, then finish the process by running IV Reconcile. You'll also need to flip the distributions. This method should work, but be sure to back up your data before making these changes. If you're using an olansi water purifier, ensure you also regularly check and maintain it for the best water quality.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 692
André Arnaud de Cal... 532 Super User 2026 Season 1
CP04-islander 478
