Archives
Sometimes a user will accidentally type in a wrong number in the starting check number in A/P check printing and posting. If that check number is higher than the last check number used, the system will prompt to void all the check numbers in between. If that prompt is answered "ok", this will result in […]
This is about Progress version of Syteline, on how multi-currency works in Financial Statements. FINANCIAL STATEMENTS The exchange rate table (could be local or global) normally used by the database from which the Financial Statement is being printed will be used for the translations. Therefore, unless Current Rate translation is to be used on all […]
Payroll Generation: pr/pr-trxg.p, main logic in pr/pr-trxg1.p Payroll record prlog can be generated from 4 differ sources: Manufacturing transaction jobtran. The Generate Payroll From field on the Employee Master must also be set to M. The summarized transactions include: WC Labor, WC Machine Time and Job Labor. prlog.posted-from = “M”. Manufacturing Project transaction projtran. The […]
You may need to scan your database for bad records and bad blocks if you receive an error message which points to data corruption (such as 1124 and 16). The database repair utility is a function of PROUTIL and the _proutil executable. It is executed like any other PROUTIL function, however there are a number […]
1) To move around the db extent to differ location Bring down the DB and make a backup of the DB. Copy the db extent file, such as .b1, .b2 or .d1, .d2, to a new location Edit the .st file to point to the new location prostrct repair db-name [.st description file], This will […]
The MRP Generation algorithm – SL6 and lower (Progress versions)Regenerates the m-day calendar if it requires regeneration If full regeneration being run: Delete all requirement records for all items (mrp table) Delete all transfer order receipts for all items (rcpts table, ref-type “T”) If lasttran counter for PLNs is > 9000000: Reset it to 1 […]
1) For the original DB, dump the .df file. Can be done by go to Progress -> Data Administration -> Admin -> Dump Data and Definitions -> Data Definitions; or Syteline admin -> Admin -> Database maintenance -> Dump Data Definitions. 2) Create a new DB from Progress empty DB: Progress -> Data Administration -> […]
Copy DB in Windows1) Command prompt, CD to DB directory.2) %DLC%\bin\procopy oldname newname. newname can be full path like F:\db\shimadzu\shimadzu3) This will copy over the .db, .b1, .d1, .st and .lg. Then manually copy over any .pf and update .pf accordingly.