Identify Journals in Cust. Ledger Entry

slmaluwa

Is there any easy standard (or customized) way of identifying the entries passed through a journal in Cust. ledger Entry table?
Auditors wanted to separate the entries posted by documents (Sales, Credit memo, Payment etc) and wanted to see whether any entries were passed directly to reduce the customer balances.

Marije_Brummel

ALL Customer Ledger enties are created through journals!!

Or at least I hope so.

I have documented the Navision data model carefuly in my book.

http://www.amazon.com/Microsoft-Dynamic ... 941&sr=8-1

There are many different types of Customer ledger entries that will tell you where the entry came from, but they all go though the General Journal.

Andwian

slmaluwa wrote:

Is there any easy standard (or customized) way of identifying the entries passed through a journal in Cust. ledger Entry table?

You can see the Document Type

slmaluwa wrote:

wanted to see whether any entries were passed directly to reduce the customer balances.

If you want to avoid this, just set the option DIrect Posting on its account card to NO.

ssingla

Source Code and Reason Code can be used to track transactions posted from Order/Invoice/Credit Memo and Journals.

Savatage

Exactly! My" source code" can show:
SALES - if it done the usual way or
SALESJNL - if an entry was made using a journal.