What's New in ComicBook Pull File 1.12

Version 1.12

User Features

Programs>Weekly Pull File tab -
When the email sending module errors out (mostly due to a bad email address), it must be restarted, causing some customers to receive duplicate emails. I added a starting and ending acct# when sending emails. So if a previous email errors out or is cancelled, you can start where you left off. You can also repeat a single email by specifying the same acct# in start and end boxes. If you specify a starting but not ending, all emails with account#s greater than or equal to the starting account# will be sent. If you specify only an ending email, the emails will start at the beginning of the customer list and quit after the ending account email is sent. I also added the customer acct# to the reference box to assist in knowing which emails were successful. This will stop customers from getting multiple emails because of a store starting emails over if there is an error. (thanks Chris-PLAY THE GAME READ THE STORY)

When emails error, offer the user to cancel the rest of the emails in the list.

Changed ‘last completion’ fields. They will specifically note whether they have been completed after the button 1 import with “sync to button 1” instead of a date. The background will also change to red in the last completion field if they button has not been ‘sync’ed with button 1. The two exceptions to how this works is with the “5. Weekly E-mail” and the “6. Remove Items Ordered” buttons. They instead sync to button 3, as both buttons are based on the last build of the weekly report.

added ‘Last Minute Customer Adds’. This button allows you to add items to customers pull lists after you have received your items for the week, without looking up individual customers. It would be beneficial if you receive an Annual, and you want to include a copy for everyone who has an Auto-Pull for the regular title. The top half of the screen shows all Monthly Auto Pulls, the bottom half of the screen shows the items received this week. As always, Ctrl-? in the Item Code and Acct# fields, gives you the valid commands. The hot-keys work just like they do in the Diamond All and Reconciliation forms.

Programs>Order Monthly Items tab -
”4. Export to Previews Program” button now displays the month exported as well as the date in the Last Completion field to the right of the button.

added first/last name to Reconciliation form. This is to assist in quickly noting who has the Monthly Auto Pull.

Show last month completed on the Program>Order Monthly Items tab>‘Find Monthly Items’ button ‘Last Completion’ field. This will show which Previews file has been processed and the date it was processed.

Reconciliation Form –
• Added filters very similar to the filters on the Diamond All form. This will assist you in quickly finding matching items being offered in the current Previews catalog. Though I’ve added many checkboxes, I’ve come to rely almost exclusively on the “Auto Series Code OR Item Description Front”, the “Auto-Query” (under the ReQuery button), and the “New Items” checkboxes.
o “New Items” – eliminates items which are offered again
o “Auto-Query” – automatically queries each time the you move to a different record on the top sub-form (Items not found).
o “Auto Series Code OR Item Description Front” – This automatically fills in the filter fields (Item Description, and Series Code) with the information from the current record. It also selects the Item Description>Begins With option. What this accomplishes is that any item which begins with the same Item Description will be shown. This would include alternate covers listed with CVR A, or SMITH CVR after the item description. The series code will display any items which match the series code for the item. Using the “OR” means that if either the Series Code or the Item Description match the results will display. Without the “OR”, both conditions would have to match for the item to display.
o Many other filters which are identical to the Diamond All filters.
• All MAPs (Live Data) allows you to view and change the Monthly Auto Pulls information for all customers. If the Item Description changes, it is a simple change to copy/paste a new Item Description for all customers pulling the same title. It also lets you quickly find all customers who are Auto Pulling a title if there is a special or annual you want to sign them up for. The background color of the form changes so you’ll be aware that you are seeing all Auto Pulls, not just the ones not found.
• Auto Repeat and Order repeats the hot-key (Ctrl-M or Ctrl-O) to all following records which match Item Description and Vender exactly. Ctrl-M causes Ctrl-O also. There is also a checkbox, “No Prompting”, which eliminates the promptings/messages which occur when Ctrl-M/Ctrl-O succeed.

In reconciliation form, on bottom form, now show all items. Not only the items which have a vender. With Diamond removing vender numbers from some items, those items stopped showing up on bottom form without the change.

Diamond All Form -
added hot keys to jump to ‘item code’ (alt-m) and ‘first batchNo/IC’ filter (alt-s)

Added ‘Pg#’ filter. This will make it quicker to find items in the Diamond All form which match a page number in the Previews catalog.

Cycle Sheet Form -
Added form to be able to enter data into cycle sheet form via the UPC code.
This is done quickest with a barcode scanner. The form to enter data is on the cycle-sheet form>UPC button on upper right of form. This data can be entered into any of the cycle sheet qty fields this way (Inventory/Order/Received/Held Back).

Cycle-Sheet Form>Count Sheet Report button>Count Sheet button with History checkbox checked. Assists in marking cycle sheet counts. There are some additional fields (last Inventory count/Total Rcv/Total Ordered/Accumulated Inventory [last inventory + Items Rcvd since the last count]) on this new report, and as it is accessed via the Cycle Sheet form, it is based on the filtering used in the source form (Diamond All, etc.) which is more comprehensive than that available from the Reports Switchboard.

Source Forms -
Concept adjustment – When opening the Cycle-Sheet form, it will display those items which are displayed on the source form (the form which Ctrl-Y was used to open the Cycle-Sheet Form). Then when choosing to run a Cycle-Sheet Report/Cycle Sheet Count Sheet/Export to Hard Drive, those items which were filtered on the source form will be what is displayed on the report. If additional filtering is chosen on the Cycle-Sheet Dynamic Groupings Form, then this additional filter will be chosen from within the original source form filter. If no filter is chosen on the source form, then these reports will work as in CBPF 1.11. The export to hard drive button will create the file based on the source form filter, but not on the dynamic groupings filtering or sorting. Source forms include the Diamond All/Customer-Items Ordered/Customer-Items Supplied/Crossover Events/Reconciliation/Last Minute Customer Adds. When using the Cycle-Sheet Report from the Reports Switchboard, there is no defined source form. (Thanks Bub – UK)

Customer Form -
Added Items Supplied (Customer Form>Special tab). This form is similar to the Items Ordered tab, but it acts as a way to keep track of items which you are ordering FROM the customer instead of SELLING TO the customer. Or you can simply keep a list of items related to this customer, but the items won’t show on the weekly report or order these items during the monthly ordering process.

added Customer Form>Special tab>import/export buttons. These two buttons can be used to import into the Items Ordered tab or the Items Supplied table on the Special tab. The export button likewise can export from the Items Ordered tab or the Items Supplied table. The export creates a POW file from this customer using a specified month (or date entered range). You can use this process to move items from one customer to another or one store to another.

Customer>Items Ordered tab -
When adding new items on the Items Ordered tab, if the item is a duplicate of a previous item already ordered by the same customer, a prompt appears asking if the customer wants more. If answering the prompt “No”, the cursor was resetting to the top record. I’ve now changed the process to do an “undo” which if changing an Item Code, it will revert to the previous Item Code, if inserting a new Item Code, the cursor will return to the new record (empty) to be ready for data entry. If answering the prompt “Yes”, then the cursor stays on the newly added record so that any additional changes can be made to the record.

Customer>Monthly Auto Pulls tab -
Added category field to Monthly Auto Pulls table. This field shows up in the Customer/Reconciliation/Monthly Auto Pulls forms. Previously, I used only the Item Description and the Vender to determine if an item should be ordered. With this change, I am also including the category (e.g. COMICS, BOOKS - GRAPHIC NOVELS, MAGAZINES, etc.) This will make it safer to use the ‘Item Description Front’ and ‘All Venders’ checkboxes. If you currently have some Monthly Auto Pulls (MAPs) which are not Comics, you’ll need to change their category to the appropriate category before the Find Monthly Item button will correctly find these items. You can make the change within each Customer form>Monthly Auto Pull tab, or you can change all MAPs within the Monthly Auto Pulls form. To make the change, find the Category field and click on the drop-down, then select the correct category. I’ve made this change optional within the Programs>setup tab>Use Category checkbox. If it is unchecked (default), CBPF will work as in the past, looking at only the Item Description and Vender.

Monthly Auto-Pull Form -
Added “Dis” conditional formatting to the Monthly Auto-Pull form to highlight if an Auto-Pull has been discontinued.

Other –
removed Previews Update File import because Diamond changed the file format to match the ‘master database’ file format. Diamond has not provided field definitions for this table at the time of this writting.

Technical Features

Following is a summary of import/export formats available within CBPF
File format review –
Button Fields Mimics Format Where Comment
Import Order (to Items Ordered or Items Supplied)
Item Code, Qty
or
Item Code, Item Desc, Price, Qty POW input file format
or POW output file format .csv Customer>Special
Create Weekly File Qty, Item Code, Item Desc Weekly file which Diamond e-mails (either format as only Qty and Item Code are used by CBPF) .csv Customer>Special Includes 4 row header
Export Order (from Items Supplied or Items Ordered) Item Code, Qty POW input file format .csv Customer>Special Allows for items to be copied from one customers Items Supplied to another (or same) customers Items Ordered (even at another CBPF store) or to move a customers Items Ordered from one store to another.
Export to Previews Program Item Code, Qty POW input file format .csv Programs>Order Monthly Items
Import Completed Order from Previews Program Item Code, Qty
or
Item Code, Item Desc, Price, Qty POW input file format
or POW output file format .csv Programs>Order Monthly Items

Added Programs>Setup tab>“On-Line Order Deadline” button which opens the table from which the “# days left on xxx09 Previews” on switchboard. Normally this table will not need to be manually changed, as I’ll keep the dates updated. However, if I get behind, or a correction to the dates needs to be made, it can be changed at the store.

Insert UPC code from weekly email into the Diamond All form when “2. Add to received numbers” button is pressed. This will place the latest “best?” UPC into the table.

Corrections

Crossover event. CBPF 1.11 would add a crossover item which has just been added to a crossover event to a customer who had subscribed to a different crossover. This would only happen if the crossover event being added to had an identical item description to an item description of an auto pull which was not a crossover.

Emails so that the Customer Form>Personal Information tab>Weekly E-mail – ‘All’ checkbox, and ‘Weekly E-mail’– ‘Mine’ checkbox, work individually for each customer. They were only being looked at for the first customer’s weekly email, and used for all subsequent customers.

when importing POW file “5. Import completed order from Previews”, if there was already a Qty Ordered (probably a 0) in the Diamond All Form, the import qty would not appear for that item on the Diamond All Form. (Thanks Charlie!!)

Version 1.11

extended file format change - The extended format weekly file from Diamond has changed format. Therefore, CBPF was forced to change how the file is imported to match the new format. There is no new data, only the same data, but moved around. You can change this from "Programs>Setup tab>Extended Format Weekly File" checkbox.

modify where the ImportWin.txt or StoreNum.csv export. added the monthly export path to the setup tab. This will allow the user to modify where the ImportWin.txt or StoreNum.csv export to. Both files export to the same folder. Currently it defaults to C:\program files\previews on windows.

