Product Category Warehouse

REQUIRED FIELDS FOR PRODUCT CATEGORY WAREHOUSE

Product Category Id (created in System Element Setup)

Warehouse Id (created in Inventory - Warehouse)

Process:

When a product category is created the system will automatically assign it to all warehouses in the system.  You will need to assign the GL accounts to the fields displayed if applicable.  The main page displays information about warehouse and product categories set up by the food bank administrator. The information displayed relates to how items will post to the GL accounts. If the food bank has more than one warehouse then different products, costs of good sold and service fees may be credited to different GL accounts.

Definitions:

Product Category ID Select from the drop-down menu.  These are the product categories set up by your food bank administrator.

Warehouse ID Select the warehouse from the drop-down menu.  This is just the warehouses(s).

Service Fee Account ID Select the GL bank account for the service fees. This is the income account for your shared maintenance account not the A/R account.

Sales Account ID Select the GL bank account for sales. This is the GL account for any sales income from any orders that have a cost for the product other than Shared Maintenance.

Inventory Account ID Select the GL account for inventory.  This is your inventory accounts you may have different GL's for Donated, Purchased and Federal, of course you can break those down further if you are tracking CSFP, USDA, TEFAP instead of a lump amount.

COGS Account ID Select the GL account for cost of goods sold.

Accrued AP/ Donated Revenue Select the GL account for the accrued payables, that is, any products that are sold to agencies that had a cost to the food bank. If it is a donated product you'll need to select some time of GL to recognize in-kind donations/ donated food income/ Programs Income type of account.