The xml file generated by the DataBrowser using Purchases and Accounts Payable > Purchases by Item is missing a number of fields listed on the columns tab. For my purposes, the lack of the Item Abbreviation (or any unique item identifier) means I am unable to use this export to track received items in our manufacturing system. Since the SalesItemDescription is included, I suspect this is just an oversight. Can this be fixed? By Aug 1?

Our settings files look very similar:

<Settings>
<Database>HOLLY</Database>
<ReportKey>45eaf75f-e0c7-42e7-9e98-5f0ac3812e2c</ReportKey>
<OutputFile>C:\Users\ward\Documents\databrowser\purchases.xml</OutputFile>
<ClearFilters>false</ClearFilters>
<Filters>
<Filter>
<Key>Filter_TransactionDate</Key>
<Type>DateTime</Type>
<FromDate>2020-01-01</FromDate>
<ToDate>2020-07-31</ToDate>
</Filter> </Filters>
<ClearOptions>false</ClearOptions>
<Options />
</Settings>

However, the result looks quite different:
<?xml version="1.0" standalone="yes"?>
<ReportDataSource>
<ReportDataSource>
<SalesItemDescription>ADVSEC Quarterly Monitoring </SalesItemDescription>
<CompanyId>2147470000</CompanyId>
<TransactionId>2147469838</TransactionId>
<ProfitCostCenterId>2147470000</ProfitCostCenterId>
<ProductionCenterId>2147470000</ProductionCenterId>
<ProjectId>2147470000</ProjectId>
<ProjectName>System supplied default </ProjectName>
<ProjectAbbreviation>N/A </ProjectAbbreviation>
<TransactionDate>2020-07-02T00:00:00-07:00</TransactionDate>
<TransactionNumber>523021 </TransactionNumber>
<MemoLine1>ADVSEC Quarterly Monitoring </MemoLine1>
<MemoLine2 />
<SubdivisionId>2147469838</SubdivisionId>
<NameId>2147464534</NameId>
<DateCreated>2020-07-16T13:41:07.4-07:00</DateCreated>
<Notation />
<VendorInvoiceNumber xml:space="preserve"> </VendorInvoiceNumber>
<ProductionYear>2020</ProductionYear>
<UserValue1>0.00000000</UserValue1>
<UserValue2>0.00000000</UserValue2>
<TransactionTypeName>AP Invoice </TransactionTypeName>
<Account>Pur: Sheet: Metal </Account>
<AccountNumber>51100 </AccountNumber>
<AccountAbbreviation>51100 </AccountAbbreviation>
<UserName />
<Amount>181.50</Amount>
<Quantity1>1.00000000</Quantity1>
<Quantity2>0.00000000</Quantity2>
<VendorLastFirst>Advanced Security Systems</VendorLastFirst>
<VendorFirstLast>Advanced Security Systems</VendorFirstLast>
<NameAbbreviation>ADVSEC </NameAbbreviation>
<Company>"HOLLY" - Restored.</Company>
<CompanyAbbreviation>holly </CompanyAbbreviation>
<ProductionCenter>000</ProductionCenter>
<ProductionCenterAbbreviation>000 </ProductionCenterAbbreviation>
<ProfitCenter>New Profit Center Description</ProfitCenter>
<ProfitCenterAbbreviation>00 </ProfitCenterAbbreviation>
<UnitOfMeasure1>Not used </UnitOfMeasure1>
<UOM1Abbreviation>n/a </UOM1Abbreviation>
<UnitOfMeasure2>Not used </UnitOfMeasure2>
<UOM2Abbreviation>n/a </UOM2Abbreviation>
<AccountId>2147469633</AccountId>
<UnitCost>181.500000000000</UnitCost>
<NameGroupId>2147469976</NameGroupId>
<NameGroupsAbbreviation>N/A </NameGroupsAbbreviation>
<NameGroupsName>System supplied default </NameGroupsName>
<PurchaseQuantity>1.00000000</PurchaseQuantity>
<PurchaseUnitCost>0.000000000000</PurchaseUnitCost>
<PurchaseUnitOfMeasure>Not used </PurchaseUnitOfMeasure>
<PurchaseUOMAbbreviation>n/a </PurchaseUOMAbbreviation>
</ReportDataSource>
...

I took a look at a migrated database. It doesn't look like there are any sales items associated with the AP invoices. Doesn't look like there is anything but untracked, service times in the TurningPoint data... not sure if that makes a difference.

Anyway, if you don't see sales items in the Purchases by Item report in CenterPoint, the Data Browser is not going to show them so that would seem to push the focus to the TurningPoint to CenterPoint migration.

I'll ask around, but the interface you are working on... is it designed to be used going forward on data entered in CenterPoint?

If so, you are only going to find Sales Item info on this report if it is entered in CenterPoint. Have you done any tests on that?

Going forward, I think that you could use either report. In your shoes, I'd probably use Reports -> Transaction Reports -> Purchase Orders -> Purchase Orders (Detail)

To see what is received for each item, you would look at the "Qty Received" field. One nice thing about this report is that unlike the A/P purchase reports, it is only going to show transactions from items. With AP purchases, there will be transactions that have nothing to do with inventory.

The other nice thing about the Purchase Order report is that you'd be able to test it on the migrated data.

This won't work if items are purchased outside of Purchase Orders though. That doesn't seem likely, but it would be something to check on.

It wasn't clear what you were after on the report, hut I suppose that you'll have to use the Purchases by Item then. The migrated data won't have items but the data created in CenterPoint will if items were entered (which they would on transactions generated by recieving POs.)

As for the Purchase Order filters, I noticed in your setup XML file that you weren't clearing the filters. I'm only mentioning this because it could cause problems later.

In the setting file below, for example, if you don't want the Data Browser to use the filters as they are set up in CenterPoint, you should set the ClearFilters value to true.

I really only need to export items received to a particular location, so I tried to add this filter to my export file definition. Unfortunately, when I check Location on the Filters form, the suggested XML attempts to filter on the profit center instead of the location. I made some guesses at the correct syntax to select on location, but was unable to get this correct. Can you give me the correct syntax?

Ah ha! I've been working with TurningPoint for too long. I exported Locations but didn't seen anything familiar. After poking around a bit more, I now believe that Location (aka Production Center) and Inventory Location are two different things, and that Inventory Location, is not a field I can filter on. I can work with that.