138
How to Link a DROPSHIP order with purchase order ! both the PO and sales order has been posted.
Already inserted record into sop60100 table no luck , still in gp the link is not showing up on inquiry window. Please provide your inslight on this.
Hi,
I'm not sure what you mean by the PO and the Sales Order is posted. You might have to elaborate just to make sure I understand. From a GP perspective you are unable to post a Sales Order or a Purchase order. You can transfer a sales order to an invoice, and you can create a Shipment Receipt or Shipment/Invoice off of a Purchase order, but you can't post either one. So, I just want to make sure I understand what you are saying to make sure I answer you correctly. :0). Sometimes 3rd parties post POs, but I can't answer how those products impact files/fields.
From a GP perspective, unfortunately, there is more to linking than just the SOP60100. There are multiple fields on the SOP side as well that get populated during the process. Each field get populated at different times during the process depending where you are at in that process (whether the Invoice on the PO side is posted or not). Same for the SOP60100.
Here is what I suggest. Typically, this is not supported, but it might be the only option you have.
1. I would enter via the front end a SOP order for a drop ship item and transfer it to a purchase order.
2. Run a select statement on the SOP10200 for the line item and the SOP60100 table. These would be the two tables I would focus on. These results would show you what it would look like BEFORE invoicing in POP. The main fields I can think of that would change during the process are QTYONPO, QTYTOINV in the SOP table. There would be others as well. The SOP60100 look at all of them.
3. Next Invoice match in POP and post. Then Run the select statements against the two tables again and save the results. You can look at the difference and see what updated.
4. Next transfer the order to an invoice and run the select statements against the SOP60100 and the SOP30300 table (order should be in history). Again, notice the difference.
Because I'm not 100% sure where your other document(s) are at in the process, use the test example you did above and compare the set of scripts in the at the same spot to compare the data to and see what fields need to be updated. My guess is there are other fields that just haven't been correctly updated and therefore it's not seeing the 'link' or that there was a PO linked. My guess it's in one of those few tables I mentioned, but if that doesn't work after up updated the table, then you would have to start looking at all of the other SOP/POP tables to compare to and see what else might be different. We do have an ALL PO and Receipts and an ALL SO script available in support that you could use to pull all the data. If you don't have them let me know and I will get them for you.
Hope this helps,
Thanks for using community forums,
Angela Ebensteiner,
Microsoft Support
Share
Report
All responses (
Answers (
