SQL SCRIPT TO PUT AP INVOICES ON HOLD

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi all,

I've looked everywhere for a sql script that can put a list of invoices (about 2000 of them) on hold, but couldn't find any. This is on GP 10. Any help would be greatly appreciated.

Odiop

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Almas Mahfooz 11,006 User Group Leader on at

Like (0)

Report

RE: SQL SCRIPT TO PUT AP INVOICES ON HOLD

diop, since it's not that complicated thing and required any accounting related thing , in my view YES you can do it through SQL. I have done this before for our clients and it's not that difficult, also if you know how to use eConnect you can also use it to put invoices on hold if you don't want to do it with custom SQL script. check SOPProcessHoldType <taSopUpdateCreateProcessHold>* schema reference.
L Vail 65,271 on at

Like (0)

Report

RE: SQL SCRIPT TO PUT AP INVOICES ON HOLD

Hi,

I am in agreement with Kirk. You can speed up the import to at least twice as fast by using the Advanced Macro menu tool named Status and marking the box 'No User Interface flash'

Kind regards,

Leslie
Suggested answer

KirkLivermont 5,985 on at

Like (0)

Report

RE: SQL SCRIPT TO PUT AP INVOICES ON HOLD

Odiop,

It normally isn't recommended to make changes like this directly via SQL though it is possible.

I recommend using a mail merged macro to accomplish this instead. Using this method the GP application validates the input and is less likely to cause unexpected repercussions down the road.

Best regards,

Kirk