Dynamics Community Forum Thread Details

How to find Original/Source Document

Hi All,

I have an issue finding Source document. Actually My problem stated when my Vendor Balance and Ledger Balance does not tally. When i check all transactions for that ledger i found a transaction was directly posted instead of through vendor.

When i click on original document for that particular transaction it should take me to source document. but it is showing empty. When i did Audit trail i found it was created by some user XXX and Showing as System generated transaction.

The voucher series used was vendor invoice voucher. When i go in deep. I found Journal batch number, but when i search posted journals reports with journal batch number it is showing same transaction voucher but not source document. I clicked on journal batch number but no use.

I know it is not possible to delete posted journals. And am not sure whether it is deleted.

My Question is

1. I want to know in what areas the ledger account is setup for automatic posting. Is there a way to check directly from ledger instead of checking each and every posting profile.

2. Will there be no source documents for system generated transactions ?

3. And does system generated transactions create journal batch numbers ? I thought journal batch numbers are created when we manually create journals.

4. If a voucher series is added for multiple references, can i know what are those references ? Since journal voucher reference will not show in number sequences.

Thanks,

Samanth Aluvaka

Hi Samanth,

Have you tried running the vendor reconciliation report? It should give you some additional insights on the underlying transaction that caused your difference.

For 1) Automatic postings can be setup in many places. In addition to your posting profiles, please also check the automatic accounts setup in GL.

For 2) Not all transactions have a source document attached. Especially automatic transactions created e.g. during inventory close, fx-revaluation, etc. typically do not have a source document

For 3) Also automatic Transactions are created in journals, You should be able to see them if you inquire about all the fields related to a Transaction. Yet, you might not be able to identify and open those journals.

For 4) What do you mean here? Have you setup one voucher number series for multiple purposes, such as e.g. purchase order invoice, customer invoice, ... something like that?

Ludwig

Quick Links