MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Manufacturing > Inventory Control > Reports > Perpetual vs. Physical Inventory Comparison Summary Report - By Descending Absolute Adjustment Value

Perpetual vs. Physical Inventory Comparison Summary Report - By Descending Absolute Adjustment Value

IC685C

 


 

 DATE  9/13/93                                ANDERSEN CONSULTING APPLICATIONS, INC                                       PAGE   1

 TIME 10:34:01                                     DISTRIBUTION WAREHOUSE 1                                               CO   001

 REPORT IC685C                                                                                                            WHS  DW1

                                        PERPETUAL VS. PHYSICAL INVENTORY COMPARISON SUMMARY

                                              BY DESCENDING ABSOLUTE ADJUSTMENT VALUE

     PART NUMBER/                PERPETUAL UNITS      PHYSICAL UNITS

     DESCRIPTION            UM   PERPETUAL VALUE      PHYSICAL VALUE       UNIT COST     ADJUSTMENT UNITS     ADJUSTMENT VALUE

 -------------------------  --  ------------------  ------------------  ---------------  ----------------     ----------------

 BOLT-300                   EA          98,772.333          10,282.873      170.0000000        88,489.460-       15,043,209.00-

 TRANSFER PART                      16,791,297.00        1,748,089.00

 BOLT-100                   EA          24,224.500         105,003.350       70.0000000        80,778.850         5,654,520.00

 PURCHASING PART                     1,695,716.00        7,350,236.00

 BOLT-200A                  EA         395,402.000         398,452.330      110.0000000         3,050.330           335,536.00

 PURCHASING PART                    43,494,220.00       43,829,756.00

 BOLT-200                   EA             111.000              72.000      110.0000000            39.000-            4,290.00-

 MANUFACTURING PART                     12,210.00            7,920.00

 ED600                      EA                .100              10.000      123.2700000             9.900             1,220.00

 EDI TESTPART 600 DW1                       12.00            1,233.00

 ED100                      BX          16,982.500          17,000.000       35.0000000            17.500               613.00

 EDI TESTPART 100 DW1                  594,387.00          595,000.00

 EDLOTCDW1                  EA               2.000               5.000      155.0000000             3.000               465.00

 EDI LOT CONTROLLED DW1                    310.00              775.00

 JJCFGPARENT                EA               1.000               5.000      100.0000000             4.000               400.00

 JULIE CFG COSTED PARENT                   100.00              500.00

 GSPART01                   EA             854.000             931.000        3.0000000            77.000               231.00

 PART DESC 01                            2,562.00            2,793.00

 SCREW-200                  EA               2.000               1.000      110.0000000             1.000-              110.00-

 MANUFACTURED PART                         220.00              110.00

 ED800                      EA              10.000              11.000       12.0300000             1.000                12.00

 EDI TESTPART 800 DW1                      120.00              132.00

 LM-COST                    EA               1.000                .000        1.0000000             1.000-                1.00-

 TEST COST RETRIEVAL                         1.00                 .00

 AMY                        EA              40.234               2.000         .0000000            38.234-                 .00

 AMY PART - GV001                             .00                 .00

 BOLT-MJB                   EA              35.000              12.000         .0000000            23.000-                 .00

 MANUFACTURING PART                           .00                 .00

Purpose

The Perpetual vs. Physical Inventory Comparison Summary by Descending Absolute Adjustment Value provides a comparison summary of the perpetual and actual physical inventories along with the calculated adjustment quantity and adjustment value.  This report, sorted by the descending absolute adjustment value within each company/warehouse listed, helps you quickly identify the most significant adjustment amounts.

To generate this report, submit a request using the Physical/Perpetual Inventory Report Request screen (IC360S02).

Report Sequence

Company/Warehouse, Adjustment Value.