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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP Fixed Assets GL Bat...
Microsoft Dynamics GP (Archived)

GP Fixed Assets GL Batch posting number fails to increment.

(0) ShareShare
ReportReport
Posted on by Hal Steinkopf TX 185

We have consolidated two GL companies (both with Fixed Assets) - most work performed by our partner - in July and since then have not been able to create GL batches from the monthly depreciation run.  We get lists (which grow every month) but no action! :(  Any advice on where to start looking?

Thanks,

 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Ken Hubbard Profile Picture
    Ken Hubbard on at

    This is likely a problem with the batch numbers in the Fixed Assets Batch Headers (FA15000) table. The system looks at the maximum value for the GL Interface Batch Number column to determine the next batch number. If your partner consolidated these values using the nonstandard format for these batches it could cause the problem you describe. You can confirm this by running the following against the company database:

    select MAX (GLINTBTCHNUM) from FA15000

    If the format of the batch number does not follow a numbering scheme a follows. This is a likely cause of the problem:

    FATRX00000001  

    In the case I am correct, I would bring this up with the partner that did the consolidation. They either need to change the number scheme of the consolidated FA batches or they need to modify the stored proc that looks for the next batch number.

  • Community Member Profile Picture
    Community Member on at

    Hi Ken,

    I have a smimilar issue.   Query returns FATRX000165-V

    Can you give me the infor you have from your partner?  I have a test install I'd like to apply it to.

    Thanks!

    Donnette

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans