Sam Horton Posted June 7, 2021 Share Posted June 7, 2021 I've tried looking around the forums for this - but I can't find the answer or figure it out (I'm obviously new to the program). When I use my barcode reader to add comics to my database I'd like the cover price to show as the cost by default. How do I set that? Additionally, is it possible to have that logic applied to the books I've already scanned in rather than having to go back and do it by hand? Also, is there a way to view only my collection rather than all the titles I don't have any issues of? Just a way to see and manipulate the data for the issues I currently own and have scanned into the database? Thanks! Link to comment Share on other sites More sharing options...
Steven L. Dasinger Posted June 7, 2021 Share Posted June 7, 2021 For new items, use Menu item Setup->Preferences... Near the bottom, change Standard Cost from Zero to Cover Price and Discount to 0%. NOTE: You can, of course, use other settings but the above will set Cost to Cover Price. For the following, make a copy or backup before proceeding, just in case 'something' goes horribly wrong... This will change ALL Issues and not just the ones you own (although you can limit it to just Titles you own). For existing items, I you can try Menu item Items->Mass Change. Select Mass Change. Set Change to COST Set To to Field, Cover Price Next to Apply To, click on the Selected Titles (this will bring up a Title Select window). At the top, next to Show, click on Titles in Stock. In the display, to to the top and click on (high-light) the first title. Then go to the bottom. Press and Hold the SHIFT key the select the last title. NOTE: This should select/high-light all Titles (that you own). Click OK. Next to Selected Titles should be a number for the amount of titles selected. If everything looks okay (and you did make a copy/backup, right?) click Make Change. You will be informed that this can not be undone (hence, the copy/backup...). click okay to implement. Having Item's you don't own with a Cost shouldn't hurt anything. Alternately, depending on the Edition of CB you have, you could try to Export the items you own, import to a spreadsheet, make the changes there, save the results, then Import back into CB. 1 Link to comment Share on other sites More sharing options...
Sam Horton Posted June 7, 2021 Author Share Posted June 7, 2021 Thank you so much! I was in both of those menus and just totally missed the standard cost field and then I was worried I'd be changing fields and not values in the mass change menu. Everything is perfect now! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now