@PeteLawson your syntax error was a double quote after OK. It should be 'OK'

@PeteLawson this text formula returns the results. case when {systemnotes.oldvalue}={systemnotes.newvalue} then 'OK' else 'Review' end I always include the formula in the results, as well as the criteria

and a formula to the search: case when field A = field B then 1 else 0 end then add the formula to the criteria with the value = 0 In the results: In the criteria:

Option B

@Jervin Nicholas Teopengco-Oracle Criteria (as a public search) Results Available Filters I want the custom field to display the applying transaction (vendor payment) status on the header of the transaction (vendor invoice)

@Jervin Nicholas Teopengco-Oracle These are not custom fields, but required for intercompany journal transactions. I want the due to from subsidary to move next to Eliminate However, these due to/from subsidiary is not on the custom form line subtab screen fields, the field is not there.

It did not answer the question. the approval workflow uses this field, but should exempt system generated transactions. Why is the FAM disposal not seen as system generated?

I found the field custbody16, a custom field for user with last edit.

we have class required on the forms, but see it only on one side of the transaction when reviewing the GL account. For example, and inventory adustment shows the class on the inventory account, but not on the designated scrap account.

This puts the data on the reports, such as the income statement, but it does not show the hierachy view, even with the with hierarchy is selected. How do I see the whole hierachy? This is the view I get from the role where these fields have been added

Tiru, This does not explain why the transfer posted to purchase price variances in it's entirety instead of in transit.

@Michelle Jabanes-Oracle Wouldn't that field tell me who ran it last, not who's running it now?

Can the committed column be populated when the work order is firmed?

I start the work order creation by entering the subsidiary. I want when I select and this field, to move to the next field of assembly, Instead, each time I enter data, I am brought to the item component next extry.

When the type payment card is selected, it can be chose to deposit to account without an account.

When a work order is firmed, I want to see that the components are fully allocated on the work order, so that the production supervisor releases to the floor the work orders that have sufficient inventory assigned.

We want this role to be able to update the expiration date on the item - lot number record. We do not want this role to be able to edit the item itself.

The vendor prepayment is applied to the purchase order. My issue was selecting an incorrect account type for the prepaid default account. Once corrected, it works as described.

@Tiru Chembeti I mapped to the internal ID of the item, and it am still getting an error for non-inventory items, such as sales tax and discount lines. The error is Can I match on the line ID or the line unique key field? Is the line level internal ID available through a saved search? If so, which is the correct field to…

On the purchasing inventory tab: On the inventory detail tab: On the bin putaway worksheet When I try to put in the inventory details, It does not find the inventory to transact.

Any suggestions on how I can clear this inventory? I tried to create a count, but this requires a bin

The role can execute the planned standard cost roll up, but not view the status. We do have other custom roles that can see that status. Permissions include Revalue Inventory Cost - Edit The role that works has Revalue Inventory Cost - Full

I understand that with standard cost, the option the check "use item cost as transfer cost" is not an option. Is that still correct? If not checked, is it looking at the average cost or standard cost, and at the origin or destination location?

Additional information, we do create the invoice from the sales order.

Yes, that is correct. We need to have "Invoice in Advance of Fulfillment" enabled for the bulk of the customers, and want to streamline and provide for more accurate invoices for those B2C customers that are invoiced directly

After fulfillment, both lines are with lot control. Lots are entered for the fulfilled line. No lots are entered on the backordered line inventory detail. Now I am no longer getting the error. I checked on the sublist field of Location on the invoice form, and the error no longer occurs. Would not having that box checked…

Figured this out, by modifying and updating the parent.

Dominica. Here is what I am looking at: Transactions -> Customer - Accept Customer Payments Edit Payment in status not deposited Edit Payment Change date Discount amount specified is reset to zero.

I do have other classes that have spaces, and was able to successfully use those classes in the search and CSV upload. My primary issue is trying to do a transfer via CSV upload, and it is returning as failed because the class is invalid, when I see that class on my class listing.

Micah, I still have some records failing. It is not seeing the class as a valid value. Can I use the class Internal ID instead?