Set the default Isolation Level used by COM+
Internal SQL Server Error when X-Ref to CO/PO Lines
Data Collection Overview in SyteLine 7.0
The Web Browser based varieties of Data Collection are online types of Data Collection and use style sheets. There are 3 style sheets provided in SyteLine 7.0 for Web Based Types of DC:
1) Default - GUI page that includes drop down boxes and requires a mouse for easy data entry.
2) Wedge - replaces the Wedge […]
Find all materials where no U-M conversion record exists
If you receive this error when running one of the BOM Processors, you have a current or job material where there is no unit of measure conversion record for the combination of the material U-M and its item master U-M. You can use one of the following utilities to find all such materials.
Here’s the code:
select ‘Material records […]
Data export utility - RMA - (SQL)
declare
@RMA RMANumType
– Enter your RMA number in the following set statement
– Purely numeric numbers (no prefix) should be right justified in the quotes
– Make certain there are ten positions between the quotes. e.g. ‘ 5000′
set @RMA = ”
set nocount on
select ‘rma:’
select * from rma
where rma.rma_num = @RMA
select ‘rmaitem:’
select * from rmaitem
where rmaitem.rma_num = @RMA
select ‘rmarepl:’
select […]
Data export utility - Current and standard routing/BOM for one item (Progress)
The ul-curstd.p program can be run from the Progress Query editor to export the item master along with its current routing/BOM and standard routing/BOM if it is standard costed. It will prompt you for an item number and then export the records to a series of files that all begin “sup-” and that have a […]
Data export utility - Purchase order and all associated records (Progress)
The attached programs can be run from the Progress Query editor to export a PO, its lines, releases, receipt and voucher records. It will prompt you for an order number and then export the records to a series of files that are listed in a “sup-file-list.out” file […]
Invoice or Credit Memo will not post in Accounts Receivable
Invoice or Credit Memo will not post and cannot determine the problem. Update the parameters in the query below and run it in SQL Query Analyzer to receive an error message. This query posts one record at a time.
set nocount on
begin tran
declare
@PSessionID RowPointerType
, @PostExtFin ListYesNoType
, @ExtFinOperationCounter OperationCounterType
, @Infobar InfobarType
set @PSessionID […]
Recommended Procedures for Form Sync when applying Patches
if the vendor version of the form works correctly but the Site, Group or User level forms cause problems or an error message, the customized forms are the old version of the form. If you have minor changes to the form, you can revert the form definition to Vendor default and then re-apply your changes […]
Data export utility - Customer and all A/R data (SQL)
The script will export a customer and their A/R posted transactions. Use the following steps to run this script and send the resulting file back to support:
1) Open query analyzer and connect to the App database in which the target data resides.
2) Select Query, Results to Text.
3) Select Tools, then Options, go […]
Utility to output version headers in StProc, Function, Trigger objects and Indexes and Constraints for compare
FIX
This script can be used to output information on all stored procedure, function and trigger objects in the database, just one specific object, a list of specific objects, or a range of objects. In Query Analyzer, choose Query > Results to Text. Then run the following code against the _App database and send back the results […]
What APAR’s are included in the latest APS Planner Patches?
ere is a list of cumulative APAR’s since January 1, 2008 that are included in the latest APS Planner Patches. Click on the APAR number for further details. They are listed newest to oldest. This Primus solution is the equivalent to a Cover Leter.
SL 8.xx.xx SL7.05.xx SL7.04.xx SL7.03.xx
APAR 110409 X X X
APAR 110351 X
APAR 110761 X X X
APAR 109886 X X X
APAR 110408 […]
Primer on manufacturing safety stock
Explanation of the Post Process manufacturing safety stock behavior: at the end of the APS planning run any manufactured item that has dipped below the safety stock level outside of the time fence will get a safety stock plan at that point in time with a quantity equal to the difference between the safety stock […]
Recommended nightly procedures to run against a Syteline Application database
Utility to output detailed information about a Syteline Form for comparison
For SL7 Download the FormComparison2.sql code here.
For SL8 Download the FormComparison2-SL8.sql code here.
Download ExamDiff.exe here.
Unable to upgrade to SL8.00.10 AND unable to create a new Demo SL8.00.10 IF Site Currency <> USD
Read more from the Knowledge Base category, or subscribe to the RSS.