Manufacturers often need a shipping log that answers basic operational questions without manual digging: what shipped, where it went, when it left, and how it was tracked. The harder part is tying that shipment back to the part details and any shipped serial numbers in a way your team can audit later.

In Cetec ERP, you can build this view by running two standard reports side by side, exporting them, and then joining them in a spreadsheet. This gives you a practical shipping log without changing your shipping workflow.

What a Shipping Log Needs to Answer

If your shipping log needs to include part number and description, shipped serial numbers, ship-to destination, ship date, and tracking number, you will want to combine invoice shipment data with the serials tied to those invoices.

Run the Invoice List Report for Shipment Details

Start with the Invoice List report (Sales > Invoices > Invoice List). This report is the backbone for shipment details such as part number and description, ship-to information, invoice date (ship date), tracking number, and other shipment-related fields.

Run the Top Level Serials Report for Shipped Serials

Next, run the Top Level Serials/Warranty report (Sales > Invoices > Top Level Serials/Warranty). This report lists the serial numbers associated with invoices, which lets you tie each shipped serial back to the shipment record.

Join the Two Exports for a Complete Shipping Log

Because the Invoice List and Top Level Serials reports each answer a different part of the question, the practical approach is to export both reports and join them in Excel. In most cases, you will join on an invoice identifier so each shipment record can include its related serial numbers.

Keep the Outputs Readable with Column Controls

After you run each report, use the +/- Columns link at the top of the report to show only the fields you need. Keeping the exports tight makes the join easier and the finished shipping log easier to review and share.

Key Takeaways

• Use the Invoice List report to capture what shipped, where it shipped, when it shipped, and tracking numbers.
• Use the Top Level Serials/Warranty report to capture the serial numbers tied to each invoice.
• Export both reports and join them in a spreadsheet to build a single shipping log view.
• Hide unnecessary columns before export to keep the final output readable and easier to maintain.

Conclusion

If your manufacturing business needs a clear shipping log that combines part details, ship-to information, dates, tracking, and shipped serials, pairing the Invoice List and Top Level Serials reports in Cetec ERP is a straightforward way to get there. Once you have the joined export, you can use it as an internal audit trail and a consistent answer to shipping history questions.