Copyright: Copyright ©


A/P Credits by G/L
A/P Credits by G/L Account #

Purpose of Report:	To assist in reconciling the General Ledger Auto Posting from A/P by listing only the G/L Credit transactions for a date range.

Overview:	The Report includes all A/P Credits (not credit memos) that were entered in the requested date range for the requested G/L Control Number.  The Control Number can be from a Trial Posting to the G/L.

The Report is sorted first by G/L Control Number, from your Auto Posting of A/P to the G/L, and then by the G/L Account Number (COA).  Totals are reported for both.  If your site is Multi-company, you can run the report for one company code or a range of codes.  The Date Range must be the same for all Company Codes.  If not, run two separate reports.

The Report is designed for both single and multi company sites.

Input Parameters:	Starting Company Code and Date

Ending Company Code and Date

G/L Control Number from the A/P Auto Posting(s)

Company Code (if applicable)

Fields on Report:	G/L Control Number

G/L Account Number

Vendor ID

Invoice Number

Invoice Date

Description

Credit Amount

Sample A/P Credits by G/L Account # Report:

How to Generate the A/P Credits by G/L Account # Report:

1.	Double click on the Report Writer Icon.  Log in and select the A/P Credits by G/L Account # Report.

2.	Click on the Preview box to preview the report to the screen.  Then click on the Preview button.  Or just click on the Print button for a printed report.

3.	The Starting and Ending Scopes in the first dialog box refer to the Company Code and A/P Credit Date range for the Report:

4.	It is unlikely you would ever want to see every A/P Credit on record.  If you do, click the Beginning of Table and End of Table buttons and then click OK..

5.	Otherwise click the Start Value button and type a Company Code and Starting Date using a  CCCCCyyyymmdd  format, e.g., AMINC20010101, then click the End Value button and type the Ending Company Code and Date.  Use the same format, e.g., AMINC20010131.  Click OK.

For single company sites:  You must replace the above Cs with 5 spaces.

5.	Type the G/L Control Number you are trying to reconcile, or leave blank to see all Control Numbers posted to the G/L in that Date Range.  Remember, the Report includes Trial Postings.

6.	Strike Enter or click OK.  The Report is now generated and printed to the printer you chose or previewed to the screen.

Additional Information:

If you think a particular G/L Control Number was the result of posting more than a one month date range, you can enter a Starting Date of "     19590101" and an Ending Date of "     20591231" to be sure.  Do not forget the Company Code or 5 spaces before the date.

If you have any problems, please do not hesitate to call A.M.I.  Support at 858.272.5875 or e-mail us at support@amisoft.com.


A/P Inventory vs PO Receipts

Purpose of Report:	To compare the dollar amounts for invoices in A/P against the PO received amounts for a given date range.

Overview:	For the desired date range, the Report is printed sequentially for all A/P invoices that contain an amount expensed against the entered Inventory G/L Account Number (COA).  The A/P invoice amount is the sum total of all charges expensed to that COA for the listed invoice.  When the PO has been posted to A/P through the PO module, the PO receiving records are summed for the PO listed in the description, but for only the associated receipt ID(s) and receipts dated on or before the End Date of the Report.

The Report is designed for both single and multi company sites.

Input Parameters:	Date Range

Inventory G/L Account Number

Company Code (if applicable)

Fields on Report:	A/P Invoice Number

A/P Invoice Date

PO Receipt Date

A/P Invoice Description

A/P Amount for the G/L COA

PO Amount for the Receipt IDs

Sample A/P Inventory vs PO Receipts Report:

How to Generate the A/P Inventory vs PO Receipts Report:

1.	Double click on the Report Writer Icon.  Log in and select the A/P Inventory vs PO Receipts Report.

2.	Click on the Preview box to preview the report to the screen.  Then click on the Preview button.  Or just click on the Print button for a printed report.

3.	Type the Starting Date using a mm/dd/yyyy  format, e.g., 04/01/2001, and strike Enter or click on the OK button.

4.	Type the Ending Date using the same mm/dd/yyyy  format, e.g., 04/30/2001, and strike Enter or click on the OK button.

5.	Next type your Inventory G/L Account number.  Do not skip any spaces and enter all 8 characters.  If there is a department code be sure to include the dash between the main account number and the department code, e.g., 12100-12.  Strike Enter or click on the OK button.

6.	You MUST type the Company Code you want to use if your site is set up as Multi-Company.  Enter a blank code if not.  Strike Enter or click on the OK button.

7.	The Report is now generated and printed to the printer you chose or previewed to the screen.  (This Report may take a lot of time, but it will be worth it.)

Additional Information:

An A/P Credit Memo entered and expensed to the Inventory G/L Account is listed on this Report without a PO.

Also, an Invoice entered directly into A/P is listed without a PO.

This Report requires all PO Postings to A/P be done using v6.80 or later.

The Report helps you check for A/P Invoices Posted to A/P using a different G/L COA.  The A/P Amount will be 0.00, or less than the PO Amount if some of the invoice is expensed to the requested COA and the rest is expensed to another COA.

If the PO Receipt Cost was changed after the PO was posted to A/P, the amounts will be different, unless you also modified the Invoice.

The PO Receipt Date must be the same or older than the Ending Date of the Report.  If the receipt is newer, the PO Amount is 0.00.

If the A/P Invoice description information does not properly refer to the PO Number, the PO Amount is 0.00

If you have any problems, please do not hesitate to call A.M.I.  Support at 858.272.5875 or e-mail us at support@amisoft.com.


All Samples

A/P Credits by G/L Account #

A/P Inventory vs PO Receipts

Canceled DO by Product

Customer Profile by Name

Customer Transactions

Customer Transactions with S/Ns

Inventory Adjustments

Item Sales Report

K-to-Keep Products

Margins with Freight In - Detailed

Margins with Freight In - Summary

Product List with Query

Reorder by Product Code with Last Purchase Cost

Reorder by Vendor with Last Purchase Cost

Sales by Customer with Customer PO #

Serial Numbers by Ship Code


Basic Product List
Product List with Query

Purpose of Report:	To list all Main Course product code data for a User defined subset of codes (like non-inventory).

