Skip to main content

Inactive, Marked for Deletion Items - not included in Inventory Reports (Optional)


Currently in the standard reports available in the Inventory Module, all inventory items are available and included regardless of their status.

We also checked the Additional Sort and Filters tab, but couldn't find a condition for an inventory status field.

Maybe we should design the Inventory Reports that the user may have the option to not include the Inactive or Marked for Deletion Items because some customers may possibly don’t want to include those items when they generate reports.

Forum|alt.badge.img+11
  • Acumatica Support Team
  • October 30, 2020

 

 

Hi,

You can customize the report ( required Inventory report ) and add a ‘Visibility’ expression for specific report group/detail section to check ItemStatus value. 

Here is an example:

  • Inventory Balance report (ScreenID:IN615000) reflects both Active and Inactive items
  • I have deactivated an item for testing
  • Customized the report and added a visibility expression [InventoryItem.ItemStatus]<>'IN'  ( ‘IN’ refers to ‘Inactive’. For ‘Marked for Deletion’ its ‘DE’, I have set only one condition for testing, you can add both).
  • I have added above part to existing visibility expression
  • When I ran the report, Inactive item did not reflect. 

here are the screenshots :

An item used for testing 

Default report output

​​​​​

Report output after modification 

With regards getting an option added on default report itself, you may post a feature request on our Product idea page (https://community.acumatica.com/ideas). 

Hope this helps. 

Regards,

 


Forum|alt.badge.img+11
  • Acumatica Support Team
  • October 30, 2020

Hi, 

To add to my above post, I have added the report as ‘Custom report’ version, without disturbing default report. Hence, I can run default report which lists all items when needed or filtered custom report version. 

Hope this helps,

Regards,

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings