Solved

LayerType field in the INCostStatus table

  • 30 December 2020
  • 2 replies
  • 33 views

Userlevel 3
Badge

Does anyone what the difference is between the N and O LayerType values in the INCostStatus Data Access Class (DAC)?

I’m also wondering if there are any possible values other than N and O.

INCostStatus is the DAC that stores inventory costing layers and it’s used in the Inventory Valuation (IN615500) report.

icon

Best answer by Naveen B 5 January 2021, 15:44

Hi @TimRodman 

We have 3 different LayerType values in the INCostStatus table.
 

  • Normal - N
  • Oversold - O
  • Unmanaged - U

When we do a normal receipt, then a record will be inserted into the INCostStatus table with the “ReceiptNbr” as “ZZZ” and LayerType will be the “N” - Normal.

 

We have do a Negative Stock Adjustment, then the “ReceiptNbr” will be “OVERSOLD” and LayerType will be “O” - OverSold.

 

I’m NOT sure about the 3rd one i.e. Unmanaged. ;) 

View original

2 replies

Userlevel 3
Badge

I’m also wondering what value the INCostStatusSummary DAC provides. It’s used by the Inventory Valuation (IN615500) report in older versions of Acumatica, but it doesn’t seem to offer anything beyond INCostStatus and some of the data appears to be incorrect.

Userlevel 4
Badge +1

Hi @TimRodman 

We have 3 different LayerType values in the INCostStatus table.
 

  • Normal - N
  • Oversold - O
  • Unmanaged - U

When we do a normal receipt, then a record will be inserted into the INCostStatus table with the “ReceiptNbr” as “ZZZ” and LayerType will be the “N” - Normal.

 

We have do a Negative Stock Adjustment, then the “ReceiptNbr” will be “OVERSOLD” and LayerType will be “O” - OverSold.

 

I’m NOT sure about the 3rd one i.e. Unmanaged. ;) 

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