Planning/Budgeting Cycle

HsinChuMark

Hi All,

how can I set up an entire planning/budgeting cycle in NAV? I.e. I would like to enter item sales per customer, item, period, then enter production costs, raw material costs, overhead and so on and finally get a trial balance/business plan or at least a CoGS plan. Ultimately multiple budget variant would have to be compared...

I know there are sales budgets, purchasing budgets and depreciation budget, but no manufacturing/cost one. Then I need to link those. Is this possible?

Thanks in advance!

Miklos_Hollender

Budgeting/planning isn't very well implemented in the standard system. You could try to enter sales at a gross level (per item per month or something like that) to Forecasts, pull that to Planning Worksheets, and writing some reports that sum up the costs from BOMs and Routings. But that has nothing to do with sales revenue.

Sales and cost can together be planned at G/L budget level, but these are just gross figures somebody pulls out of his a... khm., , I mean, just entered there as a total number no integration with manufacturing.

Or a sales plan at Sales Budgets on Customer/Item level but no integration with either G/L budgets for planning the overhead or with manufacturing for planning the COGS.

Yes, it is bad, but I think there might be a couple of add-ons that address it: http://download.microsoft.com/download/ ... dd-ons.pdf

Or a custom development - basically, a bunch of batch jobs that take the sales budgets, sum them up and write into a g/l budget, take Planning Worksheet, sum up BOMS and Routing and write that to G/L Budgets etc.

Also, I have a guess that this might be the reason Jet Reports is so popular - because I think it makes planning possible. I mean pulling BOM/Routing Costs from Planning Worksheet to one Excel sheet, Sales Budgets to another Excel sheet, overhead from G/L Budgets to yet another Excel sheet, adding them together at a fourth Excel sheet etc.

HsinChuMark

Thanks for your reply, Miklos!

The revenue problem is actually solved, we import the data from our proprietary CRM system into NAV (item quantities and prices per customer and period). But then....

"...basically, a bunch of batch jobs that take the sales budgets, sum them up and write into a g/l budget, take Planning Worksheet, sum up BOMS and Routing and write that to G/L Budgets etc. "

Yeah, that's what I am actually looking for, and that's how I was taught in acctg. school... Has anybody ever done that in NAV? How is this being carried out in other companies?

I could not find something like that in the add-on-file (which is very helpful btw, thanks!). To date we are using Excel, but it's cumbersome to change budgets or define variants this way. Let alone drilling-down or master data retrieval...

Further help much appreciated!