[Mary Mallazzo]

Hello
The “Received not invoiced”  report total does not balance to the accrued A/P account in the G/L.  We have taken into account those transactions , journal entries, that have been posted the  accrued  A/P G/L account.  My next step is to extract out of the G/L the detail in the accrued account and then compare to the “Received no Invoiced report.
Just wondering if there is an existing function/report that I could use to see what the differences are.

Thank You

——————————
Mary Mallazzo
Fromkin Brothers
Edison NJ
——————————

[Michael Taranto, CPA]

Hi Mary,

There is a historical received not invoice report that was added with GP 2015 R2.  I use it to recreate the balance at any date.  Eliminating the GJ entries to get to the bare results is a good decision.  

Hope this helps
Mike

——————————
Michael Taranto, CPA
President
ERP Consulting LLC
Pataskala OH
——————————
——————————————-

[Kurt Raddant]

?Hello:  We just upgraded from R2013 to 2015 and then up to 2018.  I am trying to use this new Historical Received/Not Invoiced Report.  I am seeing “Error: Subreport could not be show” messages on the report…..and it isn’t close to the GL balance.  Anyone else experience problems with this report and tying to the Accrued Purchases GL?  Thank you.

——————————
Kurt Raddant
Curative Connections/ProSolutions, Inc.
Green Bay WI
——————————
——————————————-

[Kurt Raddant]

?It appears to me that this new Historical Received but Not Invoiced report is not 100% accurate.  If I run this report now, using a Cut Off Date of 6/30, then it looks like it is removing anything paid in July.  It doesn’t seem to recognize that those were paid after 6/30 – and should still be showing as ‘Received/Not Invoiced’ as of that point in time (6/30/18).  Can anyone confirm this?

——————————
Kurt Raddant
Curative Connections/ProSolutions, Inc.
Green Bay WI
——————————
——————————————-

[Mary Mallazzo]

Kurt
We have never gotten the historical report to tie out.  We have given up using it.  We not go thru many gyrations dumping data to excel and validating that way.

God Luck!

——————————
Mary Mallazzo
Fromkin Brothers
Edison NJ
——————————
——————————————-

[Jo deRuiter]

?Unfortunately I do not know of a less manual way to do this kind of reconciliation.  As well as comparing the two you may want to look at posted receipts that hit the GL, but did not post to the Accrued account.  I’ve seen it occur, on occasion, that there was a miscoding on a receipt.

You can utilize SmartList Filters to find those by querying the Originating Transaction Source containing “RECV” and the Account Number “NOT” your Accrued Purchases account.

——————————
Regards,

Jo deRuiter
“That GP Red Head”
Senior Financial Systems Consultant
Heartland Business Systems, LLC
Little Chute WI
920-687-4797 (Work)
770-906-4504 (Cell)
——————————
——————————————-

[Bruce Strom]

?We use the RNI report to balance to the general ledger each month, usually to the penny.
Keep in mind that “received not invoiced” means that once a receipt has been invoiced it drops off the report whether or not the POP Invoice batch with the transaction has been posted.
Also, you have to be careful you are not sloppy in closing PO’s or PO Lines when they will not be invoiced, this will cause reconciliation problems.  Instead, “refund” those un-invoiced PO’s so a GL Entry is generated.

——————————
Bruce Strom
Programmer Analyst
Associated Grocers of Florida
sunrise FL
——————————
——————————————-

[Gianmarco Salzano]

Hi Mary, 

We have a solution called The Closer that is General Ledger Sub-Ledger reconciliation tool.  The Closer has a module for Accrued Purch.
We have helped many DynGP users with this specific issue.

If you’d like to take a look at it, please let me know and we can schedule a quick demonstration…

Thank you,

——————————
Gianmarco Salzano
Vice President
Reporting-Central
Tampa FL
813-579-4991
——————————
——————————————-

[Thomas Hill]

We just converted from GP2010 to GP2015.  When I started in 2014, the Accrued A/P had not been reconciled since 5/2012.  

Back then, I pulled a number of smartlists to get all of the fields of data.  Purchase Orders were not closed properly, ever.  If something was received and NEVER invoiced, the amount was written off directly, not clearing the receiving in Great Plains.  

Now, I use an ODBC connection to get the GL transactions for the month, with links to get the related purchase order numbers on each transaction.  I sort by Purchase Order Number.  I can see if there are any uncleared items.

Since it is under control, I can reconcile it in about 20 minutes.  The process can be done in Excel, I just do not know VBA programming to automate as it is in this tool.  

In Great Plains, the amount of purchase orders that I have showing open, even they were received and invoiced, is astronomical.  

——————————
Thomas Hill
Accounts Payable – Expense Processing
M&A Technology, Inc.
Carrollton TX
——————————
——————————————-

[Lou Spevack]

As mentioned above, issues with reconciling the received/not invoiced report often boil down to operational issues with closing POs and properly recording receiving quantities.  A good approach is to start reconciling the report balance to GL every day.  That way, you can catch errors early and without tackling a whole group of them at once.  As you resolve issues and find the report balancing most of the time, back off to reconciling once a week, then twice a month and then monthly.  By that time, errors will be few and far between.

——————————
Lou Spevack
Systems Accountant | Dynamics Credentialed Professional
American Council on Education
Washington DC
——————————
——————————————-

[Kurt Raddant]

?I just tested this report for 7/31 month-end.  I had my folks back-post any final receipts to July.  I ran the Historical report as of 7/31 and it matched exactly to the GL for Accrued Purchases (Received/Not Invoiced).  Then they entered invoices dated 8/1 and 8/2 that were for these receipts that happened in July.  I ran the report again as of 7/31 and now it is wrong.  The report seems to accurately look at the GL dates that the Receipts are posted to. But it does not correctly evaluate the Invoices paid against those receipts – to determine that those were paid after month-end.  It is already pulling those off the Received not Invoiced report as of 7/31.  Looks like GP needs to do some more work on this report.

——————————
Kurt Raddant
Curative Connections/ProSolutions, Inc.
Green Bay WI
——————————
——————————————-

[Kathy Neufeld]

Thomas Hill,
Would you be willing to share your report details – this looks like something we may be able to use??
What tables were you linking to get the information?
Thanks.

——————————
Kathy Neufeld
Mid Kansas Cooperative
Moundridge KS
——————————
——————————————-

[Thomas Hill]

These are the tables in GP I am using.  The “_MA” appended is to make it clear to me, which of our four companies I am referencing.  The MAGL_Temp is a temporary table.  In dbo.GL20000 I search for the records for the accrue payables for the current month.  Then I import them into the temporary table.  As they are imported a lookup is make from dbo.POP10500 to append the purchase order number.  

I am not an SQL expert.  This could probably be done through SQL code and dumped in Excel.  I use a database program (FileMaker Pro) to handle the work for me.  

——————————
Thomas Hill
Accounts Payable – Expense Processing
M&A Technology, Inc.
Carrollton TX
——————————
——————————————-

[Brook Newton]

Thomas,

I would also be very interested in your report.  We do not ship a lot of items from our warehouse.  Most of our shipments are drop shipped and I have an ulcer from trying to get this to balance. 

Any help you could give would be greatly appreciated.

——————————
Brook Newton
Ideal System Solutions, Inc.
Pequot Lakes MN
——————————
——————————————-

[Thomas Hill]

It is end of month right now (oy vey).  Let me play with this, to see if I can make it stand-alone.

——————————
Thomas Hill
Accounts Payable – Expense Processing
M&A Technology, Inc.
Carrollton TX
——————————
——————————————-