Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Analytical Accounting for Contract Administration

(2) ShareShare
ReportReport
Posted on by 341

Greetings everyone,

A customer i'm currently working on has a very unique business model, which involves a rent fee for the use of an asset (Land).  The contract per se does not really entail any field service, but since the billing occurs monthly for a number of years, I thought the best way to do this was by creating a contract through contract administration.  This asset can be rented to multiple customers at the same time and the fees could vary by customer.  The challenge i'm facing is that the customer wants to be able to get reports on the revenue and costs of each asset (land) individually, without having to create individual accounts for each asset in the chart of account.  I believe the best way is to use Analytical Accounting, create a transaction dimension (For example: Land Revenue) and multiple transaction dimension codes (For example: Land # 1, Land # 2, etc.).  I have set up the link for the accounts that I would be using and have tried to establish AA in a variety of ways without much success:


1) Creating a Contract directly through Contract Administration: I tried setting up a contract directly, but even though I have selected the accounts that are related to AA, I have not seen the AA button anywhere so I could never set up AA through this method.

2) Creating a Contract through Sales Order Processing (Sales Transaction Entry window): I selected the customer, the item number ("Rental Fee") in the invoice line and was able to establish Analytical Accounting for the Land (dimension code) related to that invoice (my expectation was that the AA information would carry over to the periodic invoices in the contract). Once I did that, I selected the "Additional" --> "Create Contract" options to create a contract, with the frequency, billing dates, and everything else.  After posting the invoice, the contract was created succesfully.  After that, I went to "Contract Maintenance" and indeed, the contract was there. However, for some reason, the price for the item (Rental Fee) changed automatically even though it is a Fixed Fee item type.  No harm done, I changed the price back to what I wanted (although it would be great to understand why the price changed) before any billing was done.  I went to contract billing and Invoiced the first month of the contract.  However, when I post the invoice I get the following error: "Transaction analysis information for this transaction is incorrect or missing".

Any help with this matter would be greatly appreciated.  Any alternatives to achieving what the customer wants is also welcome.  

Kind Regards,

Ricardo

*This post is locked for comments

  • RSM_RCarrillo Profile Picture
    341 on at
    RE: Analytical Accounting for Contract Administration

    Thank you very much for your clarification!

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Analytical Accounting for Contract Administration

    there isn't integration between contract maintenance and AA.  

    I resolved this putting default AA codes to each account.  

    The issue is that You need to open AA Windows in SOP and press OK.  You could create a macro for automation.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans