The Property module, located in the Setup group, displays properties that allow Fishbowl to be customized. Most properties can be set in the applicable Module Options. Because Module Options are more user-friendly, and it is less likely that a mistake will be made, modifications should only be made in the property module if they cannot be made in the Module Options.
Below are some of the property changes that can be made within Fishbowl. Many properties are already stored in the Property module search pane. We do not recommend modifying properties unless absolutely necessary. For questions or concerns, please contact support at 1-800-774-7085 ext 3 or email supportfishbowlinventory.com
|REPORT_DATE_FORMAT||MM/dd/yyyy||This property is used to modify how dates are formatted in reports. This property can also be set in the Reports module options.|
|REPORT_DECIMAL_COST||$ #,##0.00||This property is used to modify how costs are formatted in reports. This property can also be set in the Reports module options.|
|REPORT_DECIMAL_PRICE||$ #,##0.00||This property is used to modify how prices are formatted in reports. This property can also be set in the Reports module options.|
|REPORT_DECIMAL_QTY||#,##0.#####||This property is used to modify how quantities are formatted in reports. This property can also be set in the Reports module options.|
|Estimate Title||string||This property changes the title of an SO Estimate to whatever is in the value field.|
|Commit each import line||true||This Property will commit each line of an import as Fishbowl reads each line of a CSV import|
|Update Carton Costs||false||This Property will not allow carton costs to be sent back to Fishbowl after UPS/FedEx Export if customer doesn't want individual shipping costs to go to QuickBooks as a Bill to UPS or FedEx.|
|Acct Last Sync Time Accounts||Wed Jan 10 09:19:18 MST 2019||If this property is deleted, Fishbowl will look to QuickBooks for new changes in Accounts.|
|Show Available in WO||false||This will not scan all of the open work orders and available inventory.|
Note: This is useful for customers with a LOT of open Work Orders.
|InsuffInvCommittedOnly||true||This will set the Insufficient Inventory dialog to show up when the "On Hand" - "Committed" is less than the desired amount. Default is if the "Available" is less than the desired amount.|
|AlwaysSetToBeEmailed||true||Setting this will always set the "ToBeEmailed" attribute on an Invoice, Sales Receipt and/or Credit Memos in QuickBooks. If this is set to true, the customer referenced in the transaction will be checked for a valid email address. If there is no valid email address, the request will fail so Fishbowl won't try to set it. If there is a valid email address currently in QuickBooks for the customer, and the request succeeds, the transaction will be added to the QuickBooks list of forms to be emailed, possibly in a batch. The Accounting Integration module options also has an option to check the "To be Emailed" option on the QuickBooks Invoice.|
|Create Bill on Reconcile||true||Setting this will cause Fishbowl to create a Bill in QuickBooks after Reconciling a Purchase Order. Normally, Fishbowl will not create the Bill in QuickBooks until inventory has been received. But some customers have to pre-pay their vendors before shipment is made.|
|Acct Update CV on fly||true||If set to true Fishbowl will update Customers and Vendors immediately (without waiting for an QuickBooks Export). Default behavior is to wait until an Export before updating Customer/Vendor information.|
|AlwaysExportManufSummary||true||If set to true Fishbowl will export all of the accounting details of a manufacturing event to QuickBooks. This means the journal entries for each event will contain an entry for every raw/finished good consumed/created. Normally, Fishbowl will summarize the event in an effort to reduce the size of the QuickBooks file.|
|AlwaysExportOrderSummary||true||If set to true Fishbowl will export all of the accounting details of a Invoice, Sales Receipt or Credit Memo (Refund) event to QuickBooks. This means the journal entries for each event will contain an entry for every raw/finished good consumed/created. Normally, Fishbowl will summarize the event in an effort to reduce the size of the QuickBooks file.|
|addCustomerRefToInventoryJE||true||If set to true, Fishbowl will set the Customer reference in all Journal Entries so they can be tracked by Customer. Normally this is off. The Accounting Integration module options also has an option to add customer references to inventory journal entries.|
|ExportSONumToOther||true||If set to true, Fishbowl will put the Fishbowl Sales Order Number into the 'Other' field in QuickBooks for Invoices, Sales Receipts and Credit Memos. This is enabled by default.|
|ExportFBOrderNumToAcctOrderNum||true||If set to true, Fishbowl will set the Fishbowl Sales Order Number as the 'Reference Number' field in QuickBooks for Invoices, Sales Receipts and Credit Memos. This is an attempt to make Fishbowl Sales Order numbers match up with QuickBooks Invoice numbers. This is disabled by default. Though requested by a lot of customers this is not always practical. QuickBooks itself does not try to insure matching order numbers between its Sales Orders and their Invoices. The problem occurs when an Invoice is created inside of QuickBooks for non-inventory purposes thereby using the next order number. Afterwards, Fishbowl will create a Sales Order using the same order number. When Exporting to QB, Fishbowl will try to create the Invoice using the same order number in Fishbowl only to find that there is already an Invoice with that number in QB. This is why we don't do this by default and why we put the order number in QuickBooks' memo field.|
|UseCustomerDefSalesman||true||If set to true, Fishbowl will always use the Customer's default salesperson when creating sales orders. The Sales Order module options also have an option to default the salesperson field to the customer’s default salesperson.|
|Check BOM Items||true||If set to true, Fishbowl will check all BOM items to make sure a product can be produced as the parent product (part) is entered onto a Sales Order. By default this is disabled so that the inventory check is faster.|
|DateFormatLong||MMMM dd, yyyy||Changing date formats can cause issues as it does not change things like database formatting and CSV import dates.|
|DateFormatMedium||MMM d, yyyy||Changing date formats can cause issues as it does not change things like database formatting and CSV import dates.|
|DateFormatShort||MM/dd/yyyy||Changing date formats can cause issues as it does not change things like database formatting and CSV import dates.|
|DateFormatTimestamp||EEEE MMM dd, yyyy h:mma|
The following properties can be used for any of the Master shopping cart plugins.
|PLUGIN_SHOW_ADVANCED_OPTIONS||boolean||If set to true, Advanced Options will be displayed in the schedule panel for each master plugin task allowing the user to run the task for a targeted ID or timeframe.|
|PLUGIN_SHOW_TABLE_RESET||boolean||If set to true, a Table Reset button will be displayed under all the mapping tables throughout the plugin settings that allow the user to clear the current mappings and reset the required rows.|
|PLUGIN_INV_MULTI_LOCATION||boolean||If set to true, in the Inventory Update settings the user will be allowed to map the same Fishbowl Location Group to multiple locations in the shopping cart. This functionality is toggled through a system property due to the potential to allow overselling in the shopping cart.|
|PLUGIN_FIELD_MAP_LINK_PRIORITY||boolean||If set to true, the Order Import - Order Item Settings "Enable Order Import Product Linking" will cause standard channel ID linking to be ignored and use the order item linking instead.|
|[CHANNEL]_[SCHEDULE CODE]_OFFSET||int||Allows the user to define a number of hours that the last sync date will be offset back by channel and schedule.
For example, to offset Shopify's order import by 24 hours the following property would be created:
See the Channel and Schedule Code lists below for the channel name and schedule code values that can be used to build an offset property name.
Schedule Name - Schedule Code