[Jessica Murphy]

Our AP department is trying to post an invoice and gets the message “Insufficient inventory transactions with status Purchased.”  What would cause this, and how do we fix it?  We’re on AX2009

——————————
Jessica Murphy
Master Planner
Goodwill Industries of Central Indiana
Indianapolis IN
——————————

[James Wellington]

Hi Jessica,

I’d start with contacting whomever does the receiving transactions and see if they had any troubles receiving the order. Review the PO lines product registrations and receipts.

——————————
James Wellington
IT Manager – Analyst
States Industries
Eugene OR
——————————
——————————————-

[Ben Green]

When we have this problem, it’s always driven by a receiving error and I haven’t found a consistent way to correct it.  Sometimes it’s just a matter of completing a receipt or finding an open inventory transfer or incorrect consumption.  I think I still have a couple sitting open that the receiving team haven’t figured out yet.

——————————
Ben Green
Orion Energy Systems
Manitowoc
——————————
——————————————-

[Tony Malarz]

There’s a couple of things in 2009 that resets the status & receipt fields on InventTrans to zero.  This can cause your error message.
One I know is a confirmed bug with Filter by Value, fixed in a higher update (I’m stuck at sp1cu3), there’s something else too that I’ve never pinned down.
Zero is an unknown value so DAX can’t figure out what the transaction really is – so it tells you “not enough”

It’s very easy to verify using consistency check (Basic- Periodic- Consistency check)
Module = Inventory Management
Check/Fix = Check
In the checkbox tree below, uncheck Forecast, Journals, & Setup
Click on Item in the tree, click Dialog button to get the selection filter screen, add a criteria for just your item/s.
Click OK to run the check.
Runtime varies by number of transactions on the item.

Anything found will show in the info window, you can run it again with Check/Fix = Fix.

I got tired of manually doing this couple of times each month, got myself a mod to find it, call consistency check programmatically, put it on the scheduler to take care of itself.

——————————
Tony Malarz
Sr. Database Analyst
Nortek Air Solutions
Eden Prairie MN
——————————
——————————————-

[Corey Vantilborg]

The comment about the receiving is important. 

The next step would be to look at the inventory transactions for the item in question. From there you can you look at the transactions related to the PO being invoices. 

——————————
Corey Vantilborg
ERP Analyst
Tigercat International Inc.
Brantford ON
——————————
——————————————-