Skip to main content
Question

Excluding Non-Stock Items from Export


We’ve recently ran into an issue with trying to exclude non-stock items from our export on Sales Orders (SO301000). These non-stock items are populated in the Details tab of the Sales Order page. We’ve tried several different approaches to this and still have turned up no results. Right now, we are using this export restriction 

 

and this export mapping 

 

 

All we need it to do is not include any Inventory lines that are not non-stock for this export. The value is ultimately stored as ‘N’ when I try to map the export to a location and see what it looks like. However, when using the restrictions, it does not want to exclude these lines with that value.

The restrictions we have tried so far have been 

Details > [InventoryItem.ItemType] > Does Not Include/Does Not Equal > N

Details > Inventory-Type > Does Not Include/Does Not Equal > N/’N’

Details > Inventory-Type > Does Not Include/Does Not Equal > Non-Stock Item

Any help would be appreciated. 

 

2 replies

DavidEichner
Captain II
Forum|alt.badge.img+13
  • Captain II
  • 373 replies
  • January 11, 2023

Hi @Obrewer ,

 

Can you export that export scenario to XML file and upload it here so I can take a look at it?

 

Thanks,

David


  • Author
  • Freshman I
  • 1 reply
  • January 11, 2023

@DavidEichner 

 

Here is the exported file in XML


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings