Archives

 

Item number/location code (ITEMNMBR/LOCNCODE) does not exist in the Item Quantity Master Table - IV00102
taPOPLine Error 261

A couple of housekeeping things:

  • This error can occur in any module that uses inventory, the causes are the same
  • While I am going to go through the usual troubleshooting...
  • The resolution, in this case, is completely off the wall.

Today, I will discuss more on how to limit, or filter, the amount of data returned from a SELECT statement.  I will also talk a little about Boolean logic.  Don’t worry, you don’t need to be Spock to understand it.
 

This short code example will show you how to configure an ASP.NET website for Windows Authentication, then to allow only members of  a certain group

The <location path="ErrorHandler"> section is intended to allow access to the ErrorHandler folder off the root, to allow for custom error pages. If a user is not allowed, we'll give them a friendly reason why not. 

 

I am having problems with my PO processing.  The header is not updating in the POP10100 table and the lines are being added (each time I run it) rather than updated in the POP10110 table.  I think it is a problem with eConnect.
This is a complete example for the RadGrid EDITFORMS edit mode. The grid will call and load a user control and use that for editing
I had a request for a query that would update either 1 item or all items in the IV00102 table, using quantities from the SOP10200 table.  
 
I need to update the IV00102 table from a sum of the item quantities in the SOP10200 table.  I need to be able to do this for an individual item or all items.
 

 
I had a request for a query that would update the allocated quantity in the IV00102 table based on the sum of the QUANTITY’s in the SOP10200 table.  The customer wanted the ability to do this for either one individual item or all items.
 
This is a sample XML file so you can see what your final document will look like. This document is a PMTransaction with distributions
This is a sample XML file so you can see what your final document will look like. This document is a minimum PMTransaction

This is SQL code that will drop all 'inactive' Dynamics GP users from the SQL database completely. 

It is UNTESTED and should be used as such. 

This is SQL code that calls the taPMTransactionInsert stored procedure. We 'wrap' the proc and make it easier to call. 

This is a short piece of code that will run DBCC CHECKTABLE against all the tables in a database. 

In case you were wondering, DBCC CHECKDB does the following:

Runs DBCC CHECKALLOC on the database.
Runs DBCC CHECKTABLE on every table and view in the database.
Validates the Service Broker data in the database.
Runs DBCC CHECKCATALOG on the database.
Validates the contents of every indexed view in the database.

and DBCC CHECK TABLE does these tasks:

Index, in-row, LOB, and row-overflow data pages are correctly linked.
Indexes are in their correct sort order.
Pointers are consistent.
The data on each page is reasonable, included computed columns.
Page offsets are reasonable.
Every row in the base table has a matching row in each non-clustered index, and vice-versa.
Every row in a partitioned table or index is in the correct partition.

So, running CHECKDB is more comprehensive.

 

I have $100 invoice broken down into 4 lines. Out of the 4, distribution type for 3 are PURCH and the other one is OTHER. The total purchase ($100) goes to PAY.

Great Plains does not allow me to post it with an error to the effect that distribution does not match.

Is there a way to get around this?

Thanks

Paul

Do you have any examples of creating a stored proc in dexterity to match any of the eConnect stored procedures that can then be called through dexterity?

There are so many parameters and I am not sure if I have to create a one to one in the dexterity stored procedure or just for the ones I use and for the error information.

Thanks,

Lonnie

You know how GP stores their passwords in binary table fields?  Is there a library we can use to decrypt that password without having to be running as a GPAddIn?  I'm creating a web service for a client that needs to validate against the budget passwords, and noticed they were the GP encrypted password fields.
New here and relatively new to GP so if already addressed, just point me at it.  We have not had luck with SmartConnect running reliably so the directive is to write a direct update of Vendor info from another SQL DB to GP.  So, has anyone crossed this bridge and defined the tables, key fields, validations,  etc involved??

We record prepayments directly on our orders using the Amount Received field (Sales Payment Entry window).  This works perfectly when the payment is cash or credit.  However, sometimes we need to apply part of the payment from a credit on the customer account.  I don't believe there is a way to do this pre-invoice, however, I'm wondering if I can at least use the COD Amount field on the Sales Payment Entry window to track what still needs to be applied to the order after the invoice is posted.  From what I can tell, entering an amount in the COD Amount field does nothing.  It seems to be just a place holder.  Is that accurate?  If I apply a partial cash payment, put the remaining in COD, invoice, post, and then apply the remaining amount due from credit - will that work?  Or will having an amount in COD come back to bite me somewhere down the road?  I want to use this in a custom development piece that holds these orders until paid in full.  If I can use the sum of deposits received and COD amount, then I can account for apply credits later.

 I’ve noticed an issue when running my bench and entering the quantity I want to order for an item.  I can enter the quantity for an item on the Purchase Request Resolution screen, however once I print the Shortage Request Resolution – Material Requirements Planning report, the quantity amount is reset to 0 by the system for some reason on certain items.  Any thoughts on what could be causing this issue?

 

Please see the attached screen shots for examples.  The first screen shot shows the quantities I have entered and want to order, if any.  The second screen shot shows where the system reset the quantity I entered to 0 on two items.  I’m wondering if this is tied to the unit of measure for these items?  These two particular items come in multiple quantities (100pk and 10pk) instead of each. 

 

We are trying to track the country of origin for a part.

For example: HP makes a part "ABC"

ABC can be made in the USA, Mexico or Canada.

How would one track a specific part within GP 2010 to know exactly where the part we wish to use originated?

Is there a way to use Integration Manager for cash receipts applied AND unapplied in a single integration?

I am trying to figure out what 53, 54, 55, and 56 (bottom of list) mean from the following list. Does anyone have a description for these?

WHEN MO_ACTIVITY_REASON_I = 31 THEN '31 - Status Change'
WHEN MO_ACTIVITY_REASON_I = 32 THEN '32 - Allocate'
WHEN MO_ACTIVITY_REASON_I = 33 THEN '33 - Reverse Allocate'
WHEN MO_ACTIVITY_REASON_I = 34 THEN '34 - Issue'
WHEN MO_ACTIVITY_REASON_I = 35 THEN '35 - Reverse Issue'
WHEN MO_ACTIVITY_REASON_I = 36 THEN '36 - Scrap'
WHEN MO_ACTIVITY_REASON_I = 37 THEN '37 - Reverse Scrap'
WHEN MO_ACTIVITY_REASON_I = 38 THEN '38 - Raw Material Relief'
WHEN MO_ACTIVITY_REASON_I = 39 THEN '39 - Finished Good Post'
WHEN MO_ACTIVITY_REASON_I = 40 THEN '40 - Reverse Finished Good Post'
WHEN MO_ACTIVITY_REASON_I = 41 THEN '41 - Close'
WHEN MO_ACTIVITY_REASON_I = 42 THEN '42 - Complete'
WHEN MO_ACTIVITY_REASON_I = 43 THEN '43 - Post Variance From WIP'
WHEN MO_ACTIVITY_REASON_I = 44 THEN '44 - Labor Data Collection'
WHEN MO_ACTIVITY_REASON_I = 45 THEN '45 - Machine Data Collection'
WHEN MO_ACTIVITY_REASON_I = 46 THEN '46 - Outsourced Costs'
WHEN MO_ACTIVITY_REASON_I = 47 THEN '47 - Scheduled'
WHEN MO_ACTIVITY_REASON_I = 48 THEN '48 - Picklist Built'
WHEN MO_ACTIVITY_REASON_I = 49 THEN '49 - Change Working Routing'
WHEN MO_ACTIVITY_REASON_I = 50 THEN '50 - Financial Activity'
WHEN MO_ACTIVITY_REASON_I = 53 THEN '53 - Unknown'
WHEN MO_ACTIVITY_REASON_I = 54 THEN '54 - Unknown'
WHEN MO_ACTIVITY_REASON_I = 55 THEN '55 - Unknown'
WHEN MO_ACTIVITY_REASON_I = 56 THEN '56 - Unknown'

I've been trying to find a way to create a report of the current Days on Hand for all Raw Materials in the BoM (Including Alternates and different levels) for items required for MOPs.

I'm not having much luck creating this myself I am very familiar with SQL Querying, but not so much with inline table valued functions. So something with CTE's may be preferrable.

Any direction or advice is greatly welcome.

Good morning,

  There is an alternative to create a sales order from purchase orders automatically? Only GP2015 allow create automatically Sales to Purchasing but I need Purchase Order to Sales Order.

Any suggestion is welcome,

Thanks,

 Mr. García

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3