MYTE MYKE

 SOFTWARE

Business Software Providing ERP Solutions For Over 25 Years

Home
Who We Are
Products
Features
Flexible Design
Myte Myke Screens
Customization
Technical Support
eForms
Product Configurator
What's New
Contact Manager
Site Map

Reporting using ODBC

 

 

 

Current Releases

The staff at M&D Systems is constantly working on ways to enhance Myte Myke software. The following changes were made to our current version:

RELEASE 703 O

QR 37 ITM Bin Overstock Locations

New option added to the QR M3 Query to Excel menu. Use this new option to query overstock bins added to records in FM 7 IC Item Master File.  Queries can be automatically brought up in Excel (with SYCTRL set-same as rest of the query programs), saved to a .csv file or printed (using standard Myte Myke printing set up).

QR 38 PRODUCTION COST DETAIL QUERY

Added a new option that will generate the same production costing report as in "PC 30 Print Production Cost Detail", which will generate a detailed list of General Ledger distributions to Inventory,  Absorbed Labor and Absorbed Overhead accounts. Individual amounts are listed for each line of the product structure.

 

Again, Queries can be automatically brought up in Excel (with SYCTRL set-same as rest of the query programs), saved to a .csv file or printed (using standard Myte Myke printing set up).

RELEASE 703 m

SC 2B pRINT INDENTED BOM TO EXCEL

New option that will open the Indented Bill of Material to an Excel spread sheet.

FM 7 IC Item File

Added a new "Bin overstock" option that allows you to store 8 more "Bin" locations per item. Bin information on this new screen can be accessed using ODBC for reporting.

RELEASE 703 I-L

Added Duplex Printing Capability 

2 sided printing for “Windows” default print set up

If your printer has “Duplex” printing capability and this is not set up as default in your printer properties on your PC, you will now have the ability to turn this on from the “Page Set Up-Properties” box right from Myte Myke.  

RELEASE 703 F-H

Expanded the Order Entry Dollar Amount Fields for the Mexican Pesco

Note: If you need this capability to print on Sales Orders or Invoices, contact the Technical Support Department. You may need special programming if you are not using our standard printing programs.

PO 35 Query Purchase Order History

Added new option under “File” pull down to access other PO history files other than POHIST.

OE 20 Prepare Orders for Invoices

Added a credit limit check that uses the same set up response as OE 1 Enter Orders.

Release 703B-E

Added new menu option:

qr excel queries

Extract data from Myte Myke's main data files. The programs will import data directly to EXCEL or will create a .cvs file that can be opened in Excel.

Options are also available to display data to screen or print data directly in to document format, to the printer. The document can also be displayed and saved to a file.  

FM 3 AR Customer Master File.

FM 5 AP Vendor Master File

FM 7 IC Item File

Added an indicator in the records to let you know that "Sticky Notes" exist.

SC 12 DISPLAY WHERE USED

Added a new pull down option to select only active structures.

SC 46 PRINT G/L EDIT LIST

SC 47 POST COST ROLLUP

Added 2 new options that will allow you to post standard cost differences to General Ledger for existing structures that currently have quantity on hand in inventory. A new System Set Up question was added to activated this.

Release 703A

AP 7 VENDOR INQUIRY

Added a new capability to view transactions from an alternative AP History File.

SC 45 Transfer cost to item file

Program will now transfer costs from B, C or D fields that were added in the Raw Material file (to run What-if reports) to the standard cost field in the Item Master File. If  "On-hand" quantity exists for the raw material, a standard cost difference amount will post to the General Ledger (providing "SU 3B Activate GLPOST Cost Rollup" is activated). Contact the Technical Support staff for proper procedures.

Release 605Z &702Z

AR 5 CUTOMER INQUIRY

Added a new pull down option to choose to sort by invoice number or post date.

IC 4A DISPLAY INV. BY WH-LINEAR

Added a new linear display program to IC M1 menu.

PO 6 RECEIVED PURCHASED QUANTITIES

Added more information to the "Item display" under "Options".

sc4a print standard cost difference

Added a new pull down option to print cost difference between ITM costs and temporary costs.

Release 605y &702y

SC 6B

Added the new Product Structure Master File Linear screen. This program accesses the same data as SC 6. Structures can be added, deleted, replicated, printed and changed in this option (same as SC 6). The structures are first displayed in a "structure tree". Lines are displayed in a linear display.

Release 605W &702W

PC 40 DISPLAY ORDER HISTORY

Added "Completion date" and "Quantity pulled" on the display.

Release 605V &702V

ap 1 ENTER INVOICES

