An invoice created from a sales order will not, an...
# inventoryk
KevinJ of Kansas
11/01/2019, 4:23 PMAn invoice created from a sales order will not, and requires a fulfillment to decrease inventory
t
ThaFunk
11/01/2019, 4:50 PM@KevinJ of Kansas - The invoice is coming from the IF that is associated with the SO, that is not considered a stand-alone invoice correct ?
k
KevinJ of Kansas
11/01/2019, 4:51 PMCorrect, this would not be a stand alone invoice.
t
ThaFunk
11/01/2019, 4:52 PMIn fact the invoice says it was created from my SO102xxx - so in this case you are saying it "should not" remove inventory correct ?
k
KevinJ of Kansas
11/01/2019, 4:53 PMcorrect
t
ThaFunk
11/01/2019, 4:54 PMHave you ever seen an instance of this happening? I wonder if we have manipulated invoicing somehow... I just started a new job this is my 2nd week just learning their environment right now and of course get this handed to me by the CFO to research lol smh..
ThaFunk
11/01/2019, 4:56 PMIn any case thank you very much that is extremely helpful, I at least know what I can look for to compare. Thanks again!
k
KevinJ of Kansas
11/01/2019, 4:57 PMI'm not sure why the invoice would show on the report. It's plausible there could be a COGS adjustment hitting on that transaction so it's not actually changing inventory on hand depending on if there were deleted transactions that cause the item to go to 0 on hand. Unlikely though unless the deleted transaction was dated after the fulfillment and before the invoice
KevinJ of Kansas
11/01/2019, 4:58 PMWhen you pull up the invoice can you screenie the GL impact?
t
ThaFunk
11/01/2019, 5:01 PMSure one sec
ThaFunk
11/01/2019, 5:03 PMAlso my current qty on hand shows -136 for the item in question
k
KevinJ of Kansas
11/01/2019, 5:13 PMThat seems like a call to NS support
KevinJ of Kansas
11/01/2019, 5:14 PMDid the user potentially remove and replace the items on the invoice?
KevinJ of Kansas
11/01/2019, 5:14 PMDo the sales order lines show that they have been invoiced? Or is there more than one invoice on the SO?
KevinJ of Kansas
11/01/2019, 5:15 PMSo if you remove the lines and add them back it will break the link to the sales order, resulting in standalone type behavior
👍 1
t
ThaFunk
11/01/2019, 5:25 PMah okay, NS Support called me talking to them now
ThaFunk
11/01/2019, 5:28 PMLooking at the invoice it does not look like the item was removed and re-added, thats actually what NS Support wanted me to check, they are taking it offline to investigate
ThaFunk
11/01/2019, 5:29 PMAlso the SO is showing partially billed there is definitely more than 1 invoice on this SO
ThaFunk
11/01/2019, 5:31 PMGotta get to a meeting, I will let you know what happened in the end if you are interested. Thanks again you always have great insight.
m
michoel
11/02/2019, 10:15 AMDoes the invoice have anything under qty ordered for that line? Each if the invoice shows a created from link, that could be for other lines and could still contain stand alone lines as well
t
ThaFunk
11/03/2019, 2:30 PM@michoel I will double check that right now, thanks for the tip
ThaFunk
11/03/2019, 2:36 PM@michoel we dont have 'qty ordered' specifically on our results.. Here's the main columns...
m
michoel
11/03/2019, 8:22 PMI think Qty Remaining might show 0 for linked lines, and be empty for standalone lines. I'll check on my account when I get in in a bit.
michoel
11/03/2019, 10:26 PMHere's what I am talking about. I took an existing linked invoice and added a line directly on the invoice, so just the bottom line is stand-alone
michoel
11/03/2019, 10:27 PMmessage has been deleted
michoel
11/03/2019, 10:28 PMmessage has been deleted
michoel
11/03/2019, 10:29 PMOn the GL impact you can see only the bottom line hit cogs and inventory because the other lines impact happened on the fulfillment
t
ThaFunk
11/04/2019, 5:48 PMThank you @michoel and @KevinJ of Kansas - We found that a user did delete a line after all from the Invoice which triggered the COGs on the invoice for that item.
Question, which transactions should COGs be reported on?
ThaFunk
11/04/2019, 5:49 PMI know that COGs can be SET with Item Receipt, Assembly Build and Inventory Adjustment
ThaFunk
11/04/2019, 5:50 PMBut where else should we NOT be seeings COGs (such as invoices, since we do not do standalone invoices here)
k
KevinJ of Kansas
11/04/2019, 5:50 PMI'm not sure what you mean
t
ThaFunk
11/04/2019, 5:50 PMShould we see COGs on the GL impact of a PO ? SO ? etc
k
KevinJ of Kansas
11/04/2019, 5:51 PMgenerally you would see COGS on the Item Fulfillment. However, COGS adjustments can be performed on any inventory impacting transaction.
t
ThaFunk
11/04/2019, 5:52 PMOkay that makes sense
k
KevinJ of Kansas
11/04/2019, 5:52 PMThe system performs COGS adjustments
KevinJ of Kansas
11/04/2019, 5:52 PMthose are typically done when your inventory hits zero
KevinJ of Kansas
11/04/2019, 5:52 PMi.e. "I was negative and now I'm not, so now I know what COGS to use.
👍 1
t
ThaFunk
11/04/2019, 5:55 PMIs there a NetSuite book you'd recommend that goes over all of this in more depth ? Just so I can fill in my knowledge gaps
ThaFunk
11/04/2019, 5:58 PMActually I think I found what I need - Item Record Management Guide goes over Item Costing
ThaFunk
11/04/2019, 5:58 PMThanks again guys, sorry i'm such a n00b lol 🙂
2 Views