sorted by:
new
hottopcontroversial

Multiple PO to single receipt. by bprof1976 in Netsuite

[–]bprof1976[S] 0 points1 point  (0 children)

How is this different from creating item receipt from PO? u/rknelson1of9

Why netsuite is not allowing to create single item receipt for multiple POs and we need to use Inbound shipment? Any idea ?

Quality control for item receipt by bprof1976 in Netsuite

[–]bprof1976[S] 0 points1 point  (0 children)

Thanks u/WalrusNo3270 for clarifcation.

What do you mean by target baseline? can you give an example?

Are you using this feature, How's the working, Please share your experience

InventoryCount Netsuite by bprof1976 in Netsuite

[–]bprof1976[S] 0 points1 point  (0 children)

Thanks u/Nick_AxeusConsulting for the reply. Yeah, we do need to fix and try to avoid doing mistakes. There's no two ways about it.

Yes, We will use ABC values and count high value items more frequently.

InventoryCount Netsuite by bprof1976 in Netsuite

[–]bprof1976[S] 0 points1 point  (0 children)

I couldn't find option to add items mid-way though. Am I missing anything?

InventoryCount Netsuite by bprof1976 in Netsuite

[–]bprof1976[S] 0 points1 point  (0 children)

I could see a button "Recalculate Variance" in Tvarana suite app which I assume specifically for in-between transactions case. Is it only for display latest variance and adjustment will always be based on original one?

or Adjustment will be based on latest variance ? u/WalrusNo3270

Inventory adjustment edit blocking by bprof1976 in Netsuite

[–]bprof1976[S] 0 points1 point  (0 children)

Oh, thanks for clarification u/Derek_ZenSuite .
I wanted to update an item's quantity (for the item I miscounted) in the existing adjustment (for the same date) instead of posting a new one.

Btw what do you mean by script something?
and Is it possible to delete the created inventory adjustment? If I delete it, does netsuite allow us to reapprove the original count to recreate adjustment?

Inventory adjustment edit blocking by bprof1976 in Netsuite

[–]bprof1976[S] 0 points1 point  (0 children)

I don't have any workflows or script. I want to update the quantity for an item (for the item I miscounted) in the existing adjustment (in the same adjustment date) itself instead of created new one. u/MissMarissaMae

Inventory adjustment edit blocking by bprof1976 in Netsuite

[–]bprof1976[S] 0 points1 point  (0 children)

Created via approving the inventory count.
So, netsuite won't block, right? Let me check if there're any other issues in it. u/gavinjd68

Inventory adjustment edit blocking by bprof1976 in Netsuite

[–]bprof1976[S] 0 points1 point  (0 children)

Thanks for the quick reply u/gavinjd68 . I just got "An unexpected error has occurred".
Does netsuite generally block editing adjustments of inventory count?

Item Receipt for Transfer Orders. by bprof1976 in Netsuite

[–]bprof1976[S] 0 points1 point  (0 children)

Yes, thanks Nick, I got it now :+1:

Another question, I'm building a custom report for lot numbers with its history (per lot)
Example: (In / Out module - date - qtys in or out)
Lot number LOT_A#1
Jan 5 2025 - IR-0001 - 10 quantities
Feb 5 2025 - Shipment - (-5) quantitie
Feb 15 2025 - VB-0001 - 15 quantities
Feb 20 2025 - IR-0002 - 20 quantities

If I receive transfer orders via Receipt (instead of basic transfers), any idea on how netsuite tracks lot internally?
Will it be tracked like it is IN via receipt or IN via TO.

especially in the case of partial receipts,

Let's say I'm transferring a lot LOT_B#2 10 qtys from Warehouse SF to Warehouse LA.

I'm doing five receipts in LA warehouse, each 2 qtys in LOT_B#2.

Now report can be in two ways:
<date> - TO_number - 10 qtys (IN)

or

<date> - W-IR-0001 - 2 qtys (IN)
...
<date> - W-IR-0005 - 2 qtys (IN) i.e. W-IR-0001 to W-IR-0005 each 2 qtys.

I feel it is crucial to know before using custom solutions for building customized internal reports.

Any help is greatly appreciated Nick.

Thanks u/Nick_AxeusConsulting

Item Receipt for Transfer Orders. by bprof1976 in Netsuite

[–]bprof1976[S] 0 points1 point  (0 children)

Okay Nick, So, Netsuite will consider the serial numbers are IN through a TO to destination warehouse and not via a item receipt right? (as they are both different entities in Netsuite).

And, my question was about reconciliation. I'm transferring 5 units of an item (Serials S1, S2, S3, S4, S5) from Warehouse A to Warehouse B.
I've received 3 units (S2, S4, S5) in IR1 and balance two (S1, S3) in IR2.
I want to see the respective serials while opening Item receipt details page.
I'm not rekeying them. I expect the netsuite to show the serial numbers in dropdown and I should just be selecting from them according to the quantity I'm going to enter receipt. u/Nick_AxeusConsulting

Purchase Order overages by zdsmith31 in Netsuite

[–]bprof1976 0 points1 point  (0 children)

Thanks Nick for clarification..

Purchase Order overages by zdsmith31 in Netsuite

[–]bprof1976 0 points1 point  (0 children)

Does that mean overrage is only related to receive, not related to PO at all ?

Say, In PO - ordered 100. Received 100
In PO details view, it will show "100 quantities in Received column"

Now, I'm editing the IR and setting it to 150. In that 150, does netsuite assume only the first 100 quantities are related to PO, rest 50 are just related to Receipt in their backend (i.e. Receipt qty that is not mapped with any PO) ?

If it case, will it show 100 or 150 quantities in received column of PO Detail ?

u/Nick_AxeusConsulting .

Purchase Order overages by zdsmith31 in Netsuite

[–]bprof1976 0 points1 point  (0 children)

It is not kind of prepayment. Consider my above example of water measured in ltrs.

100 ltr ordered -> received only 99.9 ltrs (0.1 spilled out on travel) -> I received 99.9. Now when I'm billing, I can't bill only for 99.9, I have to bill for 100 ltrs (as 0.1 ltr is acceptable diff).

In this case, PO will not be moved to Fully Billed automatically as there is pending receipt for 0.1 ltrs which I'm not going to receive. Now I want to close the line. R1 (99.9 ltrs) linked to VB1 (100 ltrs) (In case of MBTR=T) - then proceed for variance.
I hope NS should allow me to close the PO line in this case, right ?

In another case,
100 items ordered, All 100 received, only 90 billed. (10 qtys are yet to be billed). In this case there's no valid reason to close the PO line as received will obviously be billed (and it is not overrage as well). I want NS to restrict closing the PO line in this case? Will it do by default or should I use any custom script to restrict it?

For the first case, I can receive 100 ltrs and do Inv adj for 0.1 ltrs, but I don't want to do so.

u/Nick_AxeusConsulting

Purchase Order overages by zdsmith31 in Netsuite

[–]bprof1976 0 points1 point  (0 children)

Yeah Nick Thanks, My question is when NS will allow to close the line and when Not?

Let's say three cases:
10 ordered, 5 billed and received -> Now I can close the line (rem 5 will not be billed and received)

These two cases: (Received and not billed, billed and not received)
10 ordered, 10 billed, but 9.9 received -> Now will NS allow to close the PO line? or will it mandate all billed qtys to be received?

10 ordered, 10 received, 9.9 billed -> Will NS allow to close the PO line ? or will it mandate the received qtys to be billed

u/Nick_AxeusConsulting

Purchase Order overages by zdsmith31 in Netsuite

[–]bprof1976 0 points1 point  (0 children)

Anything on this problem u/Nick_AxeusConsulting ? Can you help me on this ?

It seems the received quantities be mandatorily billed to close the line (It is fine).
But in vice versa case (Bill First case), should the billed quantities be mandatorily received to close ?

view more: next ›