How To: Set Fixed Asset Balancing Account

Insert Bal. Account option under Calculate Depreciation request page and Insert FA Bal. Account under Fixed Asset – G/L Journal -> Actions -> Functions uses the account defined in the FA Posting Group.

FA Posting Group can be defined for a Fixed Asset under Fixed Asset Card -> Lines Tab -> FA Posting Group

How To: To increase the Max no. of XML/ Excel export from NAV 2009

Step 1: Locate ClienUserSettings.Config file under C: -> Users -> Username -> AppData -> Local -> Microsoft -> Microsoft Dynamics NAV -> ClienUserSettings.Config

Step 2: Edit the file using Text Editor

Step 3: Insert the following line

<add key="MaxNoOfXMLRecordsToSend" value="20000" />

Text in red determines the maximum no. of records to be exported.

Finally, save the file.

Note: Take a backup of the .config file before making any changes to it.

Error: There is no Cust. Ledger Entry within the filter. Filters: Document No.: PSIXXXXX, Customer No.: CXXXXX, Document Type: Invoice, Open: Yes

Issue: Unable to post Sales Return Order due to following error message

“There is no Cust. Ledger Entry within the filter. Filters: Document No.: PSIXXXXX, Customer No.: CXXXXX, Document Type: Invoice, Open: Yes”

 

Reason: Referenced Customer Ledger Entry is closed by a Payment Entry.

Solutions:

Option 1

Step1: Unapply the referenced customer ledger entry from the payment entry, using Customer Ledger Entries window -> Select the Entry -> Actions -> Functions -> Unapply Entries…

Step2: Post a refund using Cash Receipt Journal -> Create a refund entry for the customer, then Actions -> Functions -> Use Apply Entries -> to select entry to be refunded. Finally, Actions -> Posting -> Post.

Step3: Now you should be able to post the Sales Return Order

In this option, payment amount have to be refunded to the customer.

Option 2

Step1: Remove the link between Sales Return Order and Posted Sales Invoice under Sales Return Order -> Invoicing Tab -> Clear the value in Applies-to Doc. No.: field.

Step2: Receive and Credit the Sales Return order.

In this option, the system would leave a credit balance on the customer account. 

How To: Applying payment discount using ‘Remaining Pmt. Disc. Possible’ under Apply Customer Entries.

As long as ‘Posting Date’ under Cash Receipt Journal should <= ‘Pmt. Discount Date’ and there is a value in ‘Remaining Pmt. Disc. Possible’ under Apply Customer Entries. Then discount will be considered.