DB Values for INPIDetail.Status

  • 19 April 2022
  • 1 reply

Userlevel 6
Badge +2



Can anyone tell me the DB values for the INPIDetail.Status field?  I need to check the status of a Physical Inventory Detail Line in a Generic Inquiry.

Thank you,

Dan Concannon


Best answer by lauraj46 19 April 2022, 23:34

View original

1 reply

Userlevel 7
Badge +8

Hi @DConcannon ,

The values are:

  • E (Entered)
  • N (Not Entered)
  • S (Skipped)

If you don’t have a local install with direct SQL access, you can investigate the database values for a field in a DAC by leaving the Schema Field column empty and entering a formula rather than selecting the field in the dropdown.


Hope this helps!



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