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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / PM Invoice Shows Rever...
Microsoft Dynamics GP (Archived)

PM Invoice Shows Reversing as Originating TRX Type in Smartlist

(0) ShareShare
ReportReport
Posted on by Ceejay 445

Post a PM Invoice in GP then check Smartlist's Financial Account Transaction. Add the Originating TRX Type. Why is it that GP logs it as Reversing? Any help is greatly appreciated. Thanks!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Vinutha Holla Profile Picture
    Vinutha Holla 705 on at
    Re: PM Invoice Shows Reversing as Originating TRX Type in Smartlist

    Hi Ceejay,

    The "Originating Trx Type" field is pulling from the ORGTRXTYP column in the GL20000 -Year to Date Transaction Open table. It will show as either standard, reversing or blank on this Smartlist query. This column stores the transaction type from the original module that the transaction came from. These values would mean different types within the module that the transaction came from. For example:

    a.) If a sales invoice is keyed in, it will store a value of "1" for this transaction in the sales module , as 1-invoice,

    2=debit memo, 3=finance charge, 4=service repair, 5=warranty, 6=credit memo, 7=return.

    b.) If a purchasing invoice is keyed, 1-invoice, 2=finance charge, 3=misc charge, 4-return, 5=credit memo.

    c.) Then when you post the transaction to GL, the original value is stored.

    Notes: A "2" would mean debit memo in the sales module, and a 2 is a finance charge in the purchasing module.

    They do not mean the same thing, but GL will store a value of 2 for each in the Originating Trx Type column.

    In GL, this column is set up to read 0-Standard or 1-Reversing. There is no value pre-set for a "2", so it will be blank.

    Any values of 2 or greater will show as blank.

    If the column has a "1" in it, the system will interpret this as "Reversing".

    Regards,

    Vinutha

  • Verified answer
    Ceejay Profile Picture
    Ceejay 445 on at
    Re: PM Invoice Shows Reversing as Originating TRX Type in Smartlist

    Microsoft confirmed it is a known issue (Bug ID 4682).

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans