Inventory Reporting
Big Business provides a number of ways to report inventory:
• Item Status - get current counts and values that represent all transactions
• Inventory Sales Analysis - get counts and values for past periods and transactions
• By Warehouse - get counts per warehouse
• Count Sheets - print a list for counting
• Export - export to a spreadsheet or other system for counting or coordinating
.
Folder Validation
Folder Connect lets you set an online folder to check for import files for automatic processing.
To avoid problems you can choose a File Kind like ".txt" for text files to skip non-matching files that could cause problems.
To further validate matching files, you can enter a test in Validation, like "OrderNumber=@" to only process files contain an OrderNumber entry.
(7151)
Chapter 65 Units
Big Business includes options for Units of Measure, including:
• Abbreviations for units of measure
• Counts for each item's units of measure
• automatic conversion of Price and Quantity
(7152)
Units on Imports
Big Business includes Fields on Imports for Units of Measure:
• UoM Abbrev. - abbreviation for unit of measure
• UoM Count - count for unit of measure
• UoM Qty - quantity for unit of measure
• UoM Price - price for unit of measure
This Solution describes using Units on Imports. (7154)
When you are mapping an import, like an Order Import, and you have Units of Measure features enabled, you will have additional Fields for import including:
• UoM Abbrev. - abbreviation for unit of measure
• UoM Count - count for unit of measure
• UoM Qty - quantity for unit of measure
• UoM Price - price for unit of measure
These work the same as the Fields on an Order. If you map data like CS, for case, to UoM Abbrev., the import will look for a matching entry on the item, like Soda Pop, to see if it comes in a case (CS) and if it does, fill in the Count (24/case). If you also map data like 1 for UoM Qty, this will order 1 CS, which is 24 Soda Pops.
If a customer is sending you the data and they want a 6-pack of Soda Pop, they may have a different Abbreviation than yours. They may send PK which standard for pack, but suppose you use 6P for six pack and 12P for twelve pack. In this case, you can import UoM Count and Big Business will find the match. If they send 1, PK, (of) 6 and you import 1 to UoM Qty and 6 to UoM Count, this will order 1 6P, which is 6 Soda Pops.
To simplify this for you customer, you can also add Part Numbers (SodaPop-24) that automatically set the UoM Count (24) so they can order 1 of Part Number, SodaPop-24, and this will order 1 CS, which is 24 Soda Pops. Part Numbers can also set their Price.
Customer Price
Customer Price is an option for Part Numbers that helps you manange part numbers for specific customers to automate pricing and preset purchase quantities.
Customer Part Numbers helps you manange part numbers for specific customers, to:
• automate orders
• simplify invoices
• provide a custom catalog
• map a static catalog to changing products
To assign a Customer or Customer Group to
To enable Customer Part Numbers:
1. Go to the Company Card to the Advanced tab.
2. Click the checkbox for Enable Customer Part Numbers.
3. Click OK to save changes.
You must restart Big Business Clients for this change to take effect.
Customer UoM Count
Customer UoM Count is an option for Part Numbers that helps you manange part numbers for specific customers to include purchase quantities.
This option is designed to work with Units of Measure.
Part Numbers helps you manange part numbers for specific customers, to:
• automate orders
• simplify invoices
• provide a custom catalog
• map a static catalog to changing products
To assign a Customer or Customer Group to
To enable Customer Part Numbers:
1. Go to the Company Card to the Advanced tab.
2. Click the checkbox for Enable Customer Part Numbers.
3. Click OK to save changes.
You must restart Big Business Clients for this change to take effect.
Alert Notes
Big Business can send you a Note with system alerts from automatic operations like Folder Connect. Just fill in Send Notifications To in the settings for any connection.
In the picture, Folder Connect is importing files from an online folder and getting alerts for Check Customer PO (6306) and Reported (6524), every two minutes.
This Solution provides tips for handling these.
You can use the Notes tool to search for Notes that have been sent to you by a tool like Folder Connect or contain the name for a setup like "test profile".
You can click Add (+) to add a column like Note to the Notes List window.
You can Select All, in the Edit menu or by typing Command-A, and then Delete by clicking the Delete button and responding to the confirmation dialog.
You can also look up the entries to see what they mean. Go to: https://bigbusiness.com/help/
and type in the number, 6306 or 6524, to see these write-ups.
To save you the trip:
• Check Customer PO (6306) means you have duplicate PO checking turned on
• Reported (6524) means some subroutine sent its own error [-9935]
The latter is a real error you can pass on to support@bigbusiness.com to find out more. Double-clicking that line opens the Note with the -9935 error and its text, "file not valid".
MySQL Keys
Big Business 12.25 added new Order Tracking and Shipping Status. These can cause an error in MySQL, used for Shipping Connect, when it attempts to create Keys. Big Business 12.29 fixes this problem.
(7158)