DataBase - PO amount different on PO Entry screen from printed PO

Asked By NathanSadownic
06-Jun-07 05:05 PM
Hi,

We have a problem that seems to happen every month.  In the Purchase Order
Entry window, the subtotal on this one particular PO is $590,776.35.  However
if we print the PO, the subtotal amount on the printed PO is only
$472,451.66.  The only seems to happen on random PO's and we can't figure out
why.  It's starting to annoy our Purchasing department...

Ideas?

Thanks,

--Nathan
PO
(1)
GP
(1)
MVP
(1)
AccoladePublications
(1)
NathanNathan
(1)
CONTROL
(1)
BDFA
(1)
AAC
(1)
  Victoria [MVP] replied...
07-Jun-07 05:12 AM
Nathan,

What version and service pack of GP?
Are there PO's entered manually or imported?
Is the PO report modified?
Are there typically a lot of changes to the PO's that this happens to?

--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.
  inf replied...
07-Jun-07 10:12 PM
In addition to Victoria's questions, which total is correct?  The screen
display or the printed form?  Have you tried to run a reconcile that PO
(Tools ->Utilities-> Purchasing->Reconcile Purchasing Documents)?  And does
this Reconcile process clean up the problem PO?

--
Richard L. Whaley
Author / Consultant / MVP
Documentation for Software Users

Get our Free Tips and Tricks Newsletter and check out our books at
http://www.AccoladePublications.com
  NathanSadownic replied...
08-Jun-07 01:48 PM
We're on v8 with service pack 5.  The PO's are enterened manually.  The PO
report is not modified.  Not a lot of changes are made.

I ran check links, however have not tried a reconcile.  The amount shown on
the screen (in the Purchase Order Entry window) is correct.

I will try the reconcile process this weekend and post the results Monday.

Thanks for the replies!

--Nathan
  NathanSadownic replied...
21-Jun-07 12:05 PM
Well I ran the reconcile process, but to no avail.  The problem still exists,
and we're still sitting here scratching our heads.  Still looking for other
ideas...

Thanks,

--Nathan
  Victoria [MVP] replied...
22-Jun-07 04:45 PM
Nathan,

If the amount on the screen is correct, then it may be a problem with the PO
report.  Since you're not using a modified report what you can do is
recreate the report.....one way to do this:

- Exit GP.
- On the workstation you're on, make sure your dynamics.set file is pointing
to a local reports.dic (as opposed to a shared one).
- Go to the local path specified for reports.dic in your dynamics.set file
and if there is already a reports.dic file there, rename it or move it
elsewhere.
- Re-enter GP and reprint the PO - do you still have the issue?

--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.
  NathanSadownic replied...
25-Jun-07 03:45 PM
Hi Victoria,

If I follow these steps, I get an error stating 'Unable to open dictionary:

I get this error if I try to print to screen, or my printer.  How can I
reprint this if I'm pointing to a local path that does not contain a
reports.dic file?

Thanks,

--Nathan
  Victoria [MVP] replied...
26-Jun-07 07:25 AM
Nathan,

I believe that error indicates a Windows permissions issue - the Windows
user you're logged in as needs to have FULL CONTROL of the entire GP
directory and the Reports.dic file if you've put it somewhere other than the
GP directory.

--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.
  NathanSadownic replied...
26-Jun-07 11:14 AM
Hi Victoria,

I've double checked and made sure that I have the appropriate Windows
permissions to that directory (which I do).

If you launch Great Plains, and it is unable to find a reports.dic file in
the directory that you've specified in the dynamics.set file, will it create
a new reports.dic file?

Thanks again,

--Nathan
  Victoria [MVP] replied...
27-Jun-07 07:34 AM
Nathan,

Yes, if it need a reports.dic file and it's not there, it will create one.
If you're still getting that error, try logging into Windows as the local
admin and see if that works.

--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.