https://netsuiteprofessionals.com logo
Join SlackCommunities
Powered by
Anybody been successful in making a Transaction se...
# general
a
Anybody been successful in making a Transaction search showing Item Fulfillments with the Quantity on the IF line AND the Inventory Detail of Bin and Bin Qty. IT'S IMPOSSIBLE. You either get weird quantities, or No Bins on some lines. Why does NS show 3 rows for every 1 line on an item fulfillment in a saved search and then the rows that have the Bin Location don't match the rows with the correct quantities. And if you try to include any costing (item rate) that's even worse. Anyone have any insights on how to accomplish this? Thanks
r
I am not sure of your issue in particular. But what I have seen is many times a saved search hides the details or interprets things not how expected. For example the hack of MainLine=T. I think they try to simplify best for non developers which solves 80% of needs. What you are wanting is likely possible with SuiteQL. I avoid saved searches now for real heavy lifting due to needing multiple table joins.
I could be wrong but you may be facing cardinaility
so each line item on a transaction can have its own fulfilment. If you ship 3 line items from a SO in one shipment then ask a saved search for item fulfilment for the SO you will see 3 entries. this gets magnified when you join other data items. maybe you can share your saved search criteria and results items
a
Try creating a saved search Type = Item Fulfillment Mainline = F Tax Line = F Shipping Line = F Add columns Date Doc number Status Line ID Item item:description Quantity Item Rate Amount Notice how there are 3 results for each line on the IF (all with different Line IDs) Then add an inventory detail join as columns Inventory Detail:Bin Inventory Detail: Quantity Notice how it only populates results for 1 of the 3 rows per line. (And it's not always consistent)
I know the 3 lines are because of the different accounts but there is no way to get all the info together showing just whatever is listed on the IF line item in the UI
b
there are multiple reasons you can see multiple lines
the most common is that you are seeing cogs lines
you can usually filter those out by using the COGS Line filter
more uncommon are things like kit items with member items, which you can also filter using things like the Applied to Link Type
I personally like using a filter on the Applied to Transaction, there is only one line which is related to the transaction it was created from
a
Even if I add the applied to or applying to result it still shows 3 results for 1 line of the IF In the pic is the results for a 2 line item IF. The top line of the IF returns 2 results with no link to the Applied to transaction OR Inventory Detail. The second line of the IF returns 3 results. The first result has a link to the Applied to transaction AND Inventory Detail but no item rate. So if I filter by applied to transaction line 1 wouldn't even show up and line 2 would have no cost/amount If I group by bin number than line 1 would show as no bin This seems like a ridiculous defect
b
dont use the main line filter
a
That fixed the missing top line but still can't get cost/amount to line up with applied to or inventory detail information
b
not sure what you are looking for
but it sounds like you are looking for the amounts related to the cogs lines
which will be filtered out if you remove the cogs lines
if you really just want the amount on the cogs lines, you may be able to get away with using the cogs amount column
a
Actually. I think COGS amount would work! It shows on the same result as the inventory detail and other custom line fields. Thanks!!
m
Looking at your multiple lines, I agree that you need to filter the account line. That’s why you have multiple lines. Using COGS account only should produce one line only.
6 Views
Open in Slack
PreviousNext
Powered by