pcorp01
Participant
Member since ‎2018 Mar 27

User Statistics

  • 58 Posts
  • 0 Solutions
  • 9 Kudos given
  • 10 Kudos received

User Activity

Alert query inconsistency

2024 Jan 08
I'm not sure what changed, but this query was working fine for a while then when we needed to restart SBO service, that's when it stopped working as it should. I have this scheduled to send email at 4:30pm daily, to show orders created within the las...

FMS copy value from active window in Item Master Data

2023 Jun 26
Not having much luck finding solution, but I have created a UDF in Items - with valid values (U_Manufacturer). When creating a new item in Master Item Data, I want the selected value in U_Manufacturer to be copied to FrgnName field. Please help with ...

Getting a syntax error in my where clause, pls help!

2022 Jul 26
SELECT T0.Segment_0 + '-' + T0.Segment_1 + '-' + T0.Segment_2 + '-' + T0.Segment_3 AS 'G/L Account', T1.Debit AS 'Debit Amount', T1.Credit AS 'Credit Amount', T1.RefDate AS 'Posting Date', T1.LineMemo AS 'Row Details', T1.Ref1 AS 'Reference 1', T1.Re...

Query returns duplicate

2020 Jan 15
Need help in modifying my AR line item invoice query. I want to be able to show the line text row as well, but it's returning duplicate records. I'm assuming Group By or Distinct will fix this? But not sure how to apply it. Please help! SELECT T1.[...

AR Invoice query to show all items of the invoice if a specific item is found in the order

2019 Oct 29
I would think this criteria would be written in the WHERE clause? But it's a bit of a challenge for me and not sure how to write it... If the item description contains "This Invoice Has Been Applied", I want the query to list out all the items in tha...
View more