tag:blogger.com,1999:blog-2902800390575811159.post6932251866230564646..comments2023-12-25T03:01:26.251-06:00Comments on Dynamics Confessions Blogspot: Using the Adjust Costs inventory Utility Warning!Dynamics Confessorhttp://www.blogger.com/profile/06555435567985477366noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-2902800390575811159.post-16817436624825973322018-05-17T14:55:15.110-05:002018-05-17T14:55:15.110-05:00Hi,
What module did you void things in?
LeslieHi,<br />What module did you void things in?<br />LeslieDynamics Confessorhttps://www.blogger.com/profile/06555435567985477366noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-30454870753163799512018-04-18T21:38:23.304-05:002018-04-18T21:38:23.304-05:00Hello Leslie,
I'm new to great plains dynami...Hello Leslie, <br /><br />I'm new to great plains dynamics and I posted voids with April dates that were invoiced in February. What is the simplest solution to fix these incorrect voids? <br /><br />Thank you for your time!Anonymoushttps://www.blogger.com/profile/12516280092282384597noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-69553277202386718632016-09-28T16:29:00.419-05:002016-09-28T16:29:00.419-05:00I have a situation where our Inventory Quantity on...I have a situation where our Inventory Quantity on the Stock status is correct for QTY but the overall cost needs to be written down.<br /><br />Here is an example:<br />Qty Rec Receipt # Qty Sold Date of Receipt Cost note****<br />40.140 RCT 00000004770 34.386 8/9/2016 538.00 remainder sold in Sep16<br />1.0 RCT 00000004770 0.0 8/9/2016 538.00 sold in Sep16<br />2.70 RCT 00000004770 0.0 8/24/2016 543.00 sold in Sep16<br />23.011 RCT 00000004770 0.0 8/31/2016 670.00 sold in Sep16<br />August 31st is our year end and our GL Inventory has been adjusted to $17,628.50 (32.645 X 543.00).<br />What I need to do is have this report show that the cost for the remainder of the units to be relieved from Inventory will be at a cost of 543.00 and perform that calculation when sold.<br /><br />I also need the Historical Cost or Any stock status report to show me the same value of 32.645 qty at a total value of $17,628.50. <br /><br />The other kicker is we went live on GP from an existing system (feb 22/16) and our GL and this report have never from day 1 matched so would like to have it match now so we can reconcile our inventory monthly. We have spent so much man hours and money trying to figure this system out so if anyone can help that would be greatly appreciated.<br /><br /><br />Lorinoreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-37173760339378209452016-07-12T14:54:06.348-05:002016-07-12T14:54:06.348-05:00Hi Jothikrishna,
This is weird. The Transaction po...Hi Jothikrishna,<br />This is weird. The Transaction posting journal on the original, source company should have item cost. If it doesn't, you'll have to compute the cost from the source company Purchase Receipts. If you used the IV10301 table as your source for the IV transaction in the new company, the item cost would be zero. However, if you posted that transaction in the old company, the item cost would be populated in the IV30300. I think you may consider reversing the original zero cost entry and then entering it again using the IV30300 table as your source.<br />Will that work? What table from which company did you use for your source?<br />Kind regards,<br />LeslieDynamics Confessorhttps://www.blogger.com/profile/06555435567985477366noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-5146683081555817552016-07-12T09:00:11.312-05:002016-07-12T09:00:11.312-05:00Hi Leslie,
It's weird, but in our case, The T...Hi Leslie,<br /><br />It's weird, but in our case, The Transaction Edit list was showing the correct Cost( Since I've updated the Cost directly on Items after those Adj transactions were posted with $0 unit cost), but Posting Journal had $0 unit cost Since the Inventory Purchase Receipt entry has Unit cost $0.<br /><br />I just want to mass update all the Items to have the Correct Unit cost.<br /><br />Regards,<br />Jothikrishna<br />Jothi krishnahttps://www.blogger.com/profile/00616068022207601399noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-35185899891951996412016-07-11T16:34:13.079-05:002016-07-11T16:34:13.079-05:00Hi,
The transaction edit list will not show a cost...Hi,<br />The transaction edit list will not show a cost, but the transaction posting journal should. If you reprint the posting journal via Inventory | Reports | Posting Journals and then reprint the Transaction Journal it should have costs on it. Given the size of the transaction, looking in the tables would likely be more efficient. The information is stored in the Inventory Transaction Batch History [IV30100], Inventory Transaction History [IV30200] and Inventory Transaction Amounts History[IV30300]. Also if serial or lot numbers are involved, you'd need to look at those history tables.<br />Kind regards,<br />LeslieDynamics Confessorhttps://www.blogger.com/profile/06555435567985477366noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-83094124235969961122016-07-11T11:49:10.761-05:002016-07-11T11:49:10.761-05:00Hi Leslie,
Thank you for this wonderful post.
I ...Hi Leslie,<br /><br />Thank you for this wonderful post.<br /><br />I transferred the Inventory from one company to another using the Stock Count entries as you suggested. Thank you very much for that! But, looks there is a Bug that the Variance transactions created by Stock Count entries had Unit Cost as 0 on all the items. I didn't realize that, and used it as Source and Created Adjustment Entry on the Target company. Now, before I fix the Unit Cost on the Adjustment entries(about 70 transactions(created per Item Class) with >15K items), User has posted almost all the transactions and it causes issues when creating any Project Inventory transfer. The reason is, it created IV Purchase Receipts with $0 unit cost for the Adjustment entries. <br /><br />How do I fix all the Items to have correct Unit cost. Using the above utility would be a difficult task as there are >15K items. You invaluable suggestion would be greatly appreciated as always.<br /><br />Thank you!<br /><br />Regards,<br />JothikrishnaJothi krishnahttps://www.blogger.com/profile/00616068022207601399noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-75256417471293453802016-04-08T08:22:55.142-05:002016-04-08T08:22:55.142-05:00Hi,
You mentioned the transaction edit list instea...Hi,<br />You mentioned the transaction edit list instead of the posting journal. Has the transaction in fact been posted? Can you find it in inquiry? I'm not 100 percent sure I understand the question. It states "the -1 unit . . " What do you mean by -1 unit?<br />Kind regards,<br />LeslieDynamics Confessorhttps://www.blogger.com/profile/06555435567985477366noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-84705104996135448332016-04-06T16:32:20.502-05:002016-04-06T16:32:20.502-05:00I have used the adjust cost function and have run ...I have used the adjust cost function and have run into an issue where the -1 unit for that item number does not show up in the adjust cost screen. I have no ability to adjust cost for that item number. I double-check transaction edit list to ensure I have the correct item number, date, site, etc. and all is correct. Do you know why it is missing or how I can get the transaction entry to display in the adjust cost screen to adjust the cost?<br /><br />thank you for your help!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-68056680191203853252016-02-23T15:35:36.878-06:002016-02-23T15:35:36.878-06:00Here is a question/insight that I came across on t...Here is a question/insight that I came across on this and wanted to make sure I did not miss something. If you have an item at multiple locations do you really need to press process after each one? If you leave the item number and change the location, the distribution accounts only take into the account the first item... at least that is what my testing has shown. <br /><br />Any/all insight into this would be appreciated. <br /><br />Thanks,<br />Jon<br />Jon Colesbyhttps://www.blogger.com/profile/03793702859312712807noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-90420228283832859442016-02-19T10:27:06.900-06:002016-02-19T10:27:06.900-06:00Hi,
I'm not sure what the question is. The onl...Hi,<br />I'm not sure what the question is. The only assembly transaction I see is for a cost of 98 cents. The qty is 12,966.40, but I don't see any correlation between that number and any of the other quantity numbers. In fact, nothing is showing a cost of .96. I would need more information or just remove all of the information that doesn't relate to the question.<br />Kind regards,<br />LeslieDynamics Confessorhttps://www.blogger.com/profile/06555435567985477366noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-53709288074311852862015-11-02T12:38:53.683-06:002015-11-02T12:38:53.683-06:00Hello
I have a problem with the cost of inventory...Hello<br /><br />I have a problem with the cost of inventory transfer . GP registers a cost transfer is not for the cost of entry . Why does this happen ?, As I can correct it?<br />In this example I record an assembly of a product costing GP $0.96 and I registered a record of transfer of inventory cost $117... Check the historical and could not find an entry document that originated this cost.<br />Document Date Document Number TRXLOCATION TOLOCATION QTY Unit Unit Cost<br />26/12/14 ASM0000042774 PROD 12,966.40 OZ 0.98<br /> TR000064025 BONA PASA 880 OZ 0.93<br /> TR000064027 BONA OPTI 6,848.00 OZ 0.93<br /> TR000064028 BONA MALE 11,744.00 OZ 0.93<br /> TR000064030 BONA BRAS 880 OZ 0.92<br /> TR000064031 BONA HIGU 2,176.00 OZ 0.92<br /> TR000064032 BONA PUCB 896 OZ 0.92<br /> TR000064034 BONA AGMA 3,584.00 OZ 110.78<br /> TR000064045 BONA JULU 1,328.00 OZ 117.57<br /> TR000064060 BONA TRATTO 2,864.00 OZ 117.57<br /> TR000064155 PROD BONA 11,546.88 OZ 0.98Anonymoushttps://www.blogger.com/profile/11360035469922998858noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-42439395511064301512012-09-05T12:59:52.185-05:002012-09-05T12:59:52.185-05:00Gijeet,
To make the negative entry, simply open th...Gijeet,<br />To make the negative entry, simply open the item transaction entry window and then put a negative amount for the quantity. The system will pull the items actual cost according to your FIFO layers and reduce your inventory by that amount. <br />You then create a positive adjustment and enter the qty with whatever cost you want.<br />If you need to write off a bunch of items at once, the easiest way to do it is with a Stock Count Entry. Put the items in a stock count schedule, and then start the count. Go into stock count entry and then check all of the verify boxes with the qty of zero. The system will create an item transaction bringing the qty and cost to zero. You can then create a positive inventory adjustment to bring the quantity and cost up to the appropriate level.<br />If you have the correct cost in the current cost field on the item card, then you can just do another stock count with the new quantity.<br />I find that using the stock count schedules make this process much easier.<br />Hope this clears things up for you.<br />Kind regards,<br />Leslie<br />Dynamics Confessorhttps://www.blogger.com/profile/06555435567985477366noreply@blogger.comtag:blogger.com,1999:blog-2902800390575811159.post-73993575437024944542012-06-20T12:38:36.664-05:002012-06-20T12:38:36.664-05:00Hello, very informative post. Can you please go i...Hello, very informative post. Can you please go into more detail regarding creating a negative entry first then an increase adj. Let's say I have 365 items I want to write off. Thanks.Gijeethttps://www.blogger.com/profile/04820943187951129422noreply@blogger.com