Curtis Beene

Thank you for the feedback @Dominica Sevilla-Oracle but this isn't want I'm looking for. I need items we have received, but have yet to receive a bill for. I believe would be accomplished by combining INBSHP data with VENDBILL data to ID those PO Lines that are one the first report but not the other.

in AE: AP Clearing Report Comment by Curtis Beene Oct 5, 2021 6:29PM

@Mikko De La Fuente-Oracle thanks for the articles. They help me build this: Select Transactions.TranID, Transactions.TRANDATE,Transactions.Transaction_Type, TRANSACTION_LINES.Amount, TRANSACTION_LINES.Account_ID, ITEMS.Name, Customers.CompanyName From Transactions, TRANSACTION_LINES, ITEMS, Customers, Accounts Where…

in Cost of Goods Sold in Excel with SQL Query Comment by Curtis Beene Oct 1, 2021 12:34PM

Hey All, thanks to anyone that took a look at this over the last few days. I figure it out and wanted to post the answer here. See below. If you are reading this I assume you already know that the "Select" section is the data fields we want returned and the "From" section are the tables we want to pull data from. The…

in SQL Query for Inventory "In-transit" Comment by Curtis Beene Sep 27, 2021 8:18PM

@Dominica Sevilla-Oracle Well that is disappointing but I appreciate the information. I will navigate to SuiteIdea's and Upvote this enhancement.

in Saved Search "filter by user" when used as a reminder Comment by Curtis Beene Sep 10, 2021 5:46PM

@Joy Noreen Magoling-Oracle Great Points. This is a Transaction SS. The Criteria I think I need to be variable is highlighted below.

in Saved Search "filter by user" when used as a reminder Comment by Curtis Beene Sep 10, 2021 2:36PM

Thanks for the feedback @Ivy Lopez-Oracle #1 - A price field on the Item group was my suggestion, but my EDI contact wasn't sure the Dev team could make that happen. If they can, this article and method are a huge help. I was afraid this would have to be a manual update every time. I've tested and see that it works. I will…

in Grouped Items and EDI PO Import Comment by Curtis Beene Sep 9, 2021 11:06AM

Spot on @Ivy Lopez-Oracle . Thanks so much.

in Saved Search - Display week range OR first day of the week that a date falls in Comment by Curtis Beene Sep 3, 2021 11:11AM

Thank you for your feedback @Jack Daryl Espiel-Oracle . I haven't fixed my issue yet (due to time) but I think this pointed me into the right location.

in How would I structure a workflow to close requisition lines after fully ordered Comment by Curtis Beene Aug 19, 2021 12:09PM

@Jack Daryl Espiel-Oracle Sorry for the delay. I was away form my laptop. I do see how the suggestion you offer would work in some cases, but not as well for mine. Once the PO is generated I would like to have the associated lines close. If not, a team member may split the PO lines and re-open a req before the scheduled…

in How would I structure a workflow to close requisition lines after fully ordered Comment by Curtis Beene Aug 15, 2021 7:13PM

MFA for Oracle Community

Curtis Beene Red Ribbon

Comments