Course Description for Spreadsheet Data Manager

This course helps you to understand how to use Spreadsheet Data Manager (SDMan.) SDMan is a very powerful tool to batch update IFS Applications objects. Objects covered by the SDMan are;

• Purchase parts, inventory parts, and part catalog parts
• Suppliers
• Supplier for parts
• Supplier agreement quotations
• Supplier Agreements

Example of activities that you can perform using SDMan are;

• Create new parts, or modify existing parts.
• Create or modify suppliers.
• Import supplier agreements and supplier agreement quotations into IFS Applications.
• Change buyers, quality control (QC) analysts, and/or technical coordinators for parts.
• Update planning parameters.
• Update lead times for parts and suppliers for parts.
• Assign and reassign inventory part asset classes, ABC codes, and/or planners.
• Update supplier agreement information, add parts to supplier agreements, and modify supplier agreements.
• Perform many other data modification activities.

Course Length

The estimated time to complete this course is 8 hours.

Target Audience

This course was designed primarily for advanced users.

Introduction

This chapter will introduce you to the SDMan.

Prerequisites

Before taking the lessons in this chapter, you should have gained deep knowledge about part, supplier, and supplier agreement handling in IFS/Enterprise, IFS/Invent, and IFS/Procurement. The reason is simply that you may effectively jeopardize the data base content if mistakes are made.

Chapter Length

The estimated time to complete this chapter is 15 minutes.

Target Audience

This chapter was designed primarily for advanced users.

SDMan in Enterprise

This chapter explains how to enter and modify supplier records.

Prerequisites

Before taking the lessons in this chapter, you should have completed the introduction chapter.

Chapter Length

The estimated time to complete this chapter is 2 hours.

Target Audience

This chapter was designed primarily for advanced users.

SDMan in Maintain Inventory

This chapter explains how to enter and modify inventory parts.

Prerequisites

Before taking the lessons in this chapter, you should have completed the introduction chapter.

Chapter Length

The estimated time to complete this chapter is 2 hours.

Target Audience

This chapter was designed primarily for advanced users.

SDMan in Procurement

This chapter explains how to enter and modify purchased parts, inventory parts, supplier for purchased parts, and supplier agreement quotations.

Prerequisites

Before taking the lessons in this chapter, you should have completed the introduction chapter.

Chapter Length

The estimated time to complete this chapter is 4 hours.

Target Audience

This chapter was designed primarily for advanced users.