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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Changing the Customer group

(0) ShareShare
ReportReport
Posted on by 4,017

Hi All,

i have a requirement, to change the customer group for some of the customers and they have the transactions on them, so what should be my approach and what things should i take care. As we are using Sales order and the project module so i will have the following scenarios and solution:

1) Sales order 

a) Sales order which are invoiced and payment received: For this case i will not touch anything

b) Sales order which are invoiced: Invoice wise i will pass the GL entry in which i will Credit the Old customer and debit the new customer by updating due date also, so that my customer aging will be okay.

c) Sales order which are delivered: Cancel the packing slips and create the new SO and post the packing slip.

d) Sales order which are open order: Simply edit the Sales order and update it with the new customer ID.

2) Project module


a) Invoice and payment received: For this case i will not touch anything.

b) Invoice generated:Invoice wise i will pass the GL entry in which i will Credit the Old customer and debit the new customer by updating due date also, so that my customer aging will be okay.

c) Open for invoicing: Change the customer ID on the project contract.

Please need suggestion, whether my approach is right or may be i missed any scenario and the area to check and consider.

Thanks in advance.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Imran Ul Haq,

    Why do you plan to cancel the packing slips in 1c? They should not affect your customer balance.

    The rest seems ok but I would suggest that you test this at least for one of your customers in your demo/test environment before applying those steps in a live system. Also run all 'Standard reports' including the reconciliation resports to ensure that everything works as expected.

    Best regards,

    Ludwig

  • imran ul haq Profile Picture
    4,017 on at

    Hi Ludwig,

    Regarding the point 1c, actually i also need to reclassify the cost and revenue so was i thinking cost and the revenue will be okay from the start.

    I will generate the reports, however it will be great if you can suggest me some reports.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Imran Ul Haq,

    What I would check at a minimum in this case are the following reports

    - customer aging

    - customer balance list

    - customer account statement

    - GL customer reconciliation report

    If they all match and do not show a difference, then you can be pretty sure that things worked out as expected.

    Best regards,

    Ludwig

  • imran ul haq Profile Picture
    4,017 on at

    Hi Ludwig,

    thanks for your suggestion and usual support.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans