1,195
I have a custom module, in which I can create a transaction and then Post to AP.
This "Post to AP" process should create a Voucher in AP module in work tables and a AP batch in which this voucher can saved.
Can any one help me on the scripts/procedures which can be used to create AP batches and vouchers by passing required parameters to the scripts.
*This post is locked for comments
I know taPMTransactionInsert this is the original Stored Procedure for creating PM transactions. But, most of them using the SP with suffix of "pre" . Each eConnect SP also has pre and post procedure. We can also use this SP to create transaction in GP. Anyway happy to hear for your problem solved.
All the best.
Thanks Soma, for your quick and detailed responses.
The Procedure to be used is "taPMTransactionInsert" but not "taPMTransactionInsertPre".
With the SP "taPMTransactionInsert", I am able to insert records in to PM Work tables.
Appreciate your quick help and responses.
Thanks for your time.
Regards,
Manjunath V
Follow below steps to create the script log file.
Hope this helps!!!
In Dexterity, we have other option for creating the PM vouchers in work table. The option is calling Dexterity procedure/function. First we need to identify the what all are the procedures/functions used for creating AP vouchers in GP. Already I have tried this way to created the AP vouchers in open tables. For open records(Posted records), dexterity has a common function. So, I have used this function to create the AP vouchers in Open table. For work table, I don't about the exact procedures/functions.
To identify the procedure/functions, you can use script debugger to find the same.
Hope this helps!!!
I had used above mentioned Procedures but I am unable to create records in PM work tables.
Hi Nataraj and Soma,
Thanks for your suggestions.
I cannot use Econnect in my current case.
Any other ways to get his done?
An addition to the above Nataraj suggestion. You can create Payables Transaction with work status with help of eConnect Stored Procedures. The below are the SQL stored procedures used for creating Payables Transactions.
taPMTransactionInsertPre - used to create Payables Transactions(Invoice, credit memo, finance charge, misc charge and return) with work status.
taPMTransactionTaxInsertPre - used to create above Payables Transactions with custom tax details.
taPMDistributionPre - used to create above Payables Transactions with custom distribution accounts.
For your case, if you want to create Payables Transactions(Vouchers) with default distribution accounts and tax details, use the SQL stored procedure taPMTransactionInsertPre.
To identify the parameters for this procedure, go to SSMS and expand the company database--> Progarammability-->Stored Procedures then right click the stored procedure taPMTransactionInsertPre and select Script Stored Procedures As-->Create To-->New Query Editor Window.
Hope this helps!!!
Hi Manjunath,
you can call the eConnect sql procedures such as
taPMTransactionInsertPre/taPMTransactionTaxInsertPost.sql in your custom module/screen button by passing required fields to above sql procedures .
note: eConnect needs to be installed.
Thanks for providing solution through econnect.
I am looking for creation of AP Batch and Voucher through Dex Code. Where I have a custom module, In which I want to Post my transaction to AP.
So once user click on "Post to AP" button in the custom screen, I want to call the dex procs or functions to create the records in SY00500 and PM work tables.
It would be great if you can suggest me on this.
#1
André Arnaud de Cal...
292,468
Super User 2025 Season 1
#2
Martin Dráb
231,287
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
