DataBase - Sales Territory Maintenance - History
Asked By rcr
26-Jan-10 04:59 PM
I am trying to reconcile the figures for a period in history, and having some
difficulty. When I pull a smartlist with territory ID I am not getting the
same figures. I am using Sales Transactions smartlist, I have tried the field
from the customer master as well as sales transaction. It is still not giving
me what is there.
What am I missing?
appreciate any comment about this matter. emiranda Great Plains Discussions Leslie Emiranda (1) Update (1) Salesperson (1) SOP (1) Hi Emiranda, There may be several issues with this approach. What need are you satisfying by updating the salesperson id on posted invoices? The salesperson ID also appears on the sop line, so that would probably need to be changed changed in the SOP files, you still need to change the summary numbers in the Salesperson Card, and potentially the sales territory card. Kind regards, Leslie Not to mention that commissions are actually calculated in Receivables Management Gomez, MIS, MCP, PMP Maximum Global Business, LLC http: / / www.maximumglobalbusiness.com The Dynamics GP Blogster at http: / / dynamicsgpblogster.blogspot.com keywords: SQL, Update, to, a, SOP, table description: Hello all
an update query I am trying to run. I have two tables, "Territories" and "Unique Territory" There are 60 entries in the Territories table and I would like the Unique territory table to display one territory at a time in order to run subsequent reports. Here is my code: Set rsterritory CurrentDb.OpenRecordset("select distinct Territory from [Territories] order by Territory") Do While Not rsterritory.EOF 'update current territory table to the current record CurrentDb.Execute ("Update [Unique Territory] set [Territory] = '" & rsterritory!territory & "'") Next r = r + 1 rs.MoveNext Loop Set rs = Nothing I am not