Solved

Physical Inventory Adjustments - GL Accounts

  • 13 June 2023
  • 6 replies
  • 267 views

Userlevel 5
Badge

When we do an inventory count, the adjustment hits 66102 - Physical Inventory Adjustments which we have specified as a COGS account.

 

However, there are certain items (such as packaging), which, when adjusted should flow through a different account (the one specified on the stock item screen). 

 

Is there a way to set up inventory counts that post adjustments directly to the related stock item expense account rather than the physical inventory adjustment account?  

icon

Best answer by dcomerford 14 June 2023, 10:51

View original

6 replies

Userlevel 7
Badge +16

Hi @jwarren 

Are you referring to when you do a Physical Inventory count and you have the adjustment as the outcome?

It create the adjustment with the Reason Code.

 

 

Userlevel 5
Badge

@kandybeatty49 

 

Right - so when I look at the Reason Code settings, seems as though I can only specify the sub-accounts within account 66102. Instead of being able to have the adjustment hit 58600 for packaging material as an example?

Userlevel 7
Badge +16

Hi @jwarren 

If you changed the Combine subaccount to I, it would pull From a subaccount associated with the inventory item. 

Userlevel 5
Badge

Hi @jwarren 

If you changed the Combine subaccount to I, it would pull From a subaccount associated with the inventory item. 

Which we would then use to reclass to 58600?

 

Most of our adjustments in a physical inventory count will hit 66102, and will be included as part of COGS. But there are certain physical inventory count adjustments, such as packaging, which should hit 58600 which is not a COGS account but a warehousing expense.

 

When we do an inventory issue for these packaging items, it hits 58600 as we want. But when it goes through physical inventory adjustment it goes to 66102 instead.

 

Sounds like we will need to use III-III in order to create manual journal entries to move certain adjustments from 66102 - Physical Inventory Adjustments (COGS) to 58600 - Packaging (Warehousing Expense), if I am understanding correctly?

Userlevel 7
Badge +12

There is a way you could do it on the Posting Class you set the Reason for Physical Inventory Adjustments. So Create another physical Inventory reason code for Packaging and point that to the GL code you want 58600. Create a posting class for Packaging items (you may already have this)  and set it to use this reason then ensure your packaging items are using this posting class can be driven from item class. That should work. 

 

Userlevel 5
Badge

There is a way you could do it on the Posting Class you set the Reason for Physical Inventory Adjustments. So Create another physical Inventory reason code for Packaging and point that to the GL code you want 58600. Create a posting class for Packaging items (you may already have this)  and set it to use this reason then ensure your packaging items are using this posting class can be driven from item class. That should work. 

 

Thanks - this was exactly what I was looking for. This allows us to specify a different account/different reason code that is used during physical inventory adjustments.

 

Can the same be done for adjustments that flow through Inventory Adjustments? The default is for INADJUST reason code but same issue - it requires one single account rather than GL accounts based on inventory type. 

 

Is there a similar ability to specify on the posting class a different reason code based on item class when doing an inventory adjustment? As we did above for physical inventory adjustments?

 

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved