Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Differences in APTran ...
Microsoft Dynamics SL (Archived)

Differences in APTran and PJTran

(0) ShareShare
ReportReport
Posted on by mco68 110

I have something that is baffling me – FTT moved some AP vouchers to the project side.  In PJTran, the amounts are a negative (-7200).  However, everything on the GL and AP side is correct without the negative (7200).  It is for only 1 vendor and in the same 2 batches.  Does anyone have any idea what might be causing this or have ever heard of this?

 

I believe my only fix is to change the amount in PJTran to a positive via SQL….

 

Update pjtran set amt = xxxxxx where amt = -xxxxxx

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Differences in APTran and PJTran

    Ignore my response.  I now see you  have an answer.  Didn't find those postings earlier

  • Community Member Profile Picture
    Community Member on at
    RE: Differences in APTran and PJTran

    What kind of document was this in AP? VO, AD, AC

    Was there any qty entered?  

    What acct type was entered on the detail line: Asset, liability, income, exp?

    What version of SL?

  • Mark E Profile Picture
    Mark E 6,451 on at
    RE: Differences in APTran and PJTran

    You can also try to update the affected PJTran records (amount and curytranamt), then run the "Rebuild All Summary Records" in the PMA Integrity Check, but I would suggest trying this in a Test DB first and validating the results before doing any of that in Production...

  • Mark E Profile Picture
    Mark E 6,451 on at
    RE: Differences in APTran and PJTran

    Ouch, that's quite a lot of transactions.  You can't just update the PJTran records, as the PJ Summary tables (PJACTSUM, PJACTROL, PJPTDSUM, PJPTDROL, etc.) are also impacted by the incorrect postings.

    My suggestion would be to analyze/summarize the differences between the GL and Projects by Project/Task/Acct Category, then make Project Charge entries to true up the Project Balances.

  • mco68 Profile Picture
    mco68 110 on at
    RE: Differences in APTran and PJTran

    Hi Mark,

    That was it....I don't know how that got changed.....

    I have changed it backed.......do you have a suggestion for the easiest way to fix with incorrect trans?  Looks like I have 680 trans.....

  • Verified answer
    Mark E Profile Picture
    Mark E 6,451 on at
    RE: Differences in APTran and PJTran

    Make sure that the Project Acct Category "Acct Type" matches the GL Account Type.  For instance, if the GL Acct Type is "Expense", then the Project Acct Type should be "Expense" also.  I have seen situations where the Acct Types did not match, and the Project posting amount is flipped because (for instance) the GL Acct Type = "Income" but the Project Acct Type = "Expense".

  • mco68 Profile Picture
    mco68 110 on at
    RE: Differences in APTran and PJTran

    I am now finding that all transactions after a certain date have this issue.....from AP, PR, IN, and GL......

    This is very disturbing.....

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

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 >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans