Property

From Fishbowl

(Redirected from User Manual:Property)
Jump to: navigation, search

Icon.Property.png 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. If you have questions or concerns please contact support at 1-800-774-7085 ext 3 or email supportEmail.png

Property Value Description
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 Small.Reports.png 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 Small.Reports.png 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 Small.Reports.png 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 Small.Reports.png 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 2015 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 your 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 Small.Accounting.png Accounting 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 Small.Accounting.png Accounting 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 Small.Sales Order.png 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.
Personal tools
Namespaces
Variants
Actions
Navigation
Other Pages
Toolbox
Print/export
Translate