- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
Good day, @rsteve06.
I'm glad to see you here in the Community. I can help you add a column on the report for the net weight of the item.
First, you have to add a custom field on the item:
- Click Lists.
- Choose Item Lists.
- Double-click the item.
- Click Custom Fields.
- Click Define Fields.
- Enter Net Weight and put a check mark on the Use column.
- Click OK to save changes.
- Enter the Net Weight of the item.
- Click OK.
Next, you will have to customize the invoice template to have a Net Weight field:
- Click Customer.
- Choose Create Invoice.
- Click the Customize Data Layout.
- Go to the Columns tab.
- Put a check mark on the Net Weight Screen and Print.
- Click OK.
- Once you select the item, the Net Weight column will automatically reflect the value.
- Click Save & Close.
Lastly, run and customize the Sales by Item Detail report:
- Click Customize Report.
- Choose the Display tab.
- On the Columns field, select Net Weight.
- Click OK.
- You can see the Net Weight column on the report.
- You can click the Excel button to export the report.
That should do it, rsteve06. Let me know if you have other report questions for me. I'm still here to help you more. Wishing you and your business continued success.