tag:blogger.com,1999:blog-2902800390575811159.post31981257368915354..comments2023-12-25T03:01:26.251-06:00Comments on Dynamics Confessions Blogspot: Moving from Work to Open to HistoryDynamics Confessorhttp://www.blogger.com/profile/06555435567985477366noreply@blogger.comBlogger18125tag:blogger.com,1999:blog-2902800390575811159.post-36485051453983665612018-02-09T10:50:15.981-06:002018-02-09T10:50:15.981-06:00Does anyone have this documented for Project Accou...Does anyone have this documented for Project Accounting Billing transactions? Anonymoushttps://www.blogger.com/profile/15819866213431806972noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-90099908002763028692015-01-17T10:43:11.548-06:002015-01-17T10:43:11.548-06:00Hi, is there a script for unlinking invoices which...Hi, is there a script for unlinking invoices which were applied to a voided RMR?<br /><br />Thanks<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-3291430868364786762015-01-12T23:13:59.158-06:002015-01-12T23:13:59.158-06:00yes i have found a record in POP30390.
We cannot r...yes i have found a record in POP30390.<br />We cannot re-receive as the items were already included in the inventory count and yes we cannot invoice match the items as well.<br /><br />THANKS :DYhelhttps://www.blogger.com/profile/00029526618030859329noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-15984518082253963062014-09-16T09:36:19.826-05:002014-09-16T09:36:19.826-05:00Do you have anything in the POP30390 table for tha...Do you have anything in the POP30390 table for that particular receipt? <br /><br />Did the items received show up in your inventory count and general ledger? <br /><br />Can you 're-receive' the item? <br /><br />I presume that you cannot invoice match the item. If you have checked the SQL tables and the data just isn't there, I would look at these other places to find it. Another thing I would do is search the database for all occurrences of both the PO Number and the Receipt number. There are several SQL scripts available on the internet that will allow you to do that. If you can't find it, send me an e-mail and I'll send you one - leslievail@earthlink.net<br /><br />If it still isn't there, that means it's just gone. What you can do is to move that receipt transaction to history (you may need to cancel the PO as well) and then re-enter the whole sequence. Doing that will allow you to use the same PO and Receipt numbers. Make sure you do not double up in your GL or inventory module (as to item count).<br /><br />Depending on where the receipt is missing, you can make manual entries to the affected modules rendering the receipt unnecessary.<br /><br />For instance, you could do an inventory transaction to get the items in inventory at the correct cost and then enter the vendor's invoice directly into payables. Make sure your entries properly hit the GL accounts to clear your accrued purchases account if necessary. You would need to cancel the PO so that the PO could be moved to history as well.<br /><br />Leslie Dynamics Confessorhttps://www.blogger.com/profile/06555435567985477366noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-37429693737321499692014-09-16T01:47:06.173-05:002014-09-16T01:47:06.173-05:00Hi, how to resolve the problem if the order receip...Hi, how to resolve the problem if the order receipt is missing, i found out that the receipt details is missing in pop30310 but it has a header in pop30300? i also check the pop10300 and pop10310 but there's no deatails.<br /><br />what should i do? <br />thanks :)Yhelhttps://www.blogger.com/profile/00029526618030859329noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-10632142839578263922014-09-03T22:41:33.632-05:002014-09-03T22:41:33.632-05:00Your way of describing all in this post is in fact...Your way of describing all in this post is in fact nice, every <br />one can easily understand it, Thanks a lot.<br /><br />My website; international moving company - <a href="http://chipskylark.com/blog/view/758033/clear-cut-international-moving-systems-whats-needed" rel="nofollow">http://chipskylark.com/blog/view/758033/clear-cut-international-moving-systems-whats-needed</a> -Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-75937841999788872882013-05-07T23:55:05.156-05:002013-05-07T23:55:05.156-05:00Hi,
Great idea, I'll look into doing this!
T...Hi,<br /><br />Great idea, I'll look into doing this!<br /><br />Thanks <br /><br />LeslieDynamics Confessorhttps://www.blogger.com/profile/06555435567985477366noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-14460426140414827842012-11-12T07:22:58.530-06:002012-11-12T07:22:58.530-06:00This is a great article. But can one explain the a...This is a great article. But can one explain the above (WORK, Open, History) as it pertains to Expense/Revenue deferrals (mainly revenue) ?<br /><br />Thank youitohttps://www.blogger.com/profile/04888827537355834147noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-10808690135037179472011-12-29T01:30:37.646-06:002011-12-29T01:30:37.646-06:00thank you Leslie, for advice, what I do is delete ...thank you Leslie, for advice, what I do is delete the complete purchase order.xFuturehttps://www.blogger.com/profile/15150462213330153921noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-53949134512438870402011-12-28T06:23:29.708-06:002011-12-28T06:23:29.708-06:00Hi xFuture,
Can you still access the document fro...Hi xFuture,<br /><br />Can you still access the document from the Receivings Trx Entry window (I'm guessing the answer is 'no').<br /><br />I would first try the usual suspects before resorting to SQL to delete the entries.<br /><br />1. Check Links<br /><br />2. Reconcile<br /><br />3. Remove Completed Purchase Orders<br /><br />This kind of thing happens every now and then, fortunately not very often. Let me know if these utilities do any good. BE SURE TO BACK UP before running any utilities.<br /><br />LeslieDynamics Confessorhttps://www.blogger.com/profile/06555435567985477366noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-12780332616848051752011-12-26T22:28:50.964-06:002011-12-26T22:28:50.964-06:00hi Leslie, I had a problem in receivings transacti...hi Leslie, I had a problem in receivings transaction entry, I have a receipt document when the document that I posted, the status of the document that became the post and unposting, document exists in the table POP10300 and POP30300, any suggestions to solve this problem.xFuturehttps://www.blogger.com/profile/15150462213330153921noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-42254598934025421552011-05-11T01:01:39.580-05:002011-05-11T01:01:39.580-05:00Thank you Harish,
You are inspiring to me. Thank ...Thank you Harish,<br /><br />You are inspiring to me. Thank you for taking the time to comment!<br /><br />LesleiDynamics Confessorhttps://www.blogger.com/profile/06555435567985477366noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-36228423014402260102010-04-23T21:42:25.194-05:002010-04-23T21:42:25.194-05:00This is one of the most useful bits of GP document...This is one of the most useful bits of GP documentation I've seen.<br /><br />I'm still mystified how these statuses do anything other than slow down work processes and make reporting and research difficult. That said, this takes away some of the mystery in the terminology.<br /><br />Now if I can only find a similar description of the various reporting tools and their utility (major weak link of GP), and a description of the various levels of user accounts (not permissions, but accounts) that are required to run GP, I would have coverage for the most uselessly confusing bits of this system.Denny Wellshttps://www.blogger.com/profile/05582713647195673139noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-35147946115023672162010-01-11T09:23:29.824-06:002010-01-11T09:23:29.824-06:00Hi Leslie,
Thanks a lot. That was the missing link...Hi Leslie,<br />Thanks a lot. That was the missing link :-). I've suggested to the purchasing departement to include it in the monthly closing routine.<br />Hope to meet @ Convergence 2010.<br />Thanks and have a great Day.Beat BUCHERhttps://www.blogger.com/profile/07394259942485626115noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-62660574586850240662010-01-09T10:24:45.848-06:002010-01-09T10:24:45.848-06:00Hi,
PO documents are not moved to the history tab...Hi,<br /><br />PO documents are not moved to the history tables automatically. You need to run the 'Remove Completed Purchase Orders' routine. Navigate to Tools>>Routines>>Purchasing>>Remove Completed Purchase Orders.<br /><br />Please let me know if you have any questions!<br /><br />You bet I'll be in Atlanta - see you there!<br /><br />LeslieDynamics Confessorhttps://www.blogger.com/profile/06555435567985477366noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-14436175017248181612010-01-08T11:35:51.188-06:002010-01-08T11:35:51.188-06:00Hi Leslie,
This is a great summary of the GP docum...Hi Leslie,<br />This is a great summary of the GP document flow. However, in the current company I'm working with (since 6 months), I realized that the POP documents are not transfered to the History tables (POP30100/POP30110)... the last documents are dated from 2005 and 2 only from 2007... we're creating every day new PO's... the history table has less then 200 entries, whereas the work table has close to 10k rows.<br />Any tips would be appreciated to solve this mistery :-)<br />Hope to see you in Atlanta this year.Beat BUCHERhttps://www.blogger.com/profile/07394259942485626115noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-81460519219732542892009-11-12T08:09:47.164-06:002009-11-12T08:09:47.164-06:00Thank you for taking a look. Also, thanks for aski...Thank you for taking a look. Also, thanks for asking the question in the first place - I had never really gone through each one in a single document. I hope this will help others who are trying to understand this.Dynamics Confessorhttps://www.blogger.com/profile/06555435567985477366noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-13848884196563776442009-11-12T06:06:40.420-06:002009-11-12T06:06:40.420-06:00Leslie, this is great! When learning GP it’s conf...Leslie, this is great! When learning GP it’s confusing trying to understand how documents move thru the system – this really helped!!Unknownhttps://www.blogger.com/profile/13954550972731467323noreply@blogger.com