I need to know if the rate of every item in a Vend...
# suitescripte
Edgar Valdés
05/04/2023, 9:18 PMI need to know if the rate of every item in a Vendor Bill is different compared to the same item in the corresponding Purchase Order.
Whats the best way to get that information? I'm open to Saved Searches and SuiteScript.
m
MGBC
05/04/2023, 9:19 PMYou can do in a saved search. Use the Applied to Transaction : Item Rate field and compare to Item Rate
MGBC
05/04/2023, 9:19 PM(assuming your search is based on the Vendor Bill)
e
Edgar Valdés
05/04/2023, 9:21 PMThanks @MGBC I will look into it
p
PWN
05/04/2023, 11:43 PMYou need this isolated or is it more of a "we need 3-way matching" scenario? There are a lot of turnkey options for that but the better ones ofc aren't free 🙂
e
Edgar Valdés
05/05/2023, 3:37 PMHi @PWN this is just for reporting purposes. I didn't know about "Applied to Transaction" was an option at the line level, so I was thinking if SuiteScript will be more flexible in that regard.
4 Views