tag:blogger.com,1999:blog-1326377569808004304.comments2023-10-18T04:01:43.173-04:00GP2TheMAX - Helping users get the 'MAX' from Dynamics GPFrank Hamellyhttp://www.blogger.com/profile/15697020892894195399noreply@blogger.comBlogger131125tag:blogger.com,1999:blog-1326377569808004304.post-52124255863905763142016-06-27T13:55:17.502-04:002016-06-27T13:55:17.502-04:00Hi Sue, it's been quite some time since I'...Hi Sue, it's been quite some time since I've worked on GP, having moved into the AX world about 3 years ago. It's been even longer since I took on a cleanup of old, un-received POs. The best suggestion I can offer would be to post your question on the GP forum - https://community.dynamics.com/gp/f/32. Lots of experts there that can help as well.<br /><br />Good luck!Frank Hamellyhttps://www.blogger.com/profile/15697020892894195399noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-6136512412045512512016-06-27T11:34:00.146-04:002016-06-27T11:34:00.146-04:00What if there are old items in accrued purchases (...What if there are old items in accrued purchases (received not invoiced) that were mistakenly paid another way or if they indeed were never invoiced (and will not be invoiced). I have items sitting in inventory and accrued purchases that are a couple of years old that I would like to clear out. Any suggestions how to do this?Suehttps://www.blogger.com/profile/11090002374019256089noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-12893066264199843182016-05-18T10:10:44.787-04:002016-05-18T10:10:44.787-04:00Wow good job! In my work I implements erp system f...Wow good job! In my work I implements <a href="http://axadsystem.com/advertising-management-software" rel="nofollow">erp system for advertising agencies</a>. This is a great developing and interesting jobAnonymoushttps://www.blogger.com/profile/02666245945780630517noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-51697414404319566532016-02-01T16:44:54.104-05:002016-02-01T16:44:54.104-05:00Hi Marc, the invoice cost is technically not relev...Hi Marc, the invoice cost is technically not relevant, since this report reflects receipts not yet invoiced. Once the invoice is matched and posted, the item drops off this report. Until you receive the invoice, as far as you know, your cost is the receipt cost, right? Frank Hamellyhttps://www.blogger.com/profile/15697020892894195399noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-81188762142160206472016-02-01T16:12:27.997-05:002016-02-01T16:12:27.997-05:00What if the Invoice price doesn't match the un...What if the Invoice price doesn't match the unit cost on the posted receipt? It would seem that simply (QTY Shipped - QTY Matched - QTY Rejected)*Unit Cost would not give us an accurate valuation of the received by not invoiced. Because our vendors take forever to get us the invoices, prices changed and we are often invoiced at prices that don't match the receipt. How can I figure out what my valuation should be for the quantities. I'm a SQL guy, so if you could put it in terms of tables, that would be swell.Anonymoushttps://www.blogger.com/profile/02885157893269933949noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-78953078280674453022015-10-22T11:47:57.904-04:002015-10-22T11:47:57.904-04:00A few of my users are having the same issue. Any u...A few of my users are having the same issue. Any updates on this?Just Another GP Guyhttps://www.blogger.com/profile/13712805995581468753noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-75932704195020681832015-09-21T15:08:37.821-04:002015-09-21T15:08:37.821-04:00Hi Kristin, in the SmartList, that would be the Jo...Hi Kristin, in the SmartList, that would be the Journal Entry column, in the SQL tables (GL10000, GL20000, GL30000) it would be JRNENTRY.Frank Hamellyhttps://www.blogger.com/profile/15697020892894195399noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-16950209448113857462015-09-21T12:15:19.488-04:002015-09-21T12:15:19.488-04:00I am looking for the journal number also, what fie...I am looking for the journal number also, what field would that be?Anonymoushttps://www.blogger.com/profile/11560253234861874788noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-72376715229391253392015-05-19T16:38:35.620-04:002015-05-19T16:38:35.620-04:00We get the same message, and we're using the S...We get the same message, and we're using the Standard Report Writer form....Anonymoushttps://www.blogger.com/profile/15746792199861524841noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-92134695408074784762015-04-07T09:16:56.111-04:002015-04-07T09:16:56.111-04:00Thank you. Just encountered this issue today with...Thank you. Just encountered this issue today with 18,000 AR invoices. Anonymoushttps://www.blogger.com/profile/03231126240796787766noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-8382353877589070392015-04-07T09:16:19.015-04:002015-04-07T09:16:19.015-04:00Thank you! Just encountered this am with 18,000 A...Thank you! Just encountered this am with 18,000 AR invoices. Sorry we are benefiting from your suffering:)Anonymoushttps://www.blogger.com/profile/03231126240796787766noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-12449561034613956622015-03-27T15:23:06.977-04:002015-03-27T15:23:06.977-04:00Thank you for the blog
I had not thought of that....Thank you for the blog<br /><br />I had not thought of that. it also works if you just blank out the Class ID field.Anonymoushttps://www.blogger.com/profile/08586596839169946707noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-12199319982559878452015-03-27T08:11:20.570-04:002015-03-27T08:11:20.570-04:00Hi Frank,
Thanks for the post. And any quick guide...Hi Frank,<br />Thanks for the post. And any quick guide on setting up an approval hierarchy in the new GP Workflow ? Thanks.<br /><br />Regards PeterMuchttps://www.blogger.com/profile/03274555905276067971noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-39571208849928448062015-03-13T14:45:52.765-04:002015-03-13T14:45:52.765-04:00Frank, this is awesome. Thank you so much for writ...Frank, this is awesome. Thank you so much for writing this. The same thing was happening to me and I kept looking for issues with the source file.<br /><br />Did the support technician say why it waited until 1,000 records to fail? The magic number for me was ~842Anonymoushttps://www.blogger.com/profile/04265914878205535185noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-36997342675153566512015-02-16T14:30:04.060-05:002015-02-16T14:30:04.060-05:00Oddly enough while the GP window does not show num...Oddly enough while the GP window does not show numbers past 48, ACCATNUM.GL00102 still holds a number that is incremented past 48 when records are added.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-80244107832832835382014-12-31T03:20:14.963-05:002014-12-31T03:20:14.963-05:00Thanks for sharing its work.
Custom BoxesThanks for sharing its work.<br /><br /><a href="http://www.liquidprinter.com/" rel="nofollow">Custom Boxes</a>John Smithhttps://www.blogger.com/profile/03139019578619022171noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-2041762477887415822014-08-12T17:03:40.702-04:002014-08-12T17:03:40.702-04:00Bud, there are a number of reasons this can occur,...Bud, there are a number of reasons this can occur, mostly related to improper transaction processing. Check out this link on the GP Forum addressing this exact issue - https://community.dynamics.com/gp/f/32/t/104907.aspx.<br /><br />Thanks, FrankFrank Hamellyhttps://www.blogger.com/profile/15697020892894195399noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-51820663067238074742014-08-12T16:35:55.187-04:002014-08-12T16:35:55.187-04:00It looks to me like even closed POs appear on this...It looks to me like even closed POs appear on this SmartList, so how can I use it to reconcile?BudChttps://www.blogger.com/profile/17283328770425714444noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-63284376501291611852014-05-14T21:29:12.116-04:002014-05-14T21:29:12.116-04:00I'm not sure Michael and Christine. I can'...I'm not sure Michael and Christine. I can't replicate this in my system and there doesn't seem to be a thing online about this issue.<br /><br />Are you using Word Templates or the Standard Report Writer form?Frank Hamellyhttps://www.blogger.com/profile/15697020892894195399noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-59444610201371167542014-05-14T14:01:43.738-04:002014-05-14T14:01:43.738-04:00I am having the same problem as Michael. 0 succee...I am having the same problem as Michael. 0 succeeded; 0 failed. I cannot figure out why this does not work.Anonymoushttps://www.blogger.com/profile/09235206079311648382noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-38710038955590036722014-04-29T04:30:01.722-04:002014-04-29T04:30:01.722-04:00Microsoft Dynamics GP
The article has elaborated...<a href="http://www.evinciblesolutions.com/solutions/microsoft_dynamics_gp.aspx%22" rel="nofollow">Microsoft Dynamics GP </a><br /> The article has elaborated an utterly delightful software best for any business.Anonymoushttps://www.blogger.com/profile/04166927842703626654noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-8118110497059906282014-04-29T04:28:42.626-04:002014-04-29T04:28:42.626-04:00Microsoft Dynamics GP
The best project manaegmen...<a href="http://www.evinciblesolutions.com/solutions/microsoft_dynamics_gp.aspx%22" rel="nofollow">Microsoft Dynamics GP </a><br /> The best project manaegment software out there, i was really impressed by it's user friendly options.Anonymoushttps://www.blogger.com/profile/04166927842703626654noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-5050281812758844832014-04-29T04:26:10.788-04:002014-04-29T04:26:10.788-04:00Microsoft Dynamics GP
The best project manaegmen...<a href="http://www.evinciblesolutions.com/solutions/microsoft_dynamics_gp.aspx%22" rel="nofollow">Microsoft Dynamics GP </a><br /> The best project manaegment software out there, i was really impressed by it's user friendly options.Anonymoushttps://www.blogger.com/profile/04166927842703626654noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-80982753467052715522014-03-29T21:43:39.798-04:002014-03-29T21:43:39.798-04:00I know this sounds like a dumb question, but did y...I know this sounds like a dumb question, but did you place a check in the box next to the documents you want to print? I ask, because I've forgotten to do that myself at times.Frank Hamellyhttps://www.blogger.com/profile/15697020892894195399noreply@blogger.comtag:blogger.com,1999:blog-1326377569808004304.post-33431533393807835432014-03-29T14:18:01.854-04:002014-03-29T14:18:01.854-04:00Any idea why my attempt doesn't print or what ...Any idea why my attempt doesn't print or what may be involved. When trying to print one or more selected invoices, it just says "Print Documents action completed. 0 succeeded; 0 failed". No error message of any kind is included and this occurs when trying to print to screen, printer or file.Anonymoushttps://www.blogger.com/profile/05937888935664692724noreply@blogger.com