Clicky

We have a situation where a vendors invoice is displayed as WORK but it’s seemed not to be.  How can we find it and delete.

asked 11/18/2011 06:53

Ramante's gravatar image

Ramante ♦♦


14 Answers:
More info:
We have an accounts payable invoice registered in GP.  It says that is in WORK, but can’t find it in the Purchases Entry Window.
 
- In Inquiry >> Purchases >> Trans by Document, it displays in the origin column as WORK
- We go to Inquiry >> Purchases >> Trans by Customer, the invoice cannot be found
- We go to Smartlist to payables transactions and it does display the invoice number
- in Smartlist, the status is not posted
 
We need to delete this transaction.
 
What other window we can go and see the transition? Or how can we best work with this problem?
link

answered

Ramante's gravatar image

Ramante

This might be a hung document, and the only way to clear it out would be by deleting it from SQL manually. But you **should not do this** if you are not comfortable with SQL and the Dynamics document flow.

There is a good table reference here
http://dyndeveloper.com/DynTable.aspx?ModuleID=PM
that will help you find the tables that you need.

Vendor invoices are in PM10000 and PM20000
link

answered 2011-11-18 at 14:54:46

sgray128's gravatar image

sgray128

We are comfortable with SQL, we'll proceed.
link

answered 2011-11-18 at 14:58:00

Ramante's gravatar image

Ramante

Ramante, why are you facing too many orphans in your DB? I think you need to find out why rather than how.
link

answered 2011-11-18 at 15:12:32

Abdulmalek_Hamsho's gravatar image

Abdulmalek_Hamsho

Hi,

You should NOT delete records as your first step to resolve that issue--that should only be your last step after trying other alternatives.

At a minimum, you should first run Check Links, which has routines to detect and resolve those types of issues.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
link

answered 2011-11-18 at 15:36:59

sendow's gravatar image

sendow

Checked out the link, but it only refers to all tables, but no specifics to our problem.

Regarding orphan in our DB, we have recently had some LAN problema that is being assessed at this moment, nevertheless, we need to correct them.

Finally when we say DELETE them is by GP windows not SQL since it seems to be a WORK invoice.

The problem is its not in the actual windows it should be.

Maybe is some sort status value?

Please advice
link

answered 2011-11-18 at 18:19:23

Ramante's gravatar image

Ramante

Hi,

Always make sure you have a full backup of your Dynamics and company databases before running Check Links, or perform this process on a copy of your databases first (i.e. DEV environment).

Note that depending on your database size and number of transactions, this may take a while to run, so you will want to schedule it for after hours.

From the Dynamics GP menu, select Maintenance -> Check Links
Select Series = Purchasing
Select the Payables Transaction Logical File
Click OK
When prompted for report options, select Screen and File, and select a file name for the TXT report
Click on OK

If there are orphaned Work records, hopefully the Check Links will add them to a new batch and correct them, or remove them appropriately.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
link

answered 2011-11-18 at 18:38:30

sendow's gravatar image

sendow

Checklinks was the first thing we did and no results.

Our question on our previous entry is since the WORK invoice is not found in the PM transaction window, maybe is some sort of status that GP didn't finished doing.

How can we verify if the transaction within the DB is properly posted?
link

answered 2011-11-21 at 11:05:18

Ramante's gravatar image

Ramante

Hi,

One simple way to check for any problematic field values is to simply enter a new PM transaction of the same transaction type into GP and save it in a new batch.  (Make sure it is the same type)

Then query PM10000, and perhaps also PM00400, for your new test transaction and the orphaned record, and compare the field values.

Make sure the record has a batch, and that the field values look similar.

And just to check, what type of transaction is it?  Are you positive that you are using the proper inquiry / transaction window to view the transaction?  i.e. you won't see a check transaction listed in the payables transaction window.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
link

answered 2011-11-21 at 11:40:13

sendow's gravatar image

sendow

It's a payable in invoice and has nothing applied to.

As doumentated in initials entires, tha invoice is found in some windows an other no.  Yet it says it's WORK, but doesn't exist in the PM transaction windows.
link

answered 2011-11-21 at 11:50:13

Ramante's gravatar image

Ramante

Hi,

Try entering a new PM invoice into GP for that vendor and save it in a new batch.  

Then query PM10000, and perhaps also PM00400, for your new test transaction and the orphaned record, and compare the field values.

Make sure the record has a batch, and that the field values look similar, or see if you find any discrepancies in the record.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
link

answered 2011-11-21 at 12:16:18

sendow's gravatar image

sendow

Ok will proceed.
link

answered 2011-11-21 at 18:09:12

Ramante's gravatar image

Ramante

Will proceed to close
link

answered 2011-11-21 at 18:44:25

Ramante's gravatar image

Ramante

Thanx
link

answered 2011-12-12 at 15:18:13

Ramante's gravatar image

Ramante

Your answer
[hide preview]

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

Asked: 11/18/2011 06:53

Seen: 368 times

Last updated: 12/12/2011 07:20