Sign Up Now!Log In



Document Attachments introduced in GP2015 is a great improvement over the old OLE Notes attachments.

Attachments are stored in SQL server, eliminating administrative headaches such as managing file permissions and backups. 

While it is easy to attach and retrieve documents one by one, accessing a whole list of documents can be challenging.  opening each document requires multiple clicks.

I have an application where the user clicks a button to save the data.  This can take several seconds to complete and I would like some way to indicate that the app is running.

Good afternoon,

We have a sales process with the following scenario:

1- Sales order has five line items.  Four of them are physical items.

2- Fifth item is a Service whereby we will be on-site to help in the assembly.\

3- We wish to invoice the customer for the four line items immediately, but do not wish to invoice them until after the on-site work is completed.

4- We have this fifth item setup as a flat fee so it cannot be configured as a back order quantity.


What is the best way to handle this in GP 2010?

Thank you,


My client is using organizational structure to prevent certain people from seeing payroll accounts. Since they are using a new six segment account structure the main segment is added more frequently than before and it causes the "edit list" on the GL print out to show the same account description every time versus the correct account description. 

Example:    instead of 10-11111-20000-12-11-10  showing  Accounts Payable like it should it shows the same account number but the description shows Accounts Receivable on all accounts. 


Anyone run into this issue?  Is this a Modified report issue? How did you fix it if so? 


The only solution I have found is to unassign and reassign the "non payroll" user in the Org structure which is not the ideal way to fix this every time. 

This is for GP2018 and it also happened while using GP2015. 

I am trying to locate the table that stores the information related to the ship to information on a line item.

When I click the arrow next to "Ship To Address ID" I get the following window:

Which table holds the information for this form?

Does DOCAMNT in SOP10100 include the freight, or is that strictly in FRTAMNT?
The follow  up question is what is/should be included in DOCAMNT in SY00500?

Many Thanks!



good day!

I would like to know if you can guide me, how I can associate by the SOP master order number, the lines that have been transferred. Example, if you make a quote with 5 items, when transferring to order, the same when transferring only 3 item was transferred, and at the time of making invoice, only 1 item had quantity available.

It is more or less, a tracking of the items in each sales document.

Someone could help me, I would like to do that in sql.

Thank you

I have been asked to change currency ID from EURO to EUR is this possible?

If its possible would this be done in GP or at a SQL level



Good evening,
     I have the following situation while landed cost increase my inventory unit cost (work fine) i need the opposite too because my vendor take me a special discount and i need to reduce the inventory unit cost (Landed Cost not accept negative amount). Any suggestions is welcome.
  Mr. García

can anyone point me toward documentation that outlines dynamics gp capability of generating/printing invoices to send to customers? Also, a way to upload our own template for invoices to adhere to? unfortunately i've come up with no solid documentation that confirms and/or describes this functionality.

thank you in advance!


Client wants a sql report (Excel refreshable spreadsheet maybe?) to pull the GL account balances.  That part is easy


the hard part is - there are multiple companies - with different currency rates.


I know that the historical rates are in the GP tables.  Is it possible (without mega programming) to dump the GL account balances for these foreign currencies and get the local USD rate?  The balances in the SQL tables are in the foreign dollars.


Maybe something exists out there somewhere?

Dear Sirs

If I want to see what items will expire in one particular month, there's no report in GP 2010 out of the box that provides me with it. I can't select a date range for this search in the lot number report in Inventory module, only by Item Number..

Any suggestion?