RE: Integration Manager: Can you change the DOC number without changing the Document Number?
Thanks for the response, sorry it took so long to respond.
The orders come from a web site and are being imported via ODBC in Integration Manager. The integration splits the query into a list and details. I don't see an order ID field in the Sales Transaction mapping, so I think what you mean is change the DOC number to be the order ID (which the web site creates), or set Document Number field in the IM mapping to be the order ID. I want to do the former but not the latter. I might be using the wrong terminology (it's based on the GUI) so I'll explain my view:
The DOC number (in IM) and the Document Number (in GP) are two different things that sometimes match up... The DOC number, AFAICT, is just a serial integer that IM displays during the integration. It seems to disappear after that. This is currently set to "Use Default" in IM. This is the number I want to change, because if an order doesn't integrate, there is no way to figure out which order. The Document Number maps into GP (currently something like W000132456). Currently, when set to Use Default in IM, I think this just uses some built-in default. I tried setting this once, and it worked, the DOC displayed in IM matched the order ID from the site, but it also changed GP's Document Number to be the order ID, not the W... format. This broke other pieces that apparently depend on the W... format.
I hope that helps... Maybe it isn't possible. My last resort would be to run a query via script after each document and insert the DOC number to map to an order ID...but that would be terrible for performance and workflow.
Thanks again.
Share
Report
135
All responses (
Answers (
