PO and AP Invoice Line Allocations

ewood

Hello Everyone,

My client (std. v4.0Sp-1) wants to be able to allocate expenses across departments and projects at the PO and AP Invoice line level. I’ve shown them the Recurring General Journal (balance function) and the Standard Purchase Codes feature. Neither accommodates their needs as eloquently as their predecessor software (Great Plains). They want the allocation to occur upon entry based on a predefined definition (for Type G/L-Account lines). Does anyone know of a way to allocate that I have not thought of, or has anyone heard of an add-on that accomplishes the same?

Thanks.

Savatage

can you explain "predifined definitions".

do you want a vendor to have a default g/l account type of thing?

Alex_Chow

The only closest feature you can use is the Recurring Journal and allocate it by percentage. We have a client that has the same problem, however, we convinced them to use the recurring journal feature to separate the expenses.

Either that or separate the expenses on entry of the purchase invoice.

Another possible way is to modify on posting to automatically separate it into the predefined formulas in the allocation percentages.

ewood

Thank you both for your responses.

Predefined means having the ability to delineate allocation formulas prior to needing them. When an allocation is selected on a PO or invoice line, code would apply the logical steps to spread the amount over the GL and dimensions defined in the allocation. For example, you want to spread utility expenses proportionally over departments that utilize the services.

No, defaulting a GL by vendor would not meet the need.

The allocation feature of Recurring Journals works but the client would prefer to see a line allocation function during invoice entry.

Yes, I can modify to meet the client's need. I was just wondering if someone has already addressed it.

Thank you again.

Savatage

I see now,

The recurring journals have been a life saver for me. It was uncomfortable in the begining, but that feeling went away quickly.
Also found helpful to seperate the Recurring Journals into their own batch names ie. MONTHLY, BI-WEEKLY, QUARTERLY.

This reminds me of a discussion a while back that a customer was familiar with their old system that they want Navision to be just like it.

And they wanted everything modified to be like the old system instead of simply learning the new system.

After a few months they will know Navision and how it works just as well.

But if they are willing to pay for mods then.... =P~
but they are not always right
http://www.mibuso.com/forum/viewtopic.php?t=10303