How to Generate the Proper Report Format Using ANTEQ POS Software
Special feature for those that use ANTEQ: Display your Close Out Data (see below for more info)

--------

ANTEQ Mall Manager version 7.x

From Main Screen or from any screen

1. File > Reports > Report Tool

2. Under REPORTS select "A Mall-Central.com Report" (this is a custom report you need to create**)

3. Choose "Current Month" for date range (or specify 1st of previous month to end of time)

4. Click EXECUTE

5. New Screen (report with alternating green and white lines)

6. Click on Disk icon to save the report

7. Navigation window appears

8. Save in: Documents (should be default)

9. Save as type: Text Format

10. File name: type in AMM and then select AMM_Booth_Sales.csv when it pops up or select it from the window

11. Click SAVE button

12. Export Complete (click OK)

13. File > Exit

14. Click Sales_Upload.BAT shortcut on your desktop

15. Black DOS (Command) window appears, upload happens, black window disappears.

16. Double check by checking your Store Sales on Mall-Central.com. You can placed a shortcut 
on your desktop to make this convenient.

=========================
** THIS IS THE CUSTOM REPORT YOU NEED TO CREATE:

From another store they did this:

They need to go to the Report Tool and create a new report with the below file syntax. 
Call the report "A Mall-Central.com Report".
Click on "Description" tab and check the "Advanced" checkbox. Copy and Paste:

SELECT V_SALESDETAILINFO.SM_INVOICENUMBER AS "VSD.SM_INVOICENUMBER",
       V_SALESDETAILINFO.SM_RECORDDATE AS "VSD.SM_RECORDDATE",
       V_SALESDETAILINFO.DM_DEALERID AS "VSD.DM_DEALERID",
       V_SALESDETAILINFO.BM_BOOTHID AS "VSD.BM_BOOTHID",
       V_SALESDETAILINFO.SD_STOCKNUMBER AS "VSD.SD_STOCKNUMBER",
       V_SALESDETAILINFO.SD_DESCRIPTION AS "VSD.SD_DESCRIPTION",
       V_SALESDETAILINFO.SD_QUANTITY AS "VSD.SD_QUANTITY",
       V_SALESDETAILINFO.SD_UNITPRICE AS "VSD.SD_UNITPRICE",
       V_SALESDETAILINFO.SD_DISCOUNTPERCENT AS "VSD.SD_DISCOUNTPERCENT",
       V_SALESDETAILINFO.SD_DISCOUNTAMOUNT AS "VSD.SD_DISCOUNTAMOUNT",
       V_SALESDETAILINFO.SM_SALESSUBTOTAL AS "VSD.SM_SALESSUBTOTAL",
       V_SALESDETAILINFO.SM_SALESTAX AS "VSD.SM_SALESTAX",
       V_SALESDETAILINFO.SM_AMOUNTDUE AS "VSD.SM_AMOUNTDUE",
       V_SALESDETAILINFO.SM_LAYAWAY AS "VSD.SM_LAYAWAY",
       V_SALESDETAILINFO.CU_ACTIVESTATUS AS "VSD.CU_ACTIVESTATUS"
        FROM V_SALESDETAILINFO
 WHERE ((V_SALESDETAILINFO.SM_RECORDDATE >= :STARTDATE) AND (V_SALESDETAILINFO.SM_RECORDDATE <= :ENDDATE))

Click on "Save" and if you are ready, select "Current Month" and 
click "Execute" or follow the instructions above.



A caveat: some stores use the same info for DEALERID and BOOTHID. Other stores use names and booth numbers.
Depending on how you set up ANTEQ v7 you may want to copy and paste one of the following. Note
lines 3 and 4 below to lines 3 and 4 above.


SELECT V_SALESDETAILINFO.SM_INVOICENUMBER AS "VSD.SM_INVOICENUMBER",
       V_SALESDETAILINFO.SM_RECORDDATE AS "VSD.SM_RECORDDATE",
       V_SALESDETAILINFO.BM_BOOTHID AS "VSD.BM_BOOTHID",
       V_SALESDETAILINFO.BM_BOOTHID AS "VSD.BM_BOOTHID",
       V_SALESDETAILINFO.SD_STOCKNUMBER AS "VSD.SD_STOCKNUMBER",
       V_SALESDETAILINFO.SD_DESCRIPTION AS "VSD.SD_DESCRIPTION",
       V_SALESDETAILINFO.SD_QUANTITY AS "VSD.SD_QUANTITY",
       V_SALESDETAILINFO.SD_UNITPRICE AS "VSD.SD_UNITPRICE",
       V_SALESDETAILINFO.SD_DISCOUNTPERCENT AS "VSD.SD_DISCOUNTPERCENT",
       V_SALESDETAILINFO.SD_DISCOUNTAMOUNT AS "VSD.SD_DISCOUNTAMOUNT",
       V_SALESDETAILINFO.SM_SALESSUBTOTAL AS "VSD.SM_SALESSUBTOTAL",
       V_SALESDETAILINFO.SM_SALESTAX AS "VSD.SM_SALESTAX",
       V_SALESDETAILINFO.SM_AMOUNTDUE AS "VSD.SM_AMOUNTDUE",
       V_SALESDETAILINFO.SM_LAYAWAY AS "VSD.SM_LAYAWAY",
       V_SALESDETAILINFO.CU_ACTIVESTATUS AS "VSD.CU_ACTIVESTATUS"
        FROM V_SALESDETAILINFO
 WHERE ((V_SALESDETAILINFO.SM_RECORDDATE >= :STARTDATE) AND (V_SALESDETAILINFO.SM_RECORDDATE <= :ENDDATE))

