How to Settle a Customer Transaction Marked for Settlement by Another User

How to Settle a Customer Transaction Marked for Settlement by Another User

How to settle a customer transaction Marked for Settlement by Another User – Issue/Scenario

About once a year Avantiico receives questions about “how to settle a customer transaction”.  The below issue is the most common request from an experienced client:

“I need to settle a customer transaction but when I go to the ‘Settle open transactions’ form for the customer (or vendor), I cannot mark the transaction. There is a red icon in the ‘Is marked’ field and I receive an error if I try to mark. I’ve looked all over and I cannot find where to unmark it.”

As a veteran Microsoft Dynamics AX partner with strong ties to the San Diego, Irvine, Ventura and Los Angeles communities, we support many Microsoft Dynamics customers operating most versions of Microsoft Dynamics AX and Microsoft Dynamics 365. The Avantiico Support Team is frequently asked about Microsoft topics, licensing, Microsoft support plans, support polices, product and Microsoft Dynamics license upgrades. So no matter if you are a manufacturing & distribution, professional service and public sector organization running an older version of Microsoft Dynamic AX, this blog about “How to Settle a Customer Transaction Marked for Settlement by Another User” is relevant to you.

AR-> Common-> Payments-> Payment journals-> Click on lines button from journal header-> then Functions button-> Settlement:

Figure 1 - Red icon and error - How to Settle a Customer Transaction Marked for Settlement by Another User

Figure 1 – Red icon and error – How to Settle a Customer Transaction Marked for Settlement by Another User

Solution

When this happens, the user has generally already done their due diligence and checked the likely places to find where the transaction may be marked – in other journals of the same type, in the Settle open transactions form, etc. and still cannot find where it is mysteriously marked.

To find where the transaction is marked, take the following steps:

1. Go to Accounts receivable-> Common-> Customers-> All customers-> highlight customer-> Collect tab-> Settle open transactions (similar path for Vendor transactions). Normally you will see the transaction still has the red icon indicating the transaction is still marked elsewhere.
2. Highlight the record in question, then click on the Inquiry button-> Specifications.

Settle open transactions form-> Inquiry-> Specifications:

Figure 2 – Inquiry button - How to Settle a Customer Transaction Marked for Settlement by Another User

Figure 2 – Inquiry button – How to Settle a Customer Transaction Marked for Settlement by Another User

3. In the Specifications form, click on each radio button in the upper left (Journals, Sales order, Invoice and Payment proposal) until a record shows on the Overview tab.

When you see a record on the Overview tab, you have found where it is marked. Look for additional info in the bottom portion of the form.

In Figure 3 for the transaction showing marked, we can see it is marked in the ‘GenJrn’ daily journal, Journal batch number 00487. In this case, the user was likely expecting to see it in a Customer payment journal, but instead it was in the GL General journal. From the ‘00487’ batch number you can either right click and select ‘View details’ to go to the journal header record or you can to it from the main menu as you normally would navigate to the general journal.

Figure 3 – Specifications form - How to Settle a Customer Transaction Marked for Settlement by Another User

Figure 3 – Specifications form – How to Settle a Customer Transaction Marked for Settlement by Another User

Figure 4 - General journal batch number 00487. Now you can unmark/fix the transaction as needed.

Figure 4 – General journal batch number 00487. Now you can unmark/fix the transaction as needed.

4. If for some reason in step 3 above. you have clicked on all 4 radio buttons and no record is found, then the marking is stuck and must be fixed be an AX administrator. This can be done by your AX reseller or administrator by going to the SpecTrans table in the AOT, finding the record, highlighting and deleting it.

The SpecTrans table stores all the Customer and Vendor open transactions that are currently marked. By deleting the record, you are not deleting a transaction, you are simply clearing the marking on the open transaction.

Figure 5 - SpecTrans table in the AOT - How to Settle a Customer Transaction Marked for Settlement by Another User

Figure 5 – SpecTrans table in the AOT – How to Settle a Customer Transaction Marked for Settlement by Another User

Did this “How to Settle a Customer Transaction Marked for Settlement by Another User” guide help you settle a customer transaction marked for settlement by another user? Please leave your feedback below or if you have other topics you would like us to write about.

Learn more about the new Microsoft Dynamics 365 and how it can help your business

Avantiico has delivered many presentations at Dynamics user group events and webinars. If you want to learn more about how you can move from your current Microsoft Dynamics AX version to Microsoft Dynamics 365 take a look at the “How to upgrade to Microsoft 365” blog post.

If you have any questions about Microsoft Dynamics Support, how to settle customer transactions, Microsoft Product Lifecycle or if we can help your team with information about Microsoft Dynamics 365 please contact our Microsoft Support team at DynamicsSupport@Avantiico.com.

In the next 6 to 12 months you will see many Microsoft news so stay informed by following Avantiico on LinkedIn and YouTube:

About Cindy Scott

Cindy Scott has created 12 entries.

One Comment

  • Zaheer

    Yes it does.
    Thanks

Post A Comment

YOUR CAPTCHA HERE

Contact Us

All fields required

First name

Last name

Company

Your Email

Subject

Your Message

×

Meet Us

All fields required

First name

Last name

Company

Your Email

Available Date & Time
AMPM

Your Message

×

Subscribe to our mailing list

* indicates required
 

×
Learn More

Contact Us

All fields required

First name

Last name

Company

Your Email

Subject

Your Message

×

CRM Test Form

×

Influence

All fields required

First name

Last name

Company

Your Email

Proposed Webinar Date & Time
AMPM

Your Message

×

Contact Us

All fields required
×

Contact Us Here! 

* indicates required

×

We want to hear your feedback

∗ indicates required

×

Let us keep you updated!

 ∗ indicates required

×

Meet Us

All fields required

First name

Last name

Company

Your Email

Available Date & Time
AMPM

Your Message

×

Contact Us Here! 

* indicates required

×

Contact Us Here! 

* indicates required

×

Schedule your meeting with us!

* indicates required

×

Schedule your meeting with us!

* indicates required

×

Book Your Time

×

                        RAMPUP SUBSCRIPTION PLANS

                    Choose a plan below, and one of our

              Support Consultants will contact you shortly.

×

                           PACKAGES START AT $4,999

                  Choose a package below, and one of our 

               Support Consultants will contact you shortly.

×

 Performance Review Details

 

Diagnostic Review of DyanmicsAX Server (AOS) & SQL performance and stability.

 

Written summary of findings and recommendations.

 

Up to 15 hours of issue resolution time to target your most immediate performance issues.

 

Review completed by our 100% onshore support team averaging more than 10+ years of DynamicsAX experience.

 

Get the help you need now, with no long-term commitment.

×

Functional/Department Help Pick 3

 

Help with up to 3 functional or department issues such as: invoicing, costing, closing the books, AR, AP, inventory, warehousing, etc.

 

Talk with our 100% onshore functional experts with over 250+ years of combined AX experience to define your issues and find recommended solutions.

 

Up to 20 additional hours of issue resolution time included.

 

Presentation of solutions and next steps from our expert team.

 

Get the help you need now, with no long-term commitment.

 

×

Reporting / BI Help

 

Choose up to 3 standard or custom reports for assistance.

 

Solve typical issues like: Report too slow, does not show what we need, need an additional field/column, etc.

 

Talk with our 100% onshore functional experts with over 250+ years of combined AX experience to troubleshoot report issues and recommend solutions.

 

Up to 20 additional hours of configuration or development time included.

 

Presentation of solutions and next steps from our expert team.

 

Get the help you need now, with no long-term commitment.

×

Please fill in the form to RSVP

 

×