Question

Excluding Non-Stock Items from Export

  • 11 January 2023
  • 2 replies
  • 52 views

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

Userlevel 7
Badge +9

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

@DavidEichner 

 

Here is the exported file in XML

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved