There are times when the Quantity and Amount of a specific item in a Transaction Saved Search shows a Negative value, even if you are expecting it to show as positive The most common reason is: the GL accounts are reversed under the Item Record’s Accounting tab. The normal account used for Item Accounts should be… Continue reading Negative Quantity in Transaction Saved Search
Tag: Transaction search
Sales order search not showing correct value of Total Amount, Tax Total, Sub Total
Jira Code : BGGN-630 Description We need to fetch the values marked in the below screen shot in the Sales order but it is showing wrong values Solution To get correct values from the Search, set the CONSOLIDATED EXCHANGE RATE as NONE
How to display Employee Name in Transaction Saved Search for Purchase Order
Description Transaction Saved Search for Purchase Order transactions results in null value shown when a join field Employee: Name is used in Results. The following method displays the way to fetch the Employee name in the transaction saved search for Purchase order. Solution To resolve, adjust the search and instead of Employee: Name join field use the… Continue reading How to display Employee Name in Transaction Saved Search for Purchase Order
How to get the “Next Approver” field in transaction search System Note fields
On Saved Transaction Searches, the System Notes Field Next Approver is not yet available on the list of Fields Available for Use as a Search Criteria. As an alternate solution, a Formula (Text) with Description = contains Next Approver; and Formula = {systemnotes.field} may be used. However, this is an enhancement – 417924.