Using Worksheet Application Concept Using Worksheet Application Using
- Slides: 32
Using Worksheet Application Concept
Using Worksheet Application
Using Worksheet Application Step 1 Begin by navigating to the Worksheet Selection page. Click the Scroll Down arrow.
Using Worksheet Application Step 2 Click the Accounts Receivable menu.
Using Worksheet Application Step 3 Click the Receivables Maintenance menu.
Using Worksheet Application Step 4 Click the Maintenance Worksheet menu.
Using Worksheet Application Step 5 Click the Create Worksheet menu.
Using Worksheet Application Step 6 Click the Add a New Value tab.
Using Worksheet Application Step 7 Enter the desired information into the Worksheet Business Unit field. Enter "US 003".
Using Worksheet Application Step 8 Click the Add button.
Using Worksheet Application Step 9 Use the Worksheet Selection page to build a new worksheet or to modify an existing one.
Using Worksheet Application Step 10 Use the Customer Criteria field to select the type of customer that you want to include in your worksheet. For this scenario, keep the default value.
Using Worksheet Application Step 11 Click in the Cust ID field.
Using Worksheet Application Step 12 Enter the desired information into the Cust ID field. Enter "USA 06".
Using Worksheet Application Step 13 Click the vertical scrollbar.
Using Worksheet Application Step 14 Use the Build button to create a new worksheet or add items that meet your selection criteria to an existing worksheet. Click the Build button.
Using Worksheet Application Step 15 Use the Worksheet Application page to select the items to which payments will be applied.
Using Worksheet Application Step 16 Use the Sel option to select the items that will be matched to the payment. In this example, to close open items, we are matching two payments with existing items having item balances of 3515. 10 and -3800. When you refresh, after selecting these two items, the net value is -284. 90. Click the Sel option.
Using Worksheet Application Step 17 Click the horizontal scrollbar.
Using Worksheet Application Step 18 You can view 8 rows at a time using the grid navigation, or click the View All link to view all rows on one page. In this example, we want to view the last 8 rows. Click the Last link.
Using Worksheet Application Step 19 Click the horizontal scrollbar.
Using Worksheet Application Step 20 Select the row for item PR-1. Click the Sel option.
Using Worksheet Application Step 21 Upon selecting the row, the Item Balance becomes available for changes, and the Balance fields are updated.
Using Worksheet Application Step 22 Click the vertical scrollbar.
Using Worksheet Application Step 23 Notice that the net balance between the selected debit and credit is -284. 90.
Using Worksheet Application Step 24 In order to close items, we can make changes to the worksheet. Hence, we replace the value of item PR-1 with a new value and refresh it again to validate.
Using Worksheet Application Step 25 Enter the desired information into the Item Balance field. Enter "-3515. 00".
Using Worksheet Application Step 26 Click the Refresh button.
Using Worksheet Application Step 27 Note that the system adds a new row, which shows the difference between the two item balances: 3, 515. 10 - 3, 800. 00 = -284. 90
Using Worksheet Application Step 28 Note that the net balance between the selected debit and credit is zero.
Using Worksheet Application Step 29 Click the Save button.
Using Worksheet Application Step 30 You have successfully used the Worksheet Application page to match received payments with existing open items. End of Procedure.
- Difference between actual self and ideal self
- Contoh selling concept
- How to write a concept application frq ap gov
- Motivation: from concepts to applications
- School leadership concept and application
- Concept paper worksheet
- Java desktop application automation testing
- Constitution worksheet answers
- Prime factors hcf and lcm worksheet
- Commas in a series worksheet
- How to find lcm using venn diagram
- Adjusting entries for depreciation
- Section 3 using thermal energy
- Algor mortis worksheet answers
- Lesson 7-5 using proportional relationships answers
- Elimination using addition and subtraction worksheet
- Synthetic division worksheet doc
- Using a calculator worksheet
- Using system.collections.generic
- Dtfd switch
- A concept paper
- Work in physics
- Thermoisoplethendiagramm polare zone
- Phenomenal concept strategy
- This concept says that "all media are constructed."
- Wellness concept
- Wdm concept
- Wdm concept
- Hydrogen bond concept map
- What does the prefix trans mean in the word transportation?
- Virtual ground in op amp
- Electric forces and fields concept review
- Marketing definition