Duplicate Information

[Nine Zero]

Hello All,

Im going to try and explain this as best as i can without real data because i currently do not have access to it.

Here at my job we use Microsoft Dynamics GP 2010 as our CRM and are experiencing something out of the norm with access.

Every morning at 3:00 am there is a job that runs in access which refreshes all out the data to ensure we pull the most current and up to date information.

What we started noticing is that in our access db, when it is pulling some transactions that have lines with the same item number it repeats the quantity of the first line. Similar to how a VLOOKUP in Excel will return the value of the first instance that it is found no matter how many times you search for it.

This is what GP has and its what i expect to see in access

Document	Customer	Item	Quantity	Price
123456	A 123-000	41	200	100
123456	A 123-000	41	560	280
123456	A 123-000	21	300	600

<tbody>
</tbody>

This is what we currently see in access which is wrong

Document	Customer	Item	Quantity	Price
123456	A 123-000	41	200	100
123456	A 123-000	41	200	100
123456	A 123-000	21	300	600

<tbody>
</tbody>

Notice how the red values are duplicates of the previous line solely because the item number is the same

If anyone has any idea why this is occurring please i value your ideas greatly.

Im sorry with the minimal information i will try to retrieve much more information as to provide it for you guys.

Thanks

 

[Joe4]

How is that second picture being returned in Access?
Is it a query between two tables?
If so, that is the kind of issue you see when you have not done the join between the two tables properly, or it is a one-to-many or many-to-many join type.

 

[Nine Zero]

How is that second picture being returned in Access?
Is it a query between two tables?
If so, that is the kind of issue you see when you have not done the join between the two tables properly, or it is a one-to-many or many-to-many join type.

That is what i thought it was initially but after speaking with a coworker, it is one single table that this information is coming from. We now believe it is an issue with GP exporting documents with multiple lines of the same item. Because within its environment (GP) everything works fine, but as soon as a document with duplicate items is exported to a different environment "weird" things occur to the document.

Hopefully we find a solution, thanks again.

 

[Joe4]

Yes, if there is no query going on in Access, then I would agree it is not an Access issue, but rather source export issue.