We uncommitted Inventory from a sales order, and t...
# generala
Anthony Moran
06/30/2023, 4:31 PMWe uncommitted Inventory from a sales order, and that inventory got automatically reallocated to a different order. How can I determine which order it got reallocated to?
a
al3xicon
06/30/2023, 4:37 PMyou can visit the reallocate items page, it should show you where it is committed
a
Anthony Moran
06/30/2023, 4:49 PMYes, but I am still having issues determining which one received the allocation. For example, 100 orders are displayed and we have 80 committed. If I uncommitted one order and the inventory gets reallocated to another. It doesn't show me which new order it got reallocated to.
t
Tim Chapman
06/30/2023, 4:51 PMI feel your pain but I don't know if there is a better solution than what @al3xicon said.
a
al3xicon
06/30/2023, 4:55 PMThe line level history on the order probably shows the change in the committed quantity, but I don't believe you can report on that like you can with system notes at the header level. There's no direct link between orders when committed stock from one is reallocated to another.
✅ 1
a
Anthony Moran
06/30/2023, 4:57 PM@al3xicon That is what I was afraid of; I appreciate your input. Thank you!
s
Stuart Anderton
07/02/2023, 8:47 AMHad a similar issue and created a new line field of “Last Committed Quantity” and use a scheduled WF to set it when it does not equal quantity committed. You could then use system notes to see what SO lines recorded a change. However there would be a delay of up to 30 minutes before you would see it.
a
al3xicon
07/02/2023, 1:27 PMWas sort of thinking about something like this, wonder if a UE script would fire when the committed qty changes, but doubt it
s
Stuart Anderton
07/03/2023, 6:10 PMNo it doesn't
d
David B
07/03/2023, 9:41 PM👋 hey, guess what I've gone and done
David B
07/03/2023, 9:43 PMhere's the results of two reallocation events:
a
al3xicon
07/03/2023, 9:50 PMNice!
d
David B
07/03/2023, 9:57 PMcriteria is just
Type is Sales OrderLine System Notes : Field is CommittedCOUNT Internal ID greater than/equal to 2s
Stuart Anderton
07/03/2023, 9:59 PMHow dod you do it?
a
al3xicon
07/03/2023, 9:59 PMI'll have to remember linesystemnotes, sweet
s
Stuart Anderton
07/03/2023, 10:00 PMCool
d
David B
07/03/2023, 10:00 PMformula:
David B
07/03/2023, 10:01 PMif any of you are PL/SQL experts, please have a look at my question on #suiteql about cleaning up these formula:
David B
07/03/2023, 10:17 PMalmost forgot, you have to add this summary criteria, otherwise you'll get false-positives (see screenshot) for transactions that increase inventory:
Copy code
┌──────────────┬───────────────────┬─────────────┬───────────────────────────────────────────────────────────────────────────────────────────────┐
│ Summary Type │ Field │ Description │ Formula │
├──────────────┼───────────────────┼─────────────┼───────────────────────────────────────────────────────────────────────────────────────────────┤
│ SUM │ Formula (Numeric) │ is 0 │ TO_NUMBER(NVL({linesystemnotes.newvalue}, 0)) - TO_NUMBER(NVL({linesystemnotes.oldvalue}, 0)) │
└──────────────┴───────────────────┴─────────────┴───────────────────────────────────────────────────────────────────────────────────────────────┘a
al3xicon
07/03/2023, 10:22 PMRight that makes sense. Thanks again..I took a look at the SuiteQL post but it is beyond me unfortunately
👍 1
d
David B
07/03/2023, 10:24 PMone thing you may need to account for is particularly big reallocation events that produce line system notes in two different minutes.
I don't know how to fix this, as you could round the
{linesystemnotes.date}