Read multiple document types from the import source to generate either a Quote or an Order
Is there a way to add the option to generate a Quote or an Order from my existing excel template? If so, how would I go about it?
Hard to say exact steps w/o seeing what you have.
However if the map should do “order” and “quotes” now, then clearly you can no longer have things “hard coded” as you do now.
So in your source you would need to have order/quote field so the map knows what to create. then you’d need either the docid as well or else use a calculation and hard code based on the sop type you are now passing the map.
Lastly, you’d need to fix the global rolling column to use the new values vs hard coded values.
With your instruction, I was able to add the document type in the source file. How would I go about fixing the global rolling column to know when there is an order verses when there is a quote? right now I have a GP rolling column just for the order, and it does not allow me to alter between two document types?
I believe I have this working now. I found a write-up on using a “Translation” table, which will allow the document type to be driving by the spreadsheet source document.
Thank you for your help
If you would like to submit an answer or comment, please sign in to the eOne portal.