physical inventory, an obligation? - serti€¦ · physical inventory, an obligation? training plan...
TRANSCRIPT
![Page 1: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/1.jpg)
2019‐05‐17
1
PHYSICAL INVENTORY, AN OBLIGATION?
TRAINING PLAN
• Keeping a good handle on your inventory all year long
• The tools that are at your fingertips (SOL)
• Inventory management report / Inventory Count
• Understanding the impacts of inventory changes on accounting
• How your SDS support team can help you
1
2
![Page 2: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/2.jpg)
2019‐05‐17
2
KEEPING A GOOD HANDLE ON YOUR INVENTORY ALL YEAR ROUND
• X325-* – Reservation List / Unshipped Parts Report
• X3A1 – Parts List (Working with Selections)
• X3A3 – On Hand / Old Core Quantity Report (Negatives)
• X3A7 – Parts By Bin Location Report
• X36-2 – Partial inventory
• X326-1 – Purchase Reconciliation Menu
KEEPING A GOOD HANDLE ON YOUR INVENTORY ALL YEAR ROUND
• Reservation list
• Received parts report
• Unshipped parts report
• On-order parts report
• Back-order parts report
3
4
![Page 3: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/3.jpg)
2019‐05‐17
3
KEEPING A GOOD HANDLE ON YOUR INVENTORY ALL YEAR ROUND• Reservation list X325-1
KEEPING A GOOD HANDLE ON YOUR INVENTORY ALL YEAR ROUND• Received parts report X325-2
5
6
![Page 4: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/4.jpg)
2019‐05‐17
4
KEEPING A GOOD HANDLE ON YOUR INVENTORY ALL YEAR ROUND• Unshipped parts report X325-3
KEEPING A GOOD HANDLE ON YOUR INVENTORY ALL YEAR ROUND
• On-order parts report X325-4
7
8
![Page 5: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/5.jpg)
2019‐05‐17
5
KEEPING A GOOD HANDLE ON YOUR INVENTORY ALL YEAR ROUND
• Back-order parts report X325-5
KEEPING A GOOD HANDLE ON YOUR INVENTORY ALL YEAR ROUND
• Parts list X3A-1• Summary selection
9
10
![Page 6: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/6.jpg)
2019‐05‐17
6
KEEPING A GOOD HANDLE ON YOUR INVENTORY ALL YEAR ROUND
Parts list X3A-1• Detailed selection
KEEPING A GOOD HANDLE ON YOUR INVENTORY ALL YEAR ROUND
• Parts list X3A-1• Inventory section• Old core section• Summaries only• Report can be back-dated
11
12
![Page 7: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/7.jpg)
2019‐05‐17
7
KEEPING A GOOD HANDLE ON YOUR INVENTORY ALL YEAR ROUND• Parts list X3A-1
• Detailed report
KEEPING A GOOD HANDLE ON YOUR INVENTORY ALL YEAR ROUND• Parts list X3A-1
• Multiple summary reports• Vendor/Class• Vendor/Source• Source
13
14
![Page 8: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/8.jpg)
2019‐05‐17
8
KEEPING A GOOD HANDLE ON YOUR INVENTORY ALL YEAR ROUND
• Let’s cover X3A-3, X3A-7, partial inventory and X326-1 later on in thiscourse
TOOLS AT YOUR FINGERTIPS - STATSONLINE• Inventory Movement Widget (X3A6)
• Inventory summary
15
16
![Page 9: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/9.jpg)
2019‐05‐17
9
INVENTORY MANAGEMENT REPORTS
• X3A-4 : Quantity at zero• Stockable parts only or not• Includes new parts since
last report was run
• X3A-5 : Parts Under minimum• Minimum added in X3-1
INVENTORY MANAGEMENT REPORTS
• X3A-2 : Transaction Report• Filled Rate
17
18
![Page 10: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/10.jpg)
2019‐05‐17
10
INVENTORY MANAGEMENT REPORTSX3A-11 : Parts by return code report
• Easy return management• Manageable in X3-1• X33-1 vendor #3
INVENTORY MANAGEMENT REPORTSX38-2 : Suggested return
19
20
![Page 11: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/11.jpg)
2019‐05‐17
11
INVENTORY MANAGEMENT REPORTS
• X5A-*• Core sales history• Old core management• Cores due
INVENTORY COUNT
• Doing inventory? Call SDS Support a week before
• We open a ticket, we do a follow up, we help you get prepared
21
22
![Page 12: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/12.jpg)
2019‐05‐17
12
INVENTORY COUNT
Difference between On-Hand VS Available Quantity• List of reservations X325-1• WIP
INVENTORY COUNT
• First report : On hand / Old Core Quantity X3A-3 (negative on hand)
23
24
![Page 13: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/13.jpg)
2019‐05‐17
13
INVENTORY COUNT
Second report : Parts with no bin X3A-7• Are they physically in a bin?
Parts with default bin X3A-7• Do you have a default bin? X33-1
Parts with multiple bins X3A-7• Risk of doubling inventory
INVENTORY COUNT
• X36-2 Generating Count Sheets (Parameters #1)
• Complete or partial
• Parts with quantities only
• How many “handwrite” pages?• We can always add more later
• Display on screen, display on count sheets
25
26
![Page 14: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/14.jpg)
2019‐05‐17
14
INVENTORY COUNT
• X36-2 Generating Count Sheets (Parameters #2)• If partial, which bins• Skip a page for each bin, how many characters
to consider• Sort method: compressed or extended• Printing in virtual, printing counts sheets for
practice before actual inventory
INVENTORY COUNT• X36-2 Generating Count Sheets (Partial)• Why do a partial inventory count?
• Section by section all year long• Allows a tight control over inventory• Lightens the inventory count• Can be done by fewer people• Exclude ENV vendor
27
28
![Page 15: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/15.jpg)
2019‐05‐17
15
INVENTORY COUNT
• X36-3 Reprinting Count sheets• To add more “Handwrite” pages
INVENTORY COUNT• X36-1 Entering Count Sheets• While doing inventory• 3 ways to find the count sheet:
by part number, by page not entered, by page number
• Entering the quantities• Validate if entered is “Yes”
29
30
![Page 16: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/16.jpg)
2019‐05‐17
16
INVENTORY COUNT
• X36-4 Verification Report• Parts whose inventory has
fluctuated• Unentered pages• Parts with multiple counts• Report can be printed as
many times as needed
INVENTORY COUNT• X36-5 Inventory variation
report• Gives you an idea of
what the variation would be
• Can take this report out as many times as needed
• Always possible to go back in the count sheets in every step
31
32
![Page 17: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/17.jpg)
2019‐05‐17
17
INVENTORY COUNT
• X36-6 Update Inventory• Point of no return• X36-1 to X36-5 can be redone as
many times as needed as long as we don’t update inventory (except X36-2)
• Having doubts? Call SDS Support!
INVENTORY COUNT
• X36-7 Inventory Report Adjustment• Date and time already
pre-entered if X36-6 is done
• Gives total variation• X3A-1 Parts list –
summaries, complementary report
33
34
![Page 18: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/18.jpg)
2019‐05‐17
18
UNDERSTANDING THE IMPACTS OF INVENTORY CHANGES ON ACCOUNTING
• X3-1 Inventory adjustment• Trans./Ajust.• Ajusted in X3-1? Please advise accounting
UNDERSTANDING THE IMPACTS OF INVENTORY CHANGES ON ACCOUNTING
• X3A-2 Adjustment Report
35
36
![Page 19: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/19.jpg)
2019‐05‐17
19
UNDERSTANDING THE IMPACTS OF INVENTORY CHANGES ON ACCOUNTING
• X326-1 Purchase Inquiry• An easy way to make sure
receptions and returns are in balance with accounting
UNDERSTANDING THE IMPACTS OF INVENTORY CHANGES ON ACCOUNTING
• X326-1 History• In history when it merges
X326-2• Force history if needed
37
38
![Page 20: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/20.jpg)
2019‐05‐17
20
UNDERSTANDING THE IMPACTS OF INVENTORY CHANGES ON ACCOUNTING
• X326-2
• If reception or return amount matches with accounting, posts to history
HOW YOUR SDS SUPPORT TEAM CAN HELP YOU
• Doing inventory? Contact SDS Support!
• In a performance group? Contact SDS Support!
• Email : [email protected]
• 1 (800) 361-6615
39
40
![Page 21: PHYSICAL INVENTORY, AN OBLIGATION? - SERTI€¦ · PHYSICAL INVENTORY, AN OBLIGATION? TRAINING PLAN • Keeping a good handle on your inventory all year long • The tools that are](https://reader036.vdocuments.us/reader036/viewer/2022071413/610bacdceb94e2010735a3a7/html5/thumbnails/21.jpg)
2019‐05‐17
21
QUESTIONS ?
THANK YOU !
41
42