DataBase - Sales invoice (receivables)

I have about 7 RM accounts which are showing the same problems.

After everything has posted to the GL accounts, it does not show the invoice
on the customers account its almost like that invoice just vanished.

Attempted Sales Reconcile on those accounts and that didn't fix the issue.

Any ideas? (thanks)

  K replied...

In case anyone runs across this issue.

I ended up running a check links on Sales -> Receivables Open Transaction
History
I then did a reconcile on sales.

This seemed to clean up dead orphans on that invoices and we just re-entered
the missing invoices.

Casey

but I can’t seem to find a solution anywhere. Below is my SQL: SELECT RM.SalesRegion, RM.SalesOffice, RM.SalesRep, RM.Advertiser, RM.Advertiser1, RM.Agency, RM.IO, RM.IO_Start, RM.IO_End, RM.inventoryClass, RM.CUR_MTD_REV, RM.JAN, RM.FEB, RM.MAR, RM.Q1

RM Detail Historical Aged Trial Balance DataBase As a tangent to this thread: http: / / groups.google microsoft.public.greatplains / browse_thread / thread / d2159a991f063471?hl = en What tables are used for (GP9) Reports> Sales> Trial Balance> Aged Trial Balance> Detail (Report Writer MC RM Detail Historical Aged Trial Balance)? RM30101 (RM History File) / RM30201 (RM Apply Open File) ? The report writer uses a couple of temp tables RM HATB Applied TEMP, for example). Great Plains Discussions Report (1) CustomerName (1) AccountRep (1) DaysOld ISNULL(s.SALSTERR, '') AS SALSTERR, c.SLPRSNID, RTRIM(LTRIM(c.USERDEF1)) AS AccountRep, RTRIM(LTRIM(rm.CUSTNMBR)) AS CUSTNMBR, RTRIM(LTRIM(c.CUSTNAME)) AS CUSTNAME, RTRIM(LTRIM(c.CNTCPRSN)) AS CNTCPRSN, LEFT(c.PHONE1, 10) AS PHONE1, RTRIM(LTRIM(c.PYMTRMID)) AS PYMTRMID, rm.BCHSOURC, rm.RMDTYPAL, rm.CSHRCTYP, rm.DOCNUMBR, rm.DOCDATE, rm.POSTDATE, rm.GLPOSTDT, rm.ORTRXAMT

INV_NUM , CRED.TRANS_TYPE , CRED.SECOND_REF , CRED.GL_JOURNAL , CRED.DATE , CRED.CREDITOR_CODE , CRED.TAX_VALUE , CRED.NET_VALUE , GL.ACCOUNT_NUMBER , GL.SECOND_REF FROM CRST_Query_2 AS CRED LEFT JOIN GENT_Query_2 AS GL ON (CRED.GL_JOURNAL = GL.REFERENCE) AND (CRED.INV_NUM = GL.SECOND_REF); Access Getting Started Discussions Accounting (1) Excel (1) VBA (1) Database (1) ParameterValue (1 INV_NUM , CRED.TRANS_TYPE , CRED.SECOND_REF , CRED.GL_JOURNAL , CRED.DATE , CRED.CREDITOR_CODE , CRED.TAX_VALUE , CRED.NET_VALUE , GL.ACCOUNT_NUMBER , GL.SECOND_REF FROM CRST AS CRED LEFT JOIN GENT AS GL ON (CRED.GL_JOURNAL = GL.REFERENCE) AND (CRED.INV_NUM = GL.SECOND_REF) WHERE (CRED.DATE> = #6 / 15

FIRST ONLY DataBase Riddle me this, Batman. . . Take the following: EXEC SQL SELECT ACCOUNT_NUM INTO :GL-REF-ACCOUNT-NUM FROM FB_LN_ACCT_PROD_REF WHERE LOAN_TYPE = :GL-REF-LOAN-TYPE AND CATEGORY = :GL-REF-CATEGORY AND CALL_TYPE = :GL-REF-CALL-TYPE AND FAMILY_1ST_DOT IN (:GL-REF-FAMILY-1ST-DOT, ' ') ORDER BY FAMILY_1ST_DOT DESC FETCH FIRST 1 ROWS ONLY END-EXEC does not work with SELECT INTO? My workaround is this: EXEC SQL SELECT ACCOUNT_NUM INTO :GL-REF-ACCOUNT-NUM FROM ( SELECT ACCOUNT_NUM FROM FB_LN_ACCT_PROD_REF WHERE LOAN_TYPE = :GL-REF-LOAN-TYPE AND CATEGORY = :GL-REF-CATEGORY AND CALL_TYPE = :GL-REF-CALL-TYPE AND FAMILY_1ST_DOT IN (:GL-REF-FAMILY-1ST

trying to capture all records from 2010 AOP even if there is none from SAP GL side. It seems to work with SAP GL, but not all of the AOP side. What am I missing? Not sure how to fix. SELECT [DC Conversion].DC, [2010 AOPII with Benefits].DC, [2010 AOPII with Benefits].[SAP GL], [Category conversion].Category, [SAP P4 GL].[COST ELEMENT], [Category conversion].[Cost Element Name], Sum([SAP P4 GL].P4) AS SumOfP4, [2010 AOPII with Benefits].P4 FROM [2010 AOPII with Benefits] INNER JOIN SAP P4 GL] INNER JOIN [DC Conversion] ON [SAP P4 GL].[COST CENTER] = [DC Conversion].[SAP Cost Center]) INNER JOIN [Category conversion] ON [SAP P4 GL].[COST ELEMENT] = [Category conversion].[SAP GL]) ON ([2010 AOPII with Benefits].[SAP GL] = [Category conversion