DataBase - PO Line Item - Item Type Incorrect
Asked By KimberlyCowgil
11-Sep-08 02:57 PM
A user received a PO but inventory transactions were never created. After
looking at the PO, the PO line item has a Item Type of non-inventory. The
same item # is on the PO twice and the item type is correct on one of the PO
line items. The item is setup as a Sales inventory item in Item Maintenance.
Has anyone ran into this undocumented feature?
PO
(1)
MCT
(1)
MCP
(1)
MVP
(1)
GP
(1)
ComWhere
(1)
ComRe
(1)
ID
(1)
Frank Hamelly, MCP-GP, MCT, MVP replied...
I'd bet a quarter somebody entered the 1st line prior to it being
setup in the Item Card. Then they decided to add the item and entered
it on the PO again, forgetting to delete the first, non-inventory
line.
Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com
KimberlyCowgil replied...
You owe me a quarter! The item was setup in Item Maintenance and is used all
the time.
AdamEckrot replied...
I'd bet 2 cents (add 2 cents) that the item is not the exact same item (maybe
only an extra space or something is slightly different) and the "Add Item"
extra/additional .cnk code is not installed nor the Add/Item setting was not
marked prior to the entering of the PO, so the item itself is not the exact
same item# that is stored in inventory. Perhaps a SQL query of the item on
the PO could be compared with the item ID field in the IV00101.
Frank Hamelly, MCP-GP, MCT, MVP replied...
Where do I send the check Kimberly? lol
Adam's suggestion is a good possibility too.
Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com
Jeganeedhi replied...
Is PO created through e
connect?
If PO created through e
connect,check out the Noninventory of Econnect input.
Otherwise skip out this.
PO next number changes randomly GP10 DataBase Hello, The company I currently work for has been seeing the next PO number being changed in the purchase order processing screen. This occurs randomly. To try to Hi JC when you say it is changing what do mean? I believe that the PO numbers will go back and fill in for PO's that have been deleted. I.E. if you PO's 1-10 and delete 8 then the next PO will be 8 and the one after that will be 11. I am not 100% tested this and it does not work as you described below. Ex. if I delete PO number 8 and try to add a new PO, it will use the po next number in the sequence. It does not try to
Changing the Item in PO Entry DataBase I have a client on GP 9.0, SP3 that cannot change the Item once it's been entered on a PO, even prior to the Item being committed on the line. When you try to edit the system that enables / disables the ability to edit the item number prior to the PO being released? Thanks in advance, Frank Hamelly MCP-GP, MCT, MVP East Coast Dynamics www.eastcoast-dynamics.com Great Plains Discussions Accounting (1) EthoSeries (1) Diagnostics
PO Receiving Tolerance code from Professional Services DataBase Is anyone currently using this tool? So far all items and vendors or if it is more granular (e.g. set for a PO or set by item). Thanks. - - Jim@TurboChef Great Plains Discussions TurboChef (1) Convergence (1) Encumbrance tolerance percentage to allow for receiving quantities. The tolerance percentage will be used when a PO is received. The system will not allow a quantity to be received that is more at 0%. Example : = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = A tolerance percentage of 20% is entered in the setup window. A PO with a line item that has a quantity of 10 is entered and saved. When the PO is received the highest quantity allowed will be 12. Quantity Ordered of 10 + 20% of the quantity ordered plus the tolerance percentage. = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = Best Regards, Raymund Gerard I. Miraflor Microsoft Dynamics GP Microsoft Online Support = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = PLEASE NOTE: The partner managed newsgroups are provided to assist with break to allow for receiving quantities. \ par \ par The tolerance percentage will be used when a PO is received. The system will not allow a quantity to be received that is more Example : \ par = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = \ par A tolerance percentage of 20% is entered in the setup window. A PO with a line item that has a quantity of 10 is entered and saved. When
Cannot change received PO to Change Order DataBase Great Plains will not allow me to change a Purchase Order open this Purchase Order so I can change the price??? Thank you. Great Plains Discussions PO (1) MCP (1) MCT (1) MVP (1) GP (1) ComYou (1) SDRAM (1) POand (1) Cheryl, Make the change directly in the PO Entry window. This will update the line item quantity and status of the PO to Change Order. It sounds like you're trying to do this in 'Edit PO
Freight field on a PO, Landed Costs DataBase We have used a non-inventory item named 'FREIGHT' to charge for the related freight costs when creating PO's for the past several years. I was curious about using the Freight field instead to our non use of it? Also, in a test company, I just entered a PO and with a amount in the freight field and when I received the PO the freight amount did not come over. It was greyed out. Then when I match costs on an invoice. Although you can enter freight in the Freight field on a PO, it does not come over to the receiving or invoicing transaction because there can be many receipts / invoices to one PO. The Freight field on the PO is nothing more than a reference field. That's why the Freight field is greyed another layer of data input to process your receipts / invoices. Hope this helps, Frank Hamelly MCP-GP, MCT, MVP East Coast Dynamics www.eastcoast-dynamics.com blog: www.gp2themax.blogspot.com