Distribution 
     Training Guide
     D100 Inventory Management: Basic
                                                	
  
                         Certification Course Prerequisites 
                         The	
  D100	
  Inventory	
  Management	
  course	
  consists	
  of	
  a	
  hands-­‐on	
  guide	
  that	
  will	
  walk	
  you	
  through	
  the	
  specifics	
  of	
  
                         Acumatica’s	
  Inventory	
  Management	
  module.	
  	
  
                         While	
  many	
  have	
  completed	
  this	
  course	
  online,	
  you	
  might	
  encounter	
  some	
  challenges	
  that	
  
                         you	
  would	
  otherwise	
  not	
  face	
  when	
  done	
  in	
  our	
  classroom	
  setting.	
  
                         You	
  will	
  perform	
  the	
  exercises	
  in	
  your	
  installed	
  copy	
  of	
  Acumatica,	
  using	
  the	
  “Demo”	
  data	
  provided	
  with	
  the	
  
                         Acumatica	
  installation	
  package	
  version	
  4.20.	
  
                         To	
  begin,	
  activate	
  all	
  the	
  features	
  of	
  the	
  application	
  using	
  the	
  Common	
  Settings:	
  
                              1.    Open	
  the	
  Enable/Disable	
  Features	
  form	
  (screen	
  ID	
  CS100000):	
  Configuration	
  >	
  Common	
  Settings	
  >	
  
                                    Licensing	
  >	
  Enable/Disable	
  Features	
  
                              2.    Click	
  the	
  Modify	
  button	
  on	
  the	
  toolbar.	
  
                              3.    Confirm	
  that	
  the	
  features	
  are	
  enabled/disabled	
  as	
  follows:	
  (When	
  you	
  come	
  to	
  a	
  field	
  not	
  specified	
  in	
  the	
  
                                    table	
  below,	
  either	
  populate	
  it	
  as	
  you	
  see	
  fit	
  or	
  leave	
  it	
  as	
  is.)	
  
                                     Field	
                                                 Value	
  
                                     Organization	
                                          {checked}	
  
                                         Customer	
  Management	
                            {checked}	
  
                                         Project	
  Management	
                             {checked}	
  
                                         Time	
  Reporting	
  on	
  Activity	
               {checked}	
  
                                     Finance	
                                               {checked}	
  
                                         Multi-­‐Branch	
  Support	
                         {checked}	
  
                                              Inter-­‐Branch	
  Transactions	
               {checked}	
  
                                         Multi-­‐Currency	
  Accounting	
                    {checked}	
  
                                         Deferred	
  Revenue	
  Management	
                 {checked}	
  
                                         Subaccounts	
                                       {checked}	
  
                                         Fixed	
  Assets	
  Management	
                     {checked}	
  
                                         VAT	
  Reporting	
                                  {checked}	
  
                                         Invoice	
  Rounding	
                               {unchecked}	
  
                                         Support	
  for	
  Expense	
  Reclassification	
     {unchecked}	
  
                                         Contract	
  Management	
                            {checked}	
  
                                         Tax	
  Entry	
  from	
  GL	
  Module	
              {unchecked}	
  
                                         Consolidated	
  Posting	
  to	
  GL	
               {checked}	
  
                                         Volume	
  Pricing	
                                 {unchecked}	
  
                                     Distribution	
                                          {checked}	
  
                                         Inventory	
  Subitems	
                             {checked}	
  
                                         Automatic	
  Packaging	
                            {checked}	
  
                                         Warehouses	
                                        {checked}	
  
                                              Warehouse	
  Locations	
                       {checked}	
  
                                         Blanket	
  Purchase	
  Orders	
                     {checked}	
  
                                         Drop	
  Shipments	
                                 {checked}	
  
                                         Multiple	
  Unit	
  of	
  Measure	
                 {checked}	
  
                                     Misc	
                                                  {checked}	
  
                                         Row-­‐Level	
  Security	
                           {checked}	
  
                                         Field-­‐Level	
  Audit	
                            {checked}	
  
                                         Avalara	
  Tax	
  Integration	
                     {checked}	
  
                                                                                             	
                                                                  	
  
        D100	
  Inventory	
  Management	
                                                    	
                                                    Page	
  2	
  of	
  92	
  
           	
  	
                                          	
  	
  
                                                     	
  
                                                  Address	
  Validation	
                             {checked}	
  
                                             Notification	
  Module	
                                 {unchecked}	
  
                                       	
  
                                 4.    Save	
  your	
  changes.	
  
                                 5.    Click	
  the	
  Enable	
  button	
  on	
  the	
  toolbar.	
  	
  
                                 6.    Open	
  Segmented	
  Keys	
  (CS202000):	
  Configuration	
  >	
  Common	
  Settings	
  >	
  Segmented	
  Keys	
  >	
  Segmented	
  
                                       Keys	
  
                                         Screen	
  Section	
                    Field	
                                     Value	
  
                                         Summary	
  	
                          Segmented	
  Key	
  ID	
                    INSUBITEM	
  
                                         	
                                     	
                                          	
  
                                         Details	
                              Segment	
  ID	
                             1	
  
                                         Details	
                              Include	
  in	
  Cost	
                     {checked}	
  
                                         	
                                     	
                                          	
  
                                         Details	
                              Segment	
  ID	
                             2	
  
                                         Details	
                              Include	
  in	
  Cost	
                     {checked}	
  
                            	
  
                                 7.    Enter	
  into	
  Segmented	
  Key	
  ID	
  field	
  =	
  INSUBITEM	
  
                                 8.    Make	
  sure	
  Include	
  in	
  Cost	
  is	
  checked	
  for	
  both	
  lines.	
  	
  
                                 9.    Since	
  branch	
  accounting	
  is	
  enabled,	
  verify	
  that	
  you	
  are	
  working	
  in	
  the	
  MAIN	
  branch	
  and	
  that	
  it	
  is	
  
                                       configured	
  correctly:	
  
                                             a.    Verify	
  that	
  you	
  are	
  connected	
  to	
  the	
  MAIN	
  branch.	
  The	
  information	
  is	
  located	
  at	
  the	
  top	
  of	
  the	
  
                                                   screen:	
  
                                                                                                                                                                                 	
  
                            	
  
                                             b.    It	
  is	
  important	
  that	
  you	
  work	
  in	
  the	
  MAIN	
  branch	
  throughout	
  this	
  certification	
  class.	
  
                                 10.  In	
  the	
  General	
  Ledger	
  module,	
  confirm	
  that	
  all	
  the	
  period	
  of	
  the	
  current	
  fiscal	
  year	
  are	
  actives:	
  Finance	
  >	
  
                                       General	
  Ledger	
  >	
  Work	
  Area	
  >	
  Manage	
  >	
  Financial	
  Periods	
  
                            	
  
                            Important Note:  
                            Training Documentation was tested with build 4.20.0784 
                                                                                                      	
                                                                         	
  
         D100	
  Inventory	
  Management	
                                                            	
                                                         Page	
  3	
  of	
  92	
  
            	
  	
                                              	
  	
  
                                               	
  
                         Table of contents 
                         Certification	
  Course	
  Prerequisites	
  .................................................................................................................................	
  2	
  
                         Inventory	
  Objectives	
  .....................................................................................................................................................	
  6	
  
                         Inventory	
  Overview	
  .......................................................................................................................................................	
  6	
  
                         Inventory	
  Process	
  Overview	
  ..........................................................................................................................................	
  6	
  
                         Benefits	
  and	
  Additional	
  Features	
  ..................................................................................................................................	
  7	
  
                            Create	
  Posting	
  Classes	
  ..............................................................................................................................................	
  8	
  
                            Create	
  Reason	
  Codes	
  ..............................................................................................................................................	
  12	
  
                            Configure	
  Inventory	
  Preferences	
  ............................................................................................................................	
  13	
  
                            Create	
  Unit	
  of	
  Measure	
  ..........................................................................................................................................	
  15	
  
                            Create	
  Warehouses	
  ................................................................................................................................................	
  16	
  
                            Create	
  Item	
  Classes	
  .................................................................................................................................................	
  19	
  
                            Create	
  Lot/Serial	
  Classes	
  .........................................................................................................................................	
  23	
  
                            Inventory	
  Costing	
  ....................................................................................................................................................	
  26	
  
                            Stock	
  Items	
  .............................................................................................................................................................	
  27	
  
                            Non-­‐Stock	
  Items	
  ......................................................................................................................................................	
  42	
  
                            Define	
  Item	
  Price	
  Classes	
  ........................................................................................................................................	
  47	
  
                            Define	
  Base	
  Price	
  ....................................................................................................................................................	
  48	
  
                            Receipt	
  Inventory	
  ....................................................................................................................................................	
  50	
  
                            Adjustments	
  Inventory	
  ...........................................................................................................................................	
  54	
  
                            Issue	
  Inventory	
  ........................................................................................................................................................	
  55	
  
                            Transfer	
  Inventory	
  ..................................................................................................................................................	
  59	
  
                            Kits	
  ..........................................................................................................................................................................	
  65	
  
                                  Kit	
  Assembly	
  ...................................................................................................................................................	
  65	
  
                            Physical	
  Inventory	
  ...................................................................................................................................................	
  72	
  
                               Full	
  Physical	
  Inventory	
  vs.	
  Cycle	
  Counting	
  ..........................................................................................................	
  72	
  
                            Movement	
  Class	
  .....................................................................................................................................................	
  72	
  
                            ABC	
  Codes	
  ...............................................................................................................................................................	
  73	
  
                                                                                            	
                                                                 	
  
        D100	
  Inventory	
  Management	
                                                   	
                                                   Page	
  4	
  of	
  92