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
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.
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...
Sohail Ahmed
2
mmv
2
Amol Salvi
2