Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Applying entries for t...
Microsoft Dynamics NAV (Archived)

Applying entries for the customer without having to use apply entries action

(0) ShareShare
ReportReport
Posted on by Sulav Thapaliya 2

Presenting my query on a case below:
I have Global dimension 1  Code  as "Product Segment Code" whose dimension values are as  for ex: X,Y, Z, also I have a Customer A which deals with me regarding every products. Invoicing for different product segments is done separately even if it is for the same customer.
I have the following transactions with A
• Sales of Rs. 50000 of product X
• Sales of Rs. 30000 of Product Y
• Sales of Rs 20000 of Product Z
The customer pays me Rs. 20000 for Product Z, and the payment method for Customer A has been set to Apply to oldest. In the Cash receipt Journal line, I select the Product segment code as Z without going ahead in Apply Entries action. But when running the ageing report Rs. 20000 is seen to applied to Product X even if we have chosen Product Z on Journal line. As customer is set at Apply to oldest it applies to the customer oldest Invoice.

So, I need a solution over the above problem, how could I make the payment apply on the particular product segment selected(oldest) on journal line entered not the customer oldest Invoice irrespective of all the product segments.

*This post is locked for comments

  • Sulav Thapaliya Profile Picture
    Sulav Thapaliya 2 on at
    RE: Applying entries for the customer without having to use apply entries action

    I know I have to go for customization and I am already halfway there.

    I just have to figure out how to apply entries while posting in cash receipt journal

  • Suggested answer
    Indikauk Profile Picture
    Indikauk 1,759 on at
    RE: Applying entries for the customer without having to use apply entries action

    Hi Sulav

    Auto Apply Default Functionality is apply to oldest entry it doesn't validate Dimension, for your requirement you need to go for a Customization.

  • Sulav Thapaliya Profile Picture
    Sulav Thapaliya 2 on at
    RE: Applying entries for the customer without having to use apply entries action

    if the customer pays Rs. 80000 then we will create two receipt vouchers for Rs.30000 and Rs.50000 and select the corresponding product ad based on that product it has to apply to its oldest entries of the product related.I have already achieved this customization but what our clients want is they will not click on apply entries action and apply the amount.They just want to post and code should do rest of the applying entries.

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Applying entries for the customer without having to use apply entries action

    Having different values of the global dimension would not prevent the system to autoapply to the oldest irrespectively the values of the dimension.

    Consider also other scenarios when you customer would pay you Rs. 80000 in one shot for first two sales invoices - which dimension would you assign to that payment? Also, consider prepayments or partial prepayments.

    According to my experience, automatic application has never worked smoothly. We always recommend to apply the transactions manually, which would be my first recommendation - select the needed invoice when posting the bank statement.

    Another option is to divide the sales by different agreements (some localizations have agreements functionality), and this would prevent autoapplications between transactions, related to different agreements.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans