Sage 100

Isn't there an AP utility to clear invoice entry transfers as there is to clear AR cash receipts payments applied? Customer's server rebooted and the transfers that were applied can no longer be applied. Thanks!!

Not AR open invoice but AP.

No, for credit card vendors where you can transfer an invoice from one vendor to the cc vendor.

Transfers? I'm not sure I understand, is the AP to AR clearing or something else?

ya i had misread that, AP i normally just manually clear the payed today flag but maybe?

It was a huge batch and I don't want to manually do it myself! There HAS to be a utility!!!

Yes, that would be a pain to do manually, can you export/import to reset the flag?

Reinitialize the Check Header and Check Detail files - I think that did it for me once. (The data entry files)

Beth has the better idea, reinitialize.

it is possible to VI to AP_openinvoice however use that at your own risk i'd say.

As @BethBowers indicated Reinitializing the Check Header and Detail automatically clears the paid today flag for all AP records. That assumes the same flag is used for transfers.

This isn't from a check entry though, it is through AP invoice data entry where you transfer from one vendor to another. That also causes the Paid Today flag to change to Y. I ran a Crystal report and there were 30 invoices which I manually cleared through DFDM. @BethBowers are you saying if I had reinitialized the check printing, that would automatically clear ALL paid today flags?? Geez....

@ThereseLogeais , I do believe this is the case.

Well, now I know! Thanks @LarryBradford and @BethBowers !

Sage works in mysterious ways... To paraphrase what the Mother Superior said - ""When a reseller is blocked at the front door, a 90Minder will show you the back way in""......

lol...

You know, I remember that for AR Cash Receipts - if you reinitialize the d/e files, it clears the payment today flag. Why I didn't think of that for this, I don't know. Oh, yes I do - I knew I could just ask it here and someone would come through!! Yay!!!

Reinitializing the AP Check Entry Detail is the easiest but if you can't other methods available is to use VI into the AP_OpenInvoice. , Also if you are in Premium you can run a query that set the flag to N. I have done both ways.

AR Cash Receipts now has the ARWAR4 utility. AP doesn't have a utility yet. It's just the reinit trick.

We had a customer reinit a check history file by mistake (oops!), and I'm looking into a potential button script as a better method (to be run from AP Invoice History Inquiry).
Everything seems to work (open a new object, SetKey, SetValue...) but when I try to Write, it fails.  LastError: "You do not have security rights to modify the record."

I'd expect that if I was trying to update AP_InvoiceHistoryHeader (because I'm in an Inquiry screen), but I opened a new object using AP_OpenInvoice_bus.  Full role permissions.  Am I missing something?  Can I not update a different table via script from an Inquiry screen?
@Alnoor Cassim
​

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 08-06-2018 10:30
From: Robert Wood
Subject: Isn't there an AP utility to clear invoice entry t

AR Cash Receipts now has the ARWAR4 utility. AP doesn't have a utility yet. It's just the reinit trick.

Hey Kevin - No you cannot run that type of script from an Inquiry screen. It's a complaint of mine too. But if you make it a BOI button instead you should be good to go.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA
------------------------------

Original Message:
Sent: 01-07-2020 13:29
From: Kevin Moyes
Subject: Isn't there an AP utility to clear invoice entry t

We had a customer reinit a check history file by mistake (oops!), and I'm looking into a potential button script as a better method (to be run from AP Invoice History Inquiry).
Everything seems to work (open a new object, SetKey, SetValue...) but when I try to Write, it fails.  LastError: "You do not have security rights to modify the record."

I'd expect that if I was trying to update AP_InvoiceHistoryHeader (because I'm in an Inquiry screen), but I opened a new object using AP_OpenInvoice_bus.  Full role permissions.  Am I missing something?  Can I not update a different table via script from an Inquiry screen?
@Alnoor Cassim
​

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------


Original Message:
Sent: 08-06-2018 10:30
From: Robert Wood
Subject: Isn't there an AP utility to clear invoice entry t

AR Cash Receipts now has the ARWAR4 utility. AP doesn't have a utility yet. It's just the reinit trick.

Thanks Alnoor. 
That is not what I wanted to hear, but good to know it isn't just me.

What do you mean by "make it a BOI button"?

(I'm thinking a button on Vendor Maintenance might work too... but I'll have to add a browse filter and loop).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 01-07-2020 18:38
From: Alnoor Cassim
Subject: Isn't there an AP utility to clear invoice entry t

Hey Kevin - No you cannot run that type of script from an Inquiry screen. It's a complaint of mine too. But if you make it a BOI button instead you should be good to go.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA
------------------------------


Original Message:
Sent: 01-07-2020 13:29
From: Kevin Moyes
Subject: Isn't there an AP utility to clear invoice entry t

We had a customer reinit a check history file by mistake (oops!), and I'm looking into a potential button script as a better method (to be run from AP Invoice History Inquiry).
Everything seems to work (open a new object, SetKey, SetValue...) but when I try to Write, it fails.  LastError: "You do not have security rights to modify the record."

I'd expect that if I was trying to update AP_InvoiceHistoryHeader (because I'm in an Inquiry screen), but I opened a new object using AP_OpenInvoice_bus.  Full role permissions.  Am I missing something?  Can I not update a different table via script from an Inquiry screen?
@Alnoor Cassim
​

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON


Original Message:
Sent: 08-06-2018 10:30
From: Robert Wood
Subject: Isn't there an AP utility to clear invoice entry t

AR Cash Receipts now has the ARWAR4 utility. AP doesn't have a utility yet. It's just the reinit trick.

Oh, and if anyone wants to give Sage a nudge for a utility, I posted something on Sage City (Partners)...
User friendly fix for AP Paid Today flag reset (KB 18024)

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 01-08-2020 09:19
From: Kevin Moyes
Subject: Isn't there an AP utility to clear invoice entry t

Thanks Alnoor.
That is not what I wanted to hear, but good to know it isn't just me.

What do you mean by "make it a BOI button"?

(I'm thinking a button on Vendor Maintenance might work too... but I'll have to add a browse filter and loop).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------


Original Message:
Sent: 01-07-2020 18:38
From: Alnoor Cassim
Subject: Isn't there an AP utility to clear invoice entry t

Hey Kevin - No you cannot run that type of script from an Inquiry screen. It's a complaint of mine too. But if you make it a BOI button instead you should be good to go.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA


Original Message:
Sent: 01-07-2020 13:29
From: Kevin Moyes
Subject: Isn't there an AP utility to clear invoice entry t

We had a customer reinit a check history file by mistake (oops!), and I'm looking into a potential button script as a better method (to be run from AP Invoice History Inquiry).
Everything seems to work (open a new object, SetKey, SetValue...) but when I try to Write, it fails.  LastError: "You do not have security rights to modify the record."

I'd expect that if I was trying to update AP_InvoiceHistoryHeader (because I'm in an Inquiry screen), but I opened a new object using AP_OpenInvoice_bus.  Full role permissions.  Am I missing something?  Can I not update a different table via script from an Inquiry screen?
@Alnoor Cassim
​

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON


Original Message:
Sent: 08-06-2018 10:30
From: Robert Wood
Subject: Isn't there an AP utility to clear invoice entry t

AR Cash Receipts now has the ARWAR4 utility. AP doesn't have a utility yet. It's just the reinit trick.