Sales invoice Paid amount

(0) Share

Report

Posted on by Community Member

I was wondering if you could help me With My Dynamics NAV problem. Dynamics NAV is not an application we use a lot, so we are not familiar with the datamodel. Here our problem:

If an sales order is only partially paid I can see a new entry in the 'customer ledger entry' table for the payment (document type = 1 !?),

Butwhat I can not see is the corresponding element with the amount paid !

So I was wondering which data-element corresponds with the amount paid ?

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Hannes Holst 5,767 on at

Like (0)

Report

Hi,

This depends how you process prepayments.

Do your customers pay a deposit upfront or do you process a Prepayment Invoice per order?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No upfront payments. I would expect that the paid amount is visible in table customer ledger entry !

Was this reply helpful? Yes No
Suggested answer

azelaya59 2,807 on at

Like (0)

Report

Here are the Document Types that are viewed in the Customer Ledger: Null, Payment, Invoice, Credit Memo, Finance Charge Memo, Reminder & Refund. If you looking by way of the object, the table is Customer Ledger Entry (21). Sort to "Applies-To-Doc. Type" to "Payment" and view the "Applies-To-Doc. No," to see which invoices the payment was applied to.

Was this reply helpful? Yes No
Suggested answer

Paras mehan 3,518 on at

Like (0)

Report

Hi,

If you want to see that which Payments made against which Invoices then in Customer ledger entry table Give the filter for Document Type as Payment and Customer No. then select any of the Payment entry and go to Navigate Pane on Ribbon and click on applied entries. Then you will able to see the output.

Best Regards,

Paras Mehan

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Alfredo, I can see an entry with document type Payment in the Customer Ledger Entry Table. Applies-to-doc.Type and Applies-to-Doc-No are both empty.

So the (partially) payment must be stored in another table. I am very interested in where the amount of the payment is stored. Please Help

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Paras, Thanks for your answer, but I am a developer and need to extract the paid amount value on an sales invoice directly via a query from the database. So i am interested in where is value is stored !

Was this reply helpful? Yes No
Paras mehan 3,518 on at

Like (0)

Report

Hi Chrit,

If in the Customer Ledger Entry Table. Applies-to-doc.Type and Applies-to-Doc-No both are empty then check the remaining amount. If it is "Zero" then check Closed by entry No.

Hope it will work.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Paras,

Both 'Closed by Entry No_ ' and 'Closed by Amount' are 'Zero' the value for 'Open' is '1' but I do not see a 'remaining value' element in this table

Was this reply helpful? Yes No
Suggested answer

Paras mehan 3,518 on at

Like (0)

Report

Please Again check there will be a field called "Remaining Amount". If In Remaining Amount and Amount Field both have same value then it means that entry is open (means not applied to any of the document).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Paras, There is no remain amount in table Customer Ledger Entry. Here the available fields in this table:

,[Entry No_]

,[Customer No_]

,[Posting Date]

,[Document Type]

,[Document No_]

,[Description]

,[Currency Code]

,[Sales (LCY)]

,[Profit (LCY)]

,[Inv_ Discount (LCY)]

,[Sell-to Customer No_]

,[Customer Posting Group]

,[Global Dimension 1 Code]

,[Global Dimension 2 Code]

,[Salesperson Code]

,[User ID]

,[Source Code]

,[On Hold]

,[Applies-to Doc_ Type]

,[Applies-to Doc_ No_]

,[Open]

,[Due Date]

,[Pmt_ Discount Date]

,[Original Pmt_ Disc_ Possible]

,[Pmt_ Disc_ Given (LCY)]

,[Positive]

,[Closed by Entry No_]

,[Closed at Date]

,[Closed by Amount]

,[Applies-to ID]

,[Journal Batch Name]

,[Reason Code]

,[Bal_ Account Type]

,[Bal_ Account No_]

,[Transaction No_]

,[Closed by Amount (LCY)]

,[Document Date]

,[External Document No_]

,[Calculate Interest]

,[Closing Interest Calculated]

,[No_ Series]

,[Closed by Currency Code]

,[Closed by Currency Amount]

,[Adjusted Currency Factor]

,[Original Currency Factor]

,[Remaining Pmt_ Disc_ Possible]

,[Pmt_ Disc_ Tolerance Date]

,[Max_ Payment Tolerance]

,[Last Issued Reminder Level]

,[Accepted Payment Tolerance]

,[Accepted Pmt_ Disc_ Tolerance]

,[Pmt_ Tolerance (LCY)]

,[Amount to Apply]

,[IC Partner Code]

,[Applying Entry]

,[Reversed]

,[Reversed by Entry No_]

,[Reversed Entry No_]

,[Prepayment]

,[Payment Method Code]

,[Applies-to Ext_ Doc_ No_]

,[Recipient Bank Account]

,[Message to Recipient]

,[Exported to Payment File]

,[Dimension Set ID]

,[Direct Debit Mandate ID]

,[Transaction Mode Code]

,[Sales Order No_]

,[PSP Reference Id]

,[Date Overdue Insurer]

,[Date Collection Insurer]

,[Discussion]

,[Sales Person To-Do]

,[Date Call Back]

Was this reply helpful? Yes No