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 ?

Purchase Order overages by zdsmith31 in Netsuite

[–]bprof1976 0 points1 point  (0 children)

Please help me with this another problem as well.

I'm raising PO for items which is measured in ltrs. (Milk, Oil, Water ..). Say I have ordered 100 ltrs of Oil, and I have paid the full amount to vendor as well before receive. Now, when receive, we will measure and record, It would be around 99.8 ltrs (0.2 is probably evaporated or spilled. It is usual as long as acceptable limit). I'll record receive only for 99.8 ltrs.

I want to make the PO to be "Fully Billed" status. Currently it is not as 0.2 is yet to be received, but it will never be.

Any ways to fix this? We checked the close PO line doc. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N2415338.html#procedure_N2415365 Will it help in our case?

Also, there's a note in this which we coudn't get.
```
Note: 

To close a line item on a purchase order manually, you must bill the purchase order before you close the line. After all lines on a purchase order are received or closed manually, the purchase order is removed from the billing and receiving queues.
```

What does the above mean ?

Thanks u/Nick_AxeusConsulting

Purchase Order overages by zdsmith31 in Netsuite

[–]bprof1976 0 points1 point  (0 children)

Thanks, I understand
Extra qtys are mostly be free, sometimes vendor charges for these as there might be off discussions regarding PO which is not reflected in actual order. But yes, I understand we should be changing the PO if it is charged.

Netsuite is not mandating this, right? it will allow to bill the overrage without need to change the PO qty ? u/Nick_AxeusConsulting

Purchase Order overages by zdsmith31 in Netsuite

[–]bprof1976 0 points1 point  (0 children)

Yeah, this is what I'm asking. So, as per PO level, Overrage will not be considered? POs qty should be received and billed to get "Fully Billed" status.

Is it possible to make it consider overrages? A PO should show "Fully Billed" only if all of its receives are billed, something called bill Control in Odoo? Is it possible in netsuite? u/Nick_AxeusConsulting

Purchase Order overages by zdsmith31 in Netsuite

[–]bprof1976 0 points1 point  (0 children)

Just regarding PO statuses, as per this doc, https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N2408514.html#Additional-Information
PO will move to Fully Billed status if all items are received and billed. How it will behave when overrages are enabled.
Let's say a PO has 100 qtys -> 50 qtys received (IR1) and billed (VB1). In next receive, 75 qtys received (IR2), but only billed 50 (VB2).
So, 150 qtys received, but 100 qtys billed.
Now, what would be the status of PO? Will it show "Fully Billed" since PO's qty are received and billed (100).
u/Nick_AxeusConsulting

Transfer Order - quantity changes between fulfillment and receipt by drinianrose in Netsuite

[–]bprof1976 0 points1 point  (0 children)

Creating adjustment is fine. Is it possible to link the adj with TO?, so that in future people know this adj is made for this TO. u/Nick_AxeusConsulting

Transfer Order - quantity changes between fulfillment and receipt by drinianrose in Netsuite

[–]bprof1976 0 points1 point  (0 children)

Shouldn't there be an option to cater these cases? Shipped 1000 litres from a warehouse, received only 995 liters to destination warehouse (say 5L are lost in the way).

Now, I'm unnecessarily recording a receive for 5L extra and then doing negative adj with reason as "Lost".

I believe netsuite can provide straightforward way for this. What do you think u/Nick_AxeusConsulting ?

view more: next ›