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

 
Adding a Date line restriction in SmartConnect
Today's task is to add a date valued line restriction in a SmartConnect map
Error Number = 9370 Stored Procedure= taSopHdrIvcInsert Error Description = You are passing a Currency ID in the header and you did not pass the same one to the line
This is a pretty simple error, barely worth blogging... but I try to record all of them. 

Error Number = 9370  Stored Procedure= taSopHdrIvcInsert  Error Description = You are passing a Currency ID in the header and you did not pass the same one to the line

Node Identifier Parameters: taSopHdrIvcInsert
SOPNUMBE = LCN-28309X
SOPTYPE = 3
Related Error Code Parameters for Node : taSopHdrIvcInsert
CURNCYID = Z-C$
<taSopHdrIvcInsert>
  <SOPTYPE>3</SOPTYPE>
  <DOCID>INV</DOCID>
  <SOPNUMBE>LCN-28309X</SOPNUMBE>
  <LOCNCODE>541</LOCNCODE>
  <DOCDATE>05/31/2019</DOCDATE>
  <CUSTNMBR>ENDOINC541</CUSTNMBR>
  <SUBTOTAL>175</SUBTOTAL>
  <DOCAMNT>175</DOCAMNT>
  <BACHNUMB>SALES20190524</BACHNUMB>
  <CURNCYID>Z-C$</CURNCYID>
</taSopHdrIvcInsert>
Bin quantity entry window does not display bin options

We use multi bin, and have come across an item that does not display the autocreate bin in the bin quantity entry window. Is there a specific reason this has happened? The autocreate bin shows on other finished good items, so we are a little confused.

 

 

 

 
Reconcilie Customer - Message

At the moment of wanting to make a conciliation to the client. I get the following message: "other user update information customer". How can I solve this problem without having to clean Activity tables and other ...

Thanks

 

 

 
Troubleshooting Slow Performance

Hello,

My client called complaining that Dynamics GP (2018) was crawling.  logging in takes 5 minutes and every operation is sluggish.  All 6 client machines are affected.  We looked into DNS, Antivirus, firewall, rebooted.  nothing seems to work.  Server is less than a year old, and oversixed for the task.

I can't find anything wrong.  Network admin says no changes were made to the system.  Disk I/O seems to be higher than normal; CPU load is tiny.  

No issue if i try GP on the SQL server, indicating it may be network/odbc/SQL Client related.  I am stumped.  I'd appreciate any help i can get.

Regards

Habib
Inventory Transfer Site Default Account

Good morning,

  I entered to the Inventory Transfer Transactions and i have the follow situation, when I transfer inventory from one site to another  I need have different accounts numbers, right now i change the "To Site" account in the distribution tab, but I want to have the inventory control account for the site automatically posted in the distribution account because I have many transfers to do. I check in the Inventory Control Setup "Segment ID for Sites" but don't work in inventory transfer o cycle only work in Sales Transactions.

GP2018 Ver 18.00.0672

Any suggestion is welcome,

Thanks

 

 

 
taxable wages

What GP table shows taxable wages for the year?

 

Thanks,

Lois Urban
Grant Access to a company in Dynamics V8 error 1918 doesn't exit

Hi Guys

Sorry, but I have a situation with a client that has Dynamics GP V8 and I'm trying to grant access a User to a company but  it's giving me this error message "ERROR MESSAGE 1918 DOESN'T EXIT" and won't allow to grant access to any company.

Can somebody help?

Thank You
I need help with a query on PM20000

I am trying to run a query on all transactions in the PM20000 where if there is a document type of 1 AND a document type of 5, AND the CURTRXAM matches both of those document types.... Then I get the following results on one line:

VCHRNMBR, VENDORID, DOCTYPE, DOCDATE, DOCNUMBR, DOCAMNT, CURTRXAM

Please help!
Import analytical accounting code on already posted transaction.

Is it possible to import analytical accounting information onto a journal entry that has already been posted? I am aware of how to integrate AA with GL pre post via econnect, however, unsure if this is possible after posting.

My dilemma is since the transactions have already been posted (there are many) without the ability to import additional AA info, i am forced to edit the analysis one by one through the application.

My last resort will be to try a macro, however, importing via econnect is preferred. Any advice or viable alternatives is appreciated. Running GP2016 R2.

 

Thanks,

Frank
"Enter Match Invoices" option don't bring the Receiving unit cost instead bring the PO unit cost
Good morning,
  My customer need the receiving unit cost per item instead that the purchase orders unit cost. The situation is the follow:
When select the PO from "Auto-Invoice" the system bring the Purchase Orders unit cost $121.57 but the user previously changed the unit cost to $125.00 at the Receiving process and need the Receiving unit cost (Shipment unit cost $125.00), right now to solve the situation the user have change the unit cost in the screen item by item but in many cases are too much. I have something alternative to bring the Receiving unit cost instead that PO unit cost?

 

Any suggestion is welcome,
GP2018 Ver 18.00.0672
Thanks,
 Mr. García
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