Code Snippets

Get All Payment Voucher Numbers against purchase order

Below is the Sample code to get all the payments against a purchase order. Tables Involved :               Tables Purchase Order Purch Table, Purch Line Packing Slip (GRN) Vend packing slip jour, Vend packing slip trans Invoice Vend Invoice Table, Vend invoice Jour Payment Ledger Journal Table, Ledger journal… Continue reading Get All Payment Voucher Numbers against purchase order

Advertisements
Code Snippets

Update Financial Dimension

I was testing a Scenario of prepayment and during invoice settlement  found that i missed project dimension on my PO header and unable to post the final invoice. Once you have done any invoicing PO header will disabled for editing. Here is the Sample code to update the financial dimension.  You can modify the table… Continue reading Update Financial Dimension

Functional Understanding · Uncategorized

Workflow : Use custom field on Workflow condition

In workflow configuration we usually got requirements to add condition on Steps. Some time we also need to create new fields and use in the conditions. If you want to use the new field in Workflow conditions, Simply add it in your workflow Document query from table. For example for Purchase requisition workflow, the document… Continue reading Workflow : Use custom field on Workflow condition

Code Snippets · Functional Understanding

Delete All Transactions in a Company

Today i got a requirement from my Functional team to delete only the posted transactions, not the configurations and master data as he has to test some scenarios. To Achieve this i found a class in AOT named as "SysDatabaseTransDelete" .On further drilling i figure out that this class is checking the table types differently… Continue reading Delete All Transactions in a Company