<?xml version="1.0" encoding="UTF-8"?>        <rss version="2.0"
             xmlns:atom="http://www.w3.org/2005/Atom"
             xmlns:dc="http://purl.org/dc/elements/1.1/"
             xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
             xmlns:admin="http://webns.net/mvcb/"
             xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
             xmlns:content="http://purl.org/rss/1.0/modules/content/">
        <channel>
            <title>
									2021 R2 - Video on Project Specific Inventory Tracking - Well done, Tim! - Everything Else				            </title>
            <link>https://www.augforums.com/forums/everything-else/2021-r2-video-on-project-specific-inventory-tracking-well-done-tim/</link>
            <description>Acumatica User Group Forums</description>
            <language>en-US</language>
            <lastBuildDate>Wed, 14 Oct 2026 10:37:22 +0000</lastBuildDate>
            <generator>wpForo</generator>
            <ttl>60</ttl>
							                    <item>
                        <title>RE: 2021 R2 - Video on Project Specific Inventory Tracking - Well done, Tim!</title>
                        <link>https://www.augforums.com/forums/everything-else/2021-r2-video-on-project-specific-inventory-tracking-well-done-tim/#post-9909</link>
                        <pubDate>Sat, 14 May 2022 08:01:56 +0000</pubDate>
                        <description><![CDATA[@timrodman oh crumbs.... Will have a look through community and see if anyone else has picked up the batton. We&#039;ve logged a case with support but nothing back yet.]]></description>
                        <content:encoded><![CDATA[@timrodman oh crumbs.... Will have a look through community and see if anyone else has picked up the batton. We've logged a case with support but nothing back yet.]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/everything-else/">Everything Else</category>                        <dc:creator>matthewjames</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/2021-r2-video-on-project-specific-inventory-tracking-well-done-tim/#post-9909</guid>
                    </item>
				                    <item>
                        <title>RE: 2021 R2 - Video on Project Specific Inventory Tracking - Well done, Tim!</title>
                        <link>https://www.augforums.com/forums/everything-else/2021-r2-video-on-project-specific-inventory-tracking-well-done-tim/#post-9902</link>
                        <pubDate>Fri, 13 May 2022 17:19:26 +0000</pubDate>
                        <description><![CDATA[Hey @matthewjames, I don&#039;t have any update unfortunately. I haven&#039;t looked at it since making that video. Typical &quot;sales demo&quot; huh? 😀]]></description>
                        <content:encoded><![CDATA[Hey @matthewjames, I don't have any update unfortunately. I haven't looked at it since making that video. Typical "sales demo" huh? 😀]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/everything-else/">Everything Else</category>                        <dc:creator>Tim Rodman</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/2021-r2-video-on-project-specific-inventory-tracking-well-done-tim/#post-9902</guid>
                    </item>
				                    <item>
                        <title>RE: 2021 R2 - Video on Project Specific Inventory Tracking - Well done, Tim!</title>
                        <link>https://www.augforums.com/forums/everything-else/2021-r2-video-on-project-specific-inventory-tracking-well-done-tim/#post-9900</link>
                        <pubDate>Fri, 13 May 2022 15:54:27 +0000</pubDate>
                        <description><![CDATA[@timrodman Hi Tim, i hope you are well, did anything come from the &quot;bug&quot; for the actual costing you found in the video when you issued the stock to the project or did you find a way around i...]]></description>
                        <content:encoded><![CDATA[@timrodman Hi Tim, i hope you are well, did anything come from the "bug" for the actual costing you found in the video when you issued the stock to the project or did you find a way around it at all? we're doing 2 implementations that require project issuing of stock and currently the costs are staying in "committed" rather than actual and this is causing us some issues. We've logged it with Acumatica but they haven't come back with anything. Any info would be appreciated.]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/everything-else/">Everything Else</category>                        <dc:creator>matthewjames</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/2021-r2-video-on-project-specific-inventory-tracking-well-done-tim/#post-9900</guid>
                    </item>
				                    <item>
                        <title>RE: 2021 R2 - Video on Project Specific Inventory Tracking - Well done, Tim!</title>
                        <link>https://www.augforums.com/forums/everything-else/2021-r2-video-on-project-specific-inventory-tracking-well-done-tim/#post-9316</link>
                        <pubDate>Wed, 13 Oct 2021 21:06:23 +0000</pubDate>
                        <description><![CDATA[Regarding the idea to put the Inventory account in an Account Group, it&#039;s been a while since I looked at it, but I think it worked something like this:
PO Receipt:Dr. Inventory (Increase Co...]]></description>
                        <content:encoded><![CDATA[<p>Regarding the idea to put the Inventory account in an Account Group, it's been a while since I looked at it, but I think it worked something like this:</p>
<p>PO Receipt:<br />Dr. Inventory (Increase Cost on Project)<br />Cr. PO Accrual</p>
<p>IN Issue:<br />Dr. COGS (Increase Cost on Project)<br />Cr. Inventory (Increase Cost on Project)<br />The next effect is Zero, especially if you put Inventory and COGS in the same Account Group</p>
<p> </p>
<p>Regarding PPV, it should be an Income Statement account. Acumatica will try to increase/decrease the value of Inventory if the Inventory is still there. But, if the Inventory is gone, then the cost difference will get booked to PPV.</p>
<p> </p>
<p>If you're just doing Average Costing, you could probably get away with using existing functionality to store everything in a regular Warehouse, then issue the inventory to Projects when it goes out. If you need to protect Inventory from getting stolen on other Projects, that's where the new 2021 R2 feature would probably help you.</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/everything-else/">Everything Else</category>                        <dc:creator>Tim Rodman</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/2021-r2-video-on-project-specific-inventory-tracking-well-done-tim/#post-9316</guid>
                    </item>
				                    <item>
                        <title>RE: 2021 R2 - Video on Project Specific Inventory Tracking - Well done, Tim!</title>
                        <link>https://www.augforums.com/forums/everything-else/2021-r2-video-on-project-specific-inventory-tracking-well-done-tim/#post-9312</link>
                        <pubDate>Wed, 13 Oct 2021 02:47:02 +0000</pubDate>
                        <description><![CDATA[Tim and Forum -
It was some issue on the Acumatica end, which they fixed and the license was assigned and check-boxed the next day. 
&quot;Inventory account in an Account Group&quot; --&gt; This is ...]]></description>
                        <content:encoded><![CDATA[<p>Tim and Forum -</p>
<p>It was some issue on the Acumatica end, which they fixed and the license was assigned and check-boxed the next day. </p>
<p>"Inventory account in an Account Group" --&gt; This is interesting! Are you suggesting if I put a B/S account (inventory) in an Account Group, that upon "PO Receipt" of a Stock Item that it would both (1) Debit inventory and be reported on and managed through subsequent issuance to a Project, and (2) hit the 'Actual Cost' field of the Cost Budget <span>with the cost of the material procurement upon PO Receipt? ... I don't see how the debits/credits would work. </span><span>I don't see how you ensure the subsequent IN Issue to the job does not result in double-count of the costs to the Project? </span></p>
<p>*In any event* Since my OP, I've decided that we <span style="text-decoration: underline">don't</span> need the cost to hit the Project at Purchase Receipt. So, the above 'gymnastics' can be avoided. For revenue recognition, it would be more appropriate and conservative to apply the cost to the Project upon IN Issue to the Project which represents the practical use of the material (typically 1-3 months after receipt). </p>
<p>So, we've decided to configure the journal transactions as follows. We're testing this week, so we'll see if it actually works as planned ... </p>
<p><span style="text-decoration: underline">Step 1. Purchase Receipt: </span></p>
<p>Dr. (A) Inventory          $xx (PO unit rate x qty)</p>
<p>Cr. (L) PO Accrual         $xx </p>
<p><span style="text-decoration: underline">Step 2. AP Bill Received </span></p>
<p>Dr. (L) PO Accrual         $xx</p>
<p>Dr. (A) Inventory, PPV    $zz =  &lt; In this case, I'm using "Inventory" method for PPV, and the AP Bill $ &gt; expected PO $  </p>
<p>Cr. (A) A/P for Vendor   $vv = </p>
<p><span style="text-decoration: underline">Step 3: Inventory Issue to Project</span></p>
<p>Dr. (E) COGS-Material   $vv</p>
<p>Cr. (A) Inventory          $xx </p>
<p>Cr. (A) Inventory, PPV   $zz</p>
<p>Impact: Yes, this will delay the costs being applied to the Project, COGS while held up in Inventory. Yes, this will slow, relatively, the realization of contract revenue since we're using a cost-to-cost basis for Rule 606. But, that is appropriate. And, in this instance, it fits the existing structure for how the Inventory module works. </p>
<p>*PPV treatment* I'm curious in opinions and experiences using the Purchase Price Variance Allocation setting in Purchase Orders. Specifically, the 'Inventory Account' vs. the 'Purchase Price Variance Account' ... The above is intended to be how we would use the 'Inventory Account' method, but testing will tell. </p>
<p>... should the Chart of Accounts have a 2ndary inventory account for PPV, or would it flow through the same Inventory account? </p>
<p> </p>
<p>*separate realization* </p>
<p>In terms of why I want "project-specific inventory" enabled: I think we do need this feature for the reasons outlined below, so please let me know what you think ... </p>
<p>- We run ~10-15 active projects; all custom contract work that is heavily reliant upon the timely and complete procurement of project materials for off-site mfg</p>
<p>- All materials are project specific so they need to be tracked and reported by project </p>
<p>- All materials are held at the same single, central warehouse in the same set of master inventory bins/locations</p>
<p>- I'd like to avoid creating individual "virtual" warehouses for each project. Don't want to need to manage master bin/location list within each of the virtual warehouses </p>
<p> </p>
<p>Is there a better way to achieve this? Or is the project-specific inventory the right feature. </p>
<p> </p>
<p>John </p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/everything-else/">Everything Else</category>                        <dc:creator>John.Shaddix</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/2021-r2-video-on-project-specific-inventory-tracking-well-done-tim/#post-9312</guid>
                    </item>
				                    <item>
                        <title>RE: 2021 R2 - Video on Project Specific Inventory Tracking - Well done, Tim!</title>
                        <link>https://www.augforums.com/forums/everything-else/2021-r2-video-on-project-specific-inventory-tracking-well-done-tim/#post-9310</link>
                        <pubDate>Mon, 11 Oct 2021 23:55:17 +0000</pubDate>
                        <description><![CDATA[Try the Apply Updates screen. Is the feature listed there? It might be that you aren&#039;t licensed for it.
I&#039;m not sure that this new feature is going to help you. You might be able to accompl...]]></description>
                        <content:encoded><![CDATA[<p>Try the Apply Updates screen. Is the feature listed there? It might be that you aren't licensed for it.</p>
<p>I'm not sure that this new feature is going to help you. You might be able to accomplish what you're looking for though using existing functionality by putting the Inventory account in an Account Group.</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/everything-else/">Everything Else</category>                        <dc:creator>Tim Rodman</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/2021-r2-video-on-project-specific-inventory-tracking-well-done-tim/#post-9310</guid>
                    </item>
				                    <item>
                        <title>RE: 2021 R2 - Video on Project Specific Inventory Tracking - Well done, Tim!</title>
                        <link>https://www.augforums.com/forums/everything-else/2021-r2-video-on-project-specific-inventory-tracking-well-done-tim/#post-9273</link>
                        <pubDate>Tue, 28 Sep 2021 18:07:28 +0000</pubDate>
                        <description><![CDATA[BUMP! 
For some reason I do not show the the &quot;Project-Specific Inventory&quot; feature on my Enable/Disable Features? ... and I am on the 2012 R2! 
Any ideas?]]></description>
                        <content:encoded><![CDATA[<p>BUMP! </p>
<p>For some reason I do not show the the "Project-Specific Inventory" feature on my Enable/Disable Features? ... and I am on the 2012 R2! </p>
<p>Any ideas?</p>
<p> </p>
2550
<p> </p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/everything-else/">Everything Else</category>                        <dc:creator>John.Shaddix</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/2021-r2-video-on-project-specific-inventory-tracking-well-done-tim/#post-9273</guid>
                    </item>
				                    <item>
                        <title>2021 R2 - Video on Project Specific Inventory Tracking - Well done, Tim!</title>
                        <link>https://www.augforums.com/forums/everything-else/2021-r2-video-on-project-specific-inventory-tracking-well-done-tim/#post-9269</link>
                        <pubDate>Tue, 28 Sep 2021 06:32:43 +0000</pubDate>
                        <description><![CDATA[Hi all, Tim posted some helpful video digging to 2021 R2 just after release (links below, FYI). 🤗 🤗
Question: Are there any Construction (we&#039;re a specialty subcontractor in glass/glazing) t...]]></description>
                        <content:encoded><![CDATA[<p>Hi all, Tim posted some helpful video digging to 2021 R2 just after release (links below, FYI). 🤗 🤗</p>
<p><span style="text-decoration: underline">Question</span>: Are there any Construction (we're a specialty subcontractor in glass/glazing) that are working to track project-specific inventory? Any that want to collaborate? Ping me or reply here if you're willing to chat</p>
<p>We have been awaiting 2021 R2 and just got our Test tenant converted, and we're working towards go-live on 1/1/2022 ... and we are working through our critical processes for PO &gt; Receive &gt; Inventory workflow. </p>
<p>Specifically, we are desiring to achieve both (1) receive into inventory &amp; IN issue to project to track depletion of project specific inventory, and (2) simultaneously we'd like to see the full and complete cost of the material procurement HIT the Cost Budget as an 'Actual Cost' upon PO Receipt ... ahead/prior to the subsequent IN Issue to the job (and, of course, not double-count 😀). </p>
<p>Rationale for this desired setup: For WIP over/under billing (calculated outside of Acumatica) we believe that we must recognize the full cost of the this custom material that is procured project-specific upon receipt (!!) not the subsequent IN issues that will occure in the weeks and months to follow.  </p>
<p>We're working with our VAR on some tricky setup to achieve this; looking for any collaborators. I'm also trying to gauge if this is a lost cause or not ... </p>
<p>Thanks! John </p>
<p>Project Specific Inventory</p>
<p>https://www.youtube.com/watch?v=u5yb0l73RCU</p>
<p>Receive Stock Item Directly to Project </p>
<p>https://www.youtube.com/watch?v=7gJBzVgo_eE</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/everything-else/">Everything Else</category>                        <dc:creator>John.Shaddix</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/2021-r2-video-on-project-specific-inventory-tracking-well-done-tim/#post-9269</guid>
                    </item>
							        </channel>
        </rss>
		