# Physical Inventory Tag Printing **URL:** \ **Category:** Epicor ERP 10\ **Tags:** e10\ **Created:** [December 31, 2019, 1:47pm UTC](https://www.epiusers.help/t/physical-inventory-tag-printing/63123 "2019-12-31T13:47:33Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![jstewart](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/a698b9/32.png) [@jstewart](https://www.epiusers.help/u/jstewart)\ **Post date:** [December 31, 2019, 1:47pm UTC](https://www.epiusers.help/t/physical-inventory-tag-printing/63123/1 "2019-12-31T13:47:33Z")
Is there a way to repirnt tags for a physical inventory? I hit the wrong button and didn’t print the tags. I get the following error and I try to print preview or print “There were not any New Tags to print.” ---
**Author:** ![jstewart](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/a698b9/32.png) [@jstewart](https://www.epiusers.help/u/jstewart)\ **Post date:** [December 31, 2019, 1:49pm UTC](https://www.epiusers.help/t/physical-inventory-tag-printing/63123/2 "2019-12-31T13:49:41Z")
Sorry, I jumped the gun on this one. Just stressing out!!! ---
**Author:** ![JasonMcD](https://www.epiusers.help/user_avatar/www.epiusers.help/jasonmcd/32/22326_2.png) [@JasonMcD](https://www.epiusers.help/u/JasonMcD)\ **Post date:** [December 31, 2019, 4:55pm UTC](https://www.epiusers.help/t/physical-inventory-tag-printing/63123/3 "2019-12-31T16:55:40Z")
I created a BAQ report instead of the Epicor form. We do not like the canned report at all. I shortened the tag number with a calculated field, to drop the zeroes. `convert(int, convert(decimal,CCTag.TagNum))` And they wanted the frozen qty on the tags, and some other things. ![image](https://epiusers.help/uploads/default/original/3X/c/c/cccb8d0ca104d53a43fb503feeb30543843b2e27.png) Note the join I had to create between CCHdr and CCTag. ---
**Author:** ![JasonMcD](https://www.epiusers.help/user_avatar/www.epiusers.help/jasonmcd/32/22326_2.png) [@JasonMcD](https://www.epiusers.help/u/JasonMcD)\ **Post date:** [December 31, 2019, 4:56pm UTC](https://www.epiusers.help/t/physical-inventory-tag-printing/63123/4 "2019-12-31T16:56:32Z")
Oh, and welcome to the group, Judi! ---
**Author:** ![LarsonSolutions](https://www.epiusers.help/user_avatar/www.epiusers.help/larsonsolutions/32/266_2.png) [@LarsonSolutions](https://www.epiusers.help/u/LarsonSolutions)\ **Post date:** [December 31, 2019, 6:10pm UTC](https://www.epiusers.help/t/physical-inventory-tag-printing/63123/5 "2019-12-31T18:10:05Z")
Have you tried reprint tags? Or did you do a print preview? Go to the system monitor and pull up the report and print them. Hope that helps. ---
**Author:** ![jstewart](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/a698b9/32.png) [@jstewart](https://www.epiusers.help/u/jstewart)\ **Post date:** [January 2, 2020, 12:23pm UTC](https://www.epiusers.help/t/physical-inventory-tag-printing/63123/6 "2020-01-02T12:23:54Z")
@JasonMcD Thank you. I’m not in IT and so I can’t change/create reports and I agree, I don’t like the can tags. I’ll get with our IT group and see if they will try some changes. @LarsonSolutions I’ll have to remember that tip about the system monitor. I was able to “reprint” tags. Like I said I was stressing and working from home with any of my notes. ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [January 2, 2020, 1:07pm UTC](https://www.epiusers.help/t/physical-inventory-tag-printing/63123/7 "2020-01-02T13:07:00Z")
> [@JasonMcD](#): > > I shortened the tag number with a calculated field, to drop the zeroes. These leading zeros always gave us issues. We’d download the tags to an excel file, and enter counts in Excel. Then Paste Insert the data from excel into the count entry. But Excel would strip off those leading zeros. So trying to paste a tag # `1234` would fail, as it was expecting `00001234`. How do you overcome the printed tags not having the “real” tag number? No concerns about mis-keying during entry? And … > [@JasonMcD](#): > > And they wanted the frozen qty on the tags, and some other things. I suggested this to our accounting dept, and they gave me the evil eye. Saying that is very bad form. For count accuracy, the fear was the counter would just write down that number, or something close to make it look like they actually counted it. With that, it brought the integrity of the Phys Inv under scrutiny with auditors ---
**Author:** ![JasonMcD](https://www.epiusers.help/user_avatar/www.epiusers.help/jasonmcd/32/22326_2.png) [@JasonMcD](https://www.epiusers.help/u/JasonMcD)\ **Post date:** [January 2, 2020, 1:26pm UTC](https://www.epiusers.help/t/physical-inventory-tag-printing/63123/8 "2020-01-02T13:26:16Z")
> [@ckrusen](#): > > How do you overcome the printed tags not having the “real” tag number? No concerns about mis-keying during entry? The entry is (initially) in a shared Excel workbook (with track changes), and they “key punchers” are just matching the short tag number to the short tag number, so it’s not bad. The spreadsheet has a hidden column with the long tag number. For “blank” tags, I have another sheet with macros to prevent editing certain columns and to verify part numbers and turn red if they are non-qty-bearing, etc. And any UOM that is not EA is highlighted yellow. And even though I use track changes, I still have the macro populate one column with the user name (for filtering) and one column with the (last) previous value, for clarity and finding, etc. I myself do the uploading and it’s still absolutely excruciating. But I let someone else do it one year and it was weeks of corrections after. So I just do it now. As they organize the plant more and more, counting gets better every year. > [@ckrusen](#): > > the fear was the counter would just write down that number Yeah I didn’t argue. Honestly our biggest problem has never been enumerating. It’s writing the wrong **part number** down or skipping a pallet or shelf entirely. Or not receiving everything before the freeze.