umadevi
16th September 2009, 16:56
Hi I am automating the process of Match and Apporove Invoices.Here i have to select all the records present in the session tfacp1131s000(Maintain Receipts).
Can any body tell How to select a group of records through AFS.


Expecting Answer from u guys,Its very Urgent.
Thanks in advance.


Regards,
Uma

mark_h
19th September 2009, 15:00
As far as I know there is no way to do what you are asking. If I get time on Monday I will look to see if I have something for 1131s000, but I do not think so.

ap2203
1st October 2009, 10:46
I need help
Hi I want automating the process of Match and Apporove Invoices.
I want to select the records present in the session tfacp1131s000(Maintain Receipts)by date.
Can any body help
(any code which work OK )

Thanks in advance.
Regards,

mark_h
1st October 2009, 21:06
Sorry forgot about this, but I was correct. I do not have any code for tfacp1131 or tfacp1130. As a matter of fact we modified tfacp1131 so that if it gets called from any of our api sessions it closes itself. I am still not aware of any method that will allow you to select a subset of the records. If you all find a solution please post it.

Thanks

Thomasm
2nd October 2009, 09:12
Not sure how relevant this is but the same kind of problem is in the session Maintain Receipts when working with Advance Shipment Notice from EDI. Basically it is a number or records in a table you zoom to, each of the lines representing each of the lines on the purchase order with the quantities delivered. What you do when you work manually is to select all the lines that belong to the sales order you are working with and 'save and exit'.

What I did to automate this was to combine regular SQL and afs (with code for receipts originally posted by Mark) in my session.

I guess you will need to have a close look at the source to figure out if a solution like this is possible and how to build it.

I do have code for approving invoices, with respecting the approval limits before calling the afs, which I'd be happy to share. But of course, that is another thing.

Another idea could be to take a step back in the process and see if it is possible to start with automating the step of registering the invoice. Because then you could use the EDI functionality to receive the invoice and benefit from the fact that EDI will match your invoice automatically. But please be aware that to get the invoice to match the receipts have to be maintained (which technically is not an issue to automate, but can be for the business). Yeah, suddenly the problem grew :D

Good luck,
/Thomas

ap2203
4th October 2009, 18:06
IS it problem to see code for approving invoices, with respecting the approval limits before calling the afs, may be help or may give a mew idea
Thanks for help
Kind regards

ap2203
14th October 2009, 22:06
I need help
Hi I want automating the process of Match and Apporove Invoices.
I want to select the records present in the session tfacp1131s000(Maintain Receipts)by date.
Can any body help
(any code which work OK )

Thanks in advance.
Regards,
I dont solve my problem
Has any one help, if I cannot selecet records by date how can I match receipt with invoice,
I appriciate any help
Best regards