Item Cost on Inventory Adjustment

SR-18962

https://helpdesk.hpgbrands.com/a/tickets/18962?current_tab=details

Average cost and est. unit cost for 26118 B-SOY-AP-BULK-NetSuite-Mixie

1. A user submitted this question:

a. Do you know why this item does not have average cost and when we try to do inventory adjustment, there is no unit cost:

2. The initial response from the NS team was to create a saved search for the item with a Formula (Numeric) field for {averagecost}. Here was the response back to the user:

a. This is due to the Average Cost field showing only 2 decimal places. A cost shows when using a formula. It's very small due to the unit of measure:

3. The NS team provided further explanation by running a report register for GL account 5102 (Inv Adj - Cycle Count/Physical):

a. It's due to that field being unable to show more than 2 decimal places on the IA. But it does have a value. I tested in sandbox and the amount is $20,756.19:

4. The user’s coworker created an inventory adjustment in SB. Initially, it didn’t have any value but calculated after a couple of minutes as follows:

a. NS calculated a value for IADJ60047 approximately 4 minutes after it was entered:

5. Final acknowledgment after testing by the user:

a. Yes I was able too, it just took a few minutes for the cost to show up.