Help with report writing

Question

I am trying to write a report involving inventory, but I cannot figure out how to get only active part numbers to print. I would think that I would need a formula something like: 
 if status=active then {partnumber}, if status=inactive then "" 
 only I can't find any field that populates the parts status. I've looked all through "Inventory" and "UOM" and a few others, but I can't find any group that contains a field called "status", does anyone know what I can do? 
 Thank you

jkwa · Accepted Answer

Hello. You are on the right track. Let me see if I can help you complete this aspect of the report. The field that identifies if the part number is Active, On hold or Inactive is the Hold field in the Inventory table. Each part number has either a value of 0 if the item is Active, 1 if the item is On hold, or 2 if the item is Inactive. So, if you need to get only Active part numbers to print, you will have the add a formula in the Record Selection that says: 
 {INVENTORY.HOLD} = 0 
 This formula can be added simply by right clicking an open white area of your report, select Report, Selection Formula, Record. You can use it by itself (if you have no other criteria) or by adding the "and" syntax to make this part of your existing formula. Once the above criteria is added to the Record Selection Formula your report will only show items with an Active status. 
 You can change the formula if you wish to: 
 {INVENTORY.HOLD} = 1 
 so that only items that are in a Hold status will print. You can have a copy of the same report with different Hold values within the Record Selection Formula so you can switch between Active and Hold status if you wish. 
 Hope this helps.

Sage BusinessVision

Help with report writing

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING