Random Doubling of Unapplied Amount for Invoices (Payables Managem

[RJL]

We have recently ran into the following problem during our last two AP
batches. Invoices are entered in Payables Management. When we begin the
process of applying amounts for payment we notice that one invoice shows an
unapplied amount double the invoice amount. For example if the invoice
amount is equal to $100. The unapplied amount shows up as $200. We
researched knowledge base and found an explanation for a situation where
every invoice in a batch has a doubled unapplied amount. In our case for
both of our batches only one invoice in each batch shows the doubled
unapplied amount. There is no apparent connection (such as same vendor or
amount) between the two doubled invoices. We were curious if anyone has run
into this problem before and if so what was the cause and solution. For your
information we are currently running Great Plains Version 8.0.

Any help will be greatly appreciated.

Thanks,

[Victoria [MVP]]

We have seen a similar situation, though not exactly the same, when our
customer was printing very large check batches which caused the printer and
the GP application to crash.

Long story short, in that particular case we had to fix the unapplied
amounts directly in the SQL tables. That should only be done by someone
knowledgeable about the GP SQL tables or GP support. Before resorting to
that, you can try running check links and reconcile on the Payables series
to see if either of those clear the problem up. Make a backup of your data
first!
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

Post by RJL
We have recently ran into the following problem during our last two AP
batches. Invoices are entered in Payables Management. When we begin the
process of applying amounts for payment we notice that one invoice shows an
unapplied amount double the invoice amount. For example if the invoice
amount is equal to $100. The unapplied amount shows up as $200. We
researched knowledge base and found an explanation for a situation where
every invoice in a batch has a doubled unapplied amount. In our case for
both of our batches only one invoice in each batch shows the doubled
unapplied amount. There is no apparent connection (such as same vendor or
amount) between the two doubled invoices. We were curious if anyone has run
into this problem before and if so what was the cause and solution. For your
information we are currently running Great Plains Version 8.0.
Any help will be greatly appreciated.
Thanks,
--
RJL

...

[RJL]

Victoria,

Thanks for the information. I will try what you suggested and let you know
if I'm able to solve our problem

Thanks Again,
--
RJL

Post by Victoria [MVP]
We have seen a similar situation, though not exactly the same, when our
customer was printing very large check batches which caused the printer and
the GP application to crash.
Long story short, in that particular case we had to fix the unapplied
amounts directly in the SQL tables. That should only be done by someone
knowledgeable about the GP SQL tables or GP support. Before resorting to
that, you can try running check links and reconcile on the Payables series
to see if either of those clear the problem up. Make a backup of your data
first!
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

Post by RJL
We have recently ran into the following problem during our last two AP
batches. Invoices are entered in Payables Management. When we begin the
process of applying amounts for payment we notice that one invoice shows an
unapplied amount double the invoice amount. For example if the invoice
amount is equal to $100. The unapplied amount shows up as $200. We
researched knowledge base and found an explanation for a situation where
every invoice in a batch has a doubled unapplied amount. In our case for
both of our batches only one invoice in each batch shows the doubled
unapplied amount. There is no apparent connection (such as same vendor or
amount) between the two doubled invoices. We were curious if anyone has run
into this problem before and if so what was the cause and solution. For your
information we are currently running Great Plains Version 8.0.
Any help will be greatly appreciated.
Thanks,
--
RJL

...

[Dwight Specht]

Are you running Workforce ROI (used to be called Intellisol Project
Costing), Project Accounting or any other third party that effects the AP
module?

Dwight

Post by RJL
We have recently ran into the following problem during our last two AP
batches. Invoices are entered in Payables Management. When we begin the
process of applying amounts for payment we notice that one invoice shows an
unapplied amount double the invoice amount. For example if the invoice
amount is equal to $100. The unapplied amount shows up as $200. We
researched knowledge base and found an explanation for a situation where
every invoice in a batch has a doubled unapplied amount. In our case for
both of our batches only one invoice in each batch shows the doubled
unapplied amount. There is no apparent connection (such as same vendor or
amount) between the two doubled invoices. We were curious if anyone has run
into this problem before and if so what was the cause and solution. For your
information we are currently running Great Plains Version 8.0.
Any help will be greatly appreciated.
Thanks,
--
RJL

...

[RJL]

Dwight,

We are not running Workforce ROI, Project Accounting or any other third
party that would effect the AP Module.
--
RJL

Post by Dwight Specht
Are you running Workforce ROI (used to be called Intellisol Project
Costing), Project Accounting or any other third party that effects the AP
module?
Dwight

Post by RJL
We have recently ran into the following problem during our last two AP
batches. Invoices are entered in Payables Management. When we begin the
process of applying amounts for payment we notice that one invoice shows an
unapplied amount double the invoice amount. For example if the invoice
amount is equal to $100. The unapplied amount shows up as $200. We
researched knowledge base and found an explanation for a situation where
every invoice in a batch has a doubled unapplied amount. In our case for
both of our batches only one invoice in each batch shows the doubled
unapplied amount. There is no apparent connection (such as same vendor or
amount) between the two doubled invoices. We were curious if anyone has run
into this problem before and if so what was the cause and solution. For your
information we are currently running Great Plains Version 8.0.
Any help will be greatly appreciated.
Thanks,
--
RJL

...