web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)
Answered

Create Sales Credit Memo for Price Adjustment with Item but not hitting inventory and update Sales GL#411004

(0) ShareShare
ReportReport
Posted on by

We sell directly to the customer from the manufacturer so there is no inventory in our local warehouse - we shipped directly to the customer. We found out that we made a mistake on the selling price and we are trying to give them a credit for the price adjustment.

What is the best way to handle this kind of credit without having to enter the item twice - wherein one sales line will have the positive quantity with the wrong price and another sales line with have the negative quantity with the correct price. This will balance out to show how much the price adjustment will be.

From accounting point - this will hit inventory - and we will need to do inventory adjustment. Is there a way we can prevent this but still be able to put in the item on the credit memo ?

We also like to have it hit our sales Gl#411004 instead of sales return allowance Gl# 413001? I was looking at the Posting setup - do we make the changes here ?

The reason why we need to still retain the item on the credit memo is that we want to update it on a customer item sales report - this report gives us the sales margin on the item level.

We are thinking of using the G/L Type on the credit memo to hit the Sales GL#411004 but this will not give us the visibility on the item level.

What is the best way to handle this ?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Alexander Ermakov Profile Picture
    28,094 on at
    RE: Create Sales Credit Memo for Price Adjustment with Item but not hitting inventory and update Sales GL#411004

    In addition to using Item Charges in Credit Memo, you can also consider to create full reversal Credit Memo that would eliminate the initial sales and then post a new sales order. This way you will not need to adjust posting setup.

  • Community Member Profile Picture
    on at
    RE: Create Sales Credit Memo for Price Adjustment with Item but not hitting inventory and update Sales GL#411004

    I will do the test. It seems to be fine when I did the initial test but then I have to change the posting setup on the Sales Credit Memo Account to be the same as the Sales Account so that when I post the credit memo it is offsetting the sales gl # 411004 instead of the sales return Gl No. 411013. I am going to have our accounting go over the G/L Entries.

  • Community Member Profile Picture
    on at
    RE: Create Sales Credit Memo for Price Adjustment with Item but not hitting inventory and update Sales GL#411004

    If you have any doubts, check the results in test environment first and see if you are convinced with it. Ideally there should not be any issue.

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Create Sales Credit Memo for Price Adjustment with Item but not hitting inventory and update Sales GL#411004

    Why no shipments lines? Dont you have option enable in Sales & Receivable setup?

    Anyway, you can use Get Posted Document Lines to Reverse option and post the credit memo. Later apply this credit memo and ealirer posted invoice to knock off the entries.

    Later you can post actual sales order with correct pricing and send the revised invoice to client.

    Hope this helps.

  • Community Member Profile Picture
    on at
    RE: Create Sales Credit Memo for Price Adjustment with Item but not hitting inventory and update Sales GL#411004

    I tried using the Sales Credit Memo - Charge Item and apply on the original shipment - but there is no shipment lines for me to apply to.

    Can we use the credit memo and Get Posted Document Lines to Reverse option instead?

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Create Sales Credit Memo for Price Adjustment with Item but not hitting inventory and update Sales GL#411004

    Simplest way to handle this would be managing via G/L account.

    You can also pass sales credit memo using charge item and apply on the original shipment. This way, you would have correct entries in G/L and value entries. You can generate the sales report as well from here.

    However if nothing works, you can post sales return and sales order transaction. (No need for Inventort adjustment)

    As this would be very rare transaction, you can decide your best suitable option from the above.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans