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 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

I have the same question (0)
  • mco68 Profile Picture
    mco68 110 on at

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

    This is very disturbing.....

  • Verified answer
    Mark E Profile Picture
    Mark E 6,451 on at

    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

    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.....

  • Mark E Profile Picture
    Mark E 6,451 on at

    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.

  • Mark E Profile Picture
    Mark E 6,451 on at

    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...

  • Community Member Profile Picture
    Community Member on at

    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?

  • Community Member Profile Picture
    Community Member on at

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

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 SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans