Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PMIX Information in Aloha DBF files?

Status
Not open for further replies.

walter1917

Technical User
Nov 27, 2014
21
US
Hello,

I am trying to create a PMIX-style report from the Aloha DBF files but would like for each item:

Item, Qty Sold, Gross Sales, Taxes, Sur/Ord, Voids, Comps, Net Sales

I'm using GND_ITEM ( to sum item sales.

I have been able to use DISC PRICE - INCLTAX to get Net Sales but can not locate:
a) Excl taxes?
b) Sur/Ord?
c) Comps?
d) Voids?

How can I get these out of PRICE and DISCPRICE?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top