Overview:	The Basic Report is always printed by Product Code.  All non quantity fields are output with the User Defined Fields and the Expanded Description being optional.  The User determines which subset of codes they want to see by setting up a query at Report run time.  The subset can be as simple as all non-Inventory products, to as complex as for a Department Code that does not have a certain Class and Category.  See the examples below.

To save paper, the optional data headings are omitted when there is no data in those fields.

Input Parameters:	The Query Information

A Report sub Title

A flag for the including of the User Defined Fields Data (Optional)

A flag for the including of the Expanded Description Data (Optional)

Fields on Report:	Product Code

Description

(I)nventory (T)axable (K)ey and (S)erialized status

Department Code

Status Code

Manufacturer ID

Manufacturer's Product Code

Primary Vendor ID

Vendor's Product Code

Class, Category and Sub Category

Price

Cost, Average Cost, PO Cost, Commission Cost and Exchange Cost

Warranty Parts and Labor Days

Data in the User Defined Fields (Optional)

Data in the Expanded Description Field (Optional)

Sample Product List with Query Report:

How to Generate the Product List with Query Report:

1.	Double click on the Report Writer Icon.  Log in and select the Product List with Query Report.

2.	Click on the Preview box to preview the report to the screen.  Then click on the Preview button.  Or just click on the Print button for a printed report.

3.	The Query dialog box appears first.  If you want to see ALL information in your Product file simply click OK.  (This is not recommended.  There are other reports in the Main Course.)  But, you can very easily limit the list of Codes to only those that meet your criteria.  Be inventive, it is quite easy once you know the format.  The following example lists all non-Inventory Codes.  See below for a second, more complex example and some of the other common possibilities.

4.	In the "Field" entry position strike the I key and INVENTORY is displayed.  (Or use the Up and Down Arrows to navigate through the list of field names.)  Tab to the "Comparison" entry field and use the Down Arrow to display equal to.  Tab again to the "Compared To" entry field and type .F. for False.  Strike Enter or click on OK.

5.	You should normally choose to verify your Query by clicking on the Verify button.  Click OK in the Verify dialog box if there are no warnings. Click OK again in the Query dialog box.

6.	Always, always type a Title for your report.  This is a free form field and what you enter is what gets printed at the top of your Report.  Our example would be Non Inventory Product Codes.  Click OK.

7.	The next Dialog box asks if you want to include the data in the User Defined Fields.  Any character will cause this data to be printed/displayed if there is any for a particular code.  A blank omits any User Defined Data for all product codes.  Strike Enter or click OK.

8.	The last Dialog box asks if you want to include the Expanded Description data for any of the codes that are on the Report.  Any character will cause this data to be printed/displayed (if there is any).  A blank omits any Expanded Description Data for all product codes.  Strike Enter or click OK.

9.	The Report is now generated and printed to the printer you chose or previewed to the screen.

Additional Information:

The Basic Report can not alter the sort order from the Product Code in ascending alpha numerical order.  Therefore if you want a report of all codes with a Dept greater than 0, there will be no comparable sorting by Dept number.  The report is still in Product Code order.  The report can be copied and customized (by AMI) if you find that you frequently run a particular version of the Query.

The following are some navigation rules while in the Query dialog box.

Field entry position:

When selecting a Field you will want to limit your selections to fields in the PRODUCT file.

Entering the first letter of the field name moves immediately to the first name that starts with that character.  Entering it a second time moves to the second field that starts with that character.  For example one C moves to CLASS and the second to CATEGORY.

Using the Up and Down Arrows allows you to scroll through all field names.

If you enter to many first characters and skip past the field name you want you can use the mouse to open the list box and drag the scroll bar to move up and/or down rather than using the keyboard Arrows.

Comparison entry position:

Using the Up and Down Arrows is the most efficient way to see the choices you have here.

The list is small, and controlled by the type of data in the field.  So you only get two choices when the field is logical like Inventory and/or Serialed.

Compared To entry position:

Character data must be entered between quote marks (").

All data except the description must be upper case.  The description field is case sensitive.  So PRINTER is not the same as Printer or printer.

True is entered as .T. and false as .F.

Numeric fields like Dept and all quantity fields are entered as numbers.

And/Or entry position:

This will normally be And when there is more than one Query line.

Use Or when you want something like a manufacturer of COMPAQ or HP and some other item like a CLASS of CPU.  Call AMI Support for help.

Other possible Query fields are listed below.  You can combine Queries by adding the first and then clicking on the Append button.  If you want to do something that is not listed and are in doubt, call A.M.I. Support or send e-mail to support@amisoft.com.

Field	Key to strike	Comparison	Compared To Example(s)  (Case sensitive)

MANFACT	M or m	equal to	"IBM" or "COMP ASSOC"

STATUS	S or s (about 5)	equal to	"W"

DEPT	D or d (2 times)	greater than	0

CLASS	C or c 	equal to	"PRINTER"

A second, more complex example will list all Codes with a Manufacturer ID of TOSHIBA, a Class of CPU and a Category of NOTEBOOK .

1.	Complete Steps 1 and 2 above to get to the Query dialog box.

2.	In the "Field" entry position strike the M key and MANFACT is displayed.  Tab to the "Comparison" entry field and use the Down Arrow to display equal to.  Tab again to the "Compared To" entry field and type "TOSHIBA".  Remember you must use upper case characters and the quote marks (") in the Compared To field.  Strike Enter or click on OK.

3.	Click the Append button to further restrict your output to a Class of CPU.  Tab to the "Field" entry position and strike the C key until the Field CLASS shows.  Tab to the "Comparison" entry field and strike the E key.  Equal to is displayed.  Lastly Tab to the "Compared To" entry field and type in the Class code you want.  Our CPU example would be entered as "CPU".  Click the OK button.

4.	To add the Category to the Query, click the Append button again.  Tab to the "Field" entry position and strike the C key until the Field CATEGORY shows.  Tab to the "Comparison" entry field and strike the E key.  Equal to is displayed.  Lastly Tab to the "Compared To" entry field and type in the Class code you want.  Our notebook example would be entered as "NOTEBOOK".  Click the OK button.

5.	You should normally choose to verify your Query by clicking on the Verify button.  Click OK in the Verify dialog box and again in the Query dialog box.

6.	Type a sub title for your report.  Our example would be Toshiba Class of CPU and Category of NOTEBOOK.  Click OK.

7.	Type any character if you want to include the data in the User Defined Fields.  Strike Enter or click OK.

8.	Type any character if you want to include the Expanded Description data.  Strike Enter or click OK.

9.	The Report is now generated and printed to the printer you chose or previewed to the screen.

If you have any problems, please do not hesitate to call A.M.I.  Support at 858.272.5875 or e-mail us at support@amisoft.com.


Canceled DO by Product

Purpose of Report:	To assist Sales Department in finding prospects when a previously hard to get product becomes readily available again.

Overview:	The Report lists all Delivery Orders for a Product Code or range of Product Codes that have been canceled since the date entered.  The Report is grouped by Product Code and then Sales Rep, listing the Customer Name, Attention and Phone Number.

The Report is designed for both single and multi company sites.

Input Parameters:	Starting Company Code and Product Code

Ending Company Code and Product Code

Oldest Canceled Date

Fields on Report:	Product Code and Description

Sales Rep

Delivery Order Number

Date DO Was Canceled

Customer Number

Customer Name

Billing Attention

Phone Number

Quantities

Sample Canceled DO by Product Report:

How to Generate the Canceled DO by Product Report:

1.	Double click on the Report Writer Icon.  Log in and select the Canceled DO by Product Report.

2.	Click on the Preview box to preview the report to the screen.  Then click on the Preview button.  Or just click on the Print button for a printed report.

3.	The Starting and Ending Scopes in the first dialog box refer to the Company Code and Product Code range for the Report:

4.	It is unlikely you would ever want to see every canceled DO on record.  If you do, click the Beginning of Table and End of Table buttons and then click OK..

5.	Otherwise click the Start Value button and type a Company Code and Starting Product Code using a  CCCCCPPPPPPPPPPPPPPP  format, e.g., COCDAPRODUCTCODEA, then click the End Value button and type the Ending Company Code and Product Code.  Use the same format, e.g., COCDBPRODUCTCODEB.  Click OK.

The Company and Product Codes must be typed in upper case (capital) letters.  COCDA and not cocda.

For single company sites:  You must replace the above Cs with 5 spaces.

5.	Type the Oldest Canceled Date for the Report using a yyyy/mm/dd format, e.g., 2001/02/01.

6.	Strike Enter or click OK.  The Report is now generated and printed to the printer you chose or previewed to the screen.

Additional Information:

If the DO quantity on any line of the Report is greater than zero, the product on that DO was partially shipped before the DO was canceled.

If you have any problems, please do not hesitate to call A.M.I.  Support at 858.272.5875 or e-mail us at support@amisoft.com.


Contents

All Samples

A/P Credits by G/L Account #

A/P Inventory vs PO Receipts

Canceled DO by Product

Customer Profile by Name

Customer Transactions

Customer Transactions with Serial #

General Notes

Inventory Adjustments

Item Sales Report

K-to-Keep Products

Margins with Freight In - Detailed

Margins with Freight In - Summary

Product List with Query

Reorder by Product Code with Last Purchase Cost

Reorder by Vendor with Last Purchase Cost

Sales by Customer with Customer PO #

Serial Numbers by Ship Code


Customer Profile
Customer Profile by Name

Purpose of Report:	To list customer year to date and cumulative sales volume, margin dollars and percent.  Also their outstanding balance and average number of days to pay.

Overview:	The Report includes the fields shown below and is sorted by the amount of year to date sales.  YTD is defined as the current calendar year.  The user can request a report for a range of customers and/or let the report limit the list to those customers with at least a certain YTD sales volume.  You can also use a cut off date.

The Report is designed for both single and multi company sites.

Input Parameters:	Range of Customer Names or All

Year To Date Sales Limit or All

Cut Off Date

Company Code (if Multi-company)

Fields on Report:	Customer Account Number

Account Name

Dollar Amount Outstanding

Average Number of Days to Pay

Average Invoice Amount

Percent Credited

Sales Year To Date

Gross Margin Dollars Year To Date

Gross Margin % Year To Date

Cumulative Sales To Date

Cumulative Margin Dollars To Date

Cumulative Margin % To Date

Sample Customer Profile by Name Report:

How to Generate the Customer Profile by Name Report:

1.	Double click on the Report Writer Icon.  Log in and select the Customer Profile by Name Report.

2.	Click on the Preview box to preview the report to the screen.  Then click on the Preview button.  Or just click on the Print button for a printed report.

3.	The Starting and Ending Scopes in the first dialog box refer to the Range of Customer Names you want the Report to use:

4.	To see ALL Customers on file leave the Beginning of Table and End of Table buttons marked.  (The list can be limited by the Sales Volume Limit entered next.)

5.	Otherwise click the Start Value button and type a Starting Customer Name.  The full name is not required BUT the input is case sensitive.  You must use upper case characters.  Click the End Value button and type the Ending Customer Name.  Use the same format.  Click OK.

6.	Next type the YTD Sales Limit.  This is a dollar amount or blank.  Customers who have not purchased at least this amount in the last calendar year will not be on the report.  If you do not want to set a limit, leave the field empty.  Strike Enter or click OK.

7.	Type an As Of Date or leave the field blank for a report including all current sales.  Use the mm/dd/yyyy format, e.g., 07/31/2001.  Strike Enter or click OK.

8.	You MUST type the Company Code you want to use if your site is set up as Multi-Company.  This input is not case sensitive.  Strike Enter or click OK.

9.	The Report is now generated and printed to the printer you chose or previewed to the screen.

Additional Information:

None

If you have any problems, please do not hesitate to call A.M.I.  Support at 858.272.5875 or e-mail us at support@amisoft.com.


Customer Transactions

Purpose of Report:	To print/display customer purchases within a range of dates for a list of Customer Account Numbers.  The Report can be restricted to a single product code or a single manufacturer ID.  The full Shipping Address is an option.

Overview:	If you have a Customer Name in your Customer List with more than one Customer Account Number, this is a report you can use to help summarize purchases for all Account Numbers.  The Report lists product purchases with Invoice Number and Date and the Customer's PO Number for a range of dates.  Including the full Shipping information is optional.  The report does not include Credit Memos.

The Report is designed for both single and multi company sites.

Input Parameters:	Date Range

List Customer Account Numbers

Product Code or blank for All Products Sold

Manufacturer ID or blank for No Manufacturer ID Filter

Shipping Address Flag

Company Code (if applicable)

Fields on Report:	Invoice Number

Invoice Date

Customer's PO Number

Ship To Name

Ship To Address (optional)

Product Code

Product Description

Quantity Shipped

Unit Price

Extended Price

Grand Total Price

Sample Customer Transactions Report:

How to Generate the Customer Transactions Report:

1.	Double click on the Report Writer Icon.  Log in and select the Customer Transactions Report.

2.	Click on the Preview box to preview the report to the screen.  Then click on the Preview button.  Or just click on the Print button for a printed report.

3.	The Starting and Ending Scopes in the first dialog box refer to the range of Invoice Dates for the Report:

4.	Should you want to see every Invoice on record, click the Beginning of Table and End of Table buttons and then click OK..

5.	Otherwise click the Start Value button and type a Starting Date using a  yyyy/mm/dd  format, e.g., 2001/01/01, then click the End Value button and type the Ending Date.  Use the same format.  Ignore the time value.  Click OK.

6.	Type a list of Customer Account Numbers that you want on the Report.  The Numbers must be separated by a comma (,) without a blank.  A blank entry in this dialog box indicates you want to include ALL customers.  (You might do this to list every customer that bought a particular product code in the date range.)  Strike Enter or click OK.

7.	Type a Product Code (not case sensitive) if you want to restrict the Report to just one code.  A blank entry indicates you want to see all products purchased by your list of Customers.  Strike Enter or click OK.

8.	Type a Manufacturer ID (max of 10 characters, not case sensitive) if you want to limit the report to products from one manufacturer.  A blank indicates no limit.  Strike Enter or click OK.

9.	If you do NOT want to see the full Ship To Address, type an N.  Leave the box blank, or type a Y to include this address.  Strike Enter or click OK.

10.	The Report is now generated and printed to the printer you chose or previewed to the screen.  (This Report may take a lot of time, but it will be worth it.)

Additional Information:

The Report assumes that the product was shipped AND invoiced at the same time, eg, nothing was Invoiced But Not Shipped.

If you have any problems, please do not hesitate to call A.M.I.  Support at 858.272.5875 or e-mail us at support@amisoft.com.


Customer Transactions with Serial #

Purpose of Report:	To print/display customer purchases including serial numbers within a range of dates for a list of Customer Account Numbers.  The Report can be restricted to a single product code or a single manufacturer ID.  The full Shipping Address is an option.

Overview:	If you have a Customer Name in your Customer List with more than one Customer Account Number, this is a report you can use to help summarize purchases for all Account Numbers.  The Report lists product purchases with Invoice Number and Date and the Customer's PO Number for a range of dates.  Including the full Shipping information is optional.  The report does not include Credit Memos.

The Report is designed for both single and multi company sites.

Input Parameters:	Date Range

List Customer Account Numbers

Product Code or blank for All Products Sold

Manufacturer ID or blank for No Manufacturer ID Filter

Shipping Address Flag

Company Code (if applicable)

Fields on Report:	Invoice Number

Invoice Date

Customer's PO Number

Ship To Name

Ship To Address (optional)

Product Code

Product Description

Quantity Shipped

Unit Price

Extended Price

Grand Total Price

All Serial Numbers (for serialized product codes)

Sample Customer Transactions with Serial # Report:

How to Generate the Customer Transactions with Serial # Report:

1.	Double click on the Report Writer Icon.  Log in and select the Customer Transactions with Serial # Report.

2.	Click on the Preview box to preview the report to the screen.  Then click on the Preview button.  Or just click on the Print button for a printed report.

3.	The Starting and Ending Scopes in the first dialog box refer to the range of Invoice Dates for the Report:

4.	Should you want to see every Invoice on record, click the Beginning of Table and End of Table buttons and then click OK..

5.	Otherwise click the Start Value button and type a Starting Date using a  yyyy/mm/dd  format, e.g., 2001/01/01, then click the End Value button and type the Ending Date.  Use the same format.  Ignore the time value.  Click OK.

6.	Type a list of Customer Account Numbers that you want on the Report.  The Numbers must be separated by a comma (,) without a blank.  A blank entry in this dialog box indicates you want to include ALL customers.  (You might do this to list every customer that bought a particular product code in the date range.)  Strike Enter or click OK.

7.	Type a Product Code (not case sensitive) if you want to restrict the Report to just one code.  A blank entry indicates you want to see all products purchased by your list of Customers.  Strike Enter or click OK.

8.	Type a Manufacturer ID (max of 10 characters, not case sensitive) if you want to limit the report to products from one manufacturer.  A blank indicates no limit.  Strike Enter or click OK.

9.	If you do NOT want to see the full Ship To Address, type an N.  Leave the box blank, or type a Y to include this address.  Strike Enter or click OK.

10.	The Report is now generated and printed to the printer you chose or previewed to the screen.  (This Report may take a lot of time, but it will be worth it.)

Additional Information:

The Report assumes that the product was shipped AND invoiced at the same time, eg, nothing was Invoiced But Not Shipped.

If you have any problems, please do not hesitate to call A.M.I.  Support at 858.272.5875 or e-mail us at support@amisoft.com.


General Notes

If you do not already have a Desktop Shortcut set up to run the R & R Reports, set one up now.  The command line is the drive and path to your AMI directory and the executable file MCRR.EXE, e.g., F:\APPS\AMI\MCRR.EXE.  Use a title like AMI Special Reports.

The AMI Special Reports (Reports) requires you to log in.  Use the same User ID and Password you use for the Main Course (MC).  You can be in both the Reports and the MC at the same time.

Some of the Reports are free.  Others have a charge.

Each of the Reports can be secured.  As Supervisor, you can enter the User ID of the users that are allowed to run each report.  A User ID of Everyone, or blank allows all MC users access to a given report.  The Reports are delivered assuming everyone should have access.

The following shows you how to limit a Report to a subset of your users:

1.	Double click on the Report Writer Icon.  You must log in as SUPERVISOR.

2.	Select the File drop down menu and then Setup User Access.

3.	Scroll down and highlight desired report found under the Report Title column.  Click on the Edit button.

4.	You will now be in the Edit Custom Report dialog box.  Click on Everyone to deselect that choice.  Scroll through and click on each of your users that you want to have access to this report.

5	Click on OK or strike the Enter key.  Click on the next OK button to return to the MC Custom Report Interface dialog box.  You can now run the report.

Not all reports were designed to be Exported to a file such as a new dBase file or a spreadsheet.  Those that can be exported will include a note on what report line to choose when in the Export procedure.

The All Samples topic has links to each of the reports.

Each of the report topics has three buttons in the banner:

Return	Returns to the sample of that report in the All Samples topic

I	Moves to the Instructions portion of that topic.

SR	Moves to the Sample Report portion of that topic

If you have any problems, please do not hesitate to call A.M.I.  Support at 858.272.5875 or e-mail us at support@amisoft.com.


Inventory Adjustments

Purpose of Report:	To assist in reconciling the General Ledger Auto Posting from A/R by listing all inventory adjustment transactions for the requested date range.

Overview:	The Report includes both manual adjustments and those done within the Main Course such as by a Physical Count Update or by the RMA module.  It is printed by Warehouse.  Within a given warehouse the transactions are grouped by G/L Control Number.  Totals are included for each warehouse and for each G/L Control Number within that warehouse.

Input Parameters:	Starting Date

Ending Date

G/L Control Number from the A/R Auto Posting(s)

Fields on Report:	Product Code

Date of the Adjustment to Inventory

Transaction Comment

Quantity Adjusted for this Transaction

Cost

Extension of Quantity times Cost

Warehouse Code for the Transactions

G/L Control Number for the Transactions

Sample Inventory Adjustments Report:

How to Generate the Inventory Adjustments Report:

1.	Double click on the Report Writer Icon.  Log in and select the Inventory Adjustments Report.

2.	Click on the Preview box to preview the report to the screen.  Then click on the Preview button.  Or just click on the Print button for a printed report.

3.	Type the Starting Date in the first dialog box and strike Enter or click OK.  Use a date format of mm/dd/yyyy, eg, 01/01/2000.

4.	Type the Ending Date, using the same format as above, and strike Enter or click OK.

5.	Type the G/L Control Number you are trying to reconcile, or leave blank to see all Control Numbers posted to the G/L in that Date Range.  Remember, the Report includes Trial Postings.

6.	Strike Enter or click OK.  The Report is now generated and printed to the printer you chose or previewed to the screen.

Additional Information:

If you think a particular G/L Control Number was the result of posting more than a one month date range, you can enter a Starting Date of 01/01/1059 and an Ending Date of 12/31/2059 to be sure.

If your Auto Post A/R to the G/L Defaults screen does not include different Chart of Account Numbers (COA) for Inventory Adjustments (+) and Inventory Adjustments (-), you probably should create these numbers in the COA menu and enter them on the Defaults screen.  This will make reconciliation a little easier.

If you have any problems, please do not hesitate to call A.M.I.  Support at 858.272.5875 or e-mail us at support@amisoft.com.


Item Sales
Item Sales Report

Purpose of Report:	To list all invoices for a given product code with the ability to restrict the output by such data as zip code, state and sales rep.  This Report can be used for sales follow up and recall/warranty issues.

Overview:	The Report is printed by Invoice/Credit Memo Date for all sales of the given Product Code within the Date Range entered.  If a customer has bought the product more than once in the Date Range, all sales for that customer are listed on the same page.  The User can enter a simple or complex Query to limit the Invoices/Credit Memos reported on to only those meeting criteria such as a certain zip code, phone area code or state and one, or a range of Sales Rep Codes.

The Report is designed for both single and multi company sites.

Input Parameters:	Date Range

Company Code (if applicable)

Product Code

Query Information Title

Fields on Report:	Invoice/Credit Memo Date

Invoice/Credit Memo Number

Customer Account Number

Customer Billing Name and Address

Customer Phone and FAX Numbers

Quantity

Sold for Price

Gross Margin %

Sales Rep Code

Sample Item Sales Report:

How to Generate the Item Sales Report:

1.	Double click on the Report Writer Icon.  Log in and select the Item Sales Report.

2.	Click on the Preview box to preview the report to the screen.  Then click on the Preview button.  Or just click on the Print button for a printed report.

3.	The Starting and Ending Scopes in the Item Sales dialog box refer to the Dates for the Report:

4.	To see ALL Invoices on file leave the Beginning of Table and End of Table buttons marked.

5.	Otherwise click the Start Value button and type a Starting Date using a mm/dd/yyyy  format, e.g., 4/4/1998, then click the End Value button and type the Ending Date.  Use the same format.  Click OK.

6.	The Query dialog box appears.  If you want to see ALL information within your Date Range simply click OK.  But, you can very easily limit the list of Invoices to only those sold in a certain zip code, area code or state.  Be inventive, it is quite easy once you know the format.  The following uses the state of New Jersey as an example.  See below for some of the other common possibilities.

7.	Always leave the first two Query Lines as they are.  (They are included at the end of this Help page just in case they are removed.)  Click the Append button when you want to restrict your output.  Tab to the "Field" entry position and strike the S key until the Field STATE shows.  Tab to the "Comparison" entry field and strike the E key.  Equal to is displayed.  (There are numerous other ways to compare things.  Click on the down pointing arrow next to this field to see your choices, or use your down arrow key.)  Lastly Tab to the "Compared To" entry field and type in the two character state code you want.  This data MUST be entered between quotation marks (") and in capital (upper case) letters.  Our New Jersey example would be entered as "NJ".  With fields like Name and City you will need to know how the data was entered, e.g., HOBOKEN or Hoboken.

8.	Click the OK button.  You should normally choose to verify your Query by clicking on the Verify button.  Click OK in the Verify dialog box and again in the Query dialog box.

9.	You MUST type the Company Code you want to use if your site is set up as Multi-Company.  Strike Enter or click OK.

10.	Type the Product Code you are interested in reporting on.  The Report is not case sensitive on the Product Code.  Everything you input is forced to upper case characters.  Strike Enter or click OK.

11.	Always, always type a sub title for your report.  This is a free form field and what you type is what gets printed at the top of your Report.  Our example would be State = NJ.  Strike Enter or click OK.

12.	The Report is now generated and printed to the printer you chose or previewed to the screen.

Additional Information:

The following are some navigation rules while in the Query dialog box.

Field entry position:

When selecting a Field you will want to limit your selections to fields in the BILLTO file.

Entering the first letter of the field name moves immediately to the first field name that starts with that character.  Entering it a second time moves to the second field that starts with that character.  For example one S moves to SYS_DATE and the second to STATE.

Using the Up and Down Arrows allows you to scroll through all field names.

If you enter to many first characters and skip past the field name you want you can use the mouse to open the list box and drag the scroll bar to move up and/or down rather than using the keyboard Arrows.

Comparison entry position:

Using the Up and Down Arrows is the most efficient way to see the choices you have here.

The list is small, and controlled by the type of data in the field.  So you only get two choices when the field is logical like SRV_CHARGE and/or CRD_HOLD.

Compared To entry position:

Character data must be entered between quote marks (").

Some data must be upper case, e.g., STATE.  Fields like NAME, ADDRESS and CITY are case sensitive.  So SMITH is not the same as Smith or smith.

True is entered as .T. and false as .F.

Numeric fields like BILL_CD and TAX and all quantity fields are entered as numbers.

And/Or entry position:

This will normally be And when there is more than one Query line.

Use Or when you want something like a state of NJ or NY and some other item like a name of Bell Atlantic.  Call AMI Support for help.

Other possible Query fields are listed below.  Normally you will want to limit your selections to fields in the BILLTO file.  You can combine Queries by appending two or more lines to those already there.  If you want to do something that is not listed and are in doubt, call A.M.I.  Support.

Field	Key to strike	Compared To Example  (Case sensitive)

STATE	S or s	"NJ"

CITY	C or c	"HOBOKEN" or "Hoboken"

ZIPCODE	Z or z	"07030"

qAreaCd	q	"201"

NAME	N or n	"AMERICAN MICRO INNOVATIONS"

REP_CD	R or r	"CARL"

The first two Query Lines should always be:

INVOICE->PROD_CD equal to rProdCd

and INVOICE->CO_CODE equal to rCoCode

If you have any problems, please do not hesitate to call A.M.I.  Support at 858.272.5875 or e-mail us at support@amisoft.com.


K-to Keep Products Report
K-to-Keep Products

Purpose of Report:	To list all K-to-Keep Product Codes and their associated Delivery Order Numbers.

Overview:	The Report is printed by Product Code for all K-to-Keep Product Codes found within the Range of Delivery Order Numbers entered.  Delivery Order Numbers are listed for each code as well as the Description used on the particular Delivery Order.  The order quantities are included to help determine the Delivery Order status.

The Report is designed for both single and multi company sites.

Input Parameters:	Starting Delivery Order Number

Ending Delivery Order Number

Company Code (if applicable)

Fields on Report:	Product Code

Delivery Order Number

Warehouse Code

Product Description

Quantity on the Delivery Order

Quantity Invoiced

Quantity Shipped

Sample K-to-Keep Products Report:

How to Generate the K-to-Keep Products Report:

1.	Double click on the Report Writer Icon.  Log in and select the K-to-Keep Products Report.

2.	Click on the Preview box to preview the report to the screen.  Then click on the Preview button.  Or just click on the Print button for a printed report.

3.	The Starting and Ending Scopes in the first dialog box refer to the Delivery Order Number range for the Report:

4.	It is unlikely you would ever want to see every K-to-Keep part number ever used.  If you do, click the Beginning of Table and End of Table buttons.

5.	Otherwise click the Start Value button and type a Starting Delivery Order Number using an  nnnnnnn  format, e.g., sss2800, then click the End Value button and type the Ending Delivery Order Number.  Use the same format.  The n signifies one digit and the s signifies one space.  The last digit of the DO # must be the seventh character.

6.	Click OK.  The Report is now generated and printed to the printer you chose or previewed to the screen.

Additional Information:

None

If you have any problems, please do not hesitate to call A.M.I.  Support at 858.272.5875 or e-mail us at support@amisoft.com.


Margins with Freight - Detailed
Margins with Freight In - Detailed

Purpose of Report:	To list the detail of all Sales (Invoices and Credit Memos) for a given date range, showing the standard margin and the margin if incoming freight from the Purchase Order were included as a cost.

Overview:	This Report is similar to a Gross Margin Report.  When there is incoming freight on the appropriate Purchase Order the line item's freight is proportioned by line item cost to the total cost of that receiving.  The PO to DO Cross Referencing must be turned on and being used.  An excellent report when the majority of your sales are drop shipped from your vendors.  The Report is grouped by Sales Rep with monthly totals.  There is also a Summary version of this Report.

The Report is designed for both single and multi company sites.

Input Parameters:	Date Range

Company Code (if applicable)

Fields on Report:	Invoice/Credit Memo Number

Date

Order Number

Customer Number & Name

Product Code

Quantity

Price & Extension

Freight Out

Cost and Extension

Margin Dollars

Freight In

Adjusted Margin Dollars

Adjusted Margin %

Sample Margins with Freight In - Detailed Report:

How to Generate the Margins with Freight In - Detailed Report:

1.	Double click on the Report Writer Icon.  Log in and select the Margins with Freight In - Detailed Report.

2.	Click on the Preview box to preview the report to the screen.  Then click on the Preview button.  Or just click on the Print button for a printed report.

3.	The Starting and Ending Scopes in the first dialog box refer to the range of Invoice Dates for the Report:

4.	It is unlikely you would ever want to see every Invoice/Credit Memo on record.  If you do, click the Beginning of Table and End of Table buttons and then click OK..

5.	Otherwise click the Start Value button and type a Starting Date using a  mm/dd/yyyy  format, e.g., 01/01/2001, then click the End Value button and type the Ending Date.  Use the same format.  Click OK.

6.	If your site is set up as Multi-company you can run the report for one Company Code at a time.  Type the Company Code.  Strike Enter or click OK.

7.	The Report is now generated and printed to the printer you chose or previewed to the screen.  (This Report may take a lot of time, but it will be worth it.)

Additional Information:

This report should not be used if you are entering the freight in for each PO Line Item in the PO to DO Cross Reference dialog box in PO Entry and/or PO Receiving.

If you have any problems, please do not hesitate to call A.M.I.  Support at 858.272.5875 or e-mail us at support@amisoft.com.


Margins with Freight - Summary
Margins with Freight In - Summary

Purpose of Report:	To list a summary of all Sales (Invoices and Credit Memos) for a given date range, showing the standard margin and the margin if incoming freight from the Purchase Order were included as a cost.

Overview:	This Report is similar to a Gross Margin Report.  When there is incoming freight on the appropriate Purchase Order the line item's freight is proportioned by line item cost to the total cost of that receiving.  The PO to DO Cross Referencing must be turned on and being used.  An excellent report when the majority of your sales are drop shipped from your vendors.  The Report is grouped by Sales Rep with monthly totals.  There is also a Detailed version of this Report.

The Report is designed for both single and multi company sites.

Input Parameters:	Date Range

Company Code (if applicable)

Fields on Report:	Invoice/Credit Memo Number

Date

Order Number

Customer Number & Name

Invoice Price

Freight Out

Invoice Cost

Margin Dollars

Freight In

Adjusted Margin Dollars

Adjusted Margin %

Sample Margins with Freight In - Summary Report:

How to Generate the Margins with Freight In - Summary Report:

1.	Double click on the Report Writer Icon.  Log in and select the Margins with Freight In - Summary Report.

2.	Click on the Preview box to preview the report to the screen.  Then click on the Preview button.  Or just click on the Print button for a printed report.

3.	The Starting and Ending Scopes in the first dialog box refer to the range of Invoice Dates for the Report:

4.	It is unlikely you would ever want to see every Invoice/Credit Memo on record.  If you do, click the Beginning of Table and End of Table buttons and then click OK..

5.	Otherwise click the Start Value button and type a Starting Date using a  mm/dd/yyyy  format, e.g., 01/01/2001, then click the End Value button and type the Ending Date.  Use the same format.  Click OK.

6.	If your site is set up as Multi-company you can run the report for one Company Code at a time.  Type the Company Code.  Strike Enter or click OK.

7.	The Report is now generated and printed to the printer you chose or previewed to the screen.  (This Report may take a lot of time, but it will be worth it.)

Additional Information:

This report should not be used if you are entering the freight in for each PO Line Item in the PO to DO Cross Reference dialog box in PO Entry and/or PO Receiving.

If you have any problems, please do not hesitate to call A.M.I.  Support at 858.272.5875 or e-mail us at support@amisoft.com.


PO Reorder by Product Code
Reorder by Product Code with Last Purchase Cost

Purpose of Report:	To list all Product Codes that need to be ordered with the required quantity and the last purchased from Vendor ID and Cost.

Overview:	The Report is printed by Product Code for all products where the Supply plus On Order quantities are less than the Demand.  Only a subset of warehouses can be reported on.  If the product has been received on a PO, the listed cost is from the most recent receipt.  Otherwise the cost comes from your Main Course or Electronic Catalogue (optional) Product List.  The same is true about the Vendor ID.  The source of the cost is indicated for each required product.

Input Parameters:	None (see Additional Information)

Fields on Report:	Product Code

Product Description

Demand

Supply

Quantity On Order

Quantity Needed

Cost

Cost Extension

Vendor ID

Source for the Cost (PO -> the PO Receipt, MC -> the Main Course List or EC -> the Electronic Catalogue (optional)

Sample Reorder by Product Code with Last Purchase Cost Report:

How to Generate the Reorder by Product Code with Last Purchase Cost Report:

1.	Double click on the Report Writer Icon.  Log in and select the Reorder by Product Code with Last Purchase Cost Report.

2.	Click on the Preview box to preview the report to the screen.  Then click on the Preview button.  Or just click on the Print button for a printed report.

3.	There are no input parameters.  But see below for instructions on limiting the warehouses that are included in the Report  The Report is now generated and printed to the printer you chose or previewed to the screen.

Additional Information:

The following shows you how to limit the Report to a subset of your warehouses:

1.	Double click on the Report Writer Icon.  You must log in as SUPERVISOR.

2.	Select the File drop down menu and then Setup User Access.

3.	Scroll down and highlight PO Reorder Report by Product Code found under the Report Title column.  Click on the Edit button.

4.	You will now be in the Edit Custom Report dialog box.  Click in the P1 area in the Parameters sub box.  List the Warehouse Codes you want included when you run this report.  Seperate each code with (only) a comma and end the list with a comma.  Be sure to use upper case (capital) letters and end with spaces to show a total of five characters for each Code.  An example is:  MAIN ,CNTRL,.  There is a space between MAIN and the first comma but no space after it.  CNTRL is five characters, so there is no space required there.

5	Click on OK or strike the Enter key.  Click on the next OK button to return to the MC Custom Report Interface dialog box.  You can now run the report.

If you have any problems, please do not hesitate to call A.M.I.  Support at 858.272.5875 or e-mail us at support@amisoft.com.


PO Reorder Report Grouped by Vendor ID
Reorder by Vendor with Last Purchase Cost

Purpose of Report:	To list all Product Codes that need to be ordered with the required quantity and the last purchased from Vendor ID and Cost.  Group the products  by Vendor ID.

Overview:	The Report is printed by Vendor ID and then Product Code for all products where the Supply plus On Order quantities are less than the Demand.  Only a subset of warehouses can be reported on.  If the product has been received on a PO, the listed cost is from the most recent receipt.  Otherwise the cost comes from your Main Course or Electronic Catalogue (optional) Product List.  The same is true about the Vendor ID.  The source of the cost is indicated for each required product.  Each Vendor ID includes a subtotal cost.

Input Parameters:	None (see Additional Information)

Fields on Report:	Vendor ID

Product Code

Product Description

Demand

Supply

Quantity On Order

Quantity Needed

Cost

Cost Extension

Vendor's Product Code

Source for the Cost (PO -> the PO Receipt, MC -> the Main Course List or EC -> the Electronic Catalogue (optional)

Sample Reorder by Vendor with Last Purchase Cost Report:

How to Generate the Reorder by Vendor with Last Purchase Cost Report:

1.	Double click on the Report Writer Icon.  Log in and select the Reorder by Vendor with Last Purchase Cost Report.

2.	Click on the Preview box to preview the report to the screen.  Then click on the Preview button.  Or just click on the Print button for a printed report.

3.	There are no input parameters.  But see below for instructions on limiting the warehouses that are included in the Report  The Report is now generated and printed to the printer you chose or previewed to the screen.

Additional Information:

The following shows you how to limit the Report to a subset of your warehouses:

1.	Double click on the Report Writer Icon.  You must log in as SUPERVISOR.

2.	Select the File drop down menu and then Setup User Access.

3.	Scroll down and highlight PO Reorder Report Grouped by Vendor ID found under the Report Title column.  Click on the Edit button.

4.	You will now be in the Edit Custom Report dialog box.  Click in the P1 area in the Parameters sub box.  List the Warehouse Codes you want included when you run this report.  Separate each code with (only) a comma and end the list with a comma.  Be sure to use upper case (capital) letters and end with spaces to show a total of five characters for each Code.  An example is:  MAIN ,CNTRL,.  There is a space between MAIN and the first comma but no space after it.  CNTRL is five characters, so there is no space required there.

5	Click on OK or strike the Enter key.  Click on the next OK button to return to the MC Custom Report Interface dialog box.  You can now run the report.

If you have any problems, please do not hesitate to call A.M.I.  Support at 858.272.5875 or e-mail us at support@amisoft.com.


Sales by Customer with Customer PO #

Purpose of Report:	To list all Sales (Invoices and Credit Memos), including the Customer's PO Number, for a range of customer names and for a given date range.

Overview:	This is similar to the Detailed Sales By Customer Report from the Reports menu.  The Customer's PO Number has been added and the Gross Margin dollars and percent were removed.  The output is sorted first by Customer Name then by Customer PO # and then by Invoice Number with totals for each Customer.  There is a Detailed version that lists the line item information of each Invoice.

The Report is designed for both single and multi company sites.

Input Parameters:	Date Range

Range of Customer Names

Detail Report Flag

Range of Company Codes (if applicable)

Fields on Report:	Customer Name & Number

Invoice/Credit Memo Number

Date

Customer's PO Number

Gross Sales

Net Sales

Freight

Tax

Product Code, Price, Quantity and Price Extension (in detail report)

Sample Sales by Customer with Customer PO # Report:

How to Generate the Sales by Customer with Customer PO # Report:

1.	Double click on the Report Writer Icon.  Log in and select the Sales by Customer with Customer PO # Report.

2.	Click on the Preview box to preview the report to the screen.  Then click on the Preview button.  Or just click on the Print button for a printed report.

3.	The Starting and Ending Scopes in the first dialog box refer to the range of Invoice Dates for the Report:

4.	It is unlikely you would ever want to see every Invoice/Credit Memo on record.  If you do, click the Beginning of Table and End of Table buttons and then click OK..

5.	Otherwise click the Start Value button and type a Starting Date using a  yyyy/mm/dd  format, e.g., 2001/01/01, then click the End Value button and type the Ending Date.  Use the same format.  Ignore the time value.  Click OK.

6.	Type the Customer Name that you want the report to start with.  A blank entry indicates you want to start with your first customer.  Strike Enter or click OK.

7.	Type the Ending Customer Name that you want.  A blank entry indicates you want to end with your last customer.  Strike Enter or click OK.

8.	If you want a detailed report type a D.  Leave blank if you want only the invoice totals.  Strike Enter or click OK.

9.	If your site is set up as Multi-company you can run the report for one Company Code or a range of codes.  Type the Company Code to start with.  A blank entry indicates you want to start with the first code.  Strike Enter or click OK.

10.	Type the Ending Company Code.  A blank entry indicates you want to end with the last code.  Strike Enter or click OK.

11.	The Report is now generated and printed to the printer you chose or previewed to the screen.  (This Report may take a lot of time, but it will be worth it.)

Additional Information:

On a detailed report you can get a negative Price for Shipping/Freight on Credit Memos because the Restocking fee is larger than the credited Freight.

Tax is applied to any Discounts in a taxed Credit Memo.  This shows on a detailed report.

If you have any problems, please do not hesitate to call A.M.I.  Support at 858.272.5875 or e-mail us at support@amisoft.com.


Serial Numbers by Ship Code

Purpose of Report:	To assist you in providing your customers with assembling/maintaining their Asset Management data.

Overview:	This Report lists all product codes and serial numbers bought by a customer in a range of dates.  It is sorted by the Ship to Name.  The output is easily Exported to a spreadsheet format.  Additional data, like Invoice Date, can easily be added to a customized version of your particular design.

The Report is designed for both single and multi company sites.

Input Parameters:	Starting Company Code and Bill To Code

Ending Company Code and Bill To Code

Date Range

Fields on Report:	Ship To Code

Ship To Name

Ship To City

Ship To State

Product Code

Serial Number

Credit Memo Flag

Sample Serial Numbers by Ship Code Report:

How to Generate the Serial Numbers by Ship Code Report:

1.	Double click on the Report Writer Icon.  Log in and select the Serial Numbers by Ship Code Report.

2.	Click on the Preview box to preview the report to the screen.  Then click on the Preview button.  Or just click on the Print button for a printed report.

3.	The Starting and Ending Scopes in the first dialog box refer to the Company Code and Bill To Code range for the Report:

4.	It is unlikely you would ever want to see every Serial Number on record.  If you do, click the Beginning of Table and End of Table buttons and then click OK..

5.	Otherwise click the Start Value button and type a Company Code and Bill To Code using a  CCCCCnnnnnnn  format, e.g., AMINCss12345, where the s is one Space key.  Then click the End Value button and type the Ending Company Code and Bill To Code.  Use the same format, e.g., AMINCss12345.  Click OK.

The Company Code must be justified to the left and the Bill To Code must be justified to the right.  This is done by putting enough spaces between your Company Code and the Bill To Code to make sure the last digit of your Bill To Code is the 12th character in the string.  If your Company Code is two characters and your Bill To Code is four characters, you need six spaces.

For single company sites:  You must replace the above Cs with 5 spaces.

6.	Type the Starting Date using a mm/dd/yyyy  format, e.g., 04/01/2001.  This is the date of the invoice.  Strike Enter or click on the OK button.

7.	Type the Ending Date using the same mm/dd/yyyy  format, e.g., 04/30/2001, and strike Enter or click on the OK button.

8.	The Report is now generated and printed to the printer you chose or previewed to the screen.

Additional Information:

None

If you have any problems, please do not hesitate to call A.M.I.  Support at 858.272.5875 or e-mail us at support@amisoft.com.