Open Forum

Expand all | Collapse all

"Unposted" Sales Order transactions

  • 1.  "Unposted" Sales Order transactions

    GPUG ALL STAR
    Posted 29 days ago
    Dear Collaborators,

    Over the weekend I did what I thought would be a minimalist Check Links. It took over an hour and came back with a 77-page report. The vast bulk of the report had messages like this:

    A record for invoice 0004380 was removed from the Sales Transaction Amounts Work table; no corresponding record was found in the Sales Transaction Work table.

    There were 2396 of these messages, a mixture of invoice and order messages.

    I dug a bit further and found that some of the SOP numbers were "Unposted"... but the orders had mostly been converted into invoices (I cross-referenced the originating document number for the orders vs. the invoices that had been created).

    Then I went further and looked at our entire SOP30200 table and found that a whole heck of a lot of our Sales transactions were flagged as "Unposted"... but nothing seems amiss. There was pretty much an even split of records with a PSTGSTUS of 0 vs. 2.

    My understanding is that the PSTGSTUS field for all rows in SOP30200 should all be set to 2 since the SOP records have been posted. What might cause half of them not to be?

    Regards,

    ------------------------------
    "Sparkly" Steve Erbach - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach

    ───────────────
    Excel Webinar List as of 22-Mar-2019
    ------------------------------


  • 2.  RE: "Unposted" Sales Order transactions

    TOP CONTRIBUTOR
    Posted 29 days ago
    Hi Steve-

    Could it be these documents were transferred from Invoice to Back Order? I just looked in our company database and all of the Invoice documents showing in history that have a posting status of 0 also have the GL Posting Date field as '1/1/1900'. These were all transferred from Invoice to Back Order.

    -Joe

    ------------------------------
    Joseph C. Markovich
    IT Manager
    Okaya Electric America
    Valparaiso IN
    ------------------------------



  • 3.  RE: "Unposted" Sales Order transactions

    GPUG ALL STAR
    Posted 28 days ago
    Hi, @Joseph C. Markovich!

    In our situation, we rarely do back orders since we make-to-order... and our inventory turnover is, like, ​​150 turns a year.

    We do use Binary Stream to convert our Sales Orders to Invoices after they've shipped. I wonder if that has something to do with it.

    This certainly isn't vital; I was simply following up after a Check Links returned more issues than I figured it would. Then I found that the SOP30200 table had about 50% of its records "Unposted".

    Regards,

    ------------------------------
    "Sparkly" Steve Erbach - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach

    ───────────────
    Excel Webinar List as of 22-Mar-2019
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role