<img src="https://secure.leadforensics.com/133892.png" alt="" style="display:none;">

What does one do when a client or customer demands that each box produced has a unique identifier? The short answer: master the art of individual box tracking with ColumbusFood.  

Some manufacturers use boxes in combination with lot numbers to tell when it was produced in the day’s production run. Box tracking is often seen as a requirement in the dairy and meat industries. I can guess your questions; why would I box track? Why does it make a difference?

Box tracking allows the manufacturer to assign individual box IDs and weights. The output of boxes may have the same weight and by using a box ID you see whether it was produced in the beginning, middle or end of the production run.

It'll also allow the user to track a box throughout the process. The user can track a box in the warehouse, if it's on a container, loose or not open at all. All aspects of the process can use box tracking, production, warehouse and sales. 

In this article you'll learn how to create a unique box identifier for each box produced using ColumbusFood ERP.

It all starts on the location card. On the Warehouse Fast tab there is a Boolean field for Box Tracked. By checking this field the client is able to use the box tracking functionality.


Next is the No. Series. A number series for the boxes will need to be set up and attached to each item that's box tracked. From the No. Series page, set up a new series.


Once the No. Series is setup on the item card, there are two fields: a Boolean field for Box Tracked and the No. Series. On the item tracking fast tab – check the box tracked Boolean field and the select the box numbers from the No. Series drop down list.


In a simplistic example of how to determine the output of a box tracked item, the user would go to batch reporting. Batch reporting is an interface to the output and consumption journals. In this example we'll only be dealing with output.

The user enters the quantity to output and selects the box tracking lines, which in turn deploy the Box Tracking Lines page.


The user can create all box IDs at one time or assign one box ID at a time.


By selecting "assign all box IDs," it has created 25 lines which include the number from the output quantity in batch reporting. The user would now enter the 25 alternate quantities. If the item was a fixed weight item, the standard weight for each box would have populated in the Qty field.

Once the weights have been entered the user would click "ok" and the Qty would be populated on the batch reporting output line.



Next the user posts the output. The output was placed on a container during the batch reporting process, so we can now review the container and determine what boxes are on the container.

From the container’s "navigate" tab on the ribbon, the user can click on the boxes and it will show all boxes.


In addition, there is a Boxes page that shows the user ID, item number, lot number, bin code, container number and quantity (alt.). It also shows whether or not the box is open.


Another feature from the box table is the ability to see the box ledger entries which show how the box has been moved throughout the plant. Once the box is shipped to a customer, the box is no longer open and will not be allowed to be transacted against. In the example below, you can see the box was output into the "batchout" bin and moved to bin B01.


Now that you have learned how ColumbusFood's box tracking works effectively, you might also be interested in learning more serialized box tracking. 

Learn about serialized box tracking


Discuss this post

Recommended posts

Here's a common scenario for Dynamics 365 Finance users: "Company A" has a purchase order for $1,000 in January that will be a part of a fixed asset. There will be two additional PO’s that will be part of this fixed asset, but won’t be invoiced until February and March. The asset should not be placed in service until all three invoices have been posted.
I've worked with Microsoft Dynamics GP for over 20 years and one of the coolest features I've seen is the workflow functionality in version GP2013 R2 and after. With each version after GP2013 additional capability and modules have been added. However, there are two major questions that need to be answered before you begin:
Data has been a very hot topic among clients lately. Specifically, I keep getting asked: "How can I create a strategy and plan around my data?" Most people I talk to are working for companies that collect data at every turn of the supply chain. This data might come from heavy equipment machinery or e-commerce metrics or financial growth numbers—the point is, it's usually contextually diverse and there's a lot of it.
In 2018, Black Friday sales pulled in a record $6.22 billion in online sales and 2019 could very well beat that number. Regardless, between Black Friday and Cyber Monday, this year's post-Thanksgiving weekend will be one of the biggest days in American retail.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down