Those who utilize SAP Crystal Reports or Bartender may need to access information from the Acctivate Database. This KB outlines commonly accessed Database Views for Label printing purposes.
All bulleted points are the exact Database View names. It's recommended to use Views (rather than Tables) to access this information.
Acctivate uses a 3rd party report software, Crystal Reports, to display all reports, forms, labels, and barcodes in the program. Crystal Reports in Acctivate is only available as a read-only form. To make report changes or customizations, there are a few options listed here. However, if you decide to use Crystal Reports to modify or design your own reports, please review our resources here.
Sales Orders:
For those that want to print labels based off Sales Order information. For example, you may need to generate labels for each line item on the order based off the Qty and Lot/Serial information.
- Orders
- Sales Order header information (highlighted in Red). This view contains all order header information such as Order number, dates, terms, bill to info, ship-to info, etc.
- OrderDetail
- Each line item detail for the related order (highlighted in Green). This view contains the Line Number, Product ID, Ordered/Scheduled Quantities, and related Pricing information.
- OrderDetail can join to Orders on Orders.GUIDOrder/OrderDetail.GUIDOrder.
- OrderDetailLot
- Lot or Serial number selected for each product in sales Order Detail (Highlighted in Yellow). This view contains the Lot Serial Number, Quantity, Location, Reference, Specification, Weight and more.
- OrderDetailLot can join to OrderDetail on OrderDetail.GUIDOrderDetail/OrderDetailLot.GUIDOrderDetail.
Purchase Orders:
For those that want to print labels based off Purchase Order information. For example, you may need to generate labels for each line item on the the PO based off Ordered /Received quantities.
- PO
- Purchase Order information (highlighted in Red). This View contains all Purchase Order header information such as PO Number, Requested Date, Vendor, Ship To Information, etc.
- Purchase Order information (highlighted in Red). This View contains all Purchase Order header information such as PO Number, Requested Date, Vendor, Ship To Information, etc.
- PODetail
- Each line item detail for the related Purchase Order (highlighted in Green.) This view contains the Line Number, Product ID, Quantities, and related Pricing information.
- PODetail can join to PO on PODetail.GUIDPO/PO.GUIDPO.
Inventory Receipts:
For those that want to print labels based off Inventory Transactions. For example, you may need to print labels that contains the Lot / Serial information from an Inventory Receipt.
- INVRegister
- Header level session information for all inventory types, , i.e., Adjustments, Issues, Receipts, Sales, Balance Adjustments, etc.
- Review our Docs page for all Transaction Types.
- INVTransaction
- Transactions within a session listed in INVRegister (transaction header information.)
- INVTransaction can join to INVRegister on INVTransaction.RegNumber/INVRegister.RegNumber.
- INVTransactionDetail
- Each line item detail for the related transaction. This view contains the line item details, Quantity, Pricing, and Lot Serial information for each line item.
- INVTransactionDetail can join to INVTransaction on INVTransactionDetail.GUIDINVTransaction/INVTransaction.GUIDINVTransaction.
Please review our Docs page for other commonly accessed database views.