180
Hi All,
I'm trying to sync the order getting below error.Can any one please suggest me in this.
Error Number = 2697 Stored Procedure= taSopHdrIvcInsert Error Description = Line items contain qauntity types that are not allowed for the Order DOCID entered
Thanks in advance,
Pavan G.
*This post is locked for comments
I ran into a virtually identical error using SmartConnect when trying to create Back Orders. The error was:
Error Number = 2695 Stored Procedure=taSopHdrIvcInsert Error Description=Line items contain qauntity types that are not allowed for the Back Order DOCID entered
We do not allow backorders to be transferred to Fulfillment Orders or Invoices so in Sales Document Setup for our Back Order ID the "Transfer Back Order to Fulfillment Order/Invoice" was not checked (it is checked in the attached image).
After checking this and selecting an Invoice ID, the backorder gets created, however the quantity is applied to "Quantity to Invoice" instead of "Quantity to Order", even though the Default Quantities in setup is set to "to Order".
Essentially, I believe taSopHdrIvcInsert is not recognizing the settings specified in the Sales Document Setup, at least when dealing with my Back Order scenario. Hopefully this will help point you to the solution and/or a workaround. In our case it was used for an initial import so once that was done I unchecked the Invoice option again.
Please mark as answered if this answered your question.
Hello Pavan,
Here is the data check in taSopHdrIvcInsert that determines if Error Number 2697 should be returned:
if (@I_vSOPTYPE = 2)
begin
if ((@ORDTOBAC = 0) and (exists(select 1 from SOP10200 (nolock) where QTYTBAOR > 0 and SOPTYPE = @I_vSOPTYPE and SOPNUMBE = @I_vSOPNUMBE)))
To find the value of @ORDTOBAC run the following (substituting your DOCID for STDORD):
SELECT ORDTOBAC,* FROM SOP40200
WHERE DOCID = 'STDORD'
AND SOPTYPE = 2
You can then run the following, entering your SOPNUMBE value for the variable:
select * from SOP10200
where QTYTBAOR > 0
and SOPTYPE = 2
and SOPNUMBE = @I_vSOPNUMBE
Basically, your Sales Order DOCID is not setup to allow back orders, but you're back-ordering some quantity on the lines you've imported for this order. You can look at this setting in GP by going to the Sales Order Processing Setup window, select the Sales Document Setup button, select Order, pull up your Order ID and looking at the "Transfer Order to Back Order' option.
Lucas
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (