Thursday, September 27, 2018
Ability to show Landed Cost information directly on the Purchase Order from which an Item Receipt was received
A. Create a saved search to show Landed cost.
1. Navigate to Transactions>Management>Saved Searches>New>Transaction.
2. Under the Criteria Tab, mark check the Use Expression checkbox.
- Set the following on the Standard subtab:
> Set "(" then the filter, Main Line = False.
> Type = Item Receipt
> Account Type = Other Current Asset (Type of account used in your item's asset account field)
> Set "(" then the filter, Memo = is not empty, on the And/Or column set to "And".
> Set Memo = does not contain Cost of Sales, then set "))".
3. Under the Results Tab, mark the Show Totals check box and add the following:
- Set the following on the Columns subtab:
> Date
> Created From
> Type
> Number
> Account
> Memo
> Amount
> Item
4. Under the Available Filters Tab:
> Select Created From fields..., then Internal Id.
5. Set a custom name for the search.
6. Mark the Result as Public and Available as Sublist View.
7. Save the Search.
B. Attach the Landed Cost Search created to the Purchase Order via a Sublist.
1. Navigate to Setup>Customization>Sublists.
2. Under the Transactions tab, select the Saved Search created.
3. Set a Label for the Sublist being created.
4. Select the tab you want top show this sublist in (for example "Related Records").
5. Mark the Purchase checkbox to make it available on Purchase Orders.
6. Hit Save.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment