tag:blogger.com,1999:blog-6691994129222744759.post6126895744369494063..comments2024-03-21T11:36:24.769-07:00Comments on Dynamics GP Land: Completely Removing a Posted SOP Invoice From Dynamics GPChristina Phillipshttp://www.blogger.com/profile/03332221198245457747noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-6691994129222744759.post-55838900414368524282013-11-19T07:39:35.074-08:002013-11-19T07:39:35.074-08:00Thanks, Steve, I was just able to use this process...Thanks, Steve, I was just able to use this process to clean up a similar situation. Worked great!<br />Anonymoushttps://www.blogger.com/profile/07698239170698526514noreply@blogger.comtag:blogger.com,1999:blog-6691994129222744759.post-75122970367476136062013-01-14T13:14:05.459-08:002013-01-14T13:14:05.459-08:00Hello GP Gurus,
I would like to pick your brains &...Hello GP Gurus,<br />I would like to pick your brains & this was the best blog, related to my problem. <br /><br />1. When I print my Document Inquiry Report (or open order report) there are at least (56) SO numbers listed at the beginning.<br /><br />2. The Customer ID field is blank, as well as the customer name and the date is 0/0/000. Plus all money totals are zero. <br /><br />3. I have tried voiding these open orders, but it says I cannot void something that has posted.<br /><br />4. I can find these jobs in the system, but all customer info fields are blank.<br /><br />I guess my question is, is there a way of flushing these jobs out? Anonymoushttps://www.blogger.com/profile/03449753253745618219noreply@blogger.comtag:blogger.com,1999:blog-6691994129222744759.post-62628884867527204552012-01-06T21:58:37.172-08:002012-01-06T21:58:37.172-08:00HI Mariano,
i am facing some issues in eConnect f...HI Mariano,<br /><br />i am facing some issues in eConnect for SOP Invoice.<br />1. I want to migrate SOP open invoice(Fully Unaaply and Partially apply)<br />2.Here we have take information for header in SOP30200 and Line from SOP30300<br />3.If i migrate these details will migrated into SOP10100 as a header and SOP10200 as a line.(there we can post)<br />4. The problem is i am taking information from history table, the econnect wont allow the distribution type 14 and 15 because these two posting accounts<br />5. How can i avoid the posting account--DISTTYPE(14 & 15) while migrating SOP Invoice? Is there any way? Thanks in Advanceweb developerhttps://www.blogger.com/profile/13664617876488633153noreply@blogger.comtag:blogger.com,1999:blog-6691994129222744759.post-7394157249705566602010-07-08T15:38:49.080-07:002010-07-08T15:38:49.080-07:00Well, in my scenario, the client uses non-inventor...Well, in my scenario, the client uses non-inventory items, so the inventory implications is one of the caveats that I mention that might not work perfectly--the inventory quantities would presumably need to be returned via SOP.<br /><br />But, regarding the GL impact, I just did a test in TWO, and I'm showing that the GL JE for the voided RM transaction does reverse the Inventory and COGS.<br /><br />So it seems that the GL is taken care of, and it would only be inventory that needs cleanup for clients that use inventory items?Steve Endowhttps://www.blogger.com/profile/03950475674093020502noreply@blogger.comtag:blogger.com,1999:blog-6691994129222744759.post-8795023225028919562010-07-08T05:34:09.604-07:002010-07-08T05:34:09.604-07:00Including the inventory and cost of goods portion?...Including the inventory and cost of goods portion? I thought when a SOP invoice got posted to RM it only carried over the RM related portion (SLS, RM, TAX, etc.) and that the inventory and cost of goods all went straight to GL, hence the reason for the "This invoice was posted in Sales Order Processing.." message.<br /><br />Now I am intrigued :-)Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-6691994129222744759.post-46267167128693426912010-07-07T22:03:52.755-07:002010-07-07T22:03:52.755-07:00Hi Mariano,
Well, the caveat that I mention with ...Hi Mariano,<br /><br />Well, the caveat that I mention with this specific procedure is that the RM transaction has been voided (or would need to be voided), so the GL distributions are reversed during that process.<br /><br />There might be some element that I'm missing, but based on some tests, it looks like the void completely reverses all of the SOP distributions.<br /><br />Thanks,<br /><br />SteveSteve Endowhttps://www.blogger.com/profile/03950475674093020502noreply@blogger.comtag:blogger.com,1999:blog-6691994129222744759.post-81426826304083029302010-07-05T17:18:34.956-07:002010-07-05T17:18:34.956-07:00You missed one: the transaction will still be in G...You missed one: the transaction will still be in GL if it was posted. Removing the transaction from RM and SOP won't remove the GL distributions, so it's best to use the backout JE feature in GL to get rid of these.<br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.com