Home

Sales Order (SO) - White Ware, Inc

1. ara L0 BrUESZBSHs x EkGX 5 A pvotrabie gt Be E 7 t A3 Y Batch ID A B D E G H J El 1 SO Recurring Journal 2 Batch ID AIT gt 4 Trans Type All Y 5 Customer ID AIT gt 6 7 Data 8 Order No Entry No Desc Ordered Qty Shipped Qty Backordered Qty Unit Cost Unit Price Ext Cost_ Ext Price 9 00004600 001 Electrical Package 100 0000 0 0000 0 0000 0 0000 380 5520 0 00 3805520 10 002 Exterior Panels 10 0000 0 0000 0 0000 0 0000 14100135 0 00 14100 14 1 003 Interior Door 5 0000 0 0000 0 0000 0 0000 45 6720 0 00 228 36 12 004 Interior Materials 5 0000 0 0000 0 0000 0 0000 8983905 0 00 4491 95 13 00004600 Total 120 0000 0 0000 0 0000 00000 2734 6280 0 00 328155 36 14 00004601 001 Interior Materials 15 0000 0 0000 0 0000 00000 8983905 0 00 13475 86 m 002 Interior Door 15 0000 0 0000 0 0000 0 0000 23 1105 0 00 346 56 16 003 Entry Door 12 0000 0 0000 0 0000 00000 238 3395 0 00 2860 07 17 004 Slide by Window 24 x 40 10 0000 0 0000 0 0000 00000 162 6765 0 00 1626 77 18 005 Millwork Package 10 0000 0 0000 0 0000 00000 1087 9050 0 00 10879 05 19 006 Cabinets 2 0000 0 0000 0 0000 0 0000 10550925 0 00 2110 19 20 00004601 Total 54 0000 0 0000 0 0000 00000 3465 5145 0 00 221792 93 21 00004603 001 Elec
2. ORDERED_d cif Sum of SHIPPED Q ENTRY NE lum of UNIT COST Invoice ENTRY_N E E invorce unir co custome urIT_PRI 1 Finish Click Next The PivotTable Wizard Step 4 dialog box appears PivotTable Wizard Step 4 of 4 HE Where do you want to put the PivotTable New worksheet Existing worksheet Click Finish to create your PivotTable Cancel Options lt Back Next gt Es 12 Thelast step lets you create the PivotTable either in the existing worksheet or in a different worksheet Accept the given options and click Finish SO Report Applet User s Manual Introduction Creating Microsoft Excel PivotTables The PivotTable is displayed 83 File Edit View Insert Format Tools Data Window Hi DG M SRY BAS oc PivatTable e 888 A INVOICE INVOICE ENTRY N Data Grand Total 24889101 12 21 95 Sum of OR 4 Sum of SH E 4 Sum of UNIT _ COMP 343 55 Sum of UNIT 475 686 475 686 Sum of OR TY 1 1 Sum of SH Y_SE 1 1 Sum of UNIT_ COMP 907 53 907 53 Sum of UNIT 1317 384 1317 384 Sum of OR T 7 7 Sum of SH T 7 7 Sum of UNIT COST T 22 01 22 01 Sum of UNIT 20 7995 20 7995 Sum of OR 5 Sum of SH E 5 Sum of UNIT 226 99 Sum of UNIT 526 131 Sum of OR _ 2 Sum of SH 2 114 pl Sheet1 Shest2 Sheet3 1
3. Creating Microsoft Excel PivotTables Read this section for an exercise in creating a PivotTable using the ODBC Kit and Microsoft Excel 97 If you require more information about Microsoft Excel consult the Microsoft Excel User s Guide or Online Help Before you can create this report complete these tasks e Install and set up the ODBC Kit Install and set up the BASIS ODBC drivers e Install Microsoft Excel 97 and Microsoft Query 97 Note This section includes instructions for using Microsoft Query with Microsoft Excel If necessary you can install Microsoft Query from the Microsoft Office 97 media You may also need to create a shortcut to Query manually SO Report Applet User s Manual 1 9 Creating Microsoft Excel PivotTables Introduction Building a Query For a PivotTable 1 Start Microsoft Query Zr Microsoft Query x oud ela 5 72 4 amp 3 t fn 3 SS 2 Under the File menu select New The Choose Data Source screen appears Databases Queries Locum IM M UIT M ETT md dBASE Files not sharable Excel Files not sharable FoxPro Files not sharable MS Access 97 Database not sharable OSAS Text Files not sharable El Use the Query Wizard to create edit queries SO Report Applet User s Manual Introduction Creating Microsoft Excel PivotTables 3 Select lt New Data Source gt and click OK
4. The Create New Data Source screen appears Create New Data Source 121x What name do you want to give pour data source ir fosas Data Select a driver for the type of database you want to access Click Connect and enter any information requested by the driver a Connect Save mpuse JD and password in the data source Cancel 4 you want to give the data source in 1 You can use the same source again 5 Select the BASIS ODBC Driver in field 2 6 Click Connect The BASIS ODBC Driver Data Source Setup box appears Enter Data Source Specification DK Data Source Name Description Cancel Database Configuration CAOSAS prog0 D config tpm Advanced gt gt 7 Enter the file path and name of the CONFIG TPM file you set up from within the OSAS ODBC software in the Database Configuration field or select Browse and locate the file SO Report Applet User s Manual 1 11 Creating Microsoft Excel PivotTables Introduction If you have already built the shadow dictionary click on the Advanced button and check the options for No Shadow Dictionary Consistency Check and Fast Connect to improve performance See online help for additional information about the options that come with the Advanced button 8 Click OK to connect to the data source You are returned to the Create New Data Source screen 9 Select a table in field 4 if you want to
5. Y ev zones Vio x00 4 M4 9 2 cl PR spoT sura wes 3 a 00x7 40301014 SO Report Applet User s Manual 3 10 accessing data Microsoft Excel 1 9 Accounts Receivable installing the applet with 2 1 D data files in Sales Order 1 5 Data Source creating a new source 1 11 Fast Connect 1 12 No Shadow Dictionary Consistency Check 1 12 selecting a data source 1 12 F Fast Connect Microsoft Query 1 12 installing the applet 2 1 M Microsoft Excel 1 9 PivotTable layout 1 21 PivotTable sample 1 23 PivotTable wizard 1 17 selecting a data source 1 18 Microsoft Query 1 9 adding tables 1 15 building a query 1 10 Filtering data 1 13 joining tables 1 16 Selecting a table 1 13 SO Report Applet User s Manual Index Sorting data 1 14 N No Shadow Dictionary Consistency Check Microsoft Query 1 12 ODBC Kit definition 1 3 OSAS general information 1 3 PivotTable adding a calculated field 1 23 changing column data 1 30 changing data sort 1 31 changing field properties 1 26 changing selection fields 1 28 definition 1 7 moving fields 1 28 PivotTable Wizard Choosing a data source 1 18 getting the data 1 18 laying out the table 1 21 returning the data 1 22 PivotTables SO Kit History 3 3 SO Recurring Journal 3 5 SO Sales Journal 3 7 SO Tax Report 3 9 IX 1 In
6. 1 iif E4 Total B c D E 1 BATCH ID All y 2 TRANSACTION y 3 4 INVOICE NUMBER INVOICE DATE ENTRY NUMBER Data Total 5 124889101 12721 99001 Sum of ORDERED_QTY 4 6 Sum of SHIPPED_QTY_SELL 4 f Sum of UNIT COST COMPNT 343 55 8 Sum of UNIT PRICE 475 686 g Sum of Profit Dollars 528 544 10 002 Sum of ORDERED_QTY 1 11 Sum of SHIPPED QTY SELL 1 12 Sum of UNIT COST COMPNT 907 53 18 Sum of UNIT_PRICE 1317 384 14 Sum of Profit Dollars 409 854 15 003 Sum of ORDERED_QTY 7 15 Sum of SHIPPED QTY SELL 7 ilc Sum of UNIT COST COMPNT 22 01 18 Sum of UNIT PRICE 20 7995 19 Sum of Profit Dollars 8 4735 20 004 Sum of ORDERED_QTY 5 21 Sum of SHIPPED QTY SELL 5 22 Sum of UNIT COST COMPNT 226 98 23 Sum of UNIT PRICE 526 131 24 Sum of Profit Dollars 1495 705 25 005 Sum of ORDERED QTY 2 26 Sum of SHIPPED QTY SELL 2 27 Sum of UNIT COST COMPNT 151 14 28 Sum of UNIT PRICE 381 645 29 Sum of Profit Dollars 441 01 30 24889101 Sum of ORDERED QTY 19 3124889101 Sum of SHIPPED_QTY_SELL 19 32 24889101 Sum of UNIT COST_COMPNT 1661 22 33 24889101 Sum of UNIT PRICE 2721 6455 34 24669101 Sum of Profit Dollars 20148 0845 35 24889102 12 21 99 001 Sum of ORDERED_QTY 3 36 ld 4 V Wi Sheet Shest2 7 Sheets Ready SO Report Applet User s Manual Sum of SHIPPED_QTY_SELL Iq 1 29 Creating Microsoft Excel PivotTables Introduction Changing the Column Data Yo
7. 72 27 000047 Total 6 0000 336 0000 1253 2600 _ 70182 56 28 000049 001 00000004 001 200100 MNOOD1 1 0000 40 0000 367 6300 _ 14705 20 29 002 00000004 001 200200 MNODO1 0000 40 0000 223 0300 8921 20 30 003 00000004 001 200300 MNODO1 0000 40 0000 419 8100 16796 40 31 004 100000004 001 200400 001 0000 40 0000 125 2300 5009 20 32 005 00000004 001 200500 MNooo1 1 0000 40 0000 45 5900 1823 60 y la 4 b DIN Sheett 14 f Ready NMI Tl A 3 4 SO Report Applet User s Manual File SORECJRN XLS Description SO Recurring Journal The SO Recurring Journal PivotTable uses the data in the Recurring Orders Detail SORLx file to display detailed information about the recurring orders that you have set up The data is sorted by Order Number Entry Number and Description but you can easily change the sort order or add the Batch ID Transaction Type or Customer ID to the sort Active Fields Default Field Type Page Row Column SO Report Applet User s Manual Field Batch ID Transaction Type Customer ID Order Number Entry Number Description Ordered Quantity Shipped Quantity Backordered Quantity Unit Cost Unit Price Extended Cost Extended Price 3 5 SO Recurring Journal Sales Order PivotTables SO Recurring Journal PivotTable 3 Ele Edit view Insert Format Tools Data Window Sample 0
8. 9 000 000 1072781 29 24708 99 cav 18101 Puelo SE 000 000 000 000 000 000000 000 000 000 000 000000 sovicer 880682 TEIL 01000000196 000 000 o0 000 000 000000 000 000000 000 000000 sgvicey 880682 12215 100 01000000 FE 000 000 000000 000 000000 000 000000 000 000 19656 000 000 1101 60000000 EE 000 000 000 000 000 000000 000 000 000 000 000 000 000 EEE ___100 60000000 ZE 000 000 000 000 000 000 000 000 000 000 000 000 220121 000 000 18101 80000000 LE 000 000 000 000 000 000 000 000 000 000 000 000 220121 000 000 OP X DE MOPUIAA 15 100 80000000 DE 000 000 000 000 000 000 000 000 000 9 000 000 76 000 000 18101 20000000 62 000 000 000 000 000 000 000 000 000 v8 1291 000 000 78129 000 000 207 X Ag E00 18 000 000 000 000 000 000 000 000 000 8S 9CS1 000 000 899261 000 000 X AQ 200 000 000 000 000 000 000 000 000 000 09 581 000 000 09 581 000 000 100 20000000 92 000 000 000 000 000 000 000 000 000 000 000 000 000 VAES 2671 12101 900000001 SC 000 000 000000 000 000000 000 000 000 000 ooo 1000 EE 181 50 000 000 000 000 000 000 000 000 000 000 000 000 000 16 957 En 1009 Jouayu 200 ez 000 000 QUU 000 000 000000 000 000 000 000 000000 EA Sue vena 100 90000000 000 000 000 000 000 ooo 000 000 coo 000 000 000 00 000 EVOL 6000000018 000 000 000 000 000 000 000
9. BS Ele Edit view Insert Format Tools Data Window Help The PivotTable is displayed with the Sum of Profit Dollars field 1515 1 lt 7 AR x 2 10 aria B H SA 55 8 ml Oa A PivotTable aia hd A B D E E Giaj 1 TRANSACTION TYT AII 2 g BATCH_ID 4 INVOICE_NUMBERIINVOICE DATE ENTRY NUMBER Data 000002 Grand Total 5 24889101 12 21 98 001 Sum of ORDERED QTY 4 4 6 Sum of SHIPPED_QTY_SELL 4 4 Sum of UNIT_COST_COMPNT 343 55 343 55 8 Sum of UNIT_PRICE 475 686 475 686 g Sum of Profit Dollars 528 544 528 544 10 002 Sum of ORDERED_QTY 1 1 11 Sum of SHIPPED_QTY_SELL 1 1 12 Sum of UNIT_COST_COMPNT 907 53 907 53 13 Sum of UNIT_PRICE 1317 384 1317 384 14 Sum of Profit Dollars 409 854 409 854 15 003 Sum of ORDERED_QTY 7 7 16 Sum of SHIPPED_QTY_SELL 7 7 17 Sum of UNIT_COST_COMPNT 22 01 22 01 18 Sum of UNIT_PRICE 20 7995 20 7995 18 Sum of Profit Dollars 8 4735 8 4735 20 004 Sum of ORDERED_QTY 5 5 21 Sum of SHIPPED_QTY_SELL 5 5 22 Sum of UNIT_COST_COMPNT 226 99 226 99 23 Sum of UNIT_PRICE 526 131 526 131 24 Sum of Profit Dollars 1495 705 1495 705 25 005 Sum of ORDERED_QTY 2 2 26 Sum of SHIPPED_QTY_SELL 2 2 27 Sum of UNIT_COST_COMPNT 161 14 161 14 28 Sum of UNIT_PRICE 301 645 301 645 EJ Sum of Pr
10. ODBC Kit you specify the location of the data files and data dictionaries in a file called CONFIG TPM You can build this file using the ODBC Kit functions You can store this file in any directory but the report applets expect the file to be located in the CAWINDOWS directory If your CONFIG TPM file is stored in a different directory you have three choices for using the PivotTables supplied with the report applet 1 Move the CONFIG TPM file to the CAWINDOWS directory and change any Data Sources you have set up and any ODBC reports or spreadsheets you have already set up to use the CONFIG TPM in its new location 2 Copy the CONFIG TPM file to the CAWINDOWS directory and leave a copy in its current location You do not need to change any Data Sources or reports you have set up but you need to make any changes in both files 3 Change the PivotTables provided with this report applet to use the CONFIG TPM file in its current location You can find instructions for doing this below If you choose methods 1 2 above you can load the PivotTables in Microsoft Excel and begin using them with your data by using the Refresh Data command in Excel If you choose option 3 follow the instructions below to point the PivotTable to the correct CONFIG TPM file 2 2 SO Report Applet User s Manual Installation Using a Different CONFIG TPM If you store your CONFIG TPM file in a location other than the CAWINDOWS directory you will s
11. tab and select the query you saved under Microsoft Query Choose Data Source 121 x Databases Queries dunning Cancel pivot Browse didi Options El Use the Query Wizard to create edit queries The Choose Columns box under Query appears Query Wizard Choose Columns 21x What columns of data do you want to include in your query Available tables and columns Columns in your query BATCH_ID ORDER_NUMBER TRANSACTION_TYPE INVOICE_NUMBER 8 ARCC Ea INVOICE_DATE EH ARCD_1 CUSTOMER_ID 8 ARCD 2 SUBTOTAL FLARED 3 il SALES TAX _ Preview Mow Beck Cancel SO Report Applet User s Manual 1 19 Creating Microsoft Excel PivotTables Introduction 6 Click Next gt The query columns are displayed 7 Click Next gt to pass by Filter Data and Sort Order options The Query Wizard Finish dialog box appears Query Wizard Finish 21x What would you like to do next Save Query View data or edit query in Microsoft Query lt Back Cancel 8 Select Return Data to Microsoft Excel and click Finish You are returned to the PivotTable Wizard Step 2 dialog box PivotT able Wizard Step 2 of 4 2 Where is your external data stored Get Data Data fields have been retrieved Cancel lt Back Finish 9 Click Next gt 1 20 SO Report Applet User s Manual Introduction 10 Creating Microso
12. the appearance of the table by moving the fields around Fields appear on the PivotTable as gray blocks with the field name on them To move any field simply drag it to a new destination You can change your PivotTable by moving fields in these ways Changing the Selection Fields If you want to be able to limit the data in the table you can make any field in the table part of the selection criteria by moving it to the Page area For example to select a specific batch for this table rather than displaying all the batches across the table columns as they are in our sample table follow these steps 1 Position the mouse cursor over the BATCH_ID field press and hold the left mouse button As you drag the BATCH_ID field around the table the cursor changes to show where you can drop it If the cursor looks like a block with an X over it you will remove the field from the table by dropping it there 2 Drag BATCH_ID field to the left of the TRANSACTION_TYPE field and drop it there 1 28 SO Report Applet User s Manual Introduction Creating Microsoft Excel PivotTables The change appears immediately X Microsoft Excel Book1 53 File Edit View Insert Format Tools Data Window Help Biel ES 2181 28 wr HA 0 8 CA v Para B 7U 9 9 S 5 A PivotTable
13. 000 000 000 000 000 16952 000 000 2000 1 200 102 000 000 000 000 000 000 000 000 000 000 000 000 LE VEST 000 000 abexaeg Buiquinid 200 6 000 000 000 000 000 000 000 000 000 000 000 000 90721 000 000 abeyaed 2941593 100 90000000 BF 000 000 000 000 000 000 000 000 000 000 000 000 000 HELL Ov Sey 18101 70000000 2b 000 000 000 000 000 000 000 000 000 000 000 000 000 8 1791 1 001 207 MOPUIAA Ag 00 191 000 000 000 000 000 000 000 000 000 000 000 000 000 COLLAN 0289 MOPUIAA AQ APIIS 200 9 000 000 000 000 000 000 000 000 000 000 000 000 000 6 9577 290 100 yooooo00 Fl 000 000 ooo 000 000 000000 000 000 000 000 000 106528 00 000 20000000 ER 000 000 000 000 000 000000 000 000 000 000 000 ezea 000 000 Onx pzmopum Aqep s 500 000 000 000000 000 000000 000 000 000 000 ooo _ 199092 000 000 1009 Aus pool 000 000 000000 000 000000 000 000 000 000 000 orsi 000 000 3ogiousw 00 or 000 000 000 000 000 000 000 000 000 000 000 000 000 000 abeyoeg Buiquinig 200 6 000 000 000 000 000 000 000 000 000 000 000 000 2206 000 000 123115815 20000000 AT S XEJUON p 147 y WI p IA E AT WI XeiuoN c AT W c IA Xeon WT 2580 sa Fe 05 E W A 1 5 Ei 3
14. 1671 84 00007 Ti 9 0000 9 0000 0 0000 1193 2200 2285 1000 10738 98 252m E 414 MA Sheet1 14 el Ready PEA 3 8 SO Report Applet User s Manual SO Tax Report File Name SOTAXRPT XLS Description The SO Tax Report PivotTable uses the data in the Open Order Detail SOTDx file to display detailed sales tax information for the orders you have entered The report is sorted by Order Number Entry Number and Description but you can easily change the order of the sort or include the Batch ID or Tax Group in the sort Active Fields Default Field Type Page Row Column SO Report Applet User s Manual Field Batch ID Tax Group Order Number Entry Number Description Level 1 Tax Taxable Subtotal and Nontaxable Subtotal Level 2 Tax Taxable Subtotal and Nontaxable Subtotal Level 3 Tax Taxable Subtotal and Nontaxable Subtotal Level 4 Tax Taxable Subtotal and Nontaxable Subtotal Level 5 Tax Taxable Subtotal and Nontaxable Subtotal 3 9 Sales Order PivotTables SO Tax Report SO Tax Report PivotTable Sample 1 ww ES pe 7 pr NITO 000 000 000 000 000 000 000 000 000 26
15. 6 10742 96 002 5 5 22 01 51 381 146 855 003 1 1 226 99 526 131 299 141 24889104 Total 16 16 1591 87 2994 678 22444 928 4 24889105 12 21 99 001 1 1 855 61 1485 495 629 885 002 4 4 161 14 381 645 882 02 003 4 4 176 47 417 96 965 96 27 24889105 Total 9 9 1193 22 2285 1 9826 92 2824889106 12 21 99 001 5 5 145 98 342 144 980 82 2924889106 Total 5 5 145 98 342 144 980 82 30 Grand Total 69 69 6979 2882 12473 1185 37907 4 2907 31 PIN Sheets Sheet Sheet Sheet 7 14 Ready esf NUM T Z 1 30 SO Report Applet User s Manual Introduction Creating Microsoft Excel PivotTables Changing the Data Sort To change the order in which the data is displayed you can simply change the Row fields around For example our PivotTable is sorted by Invoice Number To sort it by Invoice Date instead click and drag the INVOICE_DATE field to the left of the INVOICE_NUMBER field The data is sorted by Invoice Date and is redisplayed File Edit View Insert Format Tools Data Window Help 18 wz T 10 8 10 so 4 o A Bivotrable BS INVOICE NUMBER A B G H F 1 BATCH ID All y _ Data INVOICE DATE INVOICE NUMBIENTRY NUMBER of ORDERED Sum of SHIPPED_QTY_SELL Sum of UNIT COST COMPNT
16. 60 18 004 Entry Door 5 0000 5 0000 0 0000 2269900 526 1310 1134 95 2630 66 18 005 Slide by Window 24 x 40 2 0000 2 0000 0 0000 161 1400 381 6450 322 28 763 29 20 00000003 Tota 9 0000 19 0000 0 0000 1661 2200 2721 6455 31563 18 51711 26 21 00000004 00 Interior Materials 3 0000 3 0000 0 0000 840 8300 1485 4950 2522 49 4456 49 22 002 Slide by Window 24 x 40 3 0000 3 0000 0 0000 152 0000 381 6450 456 00 1144 94 23 003 Slide by Window 30 40 4 0000 4 0000 0 0000 _ 171 5500 417 9600 686 20 1671 84 24 00000004 Tota 0 0000 10 0000 0 0000 116413800 22851000 1154380 22851 00 25 00000005 00 Electrical Package 3 0000 3 0000 0 0000 _ 348 0582 475 6860 1044 17 1427 06 26 002 Plumbing Package 2 0000 2 0000 0 0000 874 5600 1317 3840 1749 12 2634 77 27 003 Interior Door 5 0000 5 0000 0 0000 0 0000 51 3810 0 00 256 91 28 00000005 Tota 0 0000 10 0000 0 0000 1222 6182 18444510 12226 18 1844451 29 00000005 00 Exterior Panels 0 0000 10 0000 0 0000 13428700 2417 1660 13428 70 24171 66 30 002 Interior Door 5 0000 5 0000 0 0000 220100 51 3810 110 05 256 91 at 003 Entry Door 1 0000 1 0000 0 0000 225 9900 526 1310 226 99 526 13 32 00000006 Tota 6 0000 16 0000 0 0000 1591 8700_2994 6780 2546992 47914 85 33 00000007 00 Interior Materials 1 0000 1 0000 0 0000 855 6100 1485 4950 855 61 1485 50 34 002 Slide by Window 24 x 40 4 0000 4 0000 0 0000 161 1400 381 6450 644 56 1526 58 a5 003 Slide by Window 30 X 40 4 0000 4 0000 0 0000 175 4700 417 9500 705 88
17. AS Data 0 BATCH li ORDER_NUM TRANSACTION TIINVOICE INVOICE DANCUSTOMER ID SUBTOTAL SALES TAX TOTAL COST gt 000002 00000003 3 24889101 1995 1221 GREOOT 675967 0 3893 03 000002 00000004 3 24889102 19951221 __ 105001 7273 27 0 3664 69 7 000002 00000005 3 24889103 19951221 SUNOOT 4318 74 0 279329 000002 00000006 3 24889104 1995 1221 CASHCA 249547 1497 28 13765 74 000002 00000007 3 24889105 1995 1221 CASHMN 4683 92 0 2206 05 1280 000002 00000008 3 24889106 1995 1221 CASHPS 1710 72 0 7283 121000002 00000009 4 24889107 1995 12 21 ACEOO1 973 95 0 1030 65 11 000002 _ 00000010 4 24889108 1995 12 21 105001 4821455 0 27910 M s RecoaTi Select View to show edit limiting records shown NUM SO Report Applet User s Manual Introduction Creating Microsoft Excel PivotTables The data in your query is displayed You can delete columns by selecting a column and pressing the Delete key You can also add a column by double clicking on the field name in the SOTH file NOTE You can also select which fields you want in your query in step 6 above Instead of selecting the entire table you can click the box next to the table you want and select the given fields from the list 14 Select the following fields e BATCH ID ORDER NUMBER e TRANSACTION TYPE INVOICE NUMBER e INVOICE DATE e CUSTOMER ID e SUBTOTAL e SALE
18. Highlight rows and columns to shift them around To display only invoices change Transaction Type from All to 3 Change it to 4 and credit memos are displayed Totals per type are also displayed Adding a Calculated Field You can also add new fields like profit to the data area To add profit to the data area follow these steps 1 Highlight the last row in your data area Sum of UNIT_PRICE right click and select Insert SO Report Applet User s Manual 1 23 Creating Microsoft Excel PivotTables Introduction The Insert Calculated Field dialog box appears Insert Calculated Field Formula 0 Delete BATCH ID ORDER NUMBER TRANSACTION TYPE INVOICE NUMBER INVOICE DATE CUSTOMER ID SUBTOTAL SALES TAX zi Insert Field 2 Enter the following information about the inserted field Enter Profit Dollars in the Name field e Enter SHIPPED QTY SELL UNIT PRICE SHIPPED QTY SELL UNIT COST COMPBNT in the Formula field 3 Click Add Insert Calculated Field 2 Profit Dollars Modify Formula SHIPPED QTY SELL UNIT_PRICE SHIPPED QT Delete Fields BATCH_ID ORDER NUMBER TRANSACTION TYPE INVOICE NUMBER INVOICE DATE CUSTOMER ID SUBTOTAL SALES TAX zi Insert Field 1 24 SO Report Applet User s Manual Introduction Creating Microsoft Excel PivotTables 4 Click OK X Microsoft Excel Book1
19. OPEN SYSTEMS Accounting Software Sales Order ODBC Report Applet User s Manual PN 2210 50060 1998 Open Systems Holdings Corp rights reserved Document Number 2210 500600 No part of this manual may be reproduced by any means without the written permission of Open Systems Holdings Corp OPEN SYSTEMS is a registered trademark and OSAS Resource Manager Resource Manager for Windows and Report Writer are trademarks of Open Systems Holdings Corp is a trademark and PRO 5 and Visual PRO S are registered trademarks of BASIS International Ltd Novell NetWare and UNIXWare are registered trademarks of Novell Inc Microsoft Microsoft Access Microsoft Windows Microsoft Windows 95 Windows MS DOS and PivotTable are either trademarks or registered trademarks of Microsoft Corporation Crystal Reports for Windows is a trademark of Seagate Software Inc TrueType is a registered trademark of Apple Computer Inc Printed in U S A August 1998 Release 6 0 This document has been prepared to conform to the current release version of OPEN SYSTEMS Accounting Software Because of our extensive development efforts and our desire to further improve and enhance the software inconsistencies may exist between the software and the documentation in some instances Call your customer support representative if you encounter an inconsistency Contents Introduction General Information Sales Order Data Files Introduction to PivotTables Crea
20. OSE SRY 2 2 4 Mo aria 8 Ready 2 Select the Data menu then select PivotTable Report SO Report Applet User s Manual 1 17 Creating Microsoft Excel PivotTables Introduction 3 The PivotTable Wizard appears PivotT able Wizard Step 1 of 4 L2 x Where is the data that you want to analyze C External data source C Multiple consolidation ranges Another PivotTable Cancel lt Back ves Finish In step 1 of the Wizard a list of options is displayed where you can choose your data source to be used in your PivotTable Select External Data Source and click Next gt The PivotTable Wizard Step 2 dialog box appears Where is your external data stored No data fields have been retrieved Cancel lt Back Next gt Finish 4 In step 2 of the Wizard click Get Data SO Report Applet User s Manual Introduction Creating Microsoft Excel PivotTables The Choose Data Source box from Microsoft Query appears Choose Data Source L2 1x OK Databases Queries lt New Data Source gt dBASE Files not sharable Excel Files not sharable FoxPro Files not sharable MS Access 97 Database not sharable OSAS Data Text Files not sharable Cancel Browse Options did El Use the Query Wizard to create edit queries 5 Click the Queries
21. S TAX e TOTAL COST 15 Select Table from the main menu and choose Add tables The Add Table dialog box appears Add Tables Close SOTH zi Options SO Report Applet User s Manual 1 15 Creating Microsoft Excel PivotTables Introduction 16 A list of all the tables is displayed Select the SOTD table and click Close Joining Tables 17 18 19 20 21 Locate BATCH_ID in the SOTD and SOTH tables then click and hold the left mouse button down on BATCH ID in the SOTH table Drag the field over to the BATCH ID field in the SOTD table and release the mouse button A line appears between the two BATCH ID fields joining the two fields Follow steps 17 through 18 with the ORDER NUMBER field NOTE You may get the following message For now click Yes to ignore the message and join the fields together Microsoft Query Columns ORDER NUMBER and ORDER NUMBER that you are about to join are of is different types Create the join anyway Select the following fields from the SOTD table e ENTRY NUMBER COST COMPNT e PRICE ORDERED QTY e SHIPPED QTY SELL e BACKORDERED QTY Select Save from the File menu to save the query SO Report Applet User s Manual Introduction Creating Microsoft Excel PivotTables Using the Query in Microsoft Excel 1 Start Excel and open new worksheet Ele Edt view Insert Format Tools Data Window Help 18 x J
22. Sum of UNIT PRICE Sum of Profit Dollars 12 21 99 24889101 001 4 4 343 55 475 686 528 544 002 1 1 907 53 1317 384 409 854 003 7 7 22 01 20 7995 8 4735 1004 5 5 226 99 526 131 1495 705 005 2 2 161 14 381 645 441 01 24889101 19 19 1661 22 2721 6455 20148 0845 124889102 1001 3 3 840 83 1485 495 1933 995 002 3 3 152 381 645 688 935 003 4 4 171 55 417 96 985 64 24889102 Total 10 10 1164 38 2285 1 11207 2 24889103 001 3 3 348 0582 475 686 382 8834 002 2 2 874 56 1317 384 885 648 003 5 5 0 51 381 256 905 24889103 Total 10 10 1222 6182 1844 451 6218 328 24889104 001 10 10 1342 87 2417 166 10742 96 002 5 5 22 01 51 381 146 855 003 1 1 226 99 526 131 299 141 24889104 16 16 1591 87 2994 678 22444 928 24889105 001 1 1 855 61 1485 495 529 885 002 4 4 161 14 381 645 882 02 003 4 4 176 47 417 96 965 96 24889105 Total 9 1193 22 2285 1 9826 92 124889106 1001 5 5 145 98 342 144 980 82 24889106 Total 5 5 145 98 342 144 980 82 30 Grand Total 69 69 6979 2882 12473 1185 379074 2907 31 _ Id 4 M Sheet Sheet Sheet Sheets Wal gt 4 You can also drag the selection fields from the Page area to the Row area to sort the data by those fields SO Report Applet User s Manual 1 31 Creating Microsoft Excel PivotTables Introduction More About Using PivotTables Feel free to experiment with the orientation of the fields on this sample report As you become more familiar with the tables and how
23. cation This manual includes instructions for loading and using these spreadsheets to sort and analyze your data With a little practice you can easily create similar PivotTables or modify the ones provided to customize them to your exact needs SO Report Applet User s Manual 1 3 Sales Order Data Files You use the Sales Order system to account for orders you take from customers Sales Order encompasses the capabilities of Accounts Receivable you can record sales you made to customers and orders that have not been paid Sales Order lends its tracking capabilities to other applications associated with tracking assets Inventory for example SO Data Files The Sales Order Report Applet contains several spreadsheets that report information from the OSAS Sales Order data files The PivotTables in the SO Report Applet are based on these data files SOTDxxx The Open Order Detail file stores records for orders and returns before they are posted If Sales Order is interfaced with Inventory orders will update serialized and nonserialized item balances and costs in Inventory Data from the Open Order Detail file is used in the SO Sales Journal SOSLSJRN XLS and SO Tax Report SOTA XRPT XLS PivotTables SORLxxx The Recurring Order Detail file stores records for recurring orders which are not real orders until you copy them to the Open Order files This data is displayed on the SO Recurring Journal SORECJRN XLS PivotTable SOKHxxx T
24. dex R Report Applet requirements for 1 9 report applet installation 2 1 report applets definition 1 3 5 Sales Order data files 1 5 description 1 5 installing 2 1 system requirements 2 1 SO Kit History PivotTable description 3 3 files used in 1 5 sample report 3 4 screen 3 4 SO Recurring Journal PivotTable description 3 5 files used in 1 5 sample report 3 6 screen 3 0 SO Sales Journal PivotTable description 3 7 files used in 1 5 sample report 3 8 screen 3 8 SO Tax Report PivotTable description 3 9 files used in 1 5 sample report 3 10 screen 3 10 SOKHxxx file description 1 5 SOKITHST XLS data files 1 5 description 3 3 SORECJRN XLS data files 1 5 description 3 5 SORLxxx file description 1 5 2 SOSLSJRN XLS data files 1 5 description 3 7 SOTAXRPT XLS data files 1 5 description 3 9 SOTDxxx file description 1 5 spreadsheets SO Kit History 3 3 SO Recurring Journal 3 5 SO Sales Journal 3 7 SO Tax Report 3 9 system requirements 2 1 SO Report Applet User s Manual
25. ee this message when you attempt to refresh the data in any PivotTable included with this report applet Microsoft Excel Ez e BASIS BASIS ODBC Driver Default configuration Failed Default CONFIG C datadict Config tpm error duplicate or missing file When you click on OK the BASIS ODBC Driver Data Source Setup dialog box appears BASIS ODBC Driver Data Source Setup Eg Enter Data Source Specification Data Source Name Description C datadict Config tpm OK Database Configuration Help Esca To specify the location of your CONFIG TPM file click Browse and select the file from the location screen Locate Configuration File Look in 73 6 ex Data progra JProgrm print l progGL 1 progSD prog P I proglN __ Rwdata prog R L Sample progBK L Ld sort progBR L progPA config tpm progEl L progPM File name confia Files of type Fies Cancel SO Report Applet User s Manual 2 3 Installation When you select the file the final dialog appears Microsoft Excel e PivotTable was changed during Refresh Data operation When you click on OK the PivotTable is updated with your accounting data Report Applet PivotTables Use the descriptions of the PivotTables in chapter 3 to work with your accounting data 2 4 SO Report Applet User s Manual Sales Order PivotTables SO Kit History SO Recurri
26. ft Excel PivotTables The PivotTable Wizard Step 3 dialog box appears PivotT able Wizard Step 3 of 4 BEI LS x LI Construct your PivotTable by dragging the field buttons on the right to the diagram on the left BATCH 109 ORDERED ORDERN rreren ransad Backorg NVOICE ENTRY NI dd INVOICE INIT CO USTOME UNI m 2 The selected fields and four areas Page Row Column and Data to put fields are displayed Drag and drop the fields to use in this report into the respective areas display the full field name hold the cursor on the button and a tool tip displays the full field name Drag and drop the following fields TRANSACTION_TYPE into Page INVOICE_NUMBER INVOICE DATE and ENTRY NUM into Row BATCH_ID into Column ORDERED QTY SHIPPED QTY SELL UNIT_COST_COMPNT and UNIT PRICE into Data SO Report Applet User s Manual 1 21 Creating Microsoft Excel PivotTables Introduction 1 22 11 The fields are displayed on the screen Numeric fields dropped into the Data section become summary fields PivotT able Wizard Step 3 of 4 L2 1x EJ 2571 Construct your PivotTable by dragging the field buttons on the right to the diagram on the left ORDERED TRANSAG BATCH Star StS
27. he Kit History file stores history information from the Bill of Materials Kitting application if it is interfaced with Sales Order The SOKHxxx file stores data each time you sell a kit through Sales Order Entry The data stored in the SOKHxxx file is the basis of the SO Kit History SOKITHST XLS PivotTable SO Report Applet User s Manual 1 5 Introduction to PivotTables A Microsoft Excel PivotTable is an interactive table that quickly summarizes or cross tabulates large amounts of data You can rotate its rows and columns to see different summaries of the source data filter the data by displaying different pages or display the details for areas of interest A PivotTable contains fields each of which summarizes multiple rows of information from the source data By dragging a field button to another part of the PivotTable you can view your data in different ways For example you can view any field either down the rows or across the columns The PivotTable summarizes data by using a summary function such as Sum Count or Average You can include subtotals and grand totals automatically or use your own formulas by adding calculated fields and items In the Sales Order Report Applet several PivotTables are provided based on the data in the OSAS data files The PivotTable is updated through the ODBC driver The next section includes a tutorial for setting up and modifying PivotTables in Excel SO Report Applet User s Manual 1 7
28. let User s Manual Introduction Creating Microsoft Excel PivotTables The PivotTable is redisplayed reflecting your changes XX Microsoft Excel Book1 iO x 83 File Edit View Insert Format Tools Data Window amp lt 7 2 2 da 4 10 2 arial 10 je z u zm GE eR G0 A pivotable INVOICE DATE INVOICE NUMBER INVOICE DATE IENTRY NUMBER 24889101 Sum of ORDERED QTY Sum of SHIPPED QTY SELL Sum of UNIT COST COMPNT Sum of UNIT PRICE Sum of Profit Dollars Sum of ORDERED QTY Sum of SHIPPED QTY SELL Sum of UNIT COST COMPNT Sum of UNIT PRICE Sum of Profit Dollars Sum of ORDERED QTY Sum of SHIPPED QTY SELL Sum of UNIT COST COMPNT Sum of UNIT PRICE Sum of Profit Dollars Sum of ORDERED QTY Sum of SHIPPED QTY SELL Sum of UNIT COST COMPNT Sum of UNIT PRICE Sum of Profit Dollars Sum of ORDERED QTY Sum of SHIPPED QTY SELL Sum of UNIT COST COMPNT Sum of UNIT PRICE Sum of Profit Dollars R H N N 0148 0845 20148 0845 35 24888102 12 21 88 001 Sum of ORDERED QTY 3 3 36 Sum of SHIPPED_QTY_SELL 3 3 x 4 Sheet 1 Sheet2 Sheets 7 1 1 gt Ready SO Report Applet User s Manual 1 27 Creating Microsoft Excel PivotTables Introduction Moving Fields and Sorting Data You can dramatically change
29. ng Journal SO Sales Journal SO Tax Report SO Report Applet User s Manual 3 1 File Name SOKITHST XLS Description SO Kit History The SO Kit History PivotTable uses the data in the Kit History SOKHx file to display detailed information about the kits you ve sold on past sales orders The data is sorted by History Sequence Number and Kit History Sequence Number but you can easily change the sort order or add the Batch ID to the sort Active Fields Default Field Type Page Row Column SO Report Applet User s Manual Field Batch ID History Sequence Number Kit History Sequence Number Order Number Entry Number Component ID Component Location Quantity for 1 Kit Base Unit Cost Selling Unit Cost Extended Cost 3 3 SO Kit History Sales Order PivotTables SO Kit History PivotTable Sample Elle Edt view Insert Format Tools Data Window la x H amp t Bm aria 10 B amp We x f 2 45 100 5 SWS dd Oo A prottable gt e 9 f A3 s Batch ID A B C D 6 H 1 150 Kit History E 3 Batch ID Y 4 5 Data B Sequence Kit Sequence Order Entr
30. ofit Dollars 441 01 441 01 30 12 21 99 Sum of ORDERED QTY 18 19 el 12 21 99 Sum of SHIPPED QTY SELL 18 19 32 12 21 99 Sum of UNIT COST COMPNT 1661 22 1661 22 33 12 21 99 Sum of UNIT PRICE 2721 6455 2721 5455 34 12 21 99 Sum of Profit Dollars 20148 0845 20148 0845 35 24889101 Sum of ORDERED QTY 18 19 36 24889101 Sum of SHIPPED_QTY_SELL 19 19 37 24889101 Sum of UNIT_COST_COMPNT 1661 22 1661 22 38 24889101 Sum of UNIT PRICE 2721 6455 2721 5455 I4 4 gt HW Sheet 1 Sheet f Sheet 7 14 4 Ready SO Report Applet User s Manual 1 25 Creating Microsoft Excel PivotTables Introduction Changing Field Properties You can also change the properties of the fields in the table For example to remove the subtotals from the INVOICE_DATE field 1 Place your mouse cursor on the INVOICE_DATE column heading right click and select Field from the menu The PivotTable Field dialog box appears PivotT able Field 2 xi Name rientation Cancel Row C Column Subtotals Delete e Automatic Custom None Hide items 12 21 99 Show items with no data You can use the PivotTable Field dialog box to change the field name its orientation on the PivotTable its display mask subtotalling options and so on 2 To shut of the subtotals select None under Subtotals and click OK 1 26 SO Report App
31. ppears Query Wizard Filter Data 2 x Filter the data to specify which rows to include in your query If you don t want to filter the data click Next Column to filter Only include rows where C nd Gr C And Gr Cind Gr Use the Filter Data dialog box to select specific records from the table In most cases you do not need to choose anything in the Filter Data dialog box For example to filter out credit memos select the field named TRANSACTION_TYPE select does not equal and then enter 4 for a value TRANSACTION_TYPE 4 is a credit memo SO Report Applet User s Manual 1 13 Creating Microsoft Excel PivotTables Introduction 12 Click Next gt The Sort Order box appears Query Wizard Sort Order Specify how you want your data sorted If you don t want to sort the data click Next Sort b Ascending 3 Descending Then by Ascending Descending Then by Ascending Descending zl lt Back Cancel Use the Sort Order dialog box to select how the data is sorted For example select a field in Sort by and check Ascending or Descending Select more fields and orders for hierarchical sorts For now don t enter any sort fields 13 Click Finish You are returned to the Microsoft Query screen gt Microsoft Query 5 File Edit View Format Table Criteria Records Window Help Ejea y 44 E E 43 Ce e a Query 1 OS
32. select a default table source otherwise leave field 4 blank and select any table when you develop the query If you select a table the list of tables always starts at that table otherwise the list of tables starts at the beginning of the list The Choose Data Source box appears Choose Data Source Databases Queries Of lt New Data Source gt dBASE Files not sharable Excel Files not sharable FoxPro Files not sharable MS Access 97 Database not sharable OSAS Text Files not sharable Cancel Browse Options dd El Use the Query Wizard to create edit queries 10 Select the data source you set up in the previous steps 1 12 SO Report Applet User s Manual Introduction Creating Microsoft Excel PivotTables The Choose Columns screen appears Query Wizard Choose Columns 2 xi What columns of data do you want to include in your query Available tables and columns Columns in your query SORH gt BATCH ID SORL ORDER_NUMBER SOSL TRANSACTION TYPE c TERMS_CODE E SOTB Lx Group EH SOTD Preview of data in selected column El 11 Selecta table you want to use in your Excel spreadsheet For this example start with one table and add a second table later Select the SOTH table select the columns for the spreadsheet and click Next gt The Filter Data box a
33. ting Microsoft Excel PivotTables Installation Sales Order PivotTables SO Kit History SO Recurring Journal SO Sales Journal SO Tax Report Index SO Report Applet User s Manual A s Xx Oo 2 1 3 3 3 7 3 9 Introduction General Information Sales Order Data Files Introduction to PivotTables Creating Microsoft Excel PivotTables SO Report Applet User s Manual General Information The OPEN SYSTEMS Accounting Software OSAS product line consists of several accounting applications Each application addresses a different phase of your financial operations together they form a powerful accounting solution to your daily and periodic accounting needs The ODBC Kit The OSAS ODBC Kit provides users with a way to access their OSAS data through any ODBC compliant productivity package The ODBC Kit includes an ODBC driver for Windows the data dictionaries for the OSAS data files utilities for maintaining the data dictionaries and some sample reports in Microsoft Excel Microsoft Access and Crystal Reports for Windows The Report Applets Since the release of the ODBC Kit OSAS users have been discovering the power of these popular productivity packages to analyze their accounting data The Report Applets provide a series of pre built Microsoft Excel PivotTables to help you get the most from your accounting data These tables are provided for each of the major data files in each appli
34. to use them you can enjoy the benefits of viewing your data in new and different ways For more information about PivotTables see the Microsoft Excel documentation or online help 1 32 SO Report Applet User s Manual Installation You can put the Sales Order ODBC Report Applet on your system by installing it through Resource Manager The installation process is described in this section The Sales Order Report Applet needs a minimum of 110 kilobytes 110KB for installation You must also have installed Sales Order and the ODBC Kit on your system and the ODBC drivers on the Windows workstation Installing the Report Applet Use the Install Application function on the Resource Manager Installation menu to install the report applet You must install the Accounts Receivable and Sales Order applications before you install this report applet The installation will treat the report applet as though you are reinstalling Sales Order This is normal behavior You must install the applet for Accounts Receivable in order to access the customers historical and master file information you enter When you install the report applet Resource Manager copies the PivotTables to the directory where your Sales Order programs are stored You must have access to this directory from your Windows machine to access the tables in Microsoft Excel SO Report Applet User s Manual 2 1 Installation The CONFIG TPM File When you install the
35. trical Package 10 0000 0 0000 0 0000 00000 451 9055 0 00 4519 06 22 002 Plumbing Package 10 0000 0 0000 0 0000 0 0000 12515205 0 00 12515 21 23 003 Exterior Panels 5 0000 0 0000 0 0000 0 0000 2551 4530 0 00 12757 27 24 004 Interior Door 5 0000 0 0000 0 0000 0 0000 54 2355 0 00 271 18 25 00004603 Total 30 0000 0 0000 0 0000 00000 4309 1145 0 00_129273 44 26 00004620 001 Electrical Package 5 0000 0 0000 0 0000 0 0000 360 7275 0 00 1803 64 27 002 Entry Door 5 0000 0 0000 0 0000 0 0000 2383395 0 00 1191 70 28 003 Slide by Window 24 x 40 5 0000 0 0000 0 0000 00000 162 6765 0 00 813 38 29 004 Millwork Package 2 0000 0 0000 0 0000 00000 10879050 0 00 2175 81 30 005 Cabinets 5 0000 0 0000 0 0000 00000 10550925 0 00 5275 46 31 00004620 Total 22 0000 0 0000 0 0000 00000 29047410 0 00 63904 30 32 AIRCOND 001 Interior Door 5 0000 0 0000 0 0000 0 0000 23 1105 0 00 115 55 I 33 AIRCOND Total 5 0000 0 0000 0 0000 0 0000 23 1105 0 00 115 55 34 SERVICE 001 SERVICE CHARGE FOR USE OF 900 1 0000 0 0000 0 0000 0 0000 43 0000 0 00 43 00 ANA 1 nnnn aan nnnnn nnnnn nnnn nnn 12 um Ready 3 6 SO Report Applet User s Manual File SOSLSJRN XLS Description SO Sales Journal The SO Sales Journal PivotTable uses the data in the Open Order Detail SOTDx file to display detailed information about your unposted sales orders The information is sorted by Order Number Entry Number and Description but yo
36. u can change the data that appears in the columns in the table by dragging the fields or data block to the column heading area For example to show the quantity price cost and profit information in our table across the columns instead of in the data block as they now appear drag the Data field above the Total column heading and drop it there The change appears immediately X Microsoft Excel Book1 BEE 8 Ele Edt view Insert Format Tools Data Window Help 1 2121 D c B 7z 0 A E e 9 Data INVOICE NUMBERIINVOICE DATE ENTRY NUMBER of ORDERED QTY Sum of SHIPPED_QTY_SELL Sum of UNIT COST COMPNT Sum of UNIT PRICE Sum of Profit Dollars 24889101 12 21 99 001 4 4 343 55 475 686 528 544 1002 1 y 907 53 1317 384 409 854 003 7 7 22 01 20 7995 8 4735 004 5 5 226 99 526 131 1495 705 1005 2 2 161 14 381 645 441 01 24889101 Total 19 19 1661 22 2721 6455 20148 0845 24889102 12 21 99 001 3 3 840 83 1485 495 1933 995 1002 3 3 152 381 645 688 935 E 1003 4 4 171 55 417 96 985 64 24889102 Total 10 10 1164 38 2285 1 11207 2 16 24889103 12 21 99 001 3 348 0582 475 686 382 8834 1002 2 2 874 56 1317 384 885 648 003 5 5 0 51 381 256 905 24889103 Total 10 10 1222 6182 1844 451 6218 328 24889104 12 21 99 001 10 10 1342 87 2417 16
37. u can change the sort easily to include the Batch ID Transaction Type or Customer ID Active Fields Default Field Type Page Row Column SO Report Applet User s Manual Field Batch ID Transaction Type Customer ID Order Number Entry Number Description Ordered Quantity Shipped Quantity Backordered Quantity Unit Cost Unit Price Extended Cost Extended Price 3 7 SO Sales Journal Sales Order PivotTables SO Sales Journal PivotTable Sample 3 Elle Edit view Insert Format Tools Data Window 18 xj 28 9 wm g 10 B 7 u S SA ER tu MI A9 gt Batch ID A B C D E E G H J F 1 1S0 Sales Journal 2 Transaction Type 1 New 4 5 6 T 8 9 Batch ID All gt 10 Trans Type All y 11 Customer ID All gt 12 13 Data 14 Order Entry No Desc Ordered Qty Shipped Qty Backordered Qt Unit Cost Unit Price Ext Cost Ext Price 15 00000003 001 Electrical Package 4 0000 4 0000 0 0000 343 5500 475 6860 1374 20 1902 74 16 002 Plumbing Package 1 0000 1 0000 0 0000 _ 907 5300 1317 3840 907 53 1317 38 17 003 Interior Door 7 0000 7 0000 0 0000 220100 20 7995 154 07 145
38. y No Component ID Component Location Qty for 1 Kit Base Unit Cost Selling Unit Cost Ext Cost 7 000043 001 00000001 001 200100 MDODO1 0000 10 0000 367 6300 3676 30 8 002 00000001 001 200200 00001 0000 10 0000 223 0300 2230 30 El 003 00000001 001 200300 00001 0000 10 0000 419 9100 4199 10 10 004 00000001 001 200400 MDO001 1 0000 10 0000 125 2300 1252 30 11 005 00000001 001 200500 00001 1 0000 10 0000 45 5900 455 90 12 006 00000001 001 200600 00001 0000 10 0000 71 8700 718 70 13 000043 Total 5 0000 50 0000 1253 2600 _ 12532 60 14 000045 001 00000002 001 200100 00001 1 0000 10 0000 357 5300 3676 30 15 002 00000002 001 200200 MDODO1 0000 10 0000 223 0300 2230 30 16 003 00000002 001 200300 00001 1 0000 10 0000 419 9100 4199 10 17 004 00000002 001 200400 00001 1 0000 10 0000 125 2300 1252 30 18 005 00000002 001 200500 MDODO1 0000 10 0000 45 5900 455 90 19 005 00000002 001 200600 00001 0000 10 0000 71 8700 718 70 20 000045 Total 6 0000 60 0000 1253 2600 1253260 21 000047 001 00000003 001 200100 001 0000 5 0000 367 6300 _ 20587 28 22 002 00000003 001 200200 MNODO1 1 0000 56 0000 223 0300 12489 68 23 003 00000003 001 200300 MNODO1 0000 56 0000 419 9100 23514 96 24 004 00000003 001 200400 MNODO1 1 0000 56 0000 125 2300 7012 88 25 005 00000003 001 200500 MNDODO1 1 0000 56 0000 45 5000 255304 26 006 00000003 001 200600 MNODO1 0000 56 0000 71 8700 4024

Sales Order (SO) - White Ware, Inc

Contents

Download Pdf Manuals

Related Search

Related Contents