75,730
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
288,768
Super User
#2
Martin Dráb
225,985
Super User
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (