Solved

Historical Inventory Valuation : How to adjust out the inventory without do the adjustment transacation

  • 18 June 2021
  • 8 replies
  • 58 views

Userlevel 1
Badge
  • Jr Varsity II
  • 84 replies

Hi Sir

We have encountered a problem about the inventory , we make mistake do receipt in a part # where that should be use existing 5 parts to do kit assembly into one part # . Currently , our system have extra 5k in inventory history valuation but in financial inventory account is correct . 

We cannot do adjustment transaction as it concern about double entry where it will affected financial account figure.

May i know if there is any way to do offset the extra 5k in inventory but not affected the financial inventory figure?  

Hope to hear from you soon.

Thank you

icon

Best answer by Naveen B 6 July 2021, 13:34

Hi @erin,

You might have “View Only” Access Rights for the “Inventory Preferences screen”, hence you are NOT able to modify the fields.

Please provide the proper Access Rights, so that you can able to modify the values accordingly.

 

 

View original

8 replies

Userlevel 2
Badge

Hi Erin,

[Erin] Q.May i know if there is any way to do offset the extra 5k in inventory but not affected the financial inventory figure? 

[Chandra] You can follow the below steps:

 1. Temporarily Disable (unselect) the "Update GL" in the Inventory Preferences screen (Refer to the screenshot below)

 2. Execute the adjustments and release the Adjustment

 3. Enable (Select) the "Update GL" option.

 

Note/Caution:

1. Forgetting to revert the settings will result in inventory transactions that do do not post to the GL.

1. No other inventory related transactions should be performed during this activity.

2. Perform this activity after notifying the users, Schedule lockout of Acumatica and execute during Off-Business hours.

 

Screenshot for reference:

Thanks

Userlevel 1
Badge

Hi ChandrasekharM

Thank you very much for the GOOD info.

Please correct me if my understanding is wrong.

Does it mean we unclick “ update GL” , which mean if we perform “ issue”  inventory  , it wont do any transaction in GL and affected transaction financial account, the inventory issue is only affected the inventory report figure?

 

Userlevel 1
Badge

Hi ChandrasekharM

Understand you are financial expert, can i quick check with you about the inventory valuation historical report figure actually not link directly with financial inventory account? is my understanding is correct?

If Yes, may i know which inventory report is directly link to financial inventory account?

used case:

we notice this matter on last month when our logistics department receipt into wrong branch but put in correct warehouse locationdue to this matter . we aware of the inventory valuation historical report is not link with financial inventory account , during that time , the figure of financial inventory account is not tie with inventory historical report.

Not sure if you could explain more about the relationship of inventory report and financial inventory account

Userlevel 2
Badge

Hi Erin, Please try the Inventory Valuation Report to get the value of your inventory vs the Trial Balance Summary Report and Trail Balance Detail Report (if subaccount is configured)

Thanks

Userlevel 1
Badge

Hi Cahndarsekhar

 

I tried to unclick the “ Update GL” but seem like i not allow to unclick it. Do you have any idea what is the reason?

 

 

Userlevel 6
Badge +8

Hi @erin,

You might have “View Only” Access Rights for the “Inventory Preferences screen”, hence you are NOT able to modify the fields.

Please provide the proper Access Rights, so that you can able to modify the values accordingly.

 

 

Userlevel 2
Badge

Hi @erin Please follow the screenshot provided by @Naveen B to update the access to the checkbox. And keep me posted.

Thanks

Userlevel 2
Badge

hi @erin  Are you able to perform the inventory adjustments without affecting the GL, with the instructions. Please confirm.

 

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 — 2020  Acumatica, Inc. All rights reserved