Item Cost on Inventory Adjustment

Modified on: Tue, 27 Jun 2023 9:29 PM

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:

https://attachment.freshservice.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6ODA2MDc5NzU0NiwiZG9tYWluIjoiaHNwcm9tby5mcmVzaHNlcnZpY2UuY29tIiwidHlwZSI6MX0.iEsNCS1RECToNajbmeteBZ-DVLNlmXKGgQOywDXPh6E


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:

https://attachment.freshservice.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6ODA2MDg1Mjk2OSwiZG9tYWluIjoiaHNwcm9tby5mcmVzaHNlcnZpY2UuY29tIiwidHlwZSI6MX0.6PuuQneYqkZnxKBThBygrzKhWC1ZU2r8KDcVmx-1zCo

 

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:

https://attachment.freshservice.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6ODA2MDg5NjM5NSwiZG9tYWluIjoiaHNwcm9tby5mcmVzaHNlcnZpY2UuY29tIiwidHlwZSI6MX0.9sf2RMvrm1MGtAbKny3rvUs7aQEEUu9kG8aRPeTRXWw

 

https://attachment.freshservice.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6ODA2MTA4ODk2MiwiZG9tYWluIjoiaHNwcm9tby5mcmVzaHNlcnZpY2UuY29tIiwidHlwZSI6MX0.Rx5refNb5t3hG0A0JZxKml5EmegpUnERCEyuqEmUrjA

 

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:

https://attachment.freshservice.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6ODA2MTQ2MTY1NiwiZG9tYWluIjoiaHNwcm9tby5mcmVzaHNlcnZpY2UuY29tIiwidHlwZSI6MX0.DbHQaqzgyWDnRtNzeqB-bMg56y4HDHYi1JOuCXmy-uo


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.

 

1 Attachment (Scanned for viruses)

(346.5 KB)
Click here to download KB - Item Cost on Inventory Adjustment.docx Click here to download KB - Item Cost on Inventory Adjustment.docx
KB - Item Cost on Inventory Adjustment.docx is loading
Was this answer helpful?