Corrected strip option (strip issue # from Item Description). It was leaving an extra blank after the Item Description.

Online order due date. Fixed switchboard to display the online order due date.

E-mail error msg change. Added user friendly error msg when email error occurs with HTML checkbox selected, but not using Outlook.

Version 1.10

Auto backup. This backup will occur once each day when you close CBPF. If it is left open all night, it will backup at midnight. You’ll notice that closing CBPF takes longer than in the past because it is waiting for the backup to complete. You’ll notice on the status bar at the lower left of the screen when you close CBPF of the backup in progress notification. This backup is optional and must be turned on. There are only two things to do. First, set the number of backups you want to keep. Set to ‘0’ to turn off. Set to ‘-1’ to save all backups. Set to a positive number to keep a specific number of backups before CBPF automatically deletes the oldest backup and saves the new backup. Second, browse to the location where you want them stored. These configurations are on the Setup tab in the Programs section of CBPF.

Adjust the cycle sheet report so that it can show items which have not been received yet.

allow pow and description file to be imported more than once with a message box stating that it’s been previously imported. (previously CBPF didn’t allow the second import of the same file)

used cCur function to convert bag and board price to currency from a variant. Gave an error with UK regional setting if bag/board price was empty.

check that email address is present before sending an email

Add country code in setup tab so UK stores can import the POW file (it is a different format than the US POW file)

use nz function on first/last names when sending email. A blank last name in previous versions would cause an “invalid use of null” error.

Removed extra space at end of “truncate” option (UK users) when importing Previews files the Item Description had an extra space at the end of each title truncated.

Corrected setup Item Descriptions so that it shows what was selected previously instead of resetting back to default.

fixed so that qty (in Monthly Auto Pulls) works for crossover events. Prompts for a qty when adding a crossover event to auto pulls for a customer (default is qty=1).

Retry a record locked error 20 times before aborting the process. This error occurs during a ‘Find Monthly Items’ button.

Version 1.09

Hot-Key changes - You’ll need to check the hot-key help (ctrl-?) on several forms. George (Empire Comics – IN) suggested that I add a re-order hot-key to the crossover events form. I didn’t see the need, but upon asking for justification, he presented a reasonable use. Therefore, instead of simply adding one hot-key, I optimized the hot-key routines so most of the forms use the same routine. This was more time intensive, but as an example, you now can view the description and cycle-sheets forms from within the crossover events and customer forms. A few of the hot-keys needed to be changed for consistency between all the forms. The forms that were changed were the Diamond All, Customer (Items Ordered, Auto Pulls), Reconciliation, and the Crossover Events.

Override weekly pull report - I added a button to the weekly process (I really split button 3 into two). There is now button 3 which builds the report and button 4 which views the report. The reason for this was that I wanted to add a way for a store to override CBPF customer selections. To do this I added button 3a to let you change the decisions made in button 3. There is no need to do this most of the time. It is only needed if the quantity you received for an item doesn’t meet the demand for the item from your customer preorders. This could be due to you not ordering a sufficient quantity or being shorted on your shipment.allow

Import cycle-sheet data - the ability to import cycle-sheet information from a POS system.

Strip Issue Numbers - I added the 'Truncate' ability for the UK stores which removes the issue number (and other stuff) from the Item Description. But for the US (while I was at it), I added the 'Strip' ability for CBPF to strip only the Issue Numbers from the Item Description when they are found. This change is in Programs under the Setup tab.

Cycle-sheet navigation - ability within the cycle sheet form to navigate to the previous/next series on the Diamond All form (or whichever form the cycle sheet was loaded from) without closing and reopening the form. This will speed up cycle sheet entry. Of course getting the Diamond All form filtered and sorted into a good counting order (prior to opening the cycle sheet form) will help also. Added prev/next item and prev/next series buttons within the cycle sheet form.

Order due date reminder - And for those retailers who need to be reminded of the ordering due date, I’ve put a countdown on the switchboard. There is no calculation for this, CBPF must go from Diamonds announced dates. I’ll continue to update these dates each year and when you upgrade CBPF at the end (or beginning) of each year, you’ll get the next years dates.

Vista users – Because of the way Vista handles files within the “program files” directory, the ComicBook Pull File should be installed to a different directory (for Vista users only). The directory I’m suggesting is C:\users\public\public documents\comicbook pull file. However, when installing to a Vista system, you’ll have to choose a custom install and browse to the directory as this directory is not an option under the Microsoft install procedure which I use.

Added these fields (Item Description Front, Series, and All Venders?) to the Reconciliation form and Customer Archive form.

Hot-keys revised in crossover events, Diamond All, Customer form (Items Ordered tab), and Reconciliation form (top and bottom). There is nothing lost but many hot-keys are now available from other forms. A few hot-keys have changed for consistency between forms.

Add ComicBook Pull File website to bottom of each report and “powered by www.comicbookpullfile.com” to the bottom of e-mails.

Added Import capability into the cycle sheet info – Programs>Maintenance>Import…Cycle Sheet Info button. The format is .csv (Item Code (required), Date (required), Inventory Qty, Order Qty, Receive Qty, Held Back Qty)

Import Customer info also. See help system for format and fields.

Import previews update file. Note: Diamond only provides 4 fields (Item Description, Item Code, SRP, Discount Code), so when you import, be aware that there will be many blank fields in the Diamond All form including the Vender field.

Make the Dynamic groupings forms open completely.

Save Setup of Customer form. This will have the customer sort order open in the same order as when it is closed.

Hot key to Requery (alt-Q) and clear (alt-C) on the Diamond All form

On weekly e-mails, added ability to send an attachment to customers (ComicBase or other collector program/spreadsheet). This attachment will allow the customer to import the items which were pulled for them instead of inputting them manually. The title on the import at this time is using Diamond’s Item Description which doesn’t often match ComicBases Titles. The user can match up the item on import though. The attachment option only works if you are using the HTML option for e-mails. This attachment is a comma delimited file with the first row being a header. The fields are Title, Issue#, Quantity.

Cycle Sheet Report – sorted by Date last for showing ordered/recved/inventory in order by history

added Series Code filter on Diamond All form. Checked=must have series code greater than zero. Unchecked=series code is blank or zero, gray=both. This will allow you to filter to see one shots or exclude one shots, or items which aren’t comics.

When updating a record in the Monthly Auto Pulls tab, if the All Covers checkbox is checked, CBPF verifies that the vender # is not blank or zero. If so, a dialog box displays explaining that a series code must be specified to use the All Covers checkbox.

blanking out a Customer credit card would cause an error. Now corrected.

added online order due date to switchboard with a ‘# of days left on JUN07 Previews’ line

Newsletter Only Checkbox - added checkbox beside the e-mail button which is a bypass of sending the items received info. The e-mail sends everything as specified on the e-mail format but not the store receivals or the customer receivals and would only send to those customers who want the newsletter. Prompts for the subject line of the e-mails with a default of ‘Your Newsletter’

Added conditional formatting to Item Description of Reconciliation form (top half) so it is easier to determine if an Auto Pull has conditions (First/Last Issue specified). Also added conditional formatting to bottom half of form (Item Code) when item is Resolicited, or has a Parent Item.

Fixed Weekly Pull Report by Item Description. When receiving back issues at the same time as regular issues, grouping was only by Item Description and so all issues and back issues showed in same group instead of grouping separately. Now grouping by ID & Issue & Item Code.

Technical Features
corrected an error msg in btnBuildWeeklyReport to read “Weekly Download Report Dynamics Grouping form (or Shortage Dynamics Grouping form) error" instead of "'Weekly Download Report - Customer First Name' report not found"

changed logic in archiveAndPull function. Don’t include Issue# in Archive file if item was not found in the Diamond All form.

Ignore write errors to Diamond Recv table because it has referential integrity, but the Comic Pull Issues doesn’t. Therefore items could be marked as sold which are not in Diamond All. This causes a ref integrity error.

Version 1.08

Created a new tab in programs called Utilities. The tab will mainly be for items which don't directly affect CBPF. The first utility to make it to this tab is called Truncate File Names.

This utility was created mainly to allow for quick name modifications for those stores who download the picture files from the Diamond website. An example of the original name might be MAY070154_low_BRAVE_AND_THE_BOLD.jpg whereas the copied name would be MAY070154.jpg when specifying 9 character truncation or MAY070154_lo.jpg with 12 character truncation.

If the truncation would create a duplicate file name, a number beginning with 1 (and incrementing) will be appended to the file name therefore making the file name longer than the specified number of characters. An example would be MAY070154_lo1.jpg for a duplicate of the above file. A second duplicate would be called MAY070154_lo2.jpg. This feature will allow for 100 duplicates.

Added Monthly Auto Pulls form - This form opens in datasheet view and will allow for an easy overview of customers ordering specific items. This is similar to a Monthly Auto Pulls report, but some changes will be allowed from this form. This will allow for quicker bulk changes (e.g. Title changes, Vender # changes, or series ends and you want to remove all Auto Pulls for a title).

Ordered Comics form - Can now be viewed in datasheet view via the new 'Datasheet View' button.

Weekly Shortage/Overage adjustments - Reconcile what you actually received against what the system is expecting you to receive. Shortage corrections (negative Qty’s) are now ignored since the retailer is expected to correct the shortage on the week it happens. Negative numbers (shortages corrected by Diamond) are displayed as white text on a red background. Promotional and 8000 codes show up as red text on a yellow background.

Encrypted Credit Card field. Displays normally on Customer Form, but is encrypted on the hard drive. Uses AES 128-bit encryption method. This is to protect this field from any kind of spyware which might read the hard drive or if the file gets stolen or lost. The field will only be readable from CBPF. No other program (including Microsoft programs such as Excel) will be able to interpret the field.

Edit e-mail list prior to sending the e-mails. This will allow removal of special orders, Adult titles and promotional items from the list of items which the store received if they are sending a weekly store receivals list to customers.

E-mails formatted in Table format if sent in HTML format.

‘Diamond All’ form – made batchNo filter fields to accept 3 (e.g. 036) & 5 (e.g. SEP05) digit formats as well as a 9 character Item code.

Added comment field on reorders table so store can comment about reason for the reorder.

Added "Export to Hard Drive" button with "Include Field Names" checkbox to export the report data to a .CSV file. If you want to know the layout but don’t want the Field Names, export it with the Field Names to see what each field is then do it again without the Field Names. This will allow the data used to generate these reports to be used by other programs (e.g. MS Word, MS Excel, etc.) which can open the .CSV file.
Reports changed to add this function –
A. Cycle Sheet (could be used for customized statistical calculations)
B. Item Pulls
C. Monthly Auto Pulls
D. Weekly Download
E. Phone Book
F. Notables (could be used to generate website data)

Added Total Sold field to Cycle Sheet report. (from cycle sheet form, and from More Reports on switchboard).

Added buttons to view the Error Log File (Front End and Back End files) from the Programs>Maintenance tab>Error Log File buttons

Monthly Auto Pulls report (by Item Description) – removed erroniously placed phone# in header.

Cycle Sheet dynamics grouping form, changed O/A, Res, and Limited Series from on/off checkboxes to tri-state fields. This will allow for "I want/I don't want/I don't care" for all 3 fields.

Removed displaying of the e-mail build process prior to sending the e-mail msg (This displaying was done for Outlook HTML users only).

Fixed date check on button 5 ‘Remove Items Ordered’ to give warning if button is used twice in the same week.

Create a file to upload for Previews online users. POW is still the prefered method because Previews Online can't export the final numbers back to CBPF for cycle-sheet usage.

Version 1.07

Save setup for each computer. (font/color/column width/hidden columns/column order etc). Frozen columns are not saved and restored at this time. This will allow for a computer to make changes to forms which include datasheets (e.g. Diamond All, Customer, Ordered Comics, Pull Archives, etc). When the form is closed, or CBPF is closed the setups are saved, then when the form is reopened, the previous form setup is restored to the way it was when it was closed. If the computer is on a network, each computer has its own setup.

On 'Weekly Pull File' tab, the “Import Weekly File’ button (button 1) checks to verify that buttons 2,3, and 5 are completed for the previous week before proceeding with the import. If they were not completed a message box with a warning message will be displayed asking whether to continue with the import. If the 'No' button is chosen, the user has the chance to complete buttons 2,3, and 5. If 'Yes' is chosen, the import continues.

Notables report. This works like the 'Previews Description' filter on the Diamond All form. On the Diamond All form, you can enter word(s) to be found in the description information. Then only those items which have the word(s) will be displayed in the Diamond All form. The notables report lets you save a list of "notables" (e.g. Alex Ross, Civil War, etc.) (Programs>Maintenance>Notables Report) that match the description information. The report (Reports>Other Reports>Notables Report) will then build a report of those items which match the "notables" that have been saved. This report is intended to inform your customers to items which they may not be aware. It can be filtered by BatchNo so that specific Previews Catalog(s) "notables" can be printed (in an effort to get preorders or special orders). Or the report can be printed by Received Date so that customers can be made aware of new items which you have received which are "notable". This report can be set on your counter or posted on a wall for customers. The report can be filtered by category (e.g. Comics, Posters, etc). If a "notable" is entered in the "notable" field on the dynamic groupings form when preparing to print the report, it will override the saved "notables" and only build the report based on the word(s) in the "notable" field on the dynamic groupings form. The description information can be turned on or off on the report.

Ctrl-z (hot-key) on the Item Description field of the Monthly Auto Pulls tab on the Customer form will cancel a monthly auto pull item and move it to archives. This will allow you to reference past Auto Pulls.

Added HTML e-mails with the requirement of Outlook on the computer. This can be turn on or off in Programs>Setup>Use Outlook E-Mails (HTML). Added e-mail banner field (information above the Customer First Name) on Programs>Maintenance>E-Mail Format. Using the HTML format is more flexible, but takes longer to format. When not using HTML format, links automatically are clickable in the e-mail. But with the HTML format, links must have anchor tags added for them to be clickable. The easiest way to correctly format the HTML is to format the information in an HTML editor (e.g. Dreamweaver, Front Page, MS Word, etc) then copy and paste the HTML from the editor into the appropriate field of the Weekly E-Mail Layout form. HTML is not hard to learn and can really jazz up your e-mail, but is more work and is prone to typographical errors. If you don't know HTML, but are interested in pursuing HTML e-mails, the easiest way to proceed is to acquire an HTML editor and check with high-school and college age customers who may be able to spend a couple of hours with you showing you the basics.

Added buttons (Programs>Setup) to allow modification/maintenance of Brand, Genre, Category, Vender.

Fixed ‘Comment’ field on cycle-sheet form to accept input.

Fixed Acct# sort on weekly download report.

Version 1.06

CBPF BASIC added as a scaled down free version.

Custom filter options on Diamond All form – allow users to build filters, then save them with a specified name. These sorts will be available on the Diamond All form via a drop down box.

Added Total Ordered and Cust% (Cust Qty/Total Ordered) fields to Item Pulls Report by Item. This will help a store determine if reorders need to be made prior to receiving items.

During Build Weekly Report, display Weekly Download Shortage Report (customers who didn’t receive items because of not enough items received).

In ‘Build Weekly Report’ button, eliminated Null errors caused by having blank Qty ordered by customers.

Added Help Section to describe 'Monthly Procedure' of events which recur periodically.

Version 1.05

Changed method of locating Data on hard drive (mainly used if on network, or if Data is physically moved between computers)

The following is designed to allow each customer to have store defined info associated with a customer. This might be an account # from a POS system. Since the fields added do not need to be unique for each customer, it could define subgroups of customers (e.g. Gamer, Comic Reader, Acct# from old pull list system, etc.). If the group has to do with how/when items are delivered to a customer, the delivery method should be used instead.
Added 'User Defined Number' on customer form and changed label of 'Middle Name' to 'Middle (User Defined Text)'. If the info added is numeric only, use the former field. If it contains letters, or letters and numbers, use the later field. Added both fields to Phone book Export and Export of Weekly Pull File Customers.
Added user defined fields on phone book report and added subgroupings to dynamic groupings form..
Added user defined fields on dynamic groupings form on Weekly Download Report. Allows user to create a different sort order for their weekly report and also to match up CBPF with a POS system or old Pull list system account#

Sorted cycle sheet chart by BatchNo then Issue. Previously was just by BatchNo, but weekly comics (e.g. ‘52’ ) would number as 4,3,2,1,8,7,6,5 on the chart instead of 1,2,3,4,5,6,7,8.

Added Dynamic Groupings form to Cycle Sheet Report allowing for more sort and filter options.

Added Dynamic Groupings form to Monthly Auto Pulls Report.

Corrected subgroup by acct# on ‘Item Pulls Report – Advanced Item’ Was sorting as a string instead of a number.

Corrected subgroup by acct# on ‘Weekly Download Report – Advanced Item’ Was sorting as a string instead of a number.

Added subgroup by delivery method on ‘Item Pulls Report’

Version 1.04

Cycle Sheet Updates

• Changed Cycle Sheet Form so that users can open the form for item which have not been received by CBPF. This will let users input cycle sheet data for items received prior to using CBPF.

• colored cycle sheet form field for consistancy with other CBPF fields (Calculated (tan) and Locked (gray))
• Added Received line to cycle sheet chart
• Change Sold line to be Received-Inventory instead of Ordered-Inventory. This will make it so the sold line doesn’t change when more items are ordered but not yet received.
• Added total received and total ordered fields to the cycle sheet form.
• Changed cycle sheet horizontal lines to gray dotted so that charted lines show up better when they are horizontal.

Added additional sort options to the Phone Book Report, Weekly Download Report, and Item Pulls Report.

Warning prompt given when ordering case packed toys or box packed cards. This is determined by a lower Srp than Price. Warning given for zero cost Srp or Price

inserted 0 if Vender POW field is Null in btnFindMonthlyItems_click(). Stops CBPF from getting Null error.

Added file export confirmation which lists the file name and location which is being saved to when “Export to Previews Program” button is pressed.

Exported .csv and .txt (tab delimited) files containing phone book info for customers who received items on the weekly pull list report. This can be used to mail merge labels to print, create custom e-mails, etc.

Added Acct# and Item Description to Detail Box when processing ‘Find Monthly Items’ button to show which record is being processed.

Version 1.03

Line chart added to cycle-sheet form.
Additional fields (O/A, Resolicited, and Parent Item) added to cycle-sheet form.
Additional fields (Resolicited, and O/A) added to cycle-sheet report.
Changed calculation of 'Sell Thru%' on Cycle Sheet report.

Able to add items to Crossover Event from Diamond All form (Ctrl-E).

E-mail items are now sorted by Item Description.

Added right-click shortcut menu to forms.

Cancel Item (Ctrl-Z) on Items Ordered tab fixed.

Version 1.02

Corrected the CD so that users get their 60 FREE trial. The CD erroneously was sent with an expiration date in place instead of using the users system date.

Version 1.01

On the ‘Cycle Sheet’ report – added ‘max issue’ field and allow user to not print items which don’t contain a ‘max issue’ (miniseries)

Added ‘Address 2’ line to ‘Customer’ form.

Infrequently a title which was not found (e.g. alternate covers), would not be in the reconcile form because there were other items which were found but consequently eliminated (e.g. O/A items). Corrected.

Resized ‘Vender’ size in 'Star Items Ordered' tab of Customer form to 30. It now matches the definition as provided by Diamond.

Added ControlTip (Help) Text to buttons, etc.

If a date was not found in the weekly import file from Diamond CBPF would error. Now corrected.

Export ‘Phone Book’ file from ‘maintenance’ tab. Can select .CSV or MS Word Mail Merge format (contains field names).

Added ‘Phone Book Report’

‘Import Order’ button on ‘special’ tab of ‘customer’ form will import both POW export formats. CBPF 1.00 only would import one of the formats.

‘Create Weekly File’ button on ‘special’ tab of ‘customer’ form to mimic the Diamond e-mail file for a specific customer. This is used for multi-store accounts who combine their orders before ordering from Diamond.

Diamond changed the way the Caution fields worked and so CBPF had to change also. The fields are no longer a check box, but now a regular field which contains 0 through 4. If CBPF is not updated to 1.01, the Caution fields will be blank starting in Feb. 2006.

'Monthly Auto Pulls' tab would default the 'Monthly?' field to -1 if the user manually entered a record. Now the default for the field is 'Yes'

Getting a 'Series Code' prompt when pressing ‘Preview Report’ button on the cycle sheet form. Corrected.