User_RWY1B

hi, Niks Blando-Oracle Yes

in how to create inventory Net Realizable Value (LCNRV) report Comment by User_RWY1B Sep 5, 2024 5:56PM

hi, does this enhancement work in 2024?

in Update Item Receipt via CSV Import Comment by User_RWY1B Aug 21, 2024 3:10PM

hi, Advanced Financials is blank, so it means we have to pay if we want to have this feature?

in Cannot enable Amortization Comment by User_RWY1B Jun 4, 2024 7:59AM

hi, it's Last purchase price

in FIFO accounting method when using inventory worksheet Comment by User_RWY1B Jun 4, 2024 2:31AM

hi, @MTL_MIA If there is an inbound shipment of a particular item with 10 units, and I know that receiving cannot exceed 10 units, if the vendor gives 11 units or gives 5 units and takes back 3 units the next day, it is looks like difficult to update the receive directly with this negative adjustment. The only solution I…

in Inventory Transfer > how is the item rate is calculated? Comment by User_RWY1B May 30, 2024 2:42AM

hi, it's purchase order

in FIFO accounting method when using inventory worksheet Comment by User_RWY1B May 28, 2024 2:34AM

hi, This item only has those transactions that I screenshotted earlier. Another question, the transactions with the type 'invoice' belong to our sales records. Are you saying that having 'Cost of Sales' noted in the memo is not normal?

in FIFO inventory's COGS and values Comment by User_RWY1B May 27, 2024 3:21AM

hi, This item only has those transactions that I screenshotted earlier.

in FIFO accounting method when using inventory worksheet Comment by User_RWY1B May 27, 2024 2:25AM

hi, The process for inbound shipment is as follows (please correct me if I'm wrong): Build PO Go to inbound shipment Click make intransit Click receive It seems that inbound shipment can solve my problem, as this way the price at receipt will equal the PO unit price. However, I have the following questions: How to create a…

in Inventory Transfer > how is the item rate is calculated? Comment by User_RWY1B May 24, 2024 8:04AM

hi, this transaction starts on 3/1

in FIFO accounting method when using inventory worksheet Comment by User_RWY1B May 23, 2024 3:21AM

hi, could you please take a look at this? thanks

in FIFO inventory's COGS and values Comment by User_RWY1B May 23, 2024 3:18AM

hi, Our current process is as follows: Once we have final PO, we import it into NetSuite, then do an item receipt to an in-transit warehouse. Based on the receiving situation, we then do an inventory transfer to a physical warehouse. This way, we can clearly see which inventory has not been received yet from the in-transit…

in Inventory Transfer > how is the item rate is calculated? Comment by User_RWY1B May 23, 2024 3:09AM

hi, 1,So even if we use FIFO, the Inventory Transfer uses the Location Average Cost of the "from location" at the time the record was created? 2.Do you have any suggestions on how to ensure that the transfer from the in-transit warehouse to the real warehouse uses the correct PO price? (Note: We put the PO items into the…

in Inventory Transfer > how is the item rate is calculated? Comment by User_RWY1B May 22, 2024 2:29AM

hi, Does anyone have any ideas? Anything is fine. Thank you

in FIFO inventory's COGS and values Comment by User_RWY1B May 21, 2024 3:34AM

hi, Does anyone have any ideas? Anything is fine. Thank you

in Inventory Transfer > how is the item rate is calculated? Comment by User_RWY1B May 21, 2024 3:28AM

hi, Avinash Either item/cost detail or Inventory Valuation shows we use FIFO

in FIFO accounting method when using inventory worksheet Comment by User_RWY1B May 20, 2024 8:58AM

hi, Avinash Our setting is FIFO and never changed. So I am confused about why the system operates this way.

in FIFO accounting method when using inventory worksheet Comment by User_RWY1B May 20, 2024 6:28AM

Thanks, but I have another question related to FIFO: On March 1, purchased 6 units at a unit price of 8 On March 15, purchased 20 units at a unit price of 20 On March 19, sold 1 unit On March 21, sold 10 units I believe that under FIFO, the COGS for March 19 should be 8, and the COGS for March 21 should be 140 (5 * 8 + 5 *…

in FIFO accounting method when using inventory worksheet Comment by User_RWY1B May 20, 2024 4:52AM

Suppose on January 1st, I set the inventory quantity to zero using the inventory worksheet (type the first transaction of the day) and then use the inventory adjustment adjust the inventory quantity (with no transactions in between). How would this impact my FIFO accounting method?

in How is average cost of an item affected when a negative quantity inventory adjustment is created? Comment by User_RWY1B May 17, 2024 8:55AM

Hi, please have a look

in Inventory Transfer > how is the item rate is calculated? Comment by User_RWY1B May 17, 2024 7:47AM

hi, However, according to our PO, we don't have any records of purchase(or receive) prices at 1,233.52.

in Inventory Transfer > how is the item rate is calculated? Comment by User_RWY1B May 16, 2024 9:05AM

hi, If the item rate is based on Amount/Quantity, then my question becomes how the Amount is calculated. Because when I do an Inventory Transfer, I can only input the quantity. For example, document number IT45581, I only input 7, and the result appears as shown in the screenshot. FYI, I use FIFO as my costing method.

in Inventory Transfer > how is the item rate is calculated? Comment by User_RWY1B May 16, 2024 2:19AM

hi, @Jeroen Sprangers ZS Does unit cost means AVERAGE COST shown on Item/Cost Detail? If not, where could I find it?

in An inventory Adjustment error message Comment by User_RWY1B May 15, 2024 11:37AM

hi, If I use FIFO, what would the situation be like? Do you have any videos about FIFO Inventory Costing?

in How is average cost of an item affected when a negative quantity inventory adjustment is created? Comment by User_RWY1B May 15, 2024 9:57AM

Hi, when I'm doing an Inventory Transfer, I don't know how the item rate is calculated.

in Add Location Average Cost To Transfer Form Comment by User_RWY1B May 15, 2024 8:27AM

hi, so what you meant is those 5M inventory items are due to previous occurrences of negative inventory, resulting in a current quantity of zero but still retaining value. And now, the only way for me to adjust is by using inventory adjustment, right

in Why is there Inventory Value when there is no inventory? Comment by User_RWY1B May 3, 2024 5:23AM

Hi, I have around 15K items with the same issue (Inventory Value when there is no inventory), and the total value is nearly 5.7 million. I would like to know how the system calculates the value. Furthermore, aside from the method you provided, is there any faster way to solve the problem?

in Why is there Inventory Value when there is no inventory? Comment by User_RWY1B Apr 29, 2024 8:24AM

User_RWY1B Green Ribbon

Comments