Hi guys. When I perform a saved search for "Invent...
# integrations
a
Hi guys. When I perform a saved search for "Inventory, non-inventory items," everything appears as expected except for the "billing schedule." I have a drop-down list for "billing schedule" in both inventory and non-inventory items and I selected "1 month billing," but after saving, the saved search does not show the "billing schedule." Is there a solution for this problem? Thank you.
m
What's the Criteria? My guess is that you have something that is blocking those trans results. Also -- that first result formula you have can be replaced with the result of "Feed Name"
a
@mightyd3 here is the saved search i created:
m
Oh wait - Billing Schedule is on the item record? If so, it should just be a result of "Billing Schedule" not trans... billing schedule.
a
yes right but i can't find it there only under transaction.
@mightyd3
message has been deleted
m
Item Field > Default Level for Search/Reporting set to None?
The custbody field of "Billing Schedule"
a
i have tried to look for it in customization but i could not find it:
@mightyd3
j
Can you click on the grey text that says
BILLING SCHEDULE
and see what the ID is?
you looked under Item Fields?
a
@jen thanks for your response. yes I looked under item record.
j
OK I can tell from the ID that it is not a custom field
a
yes you are right. But how to find it in saved search do i have to create a custom field.
@jen
j
sorry I don’t know, we don’t use that field
possibly it’s not exposed to saved search
what happens if you try to use
{billingschedule}
in a formula?
a
@jen i have the following error: ERROR: Field Not Found
when tried to deep more i fond that Billing schedule is related to sales order not items. i can find it in Transaction:billing schedule.
@jen thanks
j
it’s interesting because it is technically on inventory and noninventory items also https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2022_2/script/record/noninventoryitem.html