This did not work, the custom role has those permissions and the trigger to calculate the asset revalution does not trigger any activity Click Calculate to compute the write-down amount based on the write-down percentage. does nothing.

@PeteLawson Please verify that the formula reported in the results is the same as in the criteria. It looks like the error you are getting is in the formula in the results tab of the search.

did you fix the formula inside the report itself? It still is showing an invalid expression. Are you comparing a specific data field, or anything against anything? You may want a criteria that specifies a specific system note field

That works for transations, but not for the vendor record. I want to add a note from the receiver to the vendor record.

@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…