Finance | Project Operations, Human Resources, ...

Quantity update issue with eConnect

(0) Share

Report

Posted on by Richard Wheeler

75,788 Moderator

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.

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

Suggested answer

Isaac Olson on at

Like (0)

Report

RE: Quantity update issue with eConnect

Hi Richard,

The QTYPRBAC is the quantity previously Back Ordered, which would be the quantity that was previously transferred to a back order. So if I had 8 set to back order on my order, the QTYPRBAC would not get populated unless I transferred some of that quantity to a Back Order. If I transferred 6 quantity to a Back Order, then my QTYPRBAC would be 6, and my QTYTBAC (Quantity to Back Order) would reduce down to 2.

I hope this helps!

Isaac Olson

Microsoft Support
Community Member Microsoft Employee on at

Like (0)

Report

RE: Quantity update issue with eConnect

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.