Hello! Any idea how to query `quantitypricingsched...
# suiteql
j
Hello! Any idea how to query
quantitypricingschedule
? Checked from Item Record but itemVendor table has no schedule available, and QuantityPricingSchedule table has no fields available.
Copy code
SELECT itemVendor.* FROM item INNER JOIN itemVendor ON itemVendor.item = item.id
t
You have to have the "Quantity Pricing" feature enabled in the instance, and you'll need the "Lists - Quantity pricing Schedules" permission to see the table. The table should have these columns exposed:
👍 1
j
I saw you blog on this, it is resolved. Thank you!