Archives
If you will be dealing with customers or vendors who use currencies other than your base (domestic) currency, use the following process to set up exchange rates and other multi-currency features. Make sure the general ledger accounts specific to currency exchange are set up in the Chart of Accounts: Realized Gain Realized Loss Unrealized Gain […]
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 […]
What is a Product Code? Product Codes are one of the key areas in developing and implementing SyteLine. Items (Parts) are the driving point of the system. All modules utilize items or derive their information from the use of items. Every item must have a Product Code. The Product Code is the method used to […]
TRANS TYPE REF TYPE QUANTITY TRAN LOCATION MATL TRAN CODE DESCRIPTION A _ =0 _ AC COST ADJUSTMENT A _ <>0 _ A STOCK ADJUST B _ _ _ B CYCLE COUNT C _ <0 <> ” “ CS JOB SPLIT C _ > OR = 0 <> ” “ CM JOB MERGE C K […]
Accounts Payable Distribution Journal AP Compressed AP Journal Transactions Occurs at data entry, before posting the AP journal to the GL while stating Yes to compress journal before posting. APA # Adjustment Transaction and Voucher Number Occurs at data entry, before posting an adjustment to a vendor Invoice in the AP program Enter Vouchers and […]
The End User Type allows you to assign G/L Accounts, specific to a type of customer and provide an additional reporting functionality. You have the ability to use Unit Codes 3 and or 4 to identify different categories. For example, Unit Code 3 can be used to break out Sales separately, 1000 could represent Domestic, […]
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.