Sales Order Audit Report sample

Orders Out of Balance:

Order	  Customer			Ship To	Whse 	PO 	Type 	Stage	Promised Dt 	# of Lines

1538-00	101* Grandview Ind                  001		     so	   Ord	  06/01/15	    1

- Other Total Cost is 0; Calculated as 5
- Credit Hold Is Incorrect, Order is On Hold, Credit Manager is ab1

10152-00    24* Action Remediation		    001		     so	   Ord	  06/01/15	    3

- Requested and Promised Ship Dates are Missing; MANUALLY ADJUST!!!! 

10142-01    402* Ace Controls      01	      001		     so	    Ord	  06/14/15	   1

- ICSW/ICSS Record Does Not Exist For Product powerwasher-kit 

10108-00    14* Fiore Flour	   AL-02	   002		     so	    Ord	  09/26/15	   8

- Total Invoice Amount is 0; Calculated as 135
- Credit Hold Is Incorrect, Order is On Hold 

8820-00	1453 Cook, JK		             001	 4891	so	    Ord	  09/29/15	   1

- Total Price is -58; Calculated as 0
- Total Shipped Cost is -8.01; Calculated as 0 
- Total # of DO Lines is 0; Calculated as 3 
- Total Invoice Amount is 184; Calculated as 242 1015245-00
 
10112-00    108 Seidel Electric	ABC-08	 001		     so	     Ord	10/8/15		2 
- # Sn/Lots on Line 1 is 1; Should be 0 

Customers Out of Balance:

Customer: 24* Action Remediation
--------------------------------------------------------------------------------------------------------------
Order #     Type    Stage    Cust Order Bal    Tot Order Bal     Future Bal      Downpayment
10002874-00 so      Ord             10.00            10.00            0.00            0.00
10002876-00 so      Ord             10.00            10.00            0.00            0.00
10002877-00 so      Ord             10.00            10.00            0.00            0.00
10002878-00 so      Ord             10.00            10.00            0.00            0.00
10002879-00 so      Ord              0.00             0.00            0.00            0.00
10002934-00 so      Ord             10.00            10.00            0.00            0.00
10002941-00 SO      Ord             10.00            10.00            0.00            0.00
10002942-00 so      Ord             10.00            10.00            0.00            0.00
10002943-00 so      Ord            100.00           100.00            0.00            0.00
10002945-00 so      Ord             10.00            10.00            0.00            0.00
10002946-00 so      Ord             20.00            20.00            0.00            0.00

Order Balances:                    200.00            215.00           0.00            0.00
Customer Balances:                  15.00-            30.00          40.00            0.00
Variance:                          215.00            185.00          40.00-           0.00