APAR 78518 - Ranks are incorrect for the Vendor Item Cross Reference records
Utility to fix incorrect Ranks on Item/Vendor Cross Reference
What transactions occur with Landed Costs
Overview transaction with Landed Cost in SyteLine all versions
Accounts Receivable Parameter
Concept on how to deal with Invoice Sequence Maintenance
Not one sequence exists for customer xx that has invoice category: default category
Utility to handle same invoice number printing on all invoices by updating inv_sequence
Clear old Purchase Orders from Vouchers Payable Report
“Tax Code that has [Tax System: 1] and [Tax Code Type: Rate] and [Tax Code: (Blank)] does not exist. Tax Code Label is Tax Code for Customer Order. [Tax Computation] was not successful for…
Solution to handle Error in Order Invoicing: “Tax Code that has [Tax System: 1] and [Tax Code Type: Rate] and [Tax Code: (Blank)] does not exist. Tax Code Label is Tax Code for Customer Order. [Tax Computation] was not successful for Customer Order that has [Order: c00000088].”
Purpose of the On Order Balance field
Bear in mind that an order line may have been partial shipped and invoiced - therefore the order line value will not be used for the on order balance - only the element that has not been invoiced will be included.
Setting up Customer Document Profiles and Vendor Document Profiles
Logic used by the Purchase Requirements report when determining what items to print.
Want to clean up planner data from Global planning run to use Single site planning with Planning replication
Global APS clean up scripts
Understand the Critical Path display
Answer on What is causing my order to be late and trying to use the Demand Detail Critical path information to solve my late customer orders and the information isn’t telling me why late
Note
Understanding why late is a very complex question. There might be multiple purchase items that if expedited and multiple resources that […]
APAR 69016 - Planner is unable to transfer process plans or BOMs during the Reload step.
Some error in Planner RELOAD
Planner yields errors during the RELOAD step that indicate the presence of invalid effectivities. For example:
10/7/2003 2:02 RELOAD -103 ol_cadd_route() 0 Unable to transfer process plan [.CJ00000001 .00000.17530101]
10/7/2003 2:05 RELOAD -102 ol_cadd_bom() 0 Unable to transfer BOM [.EJ00000173 […]
How To Set Up a Planning Trace Against an Order
How to use the keydebug text file to do a trace of an order
Want to stop data from flowing to the APS Gateway table
Stopping the data from flowing into the ERDBGW gateway table, Don’t use Get ATP / Get CTP and want to prevent this functionality and Disable APS Gateway
Note
Testing shows that this prevents data from being sent to this table. Planning can still be run successfully. Get ATP/ Get CTP button can be invoked, however […]
Want to view all of my BLOCKED orders in the Analyzer.
Review blocked order in APS Analyzer
A Blocked order is an order that could not be completely planned during the planning horizon.
Test KB
Fix Planning Background Task History Task Messages: Error -30012 - Planner API returned error
Find Recursive BOM in Planning Run
Error on the Planning Server:
..\Planning\Projects\{dbname}\ol_log\ol_sched.txt
Returns the following:
STARTUP: started bom recursion check…060729.221710
ERROR: Recursive BOM in order .R000021334 .00001.JOB
ERROR: Recursive part is 220T0055-01
ERROR: which is under part 220T0055-01
ERROR: BOM Tree:
ERROR: 220T0055-01
ERROR: 220T0055-01
On the Utility Server winnt\system32\apserror.txt
041108.090200: Error -18 from function ol_csch_order.
Module: runplan.cpp Location: 1022.
Message: Planner API returned error.
————————————————-
041108.090200: Error 10054 from […]
Run Planning without getting a -30018 error.
The Background Task History entry for the Planner run displays the following information:
Error Message:
Error -1 ApsPlan: Error -30018 running the Planner. for Command - ApsPlan.exe …
Task Messages:
Planner run started at Thu Dec 18 07:20:53 2003.
Error -30018: The Planner is currently running for the specified alternative.
Single pass Infinite APS
Want APS to plan in the past or using TNOW in the past
Error: My plans are not lined up to my Due Dates
Get rid of BLOCKED orders.
One way to easily view Blocked orders is to Open the Analyzer to Order Analysis, then make sure that you Sort By “Projected Date”. This will list all of the Blocked orders first.
The Planning window for MRP/APS is determined by the Planning Horizon and NOT the MDAY Start/MDAY End fields on the Planning Parameters-General […]
Primer on manufacturing safety stock
Overview about Time Fence, Manufacturing Safety Stock, Large Order Minimum / Order Multiples, Preservation Level Multiplier, Suspend Time Fence (Second Pull)Most users of Finite APS use Post Process behavior exclusively.
Time Fence calculations are based upon the PCAL Scheduling Shift if it is defined. If it is NOT defined, then 24×7 is used.
A Preservation Level […]
Panduan mengisi Knowledge Base (Indonesia)
Kalau menemukan keyword SQL atau Progress, tolong dimasukkan ke Database, bukan Fact
Kalau menemukan keyword ‘Version’, tolong dimasukkan ke Version, bukan Fact
Ada penambahan Fix1 dan Fix2 per 08 July 2008 - Kalau menemukan keyword Fix muncul lebih dari 2 kali, tolong kata Fix yang ke-3 dan seterusnya dihapus sebelum diisikan ke Field Fix 1 atau Fix2. Sebab […]
Check Licensing, Groups and Users for a specific form
Utility to Examine Licensing, Groups and Users for a specific form
Data Export utility- Item with quantity and costing data (SQL)
Data Export Utility - Item with current and standard routing/BOM (SQL)
Running a Syteline report in SQL Query Analyzer
Troubleshooting when reports do not run in Syteline.
Error: Error starting Report: Error Number 500, Not enough memory for operation.
Return Status: Task Failed - Error 204
Utilities to purge and rebuild the _all tables
Attached are two utilities. One will purge the _all tables and the other will populate the all tables with the data from the current site. These utilities can be used when the _all tables have been corrupted and need to be re-set.
Utility to output detailed information about a SL7 or SL8 Form for comparison
To Need to compare the components on one form to those on another formOutput differences between scope levels of the same form
The FormComparison script is designed to do the following:
It will output all the scopetypes found for the form being investigated so we know if we are dealing with multiple user versions or just a […]
Verify Database
When Infor creates a Syteline Crystal .rpt file they create a stored procedure (RPT_reportname.sp) that belongs to the respective .rpt file. The stored procedure (RPT_reportname.sp) is linked to the Crystal .rpt file via these steps.
The stored procedure RPT_reportname.sp resides in the _app database. If you have multiple sites _app databases, there will be a […]
How to revert a form back to the vendor default version
Some users receive an error message but other users do not due to different version
Read more from the Knowledge Base category, or subscribe to the RSS.