Reporting to the MAX Software-Payroll Year End Procedures-Boise

UTICMS03-RUN UTICMS.EXE TO CORRECT/CHANGE DATA FIELD for the Reporting to the MAX

Occasionally, a Cougar Mtn Data File needs to have a data field corrected or changed. One technique to be able to delete an open p.o. is to use UTICMS.EXE to change the order status to zero. Once this is done, you can cancel the p.o. in a normal manner. As always, a backup of all files or the files involved in advance of using any advanced tech solution.

If you don't have on icon for UTICMS.EXE, click on Search or Find, File and Folders, UTiCMS.EXE in My Computer or the Network Drive:

Then double-click on, UTICMS, then file, open and navigate to your data directory (eg. DMODATA but use you data directory like dyn ), then put in file name your company code and the file name (eg. DMOPOITM.DBF (eg. dynpoitm.dbf) for the P.O. Open Item Header File, then click on OK.

Then, click on the POITORDST field on the purchase order you want to get rid of. Then change the POITORDST field to zero. Then click on file and exit.

Next, from the P.O. module, Receive PO's menu item, Receive PO's from the program list, select the P.O. numbers and then cancel the P.O. and post.

After posting, it is recommended that an OPEN PO report be run and balanced to the G/L Account Received/Not-invoiced and review the part numbers in the Inventory module, Stock, that were on this P.O. and verify that the quantity "ON ORDER" is correct.

Here is a section of the file layout of the P.O. ITM file

PO Open Item Header File: xxxPOITM.DBF

INDEX	TAG
UPPER(POITNUM)	POITNUM(U)
UPPER(POITVENDOR) + UPPER(POITNUM)	POITVENDOR
DTOS(POITPODATE) + UPPER(POITNUM)	POITPODATE

1.*~	PO Number	POITNUM	Char-Caps	20
2.*~	Vendor Number	POITVENDOR	Char-Caps	20
3.	Vendor Contract	POITVCONT	Char-Caps	20
4.	Shipping Method (Ship Via)	POITSHIP	Char-Caps	20
5.~	Buyer	POITBUYER	Character	15
6.	Description (from receiving screen)	POITDES	Character	30
7.	Freight Type	POITFRTYPE	Numeric	1	R:0-2
	0=Prepaid, 1=Collect, 2=Added
8.	Order Status	POITORDST	Numeric	1
9.	Invoice Status	POITINVST	Numeric	1

Web Affiliates