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

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

Prepayment Process

In this Blog, i will try to cover the complete cycle of prepayment and basics of how to apply prepayment. In MS Dynamics Prepayment for the purchase order include the following Steps. Create the purchase order. Apply prepayment. Post the prepayment Invoice. Make a payment. Settle the payment against the final invoice. Prerequisites To use … Continue reading Prepayment Process

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