Added the "Misc code" field from the FM 5 AP Vendor Master File to display on the "Enter Invoices" screen, to allow operators to know which currency the vendor is in. This applies only if Foreign Exchange is active.

ap 2B Change Dates on Open invoices

Program will no longer display voided checks.

OE 4 Print sales orders

Added a new option "print Note lines" to print OE Note lines on Sales Orders.

SC 43 PRINT FINISHED COSTS

Added new pull down option to print Standard or Temporary cost fields on the report.

Release 605 U &702 U

ap 21 & 2b-Renamed both options and enhanced ap 2b

AP 2B Change Dates on Open Invoices (formally MODIFY OPEN INVOICES-LINEAR) was enhanced only to display open invoices to easily change dates.

ap m4 print labels 

An optional print label program can be added to the AP M4 menu to print labels to laser printers.

Release 605 T &702 T

OE 33 TRANSFER RECURRING ORDERS

Added a new option to "unflag" orders if incorrectly flagged before running the transfer procedure.

PC  2 print picking list

Enhanced options functionality.

po 27 manual sort

Allow cost received purchase orders to be manually sorted to reprint quantity receivers.

PP 1 SELECT/SET UP CALENDAR WINDOW

"Shift" option can be used more than once before updating changes to the Calendar window.

sc 6 product structure master file

Scan/Select  window will only  display active items from the Item Master File.

Added a message if you try to delete a structure that contains open orders:"Deletion not allowed-Open orders exist for item xxx, Flushed not allowed, Press Return."

Release 605 R-S &702 R-S

FM 3 AR CUSTOMER MASTER FILE

FM 5 AP VENDOR MASTER FILE

FM 7 IC ITEM MASTER FILE

 

Improved Supplemental Fields selection box display for printing.

GL 92 REPRINT THE GL RECAP

Added a new option to search by posting date.

 

PO M1 MENU (GL & AP link off)

 

Added the "Manual Sort" option to the PO M1 menu (removed from the PO M2 menu).

 

PP 21 CREATE PLANNED ORDERS

 

Added a new message if errors are present. The program will automatically create a error report.

 

SC 45 TRANSFER COSTS TO ITEM FILE

 

Added a new capability (set up and menu options) to automatically post Standard Cost changes to the General Ledger when transfering costs to the Item Master File.

 

Release 605 O-P-Q &702 o-P-Q

GL 5 & 81 Print financial statements

Upgraded the program's report selection options.

GL 93 GL TRAILBAL-EXCEL

Added a new option that will not out put account numbers with zero balances.

PC 25 Complete Production Orders

Added a new set up question in System Set Up, to activate a display warning in PC-25, when the completed quantity is different from the ordered quantity.

PO 1 Enter purchase orders

Add a new insert option (that must be purchased).

Release 605n &702n 5-12-2004

sc 2a print std cost diff

Added option to the Standard Cost M2 menu. This report lists differences between current and new cost for finished items.

Release 605M &702M 5-01-2004

SC 6 PRODUCT MASTER FILE

Added a new option when replicating product structures, that allows multiply copies without exiting and re-entering the option.

Release 605L &702L 4-14-2004

SC 6 PRODUCT MASTER FILE

Modified the record re-numbering prompt that displays, when inserting records.

release 605k &702k 3-26-2004

GL 93 GL TRIAL BALANCE

New option to import the GL Trial Balance in to Excel. Options include trial balances from current year and prior year.

po 1 enter PURCHASE orders

Added a new control key capability to change the close order screen not to print purchase orders.

pp 3 display mrp

Modified display to show customer demand if System Set Up was  activated to show O/E demand on the MRP Report.

release 605J &702J 3-10-2004

AP 1- ENTER INVOICES

Improved the G/L Distribution Screen-description added to the first line will automatically display on the second.

ar 5 customer inquiry

Changed the order in which transactions will display. Transactions will display by most current invoice # sequence.

fm 3 ar customer master file & fm 7 Ic item master file

Improved Supplemental Field functionality. Fields that are selected, will stay selected after exiting the record.

gl 40 enter prior period adjustments

Added new pop up window that will prompt for the accounting year and period that adjustments will be entered to.

ic 2 display status of inventory

Improved "Reselect" option once in a record.

po 28 po received-not invoices

Added a new option to sort report by account numbers.

pp3 display mrp

Improved functionality to display another record, when accessing a record.

pp 22 print mrp report

Improved French Literals for customers using Myte Myke in French.

release 605I &702I 1-30-2004

GL 6 Display Account analysis summary

Improved the jump function with a new pop window prompting for the accounting month and accounting year.

GL 7 & 31 DISPLAY ACCOUNT ANALYSIS DETAIL

Added new pull/down options to filter data.

GL 92 REPRINT THE GL RECAP

New option to reprint any edit list previously processed from all modules.

release 605h &702h 12-31-2003

OE 1 enter orders

A new message box was added to warn that inserts within a configured order are not allowed.

SY SYSTEM PRINT

A "LARGE" new message "PLEASE WAIT" will appear while printing so that the program does not appear idle. A record counter was also added to the bottom of the screen.

release 605g & 702g 12-22-2003

PO 1 Enter Purchase ORDERS

Modified program to allow negative PO's for NON Lot or Serial Items.

SC 6 product structure file

Modified programs to automatically remove the corresponding finished good file, when flushing an entire Product Structure in SC-6.

Release 605F &702F 12-03-2003

OE 33 Transfer recurring Orders

Added additional record counter so screen never looks idle when processing large orders.

OE 88 Select to reprint Invoices

OE 89 Reprint Invoices

Added menu options to OE M8 Month End Menu, to reprint invoices that were purged to OE history.

Release 605E &702E 11-18-2003

AP 5 Post invoices

ar 4 post cash receipts

ar 23 post adjustments

ar 27 post memo invoices

 

Added new record lock messages for all AP and AR options.

 

IC 3 Display Orders by Item

PC 8 Display Orders by item

 

Added new option button which toggles between "view PO" and "view Wip".

 

oe 23 create posting file

 

Added new warning message if journal source IN02 is not set up correctly.

 

PC 1b explode orders

 

Will check for set up errors when exploding production orders from Order Entry and will list errors on a report.

 

pi 28 update inventory totals

 

Program will automatically reconcile discrepancies between ITM and ICSUB before updating inventory with new counts.

 

PP 3 Display MRP

 

Changed the screen to use the return key to advance to the next record.

 

sc 31 finished goods file

 

Added 3 new selections under the options to filter report by the "MFG or Purchased" field in FM-7.

 

release 605d & 702d 10-29-2003

 

gl 7 display account analysis detail

 

Added ability to reprint any edit list previously processed from all modules.

 

pc 20 record material movement

 

Added a new warning message-when adding transactions for a Serial Item the "Quantity Pulled" can only be 1.

 

release 605c & 702c 10-15-2003

 

gl 7 display account analysis detail

gl 33 print account analysis

 

The check number and vendor number will display in the "Transaction Description" field for all posted check transactions.

 

po 20 process vendor invoices

 

Removed error "INVALID LINE # ENTERED...PRESS RETUN"  if zero cost PO's are processed.

 

PO 37 query vendor history

 

Added this linear screen as a new menu option to the PO M3 menu to query PO history.

 

DISPLAY SYAUDT FILE FOR ODBC USERS.

 

Security information can now be viewed in an individual monthly SYAUDT file using ODBC.  A new file is generated every month.

release 605b & 702b 9-16-2003

Multi user posting process (vpn users)

Added new warning messages to all posting processes for multi  users posting, to avoid locks, especially over the VPN.

ap 27 check reconciliation

 

Added a new option to print "ALL" cashed and uncashed checks

 

oe 23 & oe 56 create posting file

po 10 & po 25create posting file

 

Added a message indicating what period transactions will be posted to.

 

po 28 po received-not invoiced

 

Added a new report menu option to the PO M2 menu to show PO's that were quantity received, but not yet invoiced.

 

sm 4 security set up

 

Added a new set up question that will convert entries made in lower case to upper case in scan/select windows.

 

all m9 90 special programs menu options

 

Made user friendly key board changes for selection and execution of Special Programs that are added here.

 

f5 function key on any menu option

 

A new screen was added that will display the program version, program version date, the current runtime version and access to this web site.

 

release 605A & 702A 8-11-2003

 

oe 3 & 47 print bill of lading

 

Added ability to manually sort to print the Bill of Lading.

 

SM 5 operator initials/codes

 

Added a new control key (that must be set up by the system manager) to set access security on the F4 function (date overrides).

 

Return to Top

 

 

Global Solutions Directory

Current Releases

Demonstration 

of the Order Entry Module

(This may take a minute to load-time will depend on your internet connection)

 

 

 

Contact Us\E-mail   

Manufacturer & Distribution Systems, Inc. 3959 N. Buffalo Street Orchard Park, New York 14127 

Phone: (716)-662-6611 Ext-109 Doug Robinson-CEO   Fax: (716)-662-2411