Home

Bill of Materials/Kitting

1. Component Exceeds Qty Available Component 001 of 014 Company H 08 22 2005 Terminal TODO OVR 1 Enter the location ID for the assembly you want to view 2 Enter the ID of the assembly you want to view Bills of Materials Kitting User s Manual 4 3 Assembly Inquiry Daily Work 3 The Do you want to calculate the maximum available prompt appears when you enter the assembly ID If you want to calculate the available number of assemblies that you can build with the available components in the specified locations select Yes or enter Y in text mode if not select No or enter N in text mode The available quantity of the assembly appears 4 Enter the number of assemblies you want to build This information appears e The maximum available quantity to build e The level of the component or material The component or item ID An asterisk before an item ID indicates that the quantity of the component in inventory is below the quantity needed to build the assembly e The location ID e The units by which the quantities are measured e The quantities required to build the requested amounts e The quantities available in inventory appear This number is based on the specified components in the Bill of Materials function 5 Select a command button e Press G and then enter the line number to go to a particular line item This command appears only if there is more than one screen of items
2. Bills of Materials Kitting includes a number of productivity reports in Microsoft Excel format These reports connect directly to your OSAS data via the ODBC JDBC driver included with OSAS 7 0 and allow you to use spreadsheet tools to manipulate the data as you want and produce charts and graphs to visualize trends The spreadsheet reports are listed on the Productivity Reports menu Double click a report name to automatically launch Excel or any other spreadsheet program capable of opening an Excel formatted spreadsheet to open the report Use the selection boxes to filter the information that appears in the report or use the tools within your spreadsheet software to create charts and graphs from the report s data 1 8 Bills of Materials Kitting User s In Windows In Other Operating Systems Using Parameters Starting OSAS OSAS runs on an operating system supported by 150 MB of permanent storage and 4 MB of RAM You may need additional space or memory depending on the size of your data files and the operating system you use Consult your reseller for more information To start OSAS on a computer running Windows double click the OSAS shortcut on the desktop or access the program from the Start menu To start OSAS on an operating system other than Windows enter osas at the operating system prompt If your operating system has graphical capabilities you can also use the OSAS shortcut to start OSAS You can use the
3. Welcome to the Bills of Materials Kitting application for OPEN SYSTEMS Accounting Software OSAS Bills of Materials Kitting helps you manage assembled and kitted items in inventory by recording the components involved in these items Bills of Materials Kitting works with the OSAS Inventory application to calculate how many assembled items you can build from existing component quantities and with the Sales Order application to sell assemblies and kits Bills of Materials Kitting plugs into Resource Manager the foundation of OSAS Consult the Resource Manager guide for more information on basic OSAS functionality and details on how Resource Manager works within the OSAS system About This Guide This guide describes the functions that make up the Bills of Materials Kitting application and gives details on how Bills of Materials Kitting fits into your existing business workflow This guide is divided into these sections e Chapter 1 introduces OSAS and the Bills of Materials Kitting application and describes the basics of the Bills of Materials Kitting system and how to navigate around OSAS e Chapter 2 Installation and Conversion details how to install Bills of Materials Kitting using Resource Manager and how to create or convert the data files it requires e Chapter 3 Getting Started gives information and checklists on the steps you need to perform to set up Bills of Materials Kitting e Chapters 4 through 12 contain function
4. 6 Set up access codes You should establish valid kits and bills of materials immediately after you install Bills of Materials Kitting Tables Before you begin to define bills of materials and kits you must set up the system tables e The Terminology TRMBK table holds labels of the user defined fields used in the Kits and Bill of Materials functions e The General Ledger BKGLxxx table assigns the general ledger accounts you specify to the amounts entered for the three user defined fields Bills of Materials Kitting User s Manual Set Up and Work Flow Setting Up Bills of Materials Kitting Access Codes To restrict access to data files menus and functions that provide confidential information or are sensitive to change use the Resource Manager Access Codes function to set up access codes on your system Access codes are company specific When you set up an access code for a user the code is assigned the company you are in After you set up your access codes print a list of them and store it in a safe place Creating a Backup Schedule Back up your Bills of Materials Kitting data files whenever they change and before you run these functions e Build Assembly e Components e Multilevel Cost Rollup e Purge Bill of Materials History e Post Transactions e Undo Build Back up your programs once a month as insurance against media damage or deterioration Use the Backup function on the Resource Manager Data File
5. Assembly ID From E ee Thru 700100 From Thru Include O Assemblies O Kits Both Update Inventory Standard Cost Y Company H 08 22 2005 Terminal T000 OVR Inquiry 1 Enter the range of location assembly and kit IDs for which you want to recalculate costs or leave the boxes blank to include all 2 Select whether to apply the rollup to Assemblies to Kits or to Both assemblies and kits Bills of Materials Kitting User s Manual 6 21 Multilevel Cost Rollup File Maintenance 3 If you want to update standard costs in Inventory select the box or enter Y in text mode if not clear the box or enter N in text mode 4 To save your entries use the Proceed OK command 6 22 Bills of Materials Kitting User s Manual Tables Use the Tables function on the File Maintenance menu to maintain the TRMBK and BKGLxxx tables Tables store information about the system data options and default settings for other applications To produce a list of the information entered for each table use the Tables List function on the Master File Lists menu Select Tables from the File Maintenance menu The BKTB screen appears BKIB ge Commands Edit Modes Other Help 2X te Table ID y Description Number of Cols Column Length Company H 08 22 2005 Terminal TODO OVR Inquiry 1 Enter or change the table ID To set up a company specific table enter the table ID plus the
6. 12 56 PM Bill of Materials List by Location ID Costed Estimated Inventory ID Description Loc ID Type Quantity Unit Unit Cost Ext Cost 700 Cabinets MNOOOL Made up of parts 700100 700300 and 700500 700100 Valnut Cabinet MNOOOZ Sub 1 0000 EA 40 0600 40 0600 700300 HANDLES MNOOOZ Item 4 0000 EA 2 0800 8 3200 700500 SERIES NUMBER MNOOOZ Item 1 0000 EA 0000 0000 Total Assembly Component Cost 48 3800 Documents File Name Description Document BRSAMPLE DOC Sample word processing document Documents File Name Description Document BESAMPLE XLS Sample spreadsheet document 700100 WALNUT CABINET MNO002 700130 VARNISH MNO002 Item 1 0000 oz 4300 4300 700998 VARNISH BRUSHES MNO002 Item 2 0000 EA 2 6300 5 2600 700120 STAIN WALNUT MNO002 Item 1 0000 oz 5200 5200 700999 OIL RAGS MNO002 Item 5 0000 EA 0800 4000 700110 UNSTAINED CABINET MNO002 Sub 1 0000 EA 0000 0000 Total Assembly Component Cost 6 6100 Documents File Name Description Document BKSAMPLE DOC Sample word processing document Documents File Name Description Document BESAMPLE XLS Sample spreadsheet document Bills of Materials Kitting User s Manual 7 7 Tables List The Tables List provides information about the table you select It is helpful when you plan to change a table and want a list to compare it against Sample List 08 22 2005 Builders Supply 12 57 PM Tables List Bills of Materials Kitting Table ID BEGL Description Bill of Mater
7. 2 76 4 82 5 58 BUILD NUMBER 8 TOTAL 438 76 PERIOD 7 TOTAL 438 76 438 76 Bills of Materials Kitting User s Manual Reports Print a Report Where Used Report Available Components Report Component Cost Report Bill of Materials History Report Bills of Materials Kitting User s Manual 5 3 5 5 5 7 5 9 5 11 5 1 Print a Report All reports are produced in the same way Use the instructions below to print a report modifying the procedure as necessary for the report you want to print For example if the screen for the report you want to print does not contain check box options ignore that step and continue to the next Follow these steps to print a report 1 Select the report you want to print from the Reports menu The selection screen for that list appears The Where Used Report screen is shown below as an example Where Used Report E ES Commands Edit Modes Other Help xelaelmal elee Location ID From CA0001 Include Thru Txo001 Assemblies Assembly ID From 700 Kits Thru 700110 Costs Kit ID From 200 Thru 200 Component ID From Thru KS KS ES Include Status Active Superseded Discontinued Print Obsolete Single Level Fully indented QUE Print tem Quantities in a BOMAKit Company H 08 22 2005 Terminal T000 OVR Inquiry 2 Select the range of values to print on the report in the list boxes Bills of Materials Kittin
8. System Messages table ID Table not found This table is not on file probably because it was deleted Try to reconstruct the table A BOM Kit cannot contain itself A BOM or a kit cannot carry its own ID as part of its definition Already sold You cannot commit an item assembly or kit that has already been sold Amount entered causes assembly cost to be too large A cost cannot be larger than 999 999 9999 The amount you entered pushes the cost over this amount Build abandoned after record in use message If you try to build an assembly that involves an item someone else is using the Record in Use message appears and the building operation stops Build cancelled Assembly contains no components You cannot build an assembly that does not have any components One reason the assembly does not have components might be that the components items IDs were deleted from Inventory since the assembly was defined in the BOM Build cancelled Assembly assembly ID not on file You cannot build an assembly that is not on file One reason it is not on file might be that the assembly item ID was deleted from Inventory since it was defined in the BOM Build cancelled Fractional quantities found for serialized items You cannot build an assembly that has a fractional quantity for at least one serialized item A 2 Bills of Materials Kitting User s Manual System Messages Build cancelled The maximum of number l
9. for example a version number or a revision number 6 24 Bills of Materials Kitting User s Manual File Maintenance Tables BKGLxxx Table The BKGLxxx table holds three general ledger accounts whose labels you can define and numbers you can specify when you use the Bill of Materials function The values you enter in the fields with these labels are sent to these general ledger accounts Enter the table ID BKGLxxx xxx is the company ID The description of fields 4 6 should be the same as user defined fields 4 6 in the TRMBK table Enter the general ledger account number you want the values from fields 4 6 to be sent Bills of Materials Kitting User s Manual 6 25 Purge Bill of Materials History Use the Purge Bill of Materials History function on the File Maintenance menu to delete records of assemblies from the BKHIxxx History file Use it when you want to free disk space Before you use this function produce the Bill of Materials History Report You cannot recover historical data after you purge it Select Purge Bill of Materials History from the File Maintenance menu The Purge Bill of Material History screen appears Purge Bill of Materials History de Commands Edit Modes Other Help wa Have You Backed Up the System Delete History tems Dated Before 1273172004 Es Company H 0812212005 Terminal T000 OVR 1 If you have backed up the information you want to purge select the check b
10. make sure that no one else is using the Bills of Materials Kitting system You cannot post if someone else is using the Bills of Materials Kitting files e Print the Build Assembly Journal e Back up all the data files 3 12 Bills of Materials Kitting User s Manual Daily Work Assembly Inquiry 4 3 Build Assembly 4 5 Undo Build 4 11 Build Assembly Journal 4 13 Post Transactions 4 15 Bills of Materials Kitting User s Manual 4 1 4 2 Daily Work Introduction This chapter explains the features and uses of the screens and processes in the Bills of Materials Kitting application Bills of Materials Kitting User s Manual Assembly Inquiry Use the Assembly Inquiry function on the Daily Work menu to inquire about assemblies that your business produces Select Assembly Inquiry from the Daily Work menu The Assembly Inquiry screen appears Assembly Inquiry Commands Edt Modes Other Scroll Commands Information entory Lookups Location ID moooi 9 MINNEAPOLIS WAREHOUSE Assembly ID 700 19 Cabinets Current Quantity 30 0000 Quantity to Build L 5 0000 Max Available to Build Item ID Description i Avail Oty 700100 MNDOO2 WALNUT CABINET 700130 Mnooo2 K 632 0000 VARNISH 700998 MNO002 10 0000 36 0000 VARNISH BRUSHES 700120 MINODOZ 5 0000 682 0000 STAIN WALNUT 700999 MNOO02 25 0000 15694 0000 OIL RAGS 700110 MNO002 5 0000 85 0000 UNSTAINED CABINET
11. 5 before you install 2 3 converting to version 7 0 2 6 installation 2 3 installing new version before converting 2 5 interface with General Ledger 3 11 interfaces 1 8 3 3 IX 1 Index options and interfaces 3 3 options for setting up 3 4 setup considerations 2 5 system requirements 2 3 BKGLxxx table description 3 6 6 25 setting up 3 6 Browse 1 20 Build Assembly Append Lotted Serial Number window 4 9 function 4 5 Build Assembly Journal function 4 13 sample 4 14 when to print 3 12 Build window 6 12 builds posting 3 4 C Codes access codes changing 1 10 commands access code 1 10 backing up 3 7 flags 1 25 hot keys 1 25 Proceed OK 1 4 companies access codes 3 7 backing up data files 3 7 Component Cost Report function 5 9 sample 5 9 Components as items 3 10 as subassemblies 3 10 decreasing 1 6 function 6 17 option to post 3 5 returning to inventory 4 11 updating in several assemblies 6 17 conversion before converting 2 5 setup considerations 2 5 IX 2 converting to OSAS version 7 0 2 6 D Daily Work adding assemblies 3 10 adding kits 3 9 deleting assemblies 3 10 deleting kits 3 9 menu description 1 7 data preparing 3 6 data dictionaries 2 3 Data File Conversion function 2 5 2 6 Data File Creation function 2 3 date fields 1 19 E Edit Item window 6 5 Existing Lot Serial Number Entry window 4 8 6 14 F F2
12. Company H Level Inventory ID 1 200100 0 200 1 200100 0 200 1 200100 0 200 1 200100 0 200 1 200200 0 200 1 200200 0 200 1 200200 0 200 1 200200 0 200 1 200300 0 200 1 200300 0 200 1 200300 0 200 1 200300 0 200 1 200400 0 200 1 200400 0 200 1 200400 0 200 1 200400 0 200 1 200500 0 200 Description Furnace Heating Cooling Furnace Heating Cooling Furnace Heating Cooling Furnace Heating Cooling Water Heater Heating Cooling Water Heater Heating Cooling Water Heater Heating Cooling Water Heater Heating Cooling Air Conditioner Heating Cooling Air Conditioner Heating Cooling Air Conditioner Heating Cooling Air Conditioner Heating Cooling Water Softener Heating Cooling Water Softener Heating Cooling Water Softener Heating Cooling Water Softener Heating Cooling Sump Pump Heating Cooling Package Package Package Package Package Package Package Package Package Package Package Package Package Package Package Package Package Builders Supply Where Used Report Single Level Costed Status Type Loc ID ee de de de de de de de dee de dee de de de de ie be caoool caoool mpoool mpoool MNOOOL MNOOOL TXOOOL TXOOOL caoool caoool mpoool mpoool MNOOOL MNOOOL TXOOOL TXOOOL caoool caoool mpoool mpoool MNOOOL MNOOOL TXOOOL TXOOOL caoool caoool mpoool MDoool MNOOOL MNOOOL TX0001 TX0001 caoool caoool Quantity 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000
13. Inquiry button 1 20 flag 1 25 F6 Maintenance flag 1 25 icon 1 20 File Maintenance menu description 1 7 files descriptions B 1 flags in text mode 1 25 G General Ledger interface with Bill of Materials Kitting 3 3 3 11 General Ledger table description 3 6 setting up 3 6 graphical mode drop down menus 1 17 function screens 1 16 Bills of Materials Kitting User s Manual Index graphical main menu 1 14 Inquiry button 1 20 Maintenance icon 1 20 MDI menu 1 15 shortcut menu 1 17 toolbars 1 19 H hot keys 1 25 l Inquiry F2 button 1 20 flag 1 25 Install Applications function 2 3 2 5 installation options and interfaces 3 3 setting up kits and BOMs 3 6 installing Bill of Materials Kitting 2 3 interfaces 3 3 Accounts Receivable 3 3 General Ledger 3 3 Inventory 3 3 Sales Order 3 3 interfaces with Bill of Materials Kitting 1 8 Inventory interfaces 3 3 item IDs source for BOMs 1 6 source for kits 1 6 items distinguished from kits 1 6 identified as assemblies 1 6 option to keep history 3 5 replacing discontinued 6 17 tracking 1 7 Kits adding 3 9 components 1 5 definition 1 5 deleting 3 9 Bills of Materials Kitting User s Manual distinguished from items 1 6 function 6 3 recalculating cost 6 21 selling 1 5 1 6 3 3 3 9 6 3 when to set up 3 6 Kits List function 7 5 sample 7 5 L launching OSAS in other operating systems 1 9 OSAS i
14. Maintenance menu to back up files You must back up all the files in the data path for a particular list of companies at once to ensure that you have up to date copies of the system files Do not try to use operating system commands to back up only a few files that have changed 1f you do your system may not work after you restore them The Backup function backs up all the data files for a specified company in a data path at one time Bills of Materials Kitting User s Manual 3 7 Work Flow Your work flow is divided into daily and periodic tasks After the kits and bills of materials are established you can use the File Maintenance functions to update information about kits or assemblies substitute components among several kits and assemblies and remove unnecessary data from history Daily Tasks You can use the functions on the Daily Work menu only if you have established bills of materials Adding Kits To add akit you must use an ID of an existing inventory item that has been marked as a kit in Inventory provided that it is not already a bill of materials The reason is that when you sell the kit Sales Order gets kit information from Inventory files Sales Order cannot recognize it except as an inventory item The best way to add a kit is to use the Items function in Inventory When you use the Items function you know that the inventory item has been established to be used as a kit Sales Order recognizes the inventory
15. Order the constituent parts of the kit are automatically taken into account If Sales Order interfaces with Bills of Materials Kitting and General Ledger kit information is sent to the GLJRxxx file when you post Bills of Materials Kitting User s Manual 3 3 Setting Up Bills of Materials Kitting Set Up and Work Flow 3 4 If Bills of Materials Kitting interfaces with General Ledger information about builds is sent to the GLJRxxx file through the BKJRxxx Transaction Journal file If Bills of Materials Kitting does not interface with General Ledger no information is sent to the GLURxxx file when you post Options To begin setting up each company s options and interfaces use the Resource Manager Options and Interfaces function see the Resource Manager User s Manual BK is the application ID This screen appears Bills of Materials Kitting Options Commands Edit Modes Other Scroll Commands Help Ee O 2x jan lmn le 0loeo x mm Description Interface to General Ledger Post Detailto General Ledger Allow Negative Builds Prompt on Negative Quantities During Build Keep Detail History Use Additional Descriptions From Inventory Display unit extended cost on HLE s Write Issue Information into Inventory Detail History Option 001 of 008 Enter Toggle Company H 08 22 2005 Terminal TODO OVR Your answers to the following questions determine how
16. Tab to move from field to field Use the scroll buttons to move from line to line in scrolling regions e Ifa screen appears prompting for the kind of information to enter or maintain such as on File Maintenance or Transactions screens select the appropriate option and click OK to continue e Press Page Down if prompted to move to the next section e Click Header when it appears to return to the screen s header section e Press F7 to exit the screen and return to the main menu 1 16 Bills of Materials Kitting User s Navigating OSAS Introduction Menus Shortcut Menu Other Commands Menu Both the graphical main menu and graphical function screens contain drop down menus that give you access to additional commands without using the function keys While you can use the function keys to access commands in graphical mode you may find it easier to access command through these menus To access a menu s commands click a menu title The commands for that menu appear followed by any associated hot key combinations in brackets lt gt To use a command click the command name or press the hot key combination Refer to the Resource Manager guide for more information on the menus available in OSAS and their commands OSAS gives you quick access to commands relating to the screen you re using via a shortcut menu The commands that are available depend on the function and the field you are currently using To use these comma
17. as a backup before you purge information and as a safeguard against circumstances that might harm your data Posting Transactions If Bills of Materials Kitting interfaces with General Ledger entries and transactions associated with a general ledger account are transferred from the BKJRxxx Transaction Journal file to the GLJRxxx Journal file for accurate tracking of the individual inventory general ledger accounts and the user defined accounts in the BKJRxxx file Each component s inventory account is credited for the cost amount and each user defined account The assembly s inventory account is debited for the sum of the components costs and the user defined amounts Bills of Materials Kitting User s Manual 3 11 Work Flow Set Up and Work Flow If detail is to be posted information about each component in the BKJRxxx file is sent to the GLJRxxx file If only summary information is to be posted information in the BKJRxxx file is accumulated for each general ledger account and the sum total is transferred to the GLJRxxx file Assembly Component User Defined 4 User Defined 5 User Defined 6 Inventory Inventory Account Account Account Account Account CR CR a CR CR If General Ledger does not interface no information is sent to the GLJRxxx file but the posting log is still produced to show what would have been posted Before you post complete these tasks e Ifyou have a multiuser system
18. assemble yourself To produce a list of the information entered in this function use the Bill of Materials List function on the Master File Lists menu Select Bill of Materials from the File Maintenance menu The Bill of Materials screen appears Bill of Materials Commands Modes Other Scroll Commands Help es q Location ID MIHHEAPOLIS WAREHOUSE Assembly ID 4 Cabinets Last Recalc Revision App Labor Drawing Overhead Version Process Approximate Costs Component 8 3200 Assembly 34 8700 Type Loc ID Component ID Qty Needed Units Sub MNODO2 700100 WALK CABIN 1 0000 EA MNOOOZ 700300 MNODOZ 700500 SERIES NUMBER MAD RA Component 001 of 003 Company H 08 22 2005 Terminal T000 OVR 1 Enter the ID of the location that stores the assembly 2 Enter the ID of the assembly you want to add or change The date of the last recalculation appears Bills of Materials Kitting User s Manual 6 9 Bill of Materials File Maintenance 3 Use the first three fields to enter alphanumeric information you set up in the Tables function Use the last three fields to enter numeric information you set up in the Tables function The cost of the components appears The total cost of the assembly including costs in the user defined fields type of component for the bill of materials location ID of the component component ID for the bill of materials description of the co
19. descriptions organized by menu These chapters mirror the order that appears on the Bills of Materials Kitting menu Bills of Materials Kitting User s Manual 1 3 Introduction Welcome to OSAS e The Appendixes contain supplimentary material not directly related to Bills of Materials Kitting functionality e The Index is a topical reference to the information in the rest of the chapters and concludes this guide Conventions This guide uses the following conventions to present information _ Inquiry When the Inquiry or Maintenance commands or both are available for a field Maint the Inquiry and Maint flags appear in the margin See page 1 20 and page 1 25 for more information on these commands When you see the phrase use the Proceed OK command in this guide press Page Down in either text or graphical mode to continue In graphical mode you can also click OK to proceed 1 4 Bills of Materials Kitting User s The Bills of Materials Kitting System Use Bills of Materials Kitting to account for assemblies that you manufacture bills of materials or take from inventory and sell kits The assemblies can be created from raw materials other assemblies or a combination of raw materials and assemblies For example a computer reseller sells a computer system as a single unit made up of a monitor a keyboard a CPU a printer and a printer stand The reseller buys the monitor the keyboard the CPU and the printer fro
20. e Press H to edit the fields in the header e Press O to send the information to an output device Then select the output device to print the breakdown of necessary components 6 Use the Exit F7 command to exit to the Daily Work menu 4 4 Bills of Materials Kitting User s Manual Build Assembly Use the Build Assembly function on the Daily Work menu to track the assembly of one bill of materials or many of the same assembly You can also build an established serialized or non serialized assembly Select Build Assembly from the Daily Work menu The Build Assembly screen appears Build Assembly a Commands Edit Modes Other Information Help gt xelselma e ee Location ID mnooo 3 MIHHEAPOLIS MANUFACTURING Assembly ID 7001 00 Walnut Cabinet Build Number 000010 Maximum Available to Build 18 0000 Quantity to Build 10 0000 Build Date 08 22 2005 Fs GL Period 8 Inquire About Assembly Company H 08 22 2005 Terminal TODO ovr 1 Enter the ID of the location that will hold the assembly you want to build 2 Enter the ID of the assembly you want to build 3 The Do you want to calculate the maximum available prompt appears when you enter the assembly ID If you want the system to calculate the maximum number of assemblies you can build from inventory select Yes or enter Y in text mode if not select No or enter N in text mode Bills of Materials Kitting User s Manual 4 5 Build As
21. is not in the specified location Perhaps a user used the Location Transfers function in Inventory to move the component item to a different location since you defined the component as part of the assembly Kit ID is not on file You must enter the ID of an existing kit To define a kit use the Kits function A kit cannot contain itself You cannot include a kit as part of the definition of itself Location location ID is not on file The location ID you entered is not on file Enter an ID that is on file in Inventory Material List list Loc ID location ID not found The specified list of materials is not in the specified location Perhaps a user used the Location Transfers function in Inventory to move the component item to a different location since you defined the component as part of the assembly in Bills of Materials Kitting Maximum number of lines reached Maximum number of lines reached Cannot insert You can assign only 999 items to a kit or an assembly Must enter or K or J The type of item you enter must be specified as either an item a kit or a job Depending on which applications are interfaced not all these choices may be available A 6 Bills of Materials Kitting User s Manual System Messages Negative quantities discovered Press Enter to back out build The Allow Negative Builds option is set to NO in the Options and Interfaces function in Resource Manager Press Enter to abort If you want
22. most effectively Sample List 08 22 2005 12 56 PM Inventory ID Description Heating Cooling Package Furnace Water Heater Air Conditioner Water Softener Sump Pump Humidifier 200100 200200 200300 200400 200500 200600 File Name Document BRSAMPLE DOC File Name Document BRSAMPLE XLS 200 Heating Cooling Package 200100 Furnace 200200 Water Heater 200300 Air Conditioner 200400 Water Softener 200500 Sump Pump 200600 Hunidifier File Name Document BRSAMPLE XLS File Name Document BKSAMPLE DOC Builders Supply Kits List by Location ID Costed caoool caoool caoool caoool caoool caoool caoool Documents Documents Documents Bills of Materials Kitting User s Manual Quantity i E BE 1 1 1 a i q i 1 1 Estimated Unit Cost 0000 EA 227 5300 0000 EA 429 9500 0000 EA 127 4000 0000 EA 47 5000 0000 EA 75 1500 Total Kit Component Cost Description Sample word processing document Description Sample spreadsheet document 0000 EA 4400 0000 EA 5300 0000 EA 9500 0000 EA 4000 0000 EA 47 5000 0000 EA 75 1500 Total Kit Component Cost Description Sample spreadsheet document Description Sample word processing document 7 5 Bill of Materials List The Bill of Materials List shows the components that are in each assembly and the cost of each component and assembly Sample List 08 22 2005 Builders Supply Page 1
23. one to three character company ID To set up a terminal specific table enter the table ID plus the four character terminal ID Bills of Materials Kitting User s Manual 6 23 Tables File Maintenance Inquiry 2 The Copy From field appears if you entered a new table ID To copy a company specific or a terminal specific table enter the table ID plus the company and terminal ID 3 Enter or change the description of the table The number and length of columns in the table appears 4 The type of characters you can enter in the table appears e A Alphanumeric N Numeric with two decimals e 3 Numeric with three decimals e 4 Numeric with four decimals Although you can change the type you cannot enter any other type of character than the table originally specified 5 To save your entries and exit to the File Maintenance menu use the Proceed OK command TRMBK Table The TRMBK table holds six fields that appear on other function screens The first three fields are alphanumeric and appear on the Bill of Materials screen and the Kits screen their values are for reference only and are not used in any calculations The last three fields are numeric and appear on the Bill of Materials screen their values are included in the cost of each assembly built Enter the table ID TRMBK Then enter a label for each field The first three fields hold miscellaneous information you might want to associate with an assembly or a kit
24. terminate the build clear the box or enter N in text mode Use the Proceed OK command to continue with the build When the build is complete enter another assembly ID to build or use the Exit F7 command to return to the Bills of Material screen Bills of Materials Kitting User s Manual 6 13 Bill of Materials File Maintenance New Existing Lot Serial Number Entry If the assembly contains lotted items the Existing Lot Number Entry screen appears after you enter build information on the Build Assembly screen If the assembly contains serialized items the Existing Serial Number Entry screen appears If the assembly contains lotted and serialized items the Existing Lot Serial Number Entry screen shown below apppears Use this screen to enter lot serial or lot and serial numbers for components Existing Lot Serial Number Entry Commands Modes Other Scroll Commands Help 2xts malaal 7e ee Item ID 700500 Loc ID MH0002 Units EA Series Number MINNEAPOLIS MANUFACTURING Requested Gty 4 0000 Serial Number Unit Cost 7000 I 2 2500 81000 2 2500 31000 2 2500 Serial Number 001 of 004 9 0000 Enter edit Append Done Information about the item such as location ID unit number and unit cost appear Select a command Move to the line you want to edit and press Enter Then see Append Edit Lotted Serial Number on page 6 15 for more information Press A t
25. the Resource Manager Defaults function Bills of Materials Kitting User s Navigating OSAS Introduction Text Mode The OSAS text mode is available on all operating systems If you use OSAS on an operating system that does not have graphical capabilities the text mode is the only mode available In text mode all screens are presented in an easy to use textual interface that you navigate through using keyboard commands Main Menu The text main menu is shown below amp OSAS T000 Settings Edit Print Help 0670172005 Company H Builders Supply 12 27 PE Main Menu General Ledger OPEN SYSTEMS R Accounting Software When you select an application the application s menu is superimposed over the main menu Selecting an entry on an application menu opens a function screen or a submenu Bills of Materials Kitting User s Manual 1 21 Introduction Navigating OSAS You can move around the text main menu in these ways e Use the arrow keys to move the cursor up and down to highlight the application you want Then press Enter to select it e Press the first letter of the application you want to move the cursor to the first application beginning with that letter Continue to press the letter key or the down arrow until the application you want is highlighted then press Enter to select it e Use the mouse to click an application to view that application s menu e To move to the first application on the menu
26. the item 6 When you finish entering lot and serial information use the Proceed OK command Bills of Materials Kitting User s Manual 6 15 Bill of Materials File Maintenance Documents Use the Documents dialog box to add or change documents attached to a master file record in OSAS See Documents on page 6 6 for more information Note You must set up file types in Resource Manager before you can attach documents See the Resource Manager User s Manual for more information Press D to return to the Bill of Materials screen 6 16 Bills of Materials Kitting User s Manual Components Use the Components function on the File Maintenance menu to update the components used in several different assemblies at once This function is useful if an item is discontinued and you need to replace it with a different item or a different quantity of items You cannot use this function for location transfers You can produce a verification log of all the bills of materials that have been added replaced or deleted Select Components from the File Maintenance menu The Components screen appears 4 Components B m x Commands Edit Modes Other ps Help we Action Update Add Component Assemblies O Replace Component O Kits Delete Component O Both Loc ID Component ID MNOOO2 700111 Cabinet Assembly Pick Locetion ID From caooo A Print Log Thru Tx0001 Roll Up Costs Assembly ID From 700 Update Sta
27. the system works and how information flows through it 1 Toggle to YES to interface Bills of Materials Kitting with General Ledger When you interface Bills of Materials Kitting with General Ledger the BKJRxxx Transaction Journal file sends information about an assembly to the GLJRxxx Journal file when you post Bills of Materials Kitting User s Manual Set Up and Work Flow Setting Up Bills of Materials Kitting 2 Toggle to YES if you want information about each component that makes up the assembly to be posted Toggle to NO if you want information about the assembly to be posted as one unit 3 Ifyou track the building of an assembly and one of its component s quantities falls into the negative range you have a negative build Toggle to YES if you want to allow a negative build or track the assembly of a bill of materials before you get the parts for it otherwise toggle to NO You might want to select YES if you usually sell items before you build them 4 Toggle to YES if you indicated that you allow negative builds and you want the system to warn you when you try to build an assembly that uses an item with a quantity of zero Toggle to NO if you want the system to proceed tracking such a build without warning you first 5 Toggle to YES if you want to keep history about each item in each kit otherwise toggle to NO You must select YES if you want the Detail History Report in Sales Order to take kits into account 6 To
28. 0 Total Total 0000 0000 0000 0000 0000 Total 0000 0000 0000 0000 0000 0000 Total Total 57 12 Component Cost Ext 0600 40 0800 0000 48 4300 6300 5200 0800 0000 6 4700 57 5000 4300 12 4100 10 0400 1100 93 Builders Supply Component Cost Report By Location ID 2900 Overhead 8200 Process 3400 Page Ext Tot 1 Bills of Materials Kitting User s Manual 5 9 Bill of Materials History Report The Bill of Materials History Report shows the date assemblies were built how many were built the unit cost of each and the user defined cost of each on that date This report is helpful when you plan a marketing strategy and want to see when assemblies are in peak demand Sample Report 08 22 2005 1 54 PM Inventory ID Description Build Number CABINETS 000004 700 CABINETS 000005 700 CABINETS 000006 700 CABINETS 000007 700 CABINETS 000008 Builders Supply Bill of Materials History Report by Location ID Loc ID Revision App Labor Drawing Overhead Build Date Version Quantity i i Process Extended 20 0000 XI 701 07 27 2004 545 701 MNOOOL T6 XI 701 07 27 2004 545 701 MNOOOL T6 XI 701 11 27 2004 545 701 MNOOOL T6 XI 701 05 27 2005 545 701 MNOOOL T6 XI 701 07 07 2005 545 701 LOCATION TOTAL Bills of Materials Kitting User s Manual 5 11 File Maintenance Kits Bi
29. 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 1 0000 Unit Cost 379 4400 379 4400 379 4400 379 4400 379 4400 379 4400 379 4400 379 4400 227 5300 227 5300 227 5300 227 5300 227 5300 227 5300 227 5300 227 5300 429 9500 429 9500 429 9500 429 9500 429 9500 429 9500 429 9500 429 9500 127 4000 127 4000 127 4000 127 4000 127 4000 127 4000 127 4000 127 4000 47 5000 47 5000 Page 1 Ext Cost 379 4400 379 4400 379 4400 379 4400 379 4400 379 4400 379 4400 379 4400 227 5300 227 5300 227 5300 227 5300 227 5300 227 5300 227 5300 227 5300 429 9500 429 9500 429 9500 429 9500 429 9500 429 9500 429 9500 429 9500 127 4000 127 4000 127 4000 127 4000 127 4000 127 4000 127 4000 127 4000 47 5000 47 5000 Bills of Materials Kitting User s Manual 5 5 Available Components Report Use the Available Components Report to determine the maximum quantity of an assembly that you can build with the inventory on hand You can also check the available quantity of each assembly and each component Sample Report 08 22 2005 1 53 PM Company H Level Inventory Description Cabinets 1 700100 WALNUT CABINET 1 700300 HANDLES 1 700500 SERIES NUMBER 0 700100 WALNUT CABINET 1 700130 VARNISH 1 700998 VARNISH BRUSHES 1 700120 STA
30. D You must enter an item ID for a component to add it to an assembly Enter or change the component or subassembly ID The description appears 05 4 Enter or change the quantity of the item the assembly requires The quantity must be greater than zero 5 Enter or change the unit of measure the item requires The item s approximate unit cost and extended cost defaults in from the Items function in Inventory 6 To continue with building the assembly use the Proceed OK command or use the Exit F7 command to exit to the Bill of Materials screen 7 After the assembly is built the File Maintenance menu appears To exit from the Bill of Materials function without building use the Exit F7 command Bills of Materials Kitting User s Manual 6 11 Bill of Materials File Maintenance Build Before the Build dialog box appears the Do you want to calculate the maximum available prompt appears when you enter the assembly ID If you want the system to calculate the maximum number of assemblies you can build from inventory select Yes or enter Y in text mode if not select No or enter N in text mode Build amp Build Number 000009 Quantity to Build 5 0000 Maximum Available to Build 5 0000 Build Date 0872272005 3 GL Period 3 Inquire About Assembly O Use the build dialog box to track an assembly 1 Enter or change the build number and the number of assemblies you want to buil
31. IN WALNUT 1 700999 OIL RAGS 1 700110 UNSTAINED CABINET 0 700110 UNSTAINED CABINET 1 700111 CABINET ASSEMBLY 1 700113 CUTTING BOARD 1 700115 DRAWER ASSEMBLY 1 700117 CABINET DOOR 1 700200 HINGES 1 700400 WOOD SCREWS End of Report Builders Supply Available Components Report by Location ID Unit Quantity Available Qty 30 0000 5 0000 MAXIMUM AVAILABLE TO BUILD 0000 0000 0000 0000 0000 0000 2 1 2 1 5 1 MAXIMUM AVAILABLE TO BUILD 0000 0000 0000 0000 3 0000 0000 15 0000 0000 4 0000 0000 91 0000 0000 4961 0000 MAXIMUM AVAILABLE TO BUILD Bills of Materials Kitting User s Manual 5 7 Component Cost Report The Component Cost Report is a list of assemblies in particular locations It shows the level 1 components of those assemblies and every cost including the user defined costs associated with each component and assembly This report is helpful when you plan a budget and want to see how to allocate components most effectively Sample Report 08 22 2005 1 54 PM Company H Assembly Component ID 700 700100 700300 700500 700100 700130 700998 700120 700999 700110 700110 700111 700113 700115 700117 700200 700400 End of Report MNO002 MNO002 MNO002 MNO002 MNO002 MNO002 MNoooz MNoooz MNO002 MNO002 MNO002 MNO002 MNO002 Assenbly Location Earn Assembly OANHHHR 2 Assembly Location Total 0000 0000 000
32. OPEN SYSTEMS Accounting Software Bills of Materials Kitting User s Manual PN 2210 BK70 2005 Open Systems Holdings Corp All rights reserved Document Number 2210 BK70 No part of this manual may be reproduced by any means without the written permission of Open Systems Inc OPEN SYSTEMS is a registered trademark and OSAS Resource Manager Resource Manager for Windows and Report Writer are trademarks of Open Systems Holdings Corp BB is a trademark and PRO S and Visual PRO S are registered trademarks of BASIS International Ltd Novell and NetWare are registered trademarks of Novell Inc Microsoft Windows Windows 95 Windows NT Windows 2000 and MS DOS are either trademarks or registered trademarks of Microsoft Corporation Adobe and Acrobat are registered trademarks of Adobe Systems Inc TrueType is a registered trademark of Apple Computer Inc Open Systems Accounting Software for UNIX uses PKZIP utilities from PKWARE Inc 648 N Plankinton Ave Suite 220 Milwaukee WI 53203 Phone 414 289 9788 Internet www pkware com Printed in U S A This manual is recyclable November 2005 Release 7 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 repre
33. appears Append Documents Commands Edit Modes Other Help RX te Document WholeSaleList xls Path L Samples Description spreadsheet listing materials available wholesale Enter the document file name and extension the full file path and a description of the file you want to attach to the master file record You can use the DocumentShare directory as specified in the Resource Manager Directories function to simplify entering document information To use this directory make sure all users have access to the DocumentShare directory then store document attachments in that directory When you enter document information in the Append Documents screen enter DOC in the Path field remember to include the parenthesis When you use this convention with the Open command to open an attachment OSAS automatically replaces the DOC variable with the appropriate path and opens the attachment from that directory If you do not store the file in the DocumentShare directory do not use the DOC variable Instead enter the full file path in the Path field OSAS will not be able to locate the file to open it if you enter an incorrect path Use the Proceed OK command to attach the file Bills of Materials Kitting User s Manual 6 7 Kits File Maintenance Edit Attached Document File Information To edit file information about attached documents select the document and then press Enter Edit the file information in th
34. ars As with menus graphical screens also contain toolbars that give you fast access to the most frequently used OSAS commands The toolbar for the main menu differs slightly from that of function screens Main Menu The toolbar for the main menu is shown below Click a button to access that Toolbar command Access Command Calendar Toggle Code Help Favorites 2 60 aa e a Application Calculator Call a BBj Pro5 Date Versions Program Function The toolbar for function screens is shown below Click a button to access that Screen command Toolbar File Start Paste Calendar Online Maintenance Over Documentation 2x BR MMA de Delete Copy Calculator Field Address Help Mapping Date Fields If you use BBj in graphical mode click the Calendar button when it appears next to date fields to open a calendar so that you can select the date you want to enter into that field Bills of Materials Kitting User s Manual 1 19 Introduction 1 20 Navigating OSAS Browse sd If you use BBj in graphical mode you can use the Browse button when it appears next to fields to navigate to directories and files and automatically enter file paths into that field Click the Browse button to open the Select Directory File screen then navigate to the directory or file and click Open to automatically enter the file path in the field Inquiry The Inquiry command helps you look up and select valid entries for fields that are connected to
35. cal mode the text mode also includes menus that give you access to commands that open additional utilities show additional information about the task at hand or set up a custom menu that contains frequently used commands Refer to Appendix A in the Resource Manager guide for full details about the menus available in OSAS Other The Other Commands or F4 menu gives you access to additional utilities and Commands commands not directly related to the function you re currently using In text mode press F4 twice on the menu or once on function screens to access this menu See page 1 17 for more information on this menu Information The Information or Shift F2 menu gives you access to additional information Menu about a customer vendor item job bill of material or employee In text mode this menu is available when the Info flag appears at the bottom of a function screen The commands on the menu are available only as they are relevant to the task you are performing For example if you are entering a transaction in Accounts Receivable you can access comments or documents about items or customers but not about employees or vendors See page 1 18 for more information Favorites The Favorites menu allows you add the OSAS menus or functions you use most Menu frequently to a custom menu After you ve set up the menu select Change to Favorites from the graphical Favorites menu or press F2 to access the functions To add a function t
36. cannot change the record and can read it only when the other user is finished using the record Restoring item ID The items that were being assembled are restored when you enter NO in the Proceed with Build field for one of the assembly s items after giving the instruction to build the assembly or when the Negative Quantities Discovered message appears and you press Enter Serialized components must have integer quantities You must enter whole numbers for quantities of serialized items Serialized kits are not allowed Serialized items are not allowed in kits You cannot involve serialized items with kits either as kit IDs or as components of kits Serial number serial number found under item item ID You must assign a serial number to the item involved with the assembly or kit A user may have made this item serialized since the assembly or kit was defined Service items are not allowed in bills of material You cannot include a service item in a bill of materials A 8 Bills of Materials Kitting User s Manual System Messages Terminology table ID not found You cannot use a function which involves user defined fields from a TRMBKxxx table which does not exist The table may have been deleted from the system with the Delete F3 command on the table itself Thru value cannot be less than from value The Thru value must be greater than or equal to the From value A valid item location is required You must ente
37. ce 3 Enter or change the information in your user defined fields or blank out the boxes The approximate component assembly totals and the location ID for the components that make up the kit appear The ID for each component in the kit the description for the component the quantity of each component needed for the kit and the unit of measure for the component appear 4 Select acommand e Press Enter to edit a line item e Press A to append a line item e Press H to move the cursor to the header region e Press R to recalculate the approximate cost for the kit and update the Last Recalc field e Press G and then enter the line number to go to a particular line item This command appears only if there is more than one screen of line items e Press N to work with the next kit e Press Dto add or change documents attached to the kit record 5 To exit to the File Maintenance menu use the Exit F7 command 6 4 Bills of Materials Kitting User s Manual File Maintenance Kits Append Edit Item Use the Append Edit Item dialog box to add or change a component in a kit Edit Item amp Commands Edit Modes Other Inventory Lookups Help RX tz Type Location MNOOO MINNEAPOLIS WAREHOUSE tem ID 200100 Furnace Qty Needed 1 0000 Approx Unit Cost Units EA y Approx Ext Cost The type of inventory item appears 1 Enter or change the location ID The description of the location appears 2 Enter or
38. change the item ID The description of the item appears 3 Enter or change the item quantity the kit requires 4 Enter or change the unit of measure used in the kit The unit cost and extended cost of the item appear 5 To save your entries and return to the File Maintenance menu use the Proceed OK command Bills of Materials Kitting User s Manual 6 5 Kits File Maintenance Documents The Documents screen appears when you use the Documents command on the Kits screen Use this screen to add or change documents attached to a kit record Documents a E Commands Edit Modes Other Scroll Commands Help Kit ID 200 Heating Cooling Package Location ID MN0001 MINNEAPOLIS WAREHOUSE Document Name BKSAMPLE XLS BKSAMPLE DOC Line No 001 of 002 Company H 08 22 2005 Terminal TODO OVR Note You must set up file types in Resource Manager before you can attach documents See the Resource Manager User s Manual for more information Press D to return to the Kits screen Press G and then enter the document name to move directly to that document This command appears only if you have more than one screen of attached documents 6 6 Bills of Materials Kitting User s Manual File Maintenance Kits Attach a Document Do the following to attach a document to a master file record 1 Click Append or enter A to attach a document The Append Documents dialog box
39. ction in Inventory see the Inventory User s Manual Bills of Materials Kitting User s Manual A 3 System Messages Currently in use You cannot commit an item assembly or kit that is being used Detail history not selected in Options table You cannot work with detail history of an assembly or a kit unless the Keep Detail History option in the Resource Manager Options and Interfaces function is set to YES Fractional quantities not allowed for serialized items material items You must enter whole numbers for quantities of serialized items and material items GL account for user defined field does not exist You cannot build an assembly when the BKGLxxx table has a general ledger account label without an account number If you use General Ledger you must enter an account number If you do not use General Ledger go to the BKGLxxx table and either add a number to the label or remove the label without the number GL account table D not found You cannot use a function which involves General Ledger accounts from a BKGLxxx table which does not exist The table may have been deleted from the system with the Delete F3 command on the table itself Invalid unit of measure You must enter a valid unit of measure Valid options appear at the bottom of the screen A 4 Bills of Materials Kitting User s Manual System Messages Inventory item item ID Loc ID location ID not found The specified item is not
40. ctions a menu contains click the menu name The menu expands to list the functions it contains Click the function name to enter the function The function screen appears in the right pane e To exit from a menu click a different menu name or application tab To exit from OSAS click the Close box in the upper right corner of the screen press F7 or select Exit from the File menu Bills of Materials Kitting User s Manual 1 15 Introduction Navigating OSAS Function Screens Graphical screens contain the same functionality as text screens presented in a graphical format that includes easy access to commands via the mouse A Tax Locations Commands Edt Modes Other Scroll Commands Help Tax Location Name Tax Level H i Tax ID l o Authority N Tax on gt Misc Tax Liability Acct Tax Refundable Acct Class Description Sales Tax Purch Tax Tax Collected Tax Paid Consumer Goods Resale Sales 0 000 00 Exempt Sales 000 0 000 00 Ind Agr Prod 0 000 00 Interstate Comm 0 000 00 Motor Vehicles i 000 0 000 00 Food Products 0 000 00 Clothing 000 0 000 00 Gasoline 0 000 00 Services 000 0 000 00 Total 1307 00 Calculated 1307 01 Over Short 01 Enter edit Tax Loc First Last Nee Prev View Header Company H 08 02 2005 Terminal T000 OVR You can move around the screen in these ways e Use the mouse or press
41. d 2 If the system calculated the number available to build based on the components that make up the assembly that number appears If the system did not do the calculation zero appears 3 The system date appears If the assembly is done on a different date change the date 4 Enter or change the general ledger period for the date of build 5 If you want more information about the assembly before you build it select the check box or enter Y in text mode if not clear the box or enter N in text mode 6 To continue building the assembly use the Proceed OK command or use the Exit F7 command to exit to the Bill of Materials screen 6 12 Bills of Materials Kitting User s Manual File Maintenance Bill of Materials Negative Item Use the Negative Item dialog box to track a build that makes the involved item quantity a negative number 4 Negative Item a x te 201988 Quantity for Item 700500 Location MH0002 Will Become 4 0000 Proceed with Build The item ID and the location for the item appears The negative quantity created when you entered the quantity to build appears You cannot include serialized items in negative builds You must have enough serialized items on hand in order to build an assembly If not enough serialized items are on hand the system does not continue with the build To continue building the specified number of assemblies select the check box or enter Y in text mode To
42. deleted 3 10 deleting 3 10 T T accounts 3 12 Tables BKGLxxx table screen 6 25 function 6 23 General Ledger BKGLxxx 3 6 setting up 3 6 Terminology IRMBK 3 6 6 24 when to set up 3 6 Tables List function 7 9 sample 7 9 Terminology table description 3 6 setting up 3 6 text mode command line 1 26 commands 1 25 flags 1 25 function screens 1 23 main menu 1 21 messages 1 26 Bills of Materials Kitting User s Manual toolbars 1 19 function screens 1 19 main menu 1 19 transactions posting 3 11 TRMBK table description 3 6 6 24 setting up 3 6 U Undo Build function 4 11 Ww Where Used Report function 5 5 sample 5 5 workstation date 1 11 IX 5
43. e Data File Creation function on the Company Setup menu in Resource Manager see the Resource Manager User s Manual For instructions on converting your files see the Conversion section later in this chapter Bills of Materials Kitting 2 3 Installation Installation and Conversion You must install and set up Inventory before you set up Bills of Materials Kitting If you plan to use General Ledger or Sales Order with Bills of Materials Kitting you must install and set up those applications before you set up Bills of Materials Kitting 2 4 Bills of Materials Kitting Conversion If you use an earlier version of OSAS Bills of Materials Kitting you can convert your files from the older version to the current version When you are ready to convert files use the Data File Conversion function on the Company Setup menu in Resource Manager see the Resource Manager User s Guide to upgrade Bills of Materials Kitting data files You can upgrade from version 4 xx 5 xx Or XX If you are converting from version 6 5x to 7 0 no conversion is necessary You should still use the Data File Conversion function to copy data files from the old data directory to the new directory however Note You must install the new version of Bank Reconciliation before you convert files You can replace and update the programs properly only by using the Install Applications function in Resource Manager Before you convert an application s
44. e Edit Documents dialog box then click OK or press F7 to save your changes To view the file information about attached documents select the document and then press View or V in text mode The View Documents dialog box appears Press any key to exit To edit the document itself click Open document or press O to launch the appropriate application and open the file Note If you have problems opening a document press Enter to change the direction of the slashes used in the attachment s directory path If the directory path contains back ward slashes change them to forward slashes and vice versa Delete Attached Documents To remove a document attachment select the attached document you wish to delete and press F3 When the confirmation message appears press Y to delete the attachment or N to return to the Documents screen Keep in mind that this procedure only removes the attachment from the master file record it does not delete the file from its storage location After you finish working with the Documents screen use the Exit F7 command to return to the Kits selection screen Enter another Kit ID or use the Exit F7 command again to return to the File Maintenance menu 6 8 Bills of Materials Kitting User s Manual Bill of Materials Use the Bill of Materials function on the File Maintenance menu to establish and update information about assemblies This function is useful if you often sell items that you
45. ect the destination directory where your new data files will reside 2 Enter the path drive and directory that has the files you want to convert You cannot enter the same path as the path you selected as the destination 3 Ifyou want source files to be erased after conversion select the check box or enter Y in text mode if not clear the box or enter N in text mode 4 If you want the conversion process to pause if a problem occurs select the box or enter Y in text mode if not clear the box or enter N in text mode The system considers file corruption or evidence of data not converting correctly a problem 2 6 Bills of Materials Kitting Installation and Conversion Conversion 5 Enter BK in the Appl column Bills of Materials Kitting appears 6 Enter your earlier version number of Bills of Materials Kitting and press Enter You can determine the version by looking at the copyrights screen when you start OSAS or in most versions by using the Application Information tool button on the menu screen in graphical mode or by pressing Shift F2 in text mode 7 If data files already exist for Bills of Materials Kitting in the intended destination path the BK data files exist Do you want this task to erase them prompt appears If you want to erase the existing files and convert the files from the version in the source path select Yes or enter Y in text mode if not select No or enter N in text mode If you elect no
46. em 3 Enter an additional comment about the item if necessary 4 To save your entries and continue building the assembly use the Proceed OK command Bills of Materials Kitting User s Manual 4 9 Undo Build Use the Undo Build function on the Daily Work menu to back out unposted bills of materials and return component parts to inventory Select Undo Build from the Daily Work menu The Undo Build screen appears Undo Build a m Commands Edit Modes Other Information Help ee Build Number 000009 y Location ID MN0001 MINNEAPOLIS Assembly ID 700 Cabinets Quantity Built Date of Build 08 22 2005 Company H 08 22 2005 Terminal T000 OVR Inquiry 1 Enter the number of the build you want to undo The location ID and description and the assembly ID and description appear The quantity built and the date of the build appear 2 Select the output device to print the Undo Build Error Log See Reports on page 1 27 for more information After the list is produced the Daily Work menu appears 3 To undo the build and return to the Daily Work menu use the Proceed OK command Bills of Materials Kitting User s Manual 4 11 Undo Build Daily Work Undo Build Error Log 08 22 2005 Builders Supply 1 44 PM Undo Build Error Log Company H Undo Build 000009 was successful End of Report 4 12 Bills of Materials Kitting User s Manual Build Assembly Journal Use the Build Assembly Jo
47. evels has been reached You have too many levels of assemblies or kits You cannot track more than 10 levels Build request is above maximum available When you send instructions to build more assemblies than your inventory is capable of supporting you can proceed only ifthe Allow Negative Builds option is setto YES in the Options and Interfaces function in Resource Manager see the Resource Manager User s Manual the code is BK Cannot delete last component of a Assembly Kit Cannot delete last line of a Assembly Kit You cannot delete the last line of an assembly or a kit if you could you would delete the assembly or kit Changing line type to KIT will clear all values The values in the line item entry area disappear when you enter the letter K to declare the item as a kit Component already exists for this Assembly Kit You cannot assign the same component to an assembly or a kit more than once Component item ID in location location ID not on file The specified component is not in the specified location Perhaps a user used the Location Transfers function in Inventory to move the component item to a different location since you defined the component as part of the assembly in Bills of Materials Kitting Cost update aborted You cannot update cost information about a kit or an assembly which involves an inventory item which is not in the INVExxx Items file You must first define all items in the Items fun
48. files make note of the version number of the application from which you are converting The Data File Conversion function has no way of determining the information from within the function Before you convert an application s files back up your data files Consider Your Setup Before you try to convert from your version of Bank Reconciliation consider the exact setup of your system Since OSAS code can be customized modifications to your system might be lost if you install a new version of a program or update a file If you are not sure if your system is ready for conversion consult your value added reseller Bills of Materials Kitting 2 5 Conversion Installation and Conversion Converting to Version 7 0 Select Data File Conversion from the Company Setup menu in Resource Manager The function screen appears amp Data File Conversion E a x Commands Edit Modes Other Help xelselmo e ee Select directory on which to create files Enter directory that contains the files to be converted D OSASB0Sidata EJ Do you want source files erased after conversion Do you wart conversion to pause if a problem is found V Appl Description Version Appl Description Version GL General Ledger 6 12 IN Inventory 6 05 so Sales Order 6 05 AR Accounts Receivable 6 05 BK Bills of Materials Kitting 4 50 as Company H 08718 2005 Terminal TODO INS 1 The system displays all valid OSAS data paths Sel
49. g User s Manual 5 3 Print a Report 5 4 Reports Leave these fields blank to select all values or enter values into a combination of fields to select specific information to print on the list The Inquiry F2 command is usually available with these list boxes If the screen contains selection options such as print Single Level or Fully Indented select Single Level to print top level assemblies and one level of detail Select Fully Indented to print assemblies and all components including subassemblies If the screen contains selection options for sorting and printing the report such as Sort By or Print By select the option to use when printing the list You can select only one option If the screen contains check boxes select the check box or press Y in text mode to include that type of information in the report Clear the check box or press N in text mode if you do not want to include that type of information in the list Select the output device to begin printing the report See Reports on page 1 27 for more information After the report is produced the Reports menu appears Bills of Materials Kitting User s Manual Where Used Report Sample Report Use the Where Used Report to review assemblies that contain components you specify This report is useful if you want to know which components are used where and how important each one is so that you can easily make substitutions 08 22 2005 1 53 PM
50. ggle to YES if the items involved with the assemblies and kits carry additional descriptions and you want to use them in Bills of Materials Kitting otherwise toggle to NO If the items involved with the assemblies and kits do not carry additional descriptions from Inventory your entry does not have an effect 7 Toggle to YES if you want to display unit and extended costs on the build screens Toggle to NO if you want to exclude the cost information from the screens during builds and inquiries 8 Toggle to YES if you want detailed information about component movement written to the Inventory Transaction History file or to NO if you do not want to save this information 9 When you finish setting options press W to save your changes and return to the Options and Interfaces screen where you can select another application or exit to the main menu Bills of Materials Kitting User s Manual 3 5 Setting Up Bills of Materials Kitting Set Up and Work Flow Preparing Your Data 3 6 Follow these steps to prepare your data 1 Organize your lists of components that constitute a kit or a bill of materials and the quantities for each Components kits and assemblies must be set up in Inventory first because Inventory must recognize each item 2 Prepare the information specified in Chapter 2 in the Inventory User s Manual 3 Build tables see page 6 23 4 Define bills of materials see page 6 9 5 Define kits see page 6 3
51. ials General Ledger Table No of Columns Column Length 12 Type A Cst Mkup CD App Labor 520000 Overhead 23000 Process 104200 Table ID BKGLH Description Bill of Materials General Ledger Table No of Columns 3 Column Length 12 Type A Description GL Number Cst Mkup CD App Labor 520000 Overhead 523000 Process 104200 Table ID BLASTH Description No of Columns l Column Length Bills of Materials Kitting User s Manual 7 9 System Messages ID Already sold The serialized item you are trying to work with has been sold and the sale has been posted ID Currently in use The serialized item you are trying to work with has been sold or is committed The sale has not been posted but it is no longer available ID Is a BOM You cannot use the ID of an existing assembly for a kit or a different assembly ID Is a Kit You cannot use the ID of an existing kit for an assembly or a different kit Item ID Is not on file You cannot use an item that is not in the INVExxx Items file You may have deleted an item from inventory without deleting it from the definition of an assembly or a kit Location ID Is not on file Location ID Not found Location ID Is not a valid location The location ID you entered does not exist You cannot add locations in Bills of Materials Kitting you must use the Locations function in Inventory see the Inventory User s Manual Bills of Materials Kitting User s Manual A 1
52. ile until you post when it is transferred to the GLJRxxx file BKLSxxx Transaction Lot Serial Numbers file The BKLSxxx file stores quantities and lot and serial information from builds Bills of Materials Kitting User s Manual B 1 File Descriptions BKMDxxx Master Detail file The BKMDxxx file stores information about assemblies components and general ledger account numbers BKMHxxx Master Header file BKTB Tables file The BKMHxxx file stores information about assemblies and user defined fields The BKTB file stores information about the TRMBK and BKGLxxx tables The TRMBK table stores information about user defined fields that you can assign to the header section of the Kits function and the Bill of Materials function Refer to the Tables function for information about how the information is used The BKGLxxx table stores General Ledger accounts for user defined fields You can assign these accounts to user defined fields 4 to 6 in the header section of the Bill of Materials function When you build an assembly or a kit information about which components are involved comes from the BKMDxxx file Information about each component comes from the Inventory system Information for user defined fields comes from the BKTB file BKTRx Build Assembly Transaction file B 2 The BKTRx file stores information about assemblies components levels units of measure general ledger account numbers quantities and cost
53. in the specified location Perhaps a user used the Location Transfers function in Inventory to move the component item to a different location since you defined the component as a part of the assembly in Bills of Materials Kitting Inventory update for this component aborted The update for the quantity of the component in inventory has been stopped because you cancelled the instruction to build an assembly Item already exists on this assembly You cannot add an item twice to the same assembly You can update the quantity of the item to increase the number of the item the assembly requires Item item ID does not have a materials list The specified item does not have any materials assigned to it you cannot build it Use the Bill of Materials function to assign materials to it Item item ID is an assembly Item item ID is not a bill of material Item item ID is not a component An item cannot be an assembly and a kit at the same time To work with a kit you must enter an item that is not already an assembly To work with an assembly you must enter an item that is not already a kit Item item ID is not an inventory item Items you enter either as assemblies kits or components must already be in inventory Bills of Materials Kitting User s Manual A 5 System Messages Item item ID is not in location location ID Item item ID is not on file Item item ID not found in location The specified item
54. ing 1 7 IX 4 periodic work 3 11 posting transactions 3 11 producing reports 3 11 Post Transactions function 4 15 posting accounts debited and credited 3 11 builds 3 4 detail 3 12 kit information 3 3 log 3 12 preliminary steps 3 12 summary information 3 12 T accounts 3 12 transactions 3 11 Proceed OK command 1 4 programs backing up 3 7 Purge Bill of Materials History function 6 27 R Reports Available Components Report 5 7 Bill of Materials History Report 5 11 Bill of Materials List 7 7 Build Assembly Journal 4 13 Component Cost Report 5 9 Kits List 7 5 menu description 1 7 producing periodically 3 11 Resource Manager Data File Conversion function 2 5 2 6 Data File Creation function 2 3 Install Applications function 2 3 2 5 right click menu See shortcut menu 1 17 S Sales Order interfaces 3 3 selling assemblies 3 10 selling items 3 3 selling kits 3 3 3 9 6 3 screens graphical function 1 16 Bills of Materials Kitting User s Manual Index graphical main menu 1 14 navigating graphical 1 16 navigating text function 1 23 OSAS MDI menu 1 15 text function 1 23 text main menu 1 21 Select 2 6 setting up Bill of Materials Kitting access codes 3 7 backup schedule 3 7 options and interfaces 3 3 preparing data 3 6 tables 3 6 shortcut menu 1 17 starting OSAS in other operating systems 1 9 in Windows 1 9 subassemblies changing assembly definitions 3 11
55. ing User s Navigating OSAS Introduction MDI Main The MDI menu centralizes all OSAS functionality in one location applications Menu appear as tabs at the top of the screen their menus and functions appear in a navigation pane on the left side of the screen and function screens appear in the large pane on the right Using this menu you can open more than one function screen at a time and move or minimize screens as needed However you cannot open two functions that lock the same data file at the same time File Modes Tools Other Window Help OSAS 7 0 DAR Date 08 02 2005 User ID Sam Transactions 2005 Edit Transactions FR Copy Recurring Entries Commands Edt Modes Other Scroll Commands Help GL Journal BL Acviy Repon 2xts malmal ee GL and Transaction Inquiry Edit Transactions Post to Master Ls GL Account il Credit Reference its Description Date 401000 11838 80 A R SALES 12 03 2005 501000 6934 94 A R COST OF SALES 12 03 2005 100000 12388 25 A R CASH SALES 12 03 2005 AJA 12 03 2005 AAR INVENTORY 12 03 2005 104200 25039 40 A P A P LINE ITEMS 12 03 2005 KS KS KS KS SKS a En Balance 00 _ Enterzedit_ __aLlocate_ Goto You can move around the MDI menu these ways e To view an application s menus click that application s tab To view the fun
56. item and you can change an established kit in the Kits function Deleting Kits To delete a kit from the BKMHxxx Master Header and BKMDxxx Master Detail files use the Delete F3 command in the Kits function You cannot undo this action Bills of Materials Kitting User s Manual 3 9 Work Flow Set Up and Work Flow Adding Assemblies To add an assembly you must use an ID of an existing inventory item provided that it is not already an assembly or a kit The reason is that when you sell the assembly Accounts Receivable and Sales Order get assembly information from the Inventory system Accounts Receivable and Sales Order cannot recognize it except as an inventory item The best way to add an assembly is to use the Items function in Inventory When you use the Items function you know that the inventory item has been established to be used as an assembly Accounts Receivable and Sales Order recognize the inventory item and you can change an established assembly in the Bill of Materials function Deleting Assemblies To delete an assembly use the Delete F3 command in the Bill of Materials function The assembly record is deleted from the BKMHxxx and BKMDxxx files but an assembly of which the deleted assembly was a part is not deleted For example if assembly 100 is part of assembly 450 and you delete assembly 100 the record for assembly 100 is gone the record for assembly 450 and the components that make it up are still in
57. ity to build is displayed You cannot include serialized items in negative builds You must have enough serialized items on hand in order to build an assembly If not enough serialized items are on hand the system will not continue with the build 3 To continue building the specified number of assemblies select the check box or enter Y in text mode To discontinue the build clear the box or enter N in text mode 4 Use the Proceed OK command to continue with the build When the build 1s complete enter another assembly ID to build or use the Exit F7 command to return to the Daily Work menu Bills of Materials Kitting User s Manual 4 7 Build Assembly Daily Work New Existing Lot Serial Number Entry If the assembly contains lotted items the Existing Lot Number Entry screen appears after you enter build information on the Build Assembly screen If the assembly contains serialized items the Existing Serial Number Entry screen appears If the assembly contains lotted and serialized items the Existing Lot Serial Number Entry screen shown below apppears Use this screen to enter lot serial or lot and serial numbers for components Existing Lot Serial Number Entry Commands Modes Other Scroll Commands Help lee al SAA Item ID 700500 Series Number Loc ID MH0002 MINNEAPOLIS MANUFACTURING Units EA Requested Gty 4 0000 Serial Number 134000 71000 81000 9 1000 Serial Number 001 of 004 En
58. keyboard commands to access functions and move around the screen If you use an operating system that does not have graphical capabilities the text mode is the only mode available You can use either text or graphical function screens indepently of the main menu For example you can use text function screens while using the graphical main menu and vice versa Select GUI Functions from the Modes menu or press Shift F6 to toggle between the text and graphical modes for function screens When available press Shift F5 to switch between graphical and text menu modes or press Shift F6 to switch between modes on function screens You can also use the Resource Manager Defaults function to select the default mode to use for the main menu and function screens In text mode use the Page Up Page Down arrow and Enter keys to move between menus select and enter functions and move around function screens When a list of commands appears at the bottom of a function screen press the highlighted letter to use acommand These methods also work in graphical mode or you can use the mouse to click on fields and command buttons Graphical Mode If you re familiar with other graphical software programs you ll find it easy to navigate around the OSAS graphical mode which uses buttons toolbars text entry boxes and menus to help you move through your tasks Bills of Materials Kitting User s Manual 1 13 Introduction Navigating OSAS Main Me
59. keyboards monitors printers and stands are all decreased by one If an assembly is sold as an item its quantity decreases by one in Inventory the quantities of its constituent parts decrease when the assembly is being built Following the example above when the computer system is sold the number of stands decreases by one but the number of boards plates and screws stays the same Those numbers are adjusted accordingly only when you use the Build Assembly function If the reseller sells the kit and each component decreases by one the reseller must check the quantities of each piece of equipment If the number of monitors keyboards CPUs or printers is in the negative range the reseller orders more from the vendor If the number of stands is in the negative range the reseller knowing that the stand is an assembly sees from the bill of materials for the stand that each stand uses five boards two plates and eighteen screws Bills of Materials Kitting User s The Bills of Materials Kitting System Introduction The reseller checks inventory again for the bill of materials components If the right quantity of necessary items is not in stock the reseller places the appropriate order If the right quantity is in stock the reseller supervises the assembly of the stand and then uses Bills of Materials Kitting to enter the fact that a stand has been built To do this task with only the Inventory application the reseller needs to kn
60. ll of Materials Components Multilevel Cost Rollup Tables Purge Bill of Materials History Bills of Materials Kitting User s Manual 6 3 6 9 6 17 6 21 6 23 6 27 6 1 Kits Use the Kits function on the File Maintenance menu to establish and update information about kits This function is useful if you sell many items at once and want to group them as one item Kits can be sold only through Sales Order To produce a list of the information entered in this function use the Kits List function on the Master File Lists menu Select Kits from the File Maintenance menu The Kits screen appears Kits m E Commands Modes Other Scroll Commands Help rajas rejes ss Location ID MINNEAPOLIS WAREHOUSE Kit ID u N Heating Cooling Package Last Recalc Revision Drawing Version Approximate Component Cost Total 1286 9700 Loc ID Component ID Description Quantity Units MNOOO1 200100 Furnace 1 0000 EA MNODO1 200200 Water Heater 1 0000 MNODO1 200300 Air Conditioner 1 0000 MNooo1 200400 Water Softener 1 0000 MNOOO1 200500 Sump Pump 1 0000 MNOOOA 200600 Humidifier 1 0000 Hao MA Component 001 of 006 Company H 08 22 2005 Terminal T000 OVR 1 Enter the ID of the location that stores the kit 2 Enter the ID of the kit you want to add or change The date of the last recalculation appears Bills of Materials Kitting User s Manual 6 3 Kits File Maintenan
61. m different companies The business also buys raw material for the printer stand but the reseller s business builds the stand for the customer The computer system is a kit The reseller identifies the system as a kit ID CS0001 with five types of components from inventory one monitor one keyboard one CPU one printer and one stand Each can be sold separately The stand is an assembly represented as a bill of materials The reseller identifies it as an assembly ID SHO001 with three types of components five boards two metal plates and eighteen screws The boards plates and screws are not sold separately from each other The parts that make up the other components are not sold separately either for example the F7 key or the monitor shell is not sold separately The difference between the stand and the other components is that the reseller is in charge of assembling the stand The reseller does not need to assemble a keyboard a monitor and a CPU they may as well be raw materials The example illustrates the difference between a kit and a bill of materials Each different kind of component in a kit can be sold separately You must use the Sales Order application to sell kits Bills of Materials Kitting does not work with the Accounts Receivable application alone Selling a kit is no different from selling its components separately other than saving keystrokes A bill of materials is composed at least in part of component
62. master file records For example when you use the Inquiry command in a Batch ID field OSAS lists all batches you have set up so that you can select the one you want to enter in that field When the Inquiry button appears next to a field you can either click the button or press F2 to open the Inquiry screen and search for valid entries Maintenance The Maintenance command allows you to enter or edit master file records on the fly from within functions For example you can use the Maintenance command to add a new customer or item from within the Transactions function The Maintenance command is available when the Maintenance button appears on the toolbar Click the button or press F6 to open the File Maintenance function associated with that field and enter or edit a new master file record Address Mapping v When you are working with a screen that contains an address you can use the Address Mapping command to view a map of that address This command combines address information with the URL and search variables in the Resource Manager Web Setup function and the Map Lookup ID in the Company Setup function to direct your web browser to a mapping website and generate the map Note Before you can view maps you must set up mapping website information in the Resource Manager Web Setup function select the Map Lookup ID to use in the Resource Manager Company Information function and enter the path to your workstation s web browser in
63. mponent quantity needed to make one assembly and the component s unit of measure appear 4 Select acommand e Move to the line you want to edit and press Enter Then see Append Edit Item on page 6 11 for more information e Press A to add an inventory item to the bill of materials e Press H to edit the user defined fields e Press R to recalculate the cost of the bill of materials If you use the Standard costing method in Inventory these costs are updated in Inventory e Press G and then enter the line number to go to a particular line item This command appears only if there is more than one screen of line items e Press N to enter and update information about the next bill of materials e Press B to build the current assembly e Press Dto add or change documents attached to a master file record in OSAS 5 To exit to the File Maintenance menu use the Exit F7 command 6 10 Bills of Materials Kitting User s Manual File Maintenance Bill of Materials Append Edit Item Use the Append Edit dialog box to add or edit bill of material sub assemblies or component items 8 Edit Item de Commands Edit Modes Other Help RX te Type Sub v Location MN002 MINNEAPOLIS MANUFACTURING tem ID 700100 Walnut Cabinet Qty Needed 1 0000 Approx Unit Cost Units Approx Ext Cost 1 Press S if the item is set up as a subassembly Press I if the item is not an assembly 2 Enter or change the location I
64. n OSAS needs information to continue Verification Press lt PgDn gt to proceed Address Mapping When you are working with a screen that contains an address you can use the Address Mapping command menu to view a map of that address This command combines address information with the URL and search variables in the Resource Manager Web Setup function and the Map Lookup ID in the Company Setup function to direct your web browser to a mapping website and generate the map The Address Mapping command is available when the Map flag appears at the bottom of the screen To view a map of the first address on the screen press Shift F4 To view a map of the second address if present press Shift F5 The second command is not available when there is only one address Note Before you can view maps you must set up mapping website information in the Resource Manager Web Setup function select the Map Lookup ID to use in the Resource Manager Company Information function and enter the path to your workstation s web browser in the Resource Manager Defaults function 1 26 Bills of Materials Kitting User s Navigating OSAS Introduction Reports All OSAS applications contain a variety of reports to help you view and analyze your business data Each report function includes a selection screen that allows you to select the range of information to include in the report which appears in alphabetical order when the report is produced After yo
65. n Windows 1 9 Lists printing 5 3 7 3 M main menu graphical 1 14 MDI 1 15 navigating graphical 1 14 navigating MDI 1 15 navigating text 1 22 text 1 21 toolbars 1 19 Maintenance F6 flag 1 25 icon 1 20 mapping 1 20 1 26 Master File Lists menu description 1 7 Master Lists printing 5 3 7 3 menus Daily Work 1 7 drop down menus 1 17 File Maintenance 1 7 graphical main menu 1 14 Master File Lists 1 7 MDI 1 15 Reports 1 7 shortcut 1 17 text main menu 1 21 messages A 1 in text mode 1 26 IX 3 Index modes graphical 1 13 text 1 21 monthly work 3 11 Multilevel Cost Rollup function 6 21 N navigating graphical function screens 1 16 graphical main menu 1 14 MDI menu 1 15 text function screens 1 23 text main menu 1 22 to directories and files 1 20 negative builds definition 3 5 option to allow 3 5 option to warn about 3 5 Negative Item window 6 13 New Lot Serial Number Entry window 4 8 New Existing Lot Serial Number Entry window 6 14 O options additional descriptions for items 3 5 allowing negative builds 3 5 keeping history items in kits 3 5 posting component information 3 5 setting up Bill of Materials Kitting 3 4 warning about negative builds 3 5 Options and Interfaces function 3 4 OSAS MDI menu 1 15 modes 1 13 graphical 1 13 text 1 21 setup considerations 2 5 starting in other operating systems 1 9 starting in Windows 1 9 P parts track
66. ndard Costs Thru 700110 Company H 08 22 2005 Terminal TODO OVR 1 Select the action you want to perform You can add a component replace a component or delete a component Bills of Materials Kitting User s Manual 6 17 Components File Maintenance 6 18 10 11 12 Select whether to apply the component update to items in Assemblies items in Kits or items in Both assemblies and kits Enter the location ID of the component you want to change Enter the ID of the component you want to change The component description appears The quantity of the component appears The unit of measure for the component appears Change it if necessary The Old section appears if you are replacing a component Enter the information about the component you are replacing in the Loc ID Component ID Quantity and Units fields The New section appears if you are replacing a component Enter the information about the replacement component in the Loc ID Component ID Quantity and Units fields Enter the range of locations for which you want to change components in the Pick Location ID boxes If you elected to change components in assemblies enter the range of assemblies for which you want to change components in the Pick Assembly ID boxes If you elected to change components in kits enter the range of kits for which you want to change components in the Pick Kit boxes If you want to print a log of changed com
67. nds click the right mouse button and select the command from the menu that appears On the main menu the shortcut menu gives you access to commands that help you manage your Favorites menu switch between sample and live data perform certain setup tasks and view function information On function screens this menu helps you access help documentation move around the function screen work with EIS dashboards and so on The Other Commands or F4 menu is available on both graphical and text menu and function screens and gives you access to additional utilities and commands not directly related to the function you re currently using Among other things these commands open calculators or allow you to view or enter additional information In text mode press F4 twice on the menu or once on function screens to access this menu Consult Appendix A in the Resource Manager guide for more information on the commands available on the Other Commands menu Bills of Materials Kitting User s Manual 1 17 Introduction Navigating OSAS Information The Information or Shift F2 menu is available in some graphical or text Menu function screens in certain applications and gives you access to additional information about a customer vendor item job bill of material or employee The commands available on the Information menu are determined by the applications you have installed and can include e General Information Comments e History e D
68. nu If you use BBj in graphical mode the main menu is available in two flavors graphical and MDI To switch between the two styles press Shift F5 If you use Visual PRO 5 the graphical main menu is the only graphical menu available Graphical The graphical main menu is shown below Main Menu 4 T000 OPEN SYSTEMSO Accounting Software E File Modes Tools Favorites Other Help Raw mas E H Builders Supply v o OPEN SYSTEMS Accounting Software Main Menu General Ledger 2005 Bills of Materials Kitting Journal Transactions Transactions Bank Reconciliation Reports Copy Recurring Entries Payroll with Direct Deposit Productivity Reports GL Journal Fixed Assets Periodic Processing GL Activity Report General Ledger File Maintenance GL and Transaction Inquiry Inventory Statement Maintenance Edit Transactions Job Cost Master File Lists Post to Master Purchase Order Sales Order Resource Manager Company H Terminal T000 08 02 2005 8 50 AM You can move around the graphical menu in these ways e Click an application to view that application s menu Click a menu item to view its functions Double click a function name to enter that function e To exit from the graphical menu click a different application or menu name or press Tab to return to the main menu To exit from OSAS click the Close box in the upper right corner of the screen press F7 or select Exit from the File menu 1 14 Bills of Materials Kitt
69. o append a bill of materials Then see Append Edit Lotted Serial Number on page 6 15 for more information When you finish entering lot and serial data use the Done D command to save your changes or use the Exit F7 command to exit to the File Maintenance menu 6 14 Bills of Materials Kitting User s Manual File Maintenance Bill of Materials Append Edit Lotted Serial Number The Append Edit Lot Number screen appears when you add or edit a lot number The Append Edit Serial Number screen appears when you add or edit a serial number The Append Lotted Serial Number screen shown below appears when you add or edit a lotted serial number Use this screen to add information about lotted and serialized items to the assembly Append Lotted Serial Number an E Commands Edit Modes Other Inventory Lookups Help 2X te 2 Serial No Lieno 4 2 2500 Ext Cost Fulfill Gty Comment 1 Enter the serial number for the item Enter or change the lot number for the item The cost of the item and the extended cost of the item appear N 3 Ifyou are building a serialized item the Auto Generate check box appears If you select the box the system automatically generates serial numbers based on the starting serial number you supply 4 Enter or change the quantity to remove from inventory You can access this field only if you are working with a lotted non serialized item 5 Enter additional information about
70. o the Favorites menu select the function you want to add from the main menu and press F10 To remove a function from the menu select the function on the Favorites menu that you want to remove and press F10 again See page 1 18 for more information on this menu 1 24 Bills of Materials Kitting User s Navigating OSAS Introduction Commands and Flags Both the text menu and text function screens let you use commands to drill down to more information change companies or access codes switch to sample data and perform tasks related to the function you are using These commands are analogous to the commands contained on drop down menus in graphical mode You access commands by pressing the hot key combination for the command you want to use If you re working with a keyboard that lacks function keys labeled with an F followed by anumber or if you re working with an emulator in UNIX which can cause function keys to become unavailable press the appropriate alternate key combination to access the command Refer to Appendix B in the Resource Manager guide for a list of all OSAS commands and their associated hot keys Not all commands are available for every function or field when a command is available a flag appears at the bottom of the function screen Common flags include Quick Info Maint Inquiry and Verify e The Quick flag reminds you that you are using the Quick Entry mode to skip fields that are not required Press Ctrl F
71. ocuments e Address Lookup Not all of the commands above appear on every Information menu instead commands are available only as they are relevant to the task you are performing For example if you are entering a transaction in Accounts Receivable you can access comments or documents about items or customers but not about employees or vendors Consult Appendix A in the Resource Manager guide for more information on how to use the functions on the Information menu Favorites The Favorites menu gives you quick access to the OSAS functions you use most Menu by allowing you to add selections for entire menus or particular functions to a custom menu After you ve set up the menu select Change to Favorites from the graphical Favorites menu or press F2 to access the functions The Favorites menu saves you time by eliminating the need to switch between applications You can add functions from several different applications to the Favorites menu and access them all there rather than switching between applications on the main menu to access the functions you need To add a function to the Favorites menu select the function you want to add and press F10 Press F2 to switch to the Favorites menu to confirm that your selection was added To remove a function from the menu select the function on the Favorites menu that you want to remove and press F10 again 1 18 Bills of Materials Kitting User s Navigating OSAS Introduction Toolb
72. on Finally click OK or press Enter to log in This screen appears only after you have set up users and access codes for the OSAS system Access Codes Access codes limit use of the system and protect sensitive information Each code allows access to specific applications menus and functions If you cannot select a menu or function your access code is not authorized for it Use the Access Codes function in Resource Manager to set up access codes To change access codes select Access code from the File menu click the Access Code button on the toolbar or press F4 on the main menu When the Access Code box appears enter the access code to change to and press Enter 1 10 Bills of Materials Kitting User s Starting OSAS Introduction Workstation Date To change the workstation date select Workstation date from the File menu click the Change Date button on the toolbar or press F6 4 Set Workstation Date 20188 Workstation Date 08 02 2005 5 When the Workstation Date box appears use the button or your keyboard to enter the date and press Enter Bills of Materials Kitting User s Manual 1 11 Navigating OSAS OSAS menus and functions are available in two modes graphical and text The graphical mode allows both keyboard and mouse commands and uses data entry fields and buttons similar to those found in any graphical software program The text mode presents information in a simpler text format and uses
73. onsult the Resource Manager guide for more information about reports Bills of Materials Kitting User s Manual 1 27 Installation and Conversion Installation Conversion Bills of Materials Kitting 2 3 2 5 Installation Before You Install Bills of Materials Kitting Make sure your system meets these minimum requirements before you install Bills of Materials Kitting The Bills of Materials Kitting system needs a minimum of 3 megabytes 3 MB of disk space to work correctly with programs sample data data dictionaries system files and graphics files Having more disk space available is necessary for the data files you create and maintain The OSAS system requires at least one megabyte 1 MB of main memory to run More memory may be necessary in certain environments and operating systems Installing Bills of Materials Kitting Use the Install Applications function in Resource Manager see the Resource Manager User s Manual to install Inventory Then use the same function to install Bills of Materials Kitting Setting up Bills of Materials Kitting Once you have Bills of Materials Kitting installed on your system you must prepare your data files for everyday use You can prepare files for use with Bills of Materials Kitting in one of two ways you can create and set up your files manually on a new system or you can convert your old files when you upgrade from an earlier version To create files on a new system use th
74. ow which items make up a stand along with any other items the business is responsible for making Inventory can track an item s ID description quantity cost and so on but it cannot automatically track its constituent parts or quantities of those parts Daily Work Use the Daily Work functions for operations that involve building and tracking assemblies producing the Build Assembly Journal undoing a build and posting transactions Reports Use the Reports functions to produce summarized information about components costs and histories File Maintenance Use the File Maintenance functions to set up and maintain information about assemblies and kits Master File Lists Use the Master File Lists functions to produce information about kits and bills of material Bills of Materials Kitting User s Manual 1 7 Introduction The Bills of Materials Kitting Application Interaction Bills of Materials Kitting requires Inventory to run These two applications can be used alone but are most useful when you interface them with other applications Bill of Sales Order Materials Kitting NI General Ledger Becounts Receivable Inventory Interfacing applications means that the information you enter in one application can be transferred to and used in other applications Doing so reduces data entry time and the number of errors that might happen along the way Productivity Reports
75. ox or enter Y in text mode if not clear the box or enter N in text mode exit to the File Maintenance menu and do so before continuing 2 If you want to delete historical information about items built before the system date press Enter To delete historical information about items built before a different date enter that date Bills of Materials Kitting User s Manual 6 27 Purge Bill of Materials History File Maintenance 3 To save your entries use the Proceed OK command To return to the File Maintenance menu use the Exit F7 command 6 28 Bills of Materials Kitting User s Manual Master File List Printing a Master File List Kits List Bill of Materials List Tables List Bills of Materials Kitting User s Manual 7 3 7 5 7 1 7 9 7 1 Printing a Master File List All master file lists are produced in the same way Use the instructions below to print a master file list modifying the procedure as necessary for the list you want to print For example if the screen for the list you want to print does not contain check box options ignore that step and continue to the next Follow these steps to print a master list 1 Select the list you want to print from the Master File Lists menu The selection screen for that list appears The Kits List screen is shown below as an example amp Kits List de Commands Edit Modes Other Help aa Location ID From CA0001 Thru TX0001 y From 200 Th
76. ponents select the check box or enter Y in text mode if not clear the box or enter N in text mode If you want costs to be rolled up for the range of kits and or assemblies select the box or enter Y in text mode if not clear the box or enter N in text mode Bills of Materials Kitting User s Manual File Maintenance Components 13 If you want standard costs in Inventory to be updated select the box or enter Y in text mode if not clear the box or enter N in text mode 14 This field appears if you are adding a component If the component already exists and you want the system to increase quantities for the component select Yes or enter Y in text mode if not select No or enter N in text mode 15 Select the output device to begin printing the update log See Reports on page 1 27 for more information When the log is printed the File Maintenance menu appears Bills of Materials Kitting User s Manual 6 19 Multilevel Cost Rollup Use the Multilevel Cost Rollup function on the File Maintenance menu to recalculate the cost for kits and assemblies If Bill of Materials interfaces with Inventory and you use the standard cost method this function recalculates the standard cost makeup for each assembly or kit Select Multilevel Cost Rollup from the File Maintenance menu The Multilevel Cost Rollup screen appears Multilevel Cost Rollup O E Location D From CA0001 Thru TX0001
77. press Home To move to the last application on the menu press End e Onan application menu press Page Up to move to the menu immediately behind it If you are several levels away from the main menu you can return to the main menu by pressing Page Up repeatedly or by pressing Tab once e To exit from OSAS press F7 1 22 Bills of Materials Kitting User s Navigating OSAS Introduction Function Screens Like the text menu OSAS text function screens can be used on all operating systems and in combination with graphical menus EMOS T000 Invoices Transaction Type You can move around the screen these ways e Press Enter or the down arrow to move from field to field e To use a command that is listed in the command bar press the highlighted letter Use hot key commands to access information screens or to toggle commands on and off Refer to Appendix B in the Resource Manager guide for more information on these commands and their corresponding hot keys Ifa screen contains more than one section press Page Down when prompted to move to the next section Bills of Materials Kitting User s Manual 1 23 Introduction Navigating OSAS e Ifa menu appears prompting you for the kind of information to enter or maintain such as in the example and on Transaction and File Maintenance screens select the appropriate option and press Enter e To exit the screen and return to the menu press F7 Menus Like the graphi
78. r an item or a location that is already in inventory Valid units of measure are You must enter one of the units of measure listed at the bottom of the screen You must build the CNVTxxx table first You must build the CNVTxxx table before you build assemblies or assign transactions to periods If General Ledger is installed you can interface Bills of Materials Kitting with General Ledger and use the Period Setup function in Resource Manager to build the CNVTxxx table Bills of Materials Kitting User s Manual A 9 File Descriptions BKHIxxx History file When you build information is sent from a scratch file to the BKJRxxx and BKHIxxx files and to the Inventory system The BKHIxxx file holds historical information about each assembly built quantity and cost of the assembly date of the assembly and information in the user defined fields The file holds information until you remove it Use the Purge Bill of Materials History function to remove information from the BKHIxxx file based on the date it was built BKJRxxx Transaction Journal file When you build information is sent from the scratch file to the BKHIxxx BKJRxxx BKTRxxx and BKLSxxx files and to the Inventory system The BKJRxxx file is sent account information about each component general ledger period account number assembly ID and date of assembly entry type and amount sequence number description and reference number This information is held in the f
79. rrent fiscal year or to the last fiscal year 3 Select the output device for the post log to begin the posting process See Reports on page 1 27 for more information After posting is complete and the log is produced the Daily Work menu appears Bills of Materials Kitting User s Manual 4 15 Post Transactions Daily Work Posting Log 08 22 2005 1 49 PM Company H Transactions Posted to GL Period 7 700500 700130 700998 700120 700999 700200 700400 700300 700110 700110 700100 700100 700110 700100 700 700111 700113 700115 700117 700 700110 700100 700 700110 700100 700 4 16 Description Item Item Item Item Item Item Item Subassembly Subassembly Subassembly Subassembly Process Process Process Item Item Item Item Assembly App Labor App Labor App Labor Overhead Overhead Overhead 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 07070008 Builders Supply Bill Of Materials Post to GL Detail GL Account 104000 104000 104000 104000 104000 104000 104000 104000 104000 104000 104000 104200 104200 104200 104200 104200 104200 104200 104400 520000 520000 520000 523000 523000 523000 bide 01 l2 34 74 06 50 43 82 35 20 29 15 23
80. ru 200 Print Additional Descriptions for Kits Components Include Costs Include Documents Sort By Location ID O Kit ID Company H 08722 2005 Terminal T000 ovR Inquiry 2 Select the range of values to print on the report in the list boxes Leave these fields blank to select all values or enter values into a combination of fields to select specific information to print on the list The Inquiry F2 command is usually available with these list boxes Bills of Materials Kitting User s Manual 7 3 Printing a Master File List Master File List 3 Ifthe screen contains check boxes select the check box or press Y in text mode to print that type of information in the list Clear the check box or press N in text mode if you do not want to print that type of information in the list 4 If the screen contains selection options that control how the system sorts the list as in the Sort By box in the example select the option to use when printing the list You can select only one option 5 Select the output device to begin printing the report See Reports on page 1 27 for more information After the list is produced the Master File Lists menu appears 7 4 Bills of Materials Kitting User s Manual Kits List The Kits List shows the components that are in each kit and the cost of each component and each kit This list is helpful when you plan a budget and want to see how to allocate components
81. s from builds Bills of Materials Kitting User s Manual A access codes changing 1 10 command 1 10 company specific 3 7 entering 1 10 purpose of 3 7 setting up 3 7 Accounts Receivable interfaces 3 3 selling assemblies 3 10 additional descriptions option to use with items 3 5 Address Lookup 1 20 1 26 address mapping 1 20 1 26 addresses 1 20 1 26 Append Lotted Serial Number window 4 9 6 15 Append Edit Item window 6 11 assemblies adding 3 10 adding and changing 6 9 building with deleted subassemblies 3 11 changing definitions 3 11 creating 1 5 deleting 3 10 6 27 identified as items 1 6 nonserialized 4 5 option to post 3 5 option to track before getting parts 3 5 recalculating costs 6 21 selling 3 3 3 10 serialized 4 5 tracking 4 5 Assembly Inquiry function 4 3 Available Components Report Bills of Materials Kitting User s Manual Index function 5 7 sample 5 7 B backing up before posting 3 12 before using critical functions 3 7 data files 3 7 for a list of companies 3 7 Operating system commands 3 7 programs 3 7 setting up schedule 3 7 Bill of Materials backing out 4 11 components 1 5 definition 1 5 function 6 9 selling 1 6 updating INVExxx file 1 6 when to set up 3 6 Bill of Materials History Report function 5 11 sample 5 11 when to print 6 27 Bill of Materials List function 7 7 sample 7 7 Bill of Materials Kitting before converting 2
82. s that are not sold separately and that the user s business is in charge of building Bills of Materials Kitting User s Manual 1 5 Introduction 1 6 The Bills of Materials Kitting The final stage involving a kit is its sale through the Sales Order application which recognizes the item as a kit The final stage involving a bill of materials is updating the INVExxx Inventory Items file with the on hand quantity of the finished product After the assembly is built it is identified as an item in the Inventory application and you can sell it as an item through the Accounts Receivable application or the Sales Order application An assembly or a built bill of materials is identified differently from a kit Bills of Materials Kitting is the only OSAS application that identifies an item ID as an assembly ID Inventory Accounts Receivable and Sales Order see an assembly as another item However Bills of Materials Kitting and Sales Order distinguish between a kit and an item Inventory and Bills of Materials Kitting check the Inventory system for the item ID if the item is an assembly Sales Order and Bills of Materials Kitting read the BKMHxxx Master Header and BKMDxxx Master Detail files for the item ID if the item is a kit If an assembly is sold as a kit the appropriate items are subtracted from Inventory Following the example above if the reseller sells one kit CS0001 the computer system the on hand quantities of CPUs
83. sembly 4 6 10 Daily Work Enter or change the build number The maximum number of assemblies that you can build with the available components in the specified locations appears Enter the number of assemblies you want to build Enter or change the date for the assemblies to be recorded as built Enter or change the general ledger period for the date of the build If you want to view the Assembly Inquiry screen select the check box or enter Y in text mode if not clear the box or enter N in text mode To save your work use the Proceed OK command If you entered more assemblies to build than the maximum available to build the Negative Item screen appears See Negative Item on page 4 7 for more information If the assembly involves lotted serialized or lotted and serialized items a screen appears where you can enter or edit the lot serial or lot and serial numbers for that item See New Existing Lot Serial Number Entry on page 4 8 for more information Bills of Materials Kitting User s Manual Daily Work Build Assembly Negative Item Use this dialog box to instruct the system to track a build that makes the involved item quantity a negative number Negative Item 2 amp Kin Quantity for tem 700500 Location MH0002 Will Become 4 0000 Proceed with Build 7 1 The item ID and the location for the item appears 2 The negative quantity created when you entered the quant
84. sentative if you encounter an inconsistency Open Systems Inc 4301 Dean Lakes Boulevard Shakopee Minnesota 55379 General Telephone 952 403 5700 General Fax 952 496 2495 Support Telephone 800 582 5000 Support Fax 952 403 5870 Internet Address www osas com Contents Introduction Welcome to OSAS The Bills of Materials Kitting System Starting OSAS Navigating OSAS Installation and Conversion Installation Conversion Set Up and Work Flow Setting Up Bills of Materials Kitting Work Flow Daily Work Assembly Inquiry Build Assembly Undo Build Build Assembly Journal Post Transactions Reports Print a Report Where Used Report Available Components Report Component Cost Report Bill of Materials History Report Bills of Materials Kitting User s Manual 1 3 1 5 1 9 1 13 2 3 2 5 3 3 3 9 4 3 4 5 4 11 4 13 4 15 5 3 5 5 5 7 5 11 iii Contents File Maintenance Kits Bill of Materials Components Multilevel Cost Rollup Tables Purge Bill of Materials History Master File List Printing a Master File List Kits List Bill of Materials List Tables List References System Messages File Descriptions Index 6 3 6 9 6 17 6 21 6 23 6 27 7 3 7 5 7 7 7 9 Bills of Materials Kitting User s Manual Introduction Welcome to OSAS The Bills of Materials Kitting System Starting OSAS Navigating OSAS Bills of Materials Kitting User s Manual 1 1 Welcome to OSAS
85. t to erase existing files you must change your directory choices so that no conflict exists 8 To convert use the Proceed OK command 9 The Do you want a printout of error log after each application prompt appears If you want the error log to be produced after files are converted for each application select Yes or enter Y in text mode if you want the log to be produced after files for all applications are converted select No or enter N in text mode If you are converting only Bills of Materials Kitting files your answer to this prompt makes no difference 10 Answer the questions that appear relating to the conversion of the employee history and last year files 11 Ifa problem occurs and you indicated that you want the system to pause when a problem occurs a prompt alerts you To stop the conversion process select Yes or enter Y in text mode To let the conversion run its course and investigate later select No or enter N in text mode 12 When the process is finished the files are converted Select the output device for the error log After conversion is finished and the error log is produced the main menu with Bills of Materials Kitting added appears Bills of Materials Kitting 2 7 Set Up and Work Flow Setting Up Bills of Materials Kitting Work Flow Bills of Materials Kitting User s Manual 3 3 3 9 3 1 Setting Up Bills of Materials Kitting Determining Options and Interfaces Setting
86. tact Whether you keep the deleted subassembly as part of the definition of assemblies is up to you When a component is marked as a subassembly the component is considered as another assembly When a component is marked as an item it is considered only as an inventory item When you use the Delete F3 command the system checks for other occurrences of the assembly s use as a subassembly Sub If the subassembly is not part of another assembly s definition the subassembly s record is deleted and the task is complete If the subassembly is part of another assembly s definition a prompt appears Change Sub D to Item Everywhere 3 10 Bills of Materials Kitting User s Manual Set Up and Work Flow Work Flow To change the definition of all the other assemblies that use the ID from a subassembly assembly to an item nonassembly from the Inventory file select Yes or enter Y in text mode To leave the other assemblies definitions alone select No or enter N in text mode If you elected not to change other assemblies and you try to build an assembly that involves a deleted subassembly you are not allowed to build the deleted subassembly Monthly Tasks Atthe end of every month complete the daily work and print the period to date reports Periodic Tasks Periodic tasks comprise tracking the occurrences of building assemblies and posting transactions Produce the reports on the Reports menu periodically
87. ter edit Append The Item ID Loc ID Units Requested Quantity Serial Number Unit Cost and Price for the item appear Use this screen to track the lot and serial number of each serialized item e Press Enter to edit a lot or serial number e Press A to append a lot or serial number e Press D to exit to the Build Assembly screen e To save your entries and continue building the assembly use the Proceed OK command 4 8 Bills of Materials Kitting User s Manual Daily Work Build Assembly Append Lotted Serial Number The Append Edit Lot Number screen appears when you add or edit a lot number The Append Edit Serial Number screen appears when you add or edit a serial number The Append Lotted Serial Number screen shown below appears when you add or edit a lotted serial number Use this screen to add information about lotted and serialized items to the assembly A Append Lotted Serial Number ES Commands Edit Modes Other Inventory Lookups Help 2X te 2 Serial No 1311000 Lot No 4 Ext Cost Fullfill City Comment Inquiry 1 Enter the lot or serial number for the item If the item is lotted and serialized the lot number associated with that serial number for the item appears and cannot be changed The cost of the item and the extended cost of the item appear 2 Enter or change the quantity that is removed from inventory You can access this field only if you are working with a lotted non serialized it
88. to build an assembly that will drive the quantity of one of your items below zero you must set the Allow Negative Builds option to YES in Resource Manager No bills of material on file You have not defined any BOMs Define a BOM assembly in the Bill of Materials function Press any key to continue with Recalc To recalculate the number of assemblies to build press any key Press F3 to delete the entire ID When you try to delete an assembly or a kit this message appears for verification If you do not want to delete use the Abandon F5 command Quantity must be greater than zero You must enter a positive quantity A quantity of zero would mean that you do no want to build and a negative quantity would mean that you want to take assemblies apart Quantity will become n for inventory You have instructed the system to push the quantity of the assembly larger than 999 999 9999 or smaller than 999 999 9999 Reduce or increase the quantity to fit within the range Bills of Materials Kitting User s Manual A 7 System Messages Recalculate cost total Information about the item assembly or kit has changed probably because of a change in the INVExxx Items file with one of the items involved To enter the instruction to recalculate the cost use the Proceed OK command to cancel use the Abandon F5 command Record in use Because someone else is using the item assembly or kit you are trying to work with you
89. to toggle quick entry on and off When the Info flag appears press Shift F2 to access the Information menu to access additional information about a customer vendor item job bill of material or employee See page 1 18 for more information on this menu When the Maint flag appears press F6 to launch the appropriate File Maintenance function to edit a master file record or enter a new one on the fly When you finish press F7 to return to the function you were using e When the Inquiry flag appears press F2 to use the Inquiry command to look up additional information and select valid entries for the field you are in e The Verify flag reminds you that you are using verification When this flag appears you must provide verification when you press Page Down or use the Proceed OK command Press Ctrl V to toggle verification on and off Bills of Materials Kitting User s Manual 1 25 Introduction Navigating OSAS Command Bar The command bar appears at the bottom of function screen and gives you access to commands that allow you to move around the screen add or edit information change settings for selected lines or select output devices The commands that are available depend upon the function you are using and are analogous to the command buttons available on graphical screens Press the highlighted key to use a command Messages Messages appear at the bottom of the screen when a command is unavailable or whe
90. u c a and t parameters in OSAS shortcut properties or after the osas command so that the system automatically uses the appropriate user ID company ID and access code to save time logging in In Windows open the OSAS shortcut s properties and enter these parameters after the path in the Target field as in the example below be sure to use the correct directories for your system C basis bin bbj exe osasstrt txt q tT00 cD osas70 progrm config bbx uSam aapple cH Note In Windows the u c and a parameters must follow the separation dash In other operating systems enter the parameters after the osas command as in this example osas t T2 c B a apple Note You can enter these parameters in any order but you must leave a space between the parameter mark t c or a and the parameter itself Refer to the Resource Manager guide for more information on these parameters Bills of Materials Kitting User s Manual 1 9 Introduction Starting OSAS Logging In After you start OSAS the login screen appears 2 OSAS Login OPEN SYSTEMS Accounting Sofware User ID Sam Company ID H Builders Supply Access Code Save Password To log in to OSAS enter your User ID the Company ID you want to work with and your Access Code If you want to save your access code so that you do not need to enter it again select the Save Password check box or enter Y in text mode to save your informati
91. u select the information to include use one of these options to output the report e Select Printer or enter P in text mode to send the report to a printer then select the printer to use e Select Print Preview or enter R to view the report in a preview window from which you can print the report later This option is only available on Windows or graphical Linux workstations running BBj e Select File or enter F to save the report to a file then change the directory path and file name followed by the txt extension if necessary Directory paths and file names must be less than 35 characters in length Note To preserve formatting view the reports you save to a text file with a fixed width or monospaced font Courier or Lucida Console for example e In text mode enter S to view the report directly in an OSAS function screen then select whether to view it in Standard or Compressed width When available select Email or enter M to e mail the report then enter the e mail address to sent the message to the subject for the message and whether to include the report as an attachment to the message Generally reports or forms that make up part of your audit trail cannot be e mailed You also must set up your e mail system in Resource Manager before you can e mail reports Note To preserve formatting view e mailed reports or attachments with a fixed width or monospaced font Courier or Lucida Console for example C
92. up the options and interfaces is a standard part of installation The selections you make determine the way Bills of Materials Kitting runs Interfaces Bills of Materials Kitting can be directly interfaced only with General Ledger However it gets most of its information from Inventory which can be interfaced with several other applications See the Inventory User s Manual and other user s manuals for information about other interfaces that could have an indirect effect on Bills of Materials Kitting Bills of Materials Kitting version 6 1 does not work with any version of Inventory Accounts Receivable or Sales Order lower than 6 10 Bills of Materials Kitting performs a specific operation it tracks the building of a bill of materials This operation involves the creation of a retail item from other inventory items and needs the Inventory application Assemblies involve only Bills of Materials Kitting and Inventory You can sellan assembly through Accounts Receivable or Sales Order but its constituent parts are not directly taken into account at the point of sale Building and selling kits involves grouping and selling items as a single item that can be sold only through Sales Order If Sales Order is not interfaced with Bills of Materials Kitting but Inventory is you can take advantage only of the functions that pertain to assemblies you can still build assemblies but you cannot sell them as kits If you sell a kit through Sales
93. urnal function on the Daily Work menu to produce a summary of the assemblies you have instructed Bills of Materials Kitting to track This function is useful if you want to see a list before you post of the assemblies that are to be built or that have been built After you post to General Ledger you can compare the Build Assembly Journal with the Audit Log Select Build Assembly Journal from the Daily Work menu The Build Assembly Journal screen appears Build Assembly Journal E O ES Commands Edit Modes Other Help EEE AAA Assembly ID From 700 Thru 700110 LocationID From CA0001 Thru TX0001 Print By GL Period Account Build Number Print Detail Summary Company H 08 22 2005 Terminal T000 OVR Inquiry 1 Enter the range of assembly IDs and location IDs you want to include in the journal or leave the fields blank to include all 2 Select the order in which you want to organize the report 3 Select whether you want to include detail information in the report Bills of Materials Kitting User s Manual 4 13 Build Assembly Journal Daily Work 4 Select the output device to begin printing the journal See Reports on page 1 27 for more information After the list is produced the Daily Work menu appears Build Assembly Journal 08 22 2005 Builders Supply 1 47 PM Build Assembly Journal by GL Account Period Assenbly Component Description k Quantity Built GL Account 700100 Waln
94. ut Cabinet Assembly 08 22 2005 pe 104000 700130 Varnish Item MNOOOZ 08 22 2005 104000 700998 Varnish Brushes Item MNOOOZ 08 22 2005 104000 700120 Stain Walnut Item MNOOOZ 08 22 2005 104000 700999 Oil Rags Item MNOOOZ 08 22 2005 x 104000 700110 Unstained Cabinet Subassembl MNOOOZ 08 22 2005 104000 GL ACCOUNT TOTAL 700100 Walnut Cabinet Process 08 22 2005 10 0000 104200 GL ACCOUNT TOTAL 700100 Walnut Cabinet MNOO0Z 08 22 2005 10 0000 520000 GL ACCOUNT TOTAL 700100 Walnut Cabinet Overhead MNOOOZ 08 22 2005 10 0000 523000 GL ACCOUNT TOTAL GL PERIOD 08 TOTAL 1414 06 End of Report 4 14 Bills of Materials Kitting User s Manual Post Transactions Use the Post Transactions function on the Daily Work menu to post the transactions related to building the assemblies to General Ledger Select Post Transactions from the Daily Work menu The Post Transactions screen appears Post Transactions Commands Edit Modes Other Help xelselmo e ee Have you Backed up your data files Printed all necessary reports Built all assemblies Company H 08 22 2005 Terminal T000 OVR 1 If you have backed up your data files printed all the necessary reports and built all assemblies select the box or enter Y in text mode if not clear the box or enter N exit to the Daily Work menu and do so before posting 2 Select the year to which you want to post entries You can post to the cu

Bill of Materials/Kitting

Contents

Download Pdf Manuals

Related Search

Related Contents