Purpose
Setup default values and GL account assignments for various aspects of your business.
Procedure
First, you must make sure the GL accounts you need are already setup under GL Accounts. Then, using the drop-down lists, assign the GL accounts you want used by default for:
- General GL Accounts
- Customers & Sales (Shipping and Handling)
- Customers & Sales Defaults
- Suppliers and Purchasing Defaults (See: Suppliers)
- Items Defaults (See: Item Categories and Items)
Other Defaults you will need to set up are:
- Past Due interval - Number of days between each past-due periods. A value of 30 is typical for most companies. (ie, 1-30 (first period), 31-60 (second period), 61-90 (third period), etc)
- Default Credit Limit - Default credit limit for new accounts. (See: Add and Manager Customers)
- Legal Text on Invoice - Any legal text, like terms and interest charges for overdue payments, which you want included on all invoices.
- Deliveries Required by - Number of days by which a sales order is considered overdue for shipping.
- Dimensions Required by - Number of days by which a dimension is considered overdue.
- Delivery/Invoice Allowance - Percentage by which you allow for deviation in pricing.
- Allow Negative Inventory - Allow inventory to have a negative value. See the tips and tricks below for more information.
- Work Order Required by - Number of days to allow for manufacturing of items.
Tips and Tricks
The problems with the Allow Negative Stock has earlier set the Average Material Cost to 0 when stock went below 0. This was due to the insecurity about which prices to use during the 'negative' period. We have now fixed this, from release 2.2.6, so it works almost like in Oracle and QuickBooks. The Average Material Cost still stays there from the last transactions before the stock went below 0. This value is used when delivering items. When a PO arrives or an Item Adjustment is done, the average material cost is now based on this new value until the stock again is above 0. The GL Inventory/COGS accounts are adjusted to the correct prices for deliveries during the 'negative' period. A Cost Update is done in the background. Then, when stock is above 0, the normal algorithms works as before.
If you have the Allow negative stocks marked, you can set the Standard Costs for new items, even if there is no stock in there yet. This value will be used during deliveries. When the correct prices are there, the GL accounts are updated just as before. But doing this will help you getting an estimated COGS. If you don't enter the Standard Cost, you will have to wait with COGS until there are better prices available (when entering POs or Item Adjustments).
Notes:
- The account set in Retained Earnings field must be Liabilities class. It is used to generate a posting during fiscal year closure.
- The account set in Profit/Loss Year field must be Expense class. It is also used to generate a posting during fiscal year closure.