Projects Module questions related to Budgets and Cash Management

Business Central/NAV
1

Hey everyone,

Can someone steer me in the right direction on whether these are native in Business Central, and if so where can I locate them specifically? Some I know are not possible because I’ve been investigating on my own but I want to double check with my peers. Going to be working through the weekend to figure these out:

**Projects (Jobs)
Budgets Related
**

  • The recording of actual expenses (Would this be through the G/L Journal? Can I tie it to the project somehow?
  • Budget revision and traceability - Would BC be able to allow me to copy or revise a budget? Somehow being able to keep a full revision history? Or should I just export the budget from excel?
  • Alerts on budget busts - When a budget goes over the allocated amount would that have to be through a custom workflow?

Cash Management related

  1. Tracking of cash inflows and outflows by company and project
  2. Cash flow forecasts based on contracts and purchase orders
  3. Alerts for critical cash thresholds (this would require a workflow correct me if I’m wrong, if even possible)

Quite the questions. Will continue working on my side in the meantime to figure what I can out. Thanks team

2

Archiving the project will allow you to capture what the budget looked like at a point in time. You can set up auto archiving as well. Archive projects | Microsoft Learn

1 Like
3

The Project G/L Journal can be used for expenses. Purchase orders can also reference the project and expense upon completion.

4

· The recording of actual expenses (Would this be through the G/L Journal? Can I tie it to the project somehow?

    • Yes- Project Module can be used for this

· Variance reports (planned vs. actual). This has to be available, right? We don’t have to create it from scratch, I’m assuming

    • Yes report exists named Project Actual to Budget

· Budget revision and traceability: Would BC be able to allow me to copy or revise a budget? Somehow, being able to keep a full revision history? Or should I just export the budget from Excel?

    • Yes, it can be revised

    • Revision history can be tracked by creating Multiple Budget Names

· Alerts on budget busts, when a budget goes over the allocated amount, would that have to be through a custom workflow?

    • Through Custom development

Cash Management related

  1. Tracking of cash inflows and outflows by company and project

    1. Tracking inflows and Outflows by Compony is available

    2. Tracking Inflows and Outflows by Project is partially available, The Project Dimension needs to be entered before receiving and Paying money then report needs to be generated for the same from the General Ledger Module

  2. Cash flow forecasts based on contracts and purchase orders

    1. Yes Cash Flow forecast The function is available based on Purchase Orders, Sales Orders, Purchase Invoices and Sales Invoices

  3. Alerts for critical cash thresholds (this would require a workflow, correct me if I’m wrong, if even possible)

    1. This seems to be a Custom Development and not the workflow