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?
I will create SQL scripts. Much quicker than IM.
If they have Integration Manager (IM), you could export the Returns and Import using IM as Invoices.
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.
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.
Martin Dráb
487
Most Valuable Professional
Abhilash Warrier
310
Saalim Ansari
291