https://netsuiteprofessionals.com logo
Join Slack
Powered by
Hello Everyone!! Wondering if someone has any idea...
# general
c
Hello Everyone!! Wondering if someone has any ideas on where to look for my issue I need assistance pulling in information into a saved search. I need to be able to pull in the amount $ from an Item Receipt Transaction into this saved search results but it's not pulling in. Instead I'm getting other amounts that I can't trace back. Any idea why or what criteria I need to add to pull this amount? Slack Conversation
b
honestly looks pretty weird
you have filters related to the applying transaction join
and grouping columns related to the applying transaction join
but dont actually sum any of the applying transaction join
c
Okay. Is that why the amounts are pulling from some weird place and not the IR?
b
thats just gonna give you a bunch of results that contain duplicated data
you dont have any data from the applying transaction (the item receipt) at all
c
How do I link that?
b
all your amounts are from the transfer order
🤯 1
my guess is that you need to understand joins better
and when to use or not use them
c
Okay... So where do I go from here? @battk
b
first question you probably want to answer is why you are doing a transfer order/inbound shipment search if you want data from the item receipt
c
Exactly. I want data from the IR but when I only select Type as: Item Receipt it doesn't provide any information so my assumption is that the TO/Inbound shipment holds some type of information needed to link the IR to the applied transaction type
b
do an item receipt search
have only 2 of your columns, amount and probably document number so you can identify which amount goes to which transaction
c
and would I be able to pull in the TO number as well? I would need the TO to validate the amount in the item receipt for accounting
b
thats the way joins work
they go both directions
you can probably do this either direction
you are currently writing a transfer order search
the amount column is related to the transfer order
the transfer order has an applying transaction join, which relates it to applying transactions
that applying transaction has its own amount column
which in your case would be data from the item receipt
you can do this in the other direction as well, with a search on item receipts
which would have an applied to join in the opposite direction
similarly, the amount of the item receipt search is related to the item receipt
and the amount of the applied to join on the item receipt is related to the applied to transaction (the transfer order)
c
@battk thank you so much for your guidance. I got the amount to show finally
3 Views
Open in Slack
PreviousNext
Powered by