-or-

SELECT V_SALESDETAILINFO.SM_INVOICENUMBER AS "VSD.SM_INVOICENUMBER",
       V_SALESDETAILINFO.SM_RECORDDATE AS "VSD.SM_RECORDDATE",
       V_SALESDETAILINFO.DM_DEALERID AS "VSD.DM_DEALERID",
       V_SALESDETAILINFO.DM_DEALERID AS "VSD.DM_DEALERID",
       V_SALESDETAILINFO.SD_STOCKNUMBER AS "VSD.SD_STOCKNUMBER",
       V_SALESDETAILINFO.SD_DESCRIPTION AS "VSD.SD_DESCRIPTION",
       V_SALESDETAILINFO.SD_QUANTITY AS "VSD.SD_QUANTITY",
       V_SALESDETAILINFO.SD_UNITPRICE AS "VSD.SD_UNITPRICE",
       V_SALESDETAILINFO.SD_DISCOUNTPERCENT AS "VSD.SD_DISCOUNTPERCENT",
       V_SALESDETAILINFO.SD_DISCOUNTAMOUNT AS "VSD.SD_DISCOUNTAMOUNT",
       V_SALESDETAILINFO.SM_SALESSUBTOTAL AS "VSD.SM_SALESSUBTOTAL",
       V_SALESDETAILINFO.SM_SALESTAX AS "VSD.SM_SALESTAX",
       V_SALESDETAILINFO.SM_AMOUNTDUE AS "VSD.SM_AMOUNTDUE",
       V_SALESDETAILINFO.SM_LAYAWAY AS "VSD.SM_LAYAWAY",
       V_SALESDETAILINFO.CU_ACTIVESTATUS AS "VSD.CU_ACTIVESTATUS"
        FROM V_SALESDETAILINFO
 WHERE ((V_SALESDETAILINFO.SM_RECORDDATE >= :STARTDATE) AND (V_SALESDETAILINFO.SM_RECORDDATE <= :ENDDATE))


=========================

How to install the Mall-Central.com helper files

On your Store Page there is a list of three helper files located in the Store Information 
blue section on the right side. Right-mouse-click on these files and "Save Target As..." 
and place these three files in the directory you save the report in which may be your 
Documents folder.

Create a shortcut for the SALES_UPLOAD.BAT file and place the shortcut on your desktop for 
your convenience.

You can use MCTEST.BAT to test your upload capability by launching MCTEST.BAT and then check your
Store Page under the 'REFRESH' button (see middle of STORE INFORMATION section). Click "REFRESH"
button as needed. You should see filename MALLUPLD.EXE file size increase each time you launch
MCTEST.BAT (increments of 159.744).

=========================

Close Out Data:

One of our stores asked if we could display their Close Out Data. To do so they upload a 
different file using another shortcut (similar to the UPLOAD_SALES.BAT Shortcut most stores 
place on their desktop).

The file needs to be designed as follows:

SELECT V_CLOSEOUT.CM_BEGINDATE AS "CG:CM_BEGINDATE", 
V_CLOSEOUT.CM_ENDDATE AS "CG:CM_ENDDATE", 
V_CLOSEOUT.DM_DEALERID AS "CG:DM_DEALERID", 
V_CLOSEOUT.CD_RETAILSALES AS "CG: RETAIL SALES", 
V_CLOSEOUT.CD_WHOLESALESSALES AS "CG: WHOLESALE SALES", 
V_CLOSEOUT.CD_CHARGECARDFEES AS "CG: CREDIT CARD FEES", 
V_CLOSEOUT.CD_COMMISSIONWITHHELD AS "CG: COMMISSION WITHHELD", 
V_CLOSEOUT.CD_TOTALPAYOUT AS "CG: TOTAL PAYOUT", 
V_CLOSEOUT.CD_RENTPERMONTH AS "CG: RENT PER MONTH", 
V_CLOSEOUT.CD_RENTWITHHELD AS "CG: RENT WITHHELD", 
V_CLOSEOUT.CD_RENTINARREARS AS "CG: RENT IN ARREARS",
V_CLOSEOUT.CD_NEWPREPAID AS "CG: RENT PAID BALANCE"

FROM V_CLOSEOUT

WHERE (V_CLOSEOUT.CM_BEGINDATE >= :STARTDATE) and (V_CLOSEOUT.CM_ENDDATE < :ENDDATE)

The following is extracted from two emails from that store which prompted the development 
of this feature.:

"An employee brought up a very good point... our dealers will also want to see the overview 
of how we calculated the payout to them after settlement (amount in check). As we want to 
eliminate all paper printing with this, we wanted to check with you to see if it was possible 
to also upload a seperate file (like attached), where dealers, when they log in, and choose 
CON or SUMMARY VIEW, that they can also see the following info for themselves (seperate) from 
daily sales file upload.  Or, because you have dealt with Anteq in the past, maybe you have a 
better idea or already a solution to uploading two different file names to your server, one 
summary of settlements and one the AMM_Booth_Sales file we are currently uploading.

we have alot of vendors that also want to see rent data (total rent per month. rent in arrears. 
Rent prepaid balence. Rent withheld. These four columns group rent from closeouts for them to view."