DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
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

Archives

 
Material Issued to a Manufacturing Order

Hello DD family,

When material is issued to a manufacturing order, I have to select the BIN or BINS the material is issued from.  I would like to be able PRINT a summary of what BIN(s) were used, by Item Number.  Anyone have a SQL Query that will give me that information, by manufacturing order number?

Thanks

David C
Creating a VIEW from a SQL Query

Hello DD Family,

 

You guys did such a wonderful job with my recent request for help with a query, I thought I would press my luck and ask how to turn it into a VIEW, so that I can create an Excel Builder file...  :-)

The query is...

SELECT it.TRXSORCE, it.IVDOCTYP, it.DOCNUMBR, it.docdate, it.BCHSOURC, it.BACHNUMB, it.GLPOSTDT, it.SRCRFRNCNMBR,
        it.SOURCEINDICATOR, itd.ITEMNMBR, itd.UOFM, itd.TRXQTY,
        COALESCE(bin.bin,lotbin.frombin) combinedfields,
        itd.TRXLOCTN, bin.BIN, lotbin.SERLTNUM, lotbin.FROMBIN
    FROM iv30200 it
        JOIN iv30300 itd ON it.DOCNUMBR = itd.DOCNUMBR AND it.IVDOCTYP = itd.DOCTYPE              
        LEFT JOIN iv30302 bin ON bin.DOCNUMBR = it.DOCNUMBR AND bin.DOCTYPE = itd.DOCTYPE AND bin.LNSEQNBR = itd.LNSEQNBR
        LEFT JOIN iv30400 lotbin ON lotbin.DOCNUMBR = bin.DOCNUMBR AND lotbin.IVDOCTYP = it.IVDOCTYP AND lotbin.LNSEQNBR = bin.LNSEQNBR

 

Thanks

 

DavidC_IL
Stored Procedure to clear stuck batches

I was wondering if anyone has created an stored procedure for clearing stuck batches. If it's driven by batch name and possibly user it should be pretty safe to do right?

These are the queries used to clear batches that I have found. I figure I can write an SP with parameters to run all of these.

 

delete
from DYNAMICS..SY00800
where bachnumb = 'SOMEBATCH'

UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='SOMEBATCH'

 
Changing Account Format...manually?

Hi there!

What is the best approach to merging a GP company db into another system when the account formats do not match.

The GL00100 table in the target system as 7 account number segments ACTNUMBE_1 through ACTNUMBE_7.

the one we want to put in only has 5 segments setup.  

Should we buy the Re-formatter product (https://crgroup.com/re-formatter/)  or is there a set of tables we can update manually? I identified large number of them and started that way - but the smartlists give me errors.

Thanks!

Mark
eConnect AP Invoice - only can load 1000 distribution lines

I'm running into an issue with a process that utilizes eConnect to load AP Invoices into GP.  The process is not generating all distribution lines.  In my case there are 1027 line.  Problem is that once it loads the invoice, there are only 1000 distribution lines.  This of course means that the batch is out of balance.  Seems like there's some sort of limitation I'm running into.  We use Infinia to upload batches as well and I have no problem loading more that 1000 lines there.   It appears to be an eConnect limitation.

Has anyone run into this problem before? Is there a setting I'm missing.  I have never done anything with the eConnect configuration and don't even know where to look.
Reverse the Move Record into History Process

In GP world - this data condition should not exist - I have a total of 3 Returns that were moved into history with no applied records - has anyone seen this before?

I need to get the record out of RM30101 (History Table) and back into the RM20101 so we can actually apply the credit document.

Any suggestions? I checked Professional tools - didn't see anything pertinent. 

 
VBA doesn't work on Server 2019 FIX (maybe)
VBA will not run on Server 2019 and higher. This is a possible fix
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3