New Blend Audit Spreadsheet (AGS-9519)

Benefits:

• Reduce time and effort to research blends and batches containing certain products.
• Reduce time and effort to research blends and batches containing certain custom applied products.
• Reduce time and effort to see the totals for batches that were done during a certain period of time OR done for a certain customer for a certain period of time.
• Maximize the ability to use and analyze acreage (i.e., "Crop Area" and "Crop Area UOM") associated with blends.

Details:

Summary:

Blend Audit Report can now be exported as a Spreadsheet. Now you can view subtotals by Blend or Customer. Also, the grand total will show a summary by Batch with totals.

Navigation:

AgroGuide > Report Manager > Blend Audit Reports > Print Standard Reports > Blend Audit Spreadsheet > Select

Data:

Here are the columns that are available in the spreadsheet:

There are 75 columns on this report:

1. Blend Number
2. Batch Number
3. Induction Order
4. Item Location
5. Item Number
6. In Blend
7. Item Qty
8. Item Qty UOM
9. Item Weight
10. Item Weight UOM
11. Item Volume
12. Item Volume UOM
13. Actual Qty
14. Formula Code
15. Batch Date
16. Batch Qty
17. Batch Qty UOM
18. Batch Weight
19. Batch Weight UOM
20. Batch Area
21. Batch Area UOM
22. Batch Comments
23. Field Ticket Comments
24. Sales Order
25. Order Location
26. Formula Comments
27. Formula Price
28. Price UOM
29. Total Price
30. Reaction Temperature
31. Salt Out Temperature
32. Precipitate Name
33. Formulation Group
34. Blend Type
35. Blend Type Description
36. Analysis
37. Percent Clay
38. Percent Water
39. Hot Water Temperature
40. Solubility Source
41. Client
42. Client Name
43. Formulation Weight
44. Formulation Weight UOM
45. Is Negotiated
46. Is Tank Mix
47. Farm
48. Field
49. NA
50. Farm Name
51. Field Name
52. NA Name
53. Crop Code
54. Formulation Location
55. Formulation Date
56. Expire Date
57. Crop Area
58. Crop Area UOM
59. Formulation Volume
60. Formulation Volume UOM
61. Density
62. Formula Unit Cost
63. Formulation Unit Cost UOM
64. Formulation Total Cost
65. Blender Name
66. Load Out Name
67. Item Description
68. Item Location Description
69. Order Location Description
70. Formula Location Description
71. Extended Amount
72. Crop Zone Code
73. Crop Zone Name
74. Trancode
75. Trancode Description