Changing the job number is not hard. Just use DFDM and go into edit ARN. However since this involves Job Cost and postings there you might have to do a credit to cancel the invoice and then re-invoice with the correct job number.
Well, I can use the DFDM, but I certainly don't want to tell my AR clerk to play with that.
Hey, maybe a VI Job that conforms to the existing primary keys in the AR record, just replaces the Job number, so the clerks can't do any real damage? I will give that a try.
Thanks,
ChaZ
There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
Here is your real issue. While you can edit the field in ARN what about the data in Job Cost? if billing data was posted to the wrong job in Job Cost how are you going to correct that. That is why I suggested issuing a credit to basically reverse the transaction and then re-invoicing with the correct job number.
That is a good point, but it doesn't really apply to my set up. I purge the jobs, but each job being unique, I look back at history from A/R , A/P , P/R to review and just ignore Job Cost data.
So for me, this will work, but you are right, any other environment this would be a problem.
Thank you,
ChaZ
There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
How many invoices do you have? If it is just one or two just DFDM but it is a large quantity you can use VI. Just have the keys plus this one field. On the validation tab remove all validation enteries except for the ones for the keys and the one field.
Right now, I have 3 to fix. The system is bizzarre.
I built an external invoicing module (We needed to do this) that peeks into mas, and when everything is done, it pokes the invoice into mas. I have noticed that sometimes we use the incorrect job number. Not huge, but want to be able to correct it, with out requireing that I do it, and I would not like to see our A/R folks playing with DFDM because though bright they are, they are not techie type people.
Either way, I built the VI job and it functions so I am good.
I appreciate your help,
ChaZ
There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.