Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

eConnect and SOP10200.QTYTBAOR and SOP10200.QTYPRBAC

Posted on by 75,730

When does SOP10200.QTYPRBAC get a value? I tried entering an order for quantity 12. I invoiced 4 and back ordered 8. SOP10200.QTYTBAOR went to 8. I then transferred this order to an invoice and posted it. I then pulled up the order again and invoiced 2 more think that SOP10200.QTYPRBAC would go to 6 and SOP10200.QTYTBAOR would go to 2. That is not what happened.

SOP10200.QTYPRBAC stayed at 0 and SOP10200.QTYTBAOR went to 6. I am asking because I have an import routine using eConnect that updates order quantities.All is fine if the order is only transferred to an invoice once. It starts to double up quantities with the second invoice. I currently have this formula:

QUANTITY = QTYCANCE+QTYPRBAC+QTYPRINV+QTYTBAOR+QTYTOIVC;        /* This is the total quantity on the SO line */

sopLine.TOTALQTY = QUANTITY;                    /* Required to reset amounts */

Looks like I need to correct this calculation and also calculate QTYTBAOR.

  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: eConnect and SOP10200.QTYTBAOR and SOP10200.QTYPRBAC

    Hi Richard,

    I the Quantity Previously Back Orderd, would have to actually be transferred to a Back Order for it to be populated.  So in your example, if you added the step below, then it would have populated the Previously Backordered column. 

    1. I tried entering an order for quantity 12. I invoiced 4 and back ordered 8. SOP10200.QTYTBAOR went to 8.

    2. I then transferred this order to an invoice and posted it.

    3.  Transfer the 8 back ordered quantity to a Back Order (This is the Part you missed)

    Now the SOP10200.QTYPRBAC would go to 8 because you previously transferred the 8 quantity to a back order.  

    I hope this helps!

    Isaac Olson

    Microsoft Support

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans