Background
Munson's Pickles and Preserves Farm grows and distributes produce, jellies, and jams. The company's corporate headquarters is located in Dallas, TX. Munson's has one operations center and seven regional distribution centers in the United States.
The company has two wholly owned subsidiaries that operate in Canada. The Canadian entity owns an entity in France.
Munson's plans to expand into Latin America by purchasing the last 25 percent of a subsidiary that they own in Costa Rica. This process is expected to complete within the next two years.
The company plans to implement Dynamics 365 Finance and Dynamics 365 Supply Chain to meet their growing business needs.
Current environment. General
Munson's uses a mix of internally-developed legacy systems that handle their finance and distribution activities. The company has an isolated CRM system.
1. Both Canadian subsidiaries have two departments: marketing and operations.
2. Financial reporting is difficult due to data residing in disparate systems.
3. Financial reporting is currently performed by using Microsoft Excel.
4. Pre-orders in the current system are difficult to track because the order management system is not integrated with the finance system.
5. Pickle sales post to one revenue account, but this does not allow for targeted reporting by pickle cut and type.
Current environment. Organization
The following chart shows Accounting/Reporting Currencies and Tax ID, if applicable.
1. Typically, vendor invoices are received prior to receipt of product.
2. The following fixed assets are sold for a loss:
2.1. BUILD-100
2.2. CAR-1233
3. At the regional distribution centers, the value for physical inventory does not match the inventory in the financial system.
4. Munson's rents their corporate office. Rent is not paid by purchase order. Rent is due once a quarter.
5. Allocations are performed manually.
6. Barrels are inventoried by site and warehouse.
7. Munson's has multiple depreciation and tax books for all of their fixed asset equipment.
8. Budgets are posted at the department level for each legal entity.
Requirements. Sales
1. Customers should be able to pre-order for fall release of pickles.
2. Three-way matching must be enforced for all purchases.
3. Fixed asset sale transactions require a ledger account entered at the time of transaction.
4. Fixed assets purchased must be automatically created in fixed asset module. This includes inventory items and write in purchase orders/non-inventoried items.
5. One dollar from every sale needs must be tracked and donated at the end of each month to a charitable organization.
6. Purchasing budgets must be enforced at the main account level.
Requirements. Finance
1. Accounts payable must be able to enter vendor invoices on the day they were received to be settled against when product is received.
2. Accounts payable must be able to enter vendor invoices to accrue expense without specifying a purchase order at the time of entry.
3. Postage expenses must be split evenly across the regional distribution centers automatically.
4. Administrative expenses must be distributed across the regional distribution centers by percentage of fulfillment orders monthly.
5. Pickling machines depreciation must be uniquely recorded for visibility but not post to the ledger.
Issues
1. During implementation testing, User1 indicates that after packing slips are generated for purchase orders, there are no ledger postings.
2. User2 indicates that fixed assets purchased on a purchase order do not show up in the Fixed Assets module.
3. User3 reports that they are seeing inconsistent application of the one-dollar donation from all sales orders.
4. User4 in the Canadian subsidiary is able to purchase supplies for marketing despite exceeding the marketing department budget.
5. User5 reports that when purchasing a non-inventoried computer, the system is automatically assigning it to the buildings fixed asset group.