Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In

Archives

 

This article discusses error 3770, Duplicate MSTRNUMB

 

Join us in our video training series, today's topic is a tutorial on how to create a multi page SSRS invoice. 

The script used in the video is below

 

 

Hi Everyone,

I'm hoping one of you may be able to shed light on this topic as I am attempting to create Inventory Variances in our database that override the quantity available.

For example, if the item# has a negative quantity available, I'd like the TRXQTY to override the negative quantity available values .

As of now I have successfully achieved this when passing a positive value but for some reason when I pass a negative value (to subtract from the inventory) it throws this error:

 

Sql procedure error codes returned: 

Error Number = 1789  Stored Procedure= taIVTransactionLineInsert  Error Description = The Transaction Qty (TRXQTY) exceeds the Qty available
Node Identifier Parameters: taIVTransactionLineInsert
IVDOCNBR = 9872422-CHARGEOFF
IVDOCTYP = 2
ITEMNMBR = 7-38545-02004
Related Error Code Parameters for Node : taIVTransactionLineInsert
TRXQTY = -278

If anyone has had success passing negative TRXQTY values when the quantity available is also negative I'd appreciate any advice or input.

Here is the xml I'm feeding:

<?xml version="1.0" encoding="utf-8"?>
<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<IVInventoryTransactionType>
  <taIVTransactionLineInsert_Items>
<taIVTransactionLineInsert>
<IVDOCNBR>9872422-CHARGEOFF</IVDOCNBR>
<IVDOCTYP>2</IVDOCTYP>
<ITEMNMBR>7-38545-02004</ITEMNMBR>
<TRXQTY>-278</TRXQTY>
<TRXLOCTN>CA2</TRXLOCTN>
<InventoryAccountOffSet>69709-01</InventoryAccountOffSet>
<OverrideQty>1</OverrideQty> (I added this line in manually on the Document Sender because even when set to 1 it didn't show up.)
</taIVTransactionLineInsert>
</taIVTransactionLineInsert_Items>
  <taIVTransactionHeaderInsert>
<BACHNUMB>91+ CR</BACHNUMB>
<IVDOCNBR>9872422-CHARGEOFF</IVDOCNBR>
<IVDOCTYP>2</IVDOCTYP>
<DOCDATE>06/30/2020</DOCDATE>
</taIVTransactionHeaderInsert>
</IVInventoryTransactionType>
</eConnect>

 

Error: A POP Receipt Bin is not set up for this item or site

I'm trying to determine how and where GP is making this mistake.  Our users are entering sales orders for drop ships.  In the sales order, they are entering the manufacturer part number that corresponds to our part number in the sales order line comments (SOP10202).  Then, they generate a purchase order from that sales order (SOP60100) and those comments, which is the mfg. part number,  are added to the PO line item comments (POP10550) "automatically".

Approximately 30% of the time, the comments don't transfer over correctly.  

My question is this:  is there a stored procedure that gets executed to generate the PO or is it done programmatically by GP (leaving me no way to determine what is causing the comments to not match some of the time)?

Data and query below.

Thank you,

James

sopnumbe soptype lnitmseq ord SOP Comment POP Comment
SO-030627 2 16384 16384 AF1A0072R6B09-062M AF1A0072R0001-057M
SO-030627 2 32768 32768 AF1A0072R6B09-065M AF1A0072R0001-075M
SO-030627 2 49152 49152 AF1A0072R6B09-068M AF1A0072R0001-082M
select
    sop6.sopnumbe,
    sop6.soptype,
    sop6.lnitmseq, sop6.ord,
    sop1.Comment_1 c1, pop1.comment_1 c2,
    case when sop1.Comment_1 = pop1.comment_1 then '' else 'NOT MATCHING' end [matching]
from sop60100 sop6
    join SOP10202 sop1 on
       sop6.sopnumbe = sop1.sopnumbe
       and sop6.soptype = sop1.soptype
       and sop6.lnitmseq = sop1.lnitmseq
    join pop10550 pop1 on
       pop1.popnumbe = sop6.ponumber
       and sop6.ord = pop1.ord
    join pop10100 poph on
       poph.ponumber = pop1.POPNUMBE
where
    poph.potype = 2

Hi everyone

I am looking for a view that would produce a report like below. Right now I am pulling a report from RM00102 but each address code

appears on two lines

 

Thanks a lot

Paul

Howdy

Is there a way to create a work order via eConnect?

Thanks







Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables