Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

AR Invoice already posted

Status
Not open for further replies.

Blorf

Programmer
Dec 30, 2003
1,608
US
Hi.

Is it possible, and if so how please, to change the Job number on an AR Invoice, using Mas 200 V 3.71

Thanks,
ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
 
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.
 
Hi.

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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top