Allocation Function/Set up

(0) Share

Report

Posted on by Community Member

I can't seem to find any sort of online help/tutorials regarding allocation functions outside of the basic recurring journal allocation. (Which to my knowledge is limited to percentage, quantity, and amount.) My company is hoping to do the two tasks below, does anyone know of a manual or helpful video to walk us through the allocation functionality? (preferably for NAV 2009, but I'll take whatever help I can get if it's for a more recent version).

-set up expense allocations based on sales activity and/or item shipments

-set up monthly allocations of the balance of an account, versus allocating each individual transaction

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

Could you download the relevant balances/activity each period into an Excel spreadsheet, which would have the allocation formulas you would want to use, then upload a JE from the Excel spreadsheet?

We have many JE templates set up for recurring entries where the account selection remains the same, but the amounts change (payroll is one example), that we just upload on a weekly basis. Formulas determine amounts, and posting dates.

Just another example of a workaround needed if you want to use the antique NAV in real life. I think I'll crank up my Model T now and take it out on the highway...

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report
Copy link

Link copied!

Check below links :

www.archerpoint.com/.../microsoft-dynamics-nav-2013r2-creating-recurring-general-journals

msdn.microsoft.com/.../hh167341(v=nav.90).aspx

Was this reply helpful? Yes No
Jens Glathe 6,092 on at

Like (0)

Report
Copy link

Link copied!

Hehe... ;) NAV isn't antique, it is UX-optimized. To the point of getting useless for real work, sadly.

Regarding these examples: They sound like cost accounting to me. If you don't want to use the CA module, Raokman's workaround is the best choice. How you get the sales activity / item shipments out to CA as a usable reference unit is another matter, though.

Was this reply helpful? Yes No