Update allocation accounts

(0) Share

Report

Posted on by painterisaac

3,015

I have the destination edit mode set to insert and update and it keeps producing an error. The error says that the account already exists. Shouldn't insert and update disregard this? How do I get around it? I have hundreds of accounts that need the percentages updated and it would be extremely cumbersome to go and delete each account just so it can be updated.

Any help would be appreciated. Thanks!

*This post is locked for comments

All responses (2)

Answers (1)

Verified answer

painterisaac 3,015 on at

Like (0)

Report

Re: Update allocation accounts

Nope, we haven't. Only because we had never heard of one before. Thank you for the advice though. For future people looking into this here is a good walk-through as to what a mail-merge macro is:

blogs.msdn.com/.../how-to-use-word-mail-merge-and-macros-to-import-data.aspx
Dan Liebl 7,320 on at

Like (0)

Report

Re: Update allocation accounts

Have you given consideration to using a mail-merge macro? Works for updating many other windows/tables...

Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com