How to round a calculated field in Report Writer on the SOP Blank Packing Slip


TechKnowledge Content


SUMMARY

This article describes how to round a calculated field in Report Writer on the Sales Order Processing Blank Packing Slip.

MORE INFORMATION

For example: You created a calculated field on the SOP Blank Packing Slip that takes QTY multiplied by Item Shipping Weight and divides it by 100 to get total shipping weight per line item. Here is an example of how the calculated field was created and how it was rounded to the nearest one (no decimal places).

1. In Report Writer (click Tools, click Customize, click Report Writer), click the Reports icon from the top menu bar.

2. From the Original Reports side, select the SOP Blank Packing Slip Form and then click insert.

3. On the Modified Reports side, select the same report and then click Open.

4. In the Report Definition window, click the Tables button. Select the Sales Transaction Amounts Work table, and then click New. Select Item Master and then click OK. Click Close.

5. In the Report Definition window click the Layout button.

6. In the Toolbox, select Calculated Fields from the drop-down list. Click New.

7. In the Calculated Field Definition window, type Shipping Weight (C) as the name.

8. For the Result type, select Currency from the drop-down list. The Expression Type should be Calculated.

9. Place your cursor in the Calculated Expression. In the operators section, click the ( button.

10. Select the Fields tab.

11. Click the drop-down list for Report Table and then select Sales Transaction Amounts Work.

12. Click the drop-down list for Table Fields and then select QTY. Click Add.

13. In the operators section, click the * button.

14. Select the Fields tab.

15. Click the drop-down list for Report Table and then select Item Master.

16. Click the drop-down list for Table Fields and then select Item Shipping Weight. Click Add.

17. In the operators section, click the ) button.

18. In the operators section, click the / button.

19. Select the Constants Tab.

20. Click the drop-down list for Type and then click Integer.

21. Type 100 in the Constants field, and then click Add.

22. The Calculated Expression should read: (QTY * Item Shipping Weight)/100

23. Click OK.

24. In the Toolbox, select Calculated Fields from the drop-down list. Click New.

25. In the Calculated Field Definition window, type Rounded Shipping Weight (C) as the name.

26. For the Result type select Integer from the drop-down list.

27. The Expression Type should be Calculated.

28. Place your cursor in the Calculated Expression

29. Select the Fields tab.

30. Click the drop-down list for Report Table and then select Calculated Fields.

31. Click the drop-down list for Table Fields, select Shipping Weight (C), and then click Add.

32. In the operators section, click the + button.

33. Select the Constants Tab.

34. Click the drop-down list for Type and select Currency. Type .5 in the Constants field, and then click Add.

35. The Calculated Expression should read: Shipping Weight (C) + .5

36. Click OK.

37. In the Toolbox, select Calculated Fields from the drop-down list.

38. If you are using version 6.0, in the scrolling window find Rounded Shipping Weight (C) and drag it into the H3 section on the report.

If you are using version 7.0 or 7.5, drag Rounded Shipping Weight (C) into the H5 section on the report.

39. In the report layout, double-click the field that was just put on the report.

40. In the Report Field Options window, be sure the Display Type is set to Visible, and then set the Field Type to Data.

41. Select the X from the top right corner of the Report Layout window and save your changes.

42. Click OK in the Report Definition window.

43.. From the top menu bar, click File, and then click Microsoft Business Solutions.

44. Give users access to the modified report in the Security Setup window (click Setup, click System, click Security) in Great Plains.

To see an example of this report, click the following link and download the package:

https://mbs.microsoft.com/downloads/customer/TK3833.package

To import a package file into Great Plains, follow these steps:

1. Download the package file to your desktop.

2. In Great Plains, click Tools, click Customize, and then click Customization Maintenance.

3. In Customization Maintenance, click Import.

4. In the Import Package File window, click Browse and browse to your desktop; select the package file you downloaded, and then click Open.

5. After the package is in the Import Package File window, click OK.

Note You may be prompted to overwrite the existing file. Choosing Yes will overwrite your existing modified report. You may wish to exit and make a backup of your existing report before you overwrite it.

6. Access the report in Report Writer.

This article was TechKnowledge Document ID: 3833