Derek Sevel's Page

 My client's year begins on the 04/03 instead of 01/03 ....all of a sudden on sheet 1 of the standard management pack it duplicates the accounts the only difference is the "firstperiod" column. one line has 20120301 and the second 20120304 causing my fin statements to fall over Any solution , other than puting in a filter on first period which is not ideal ? DerekSee More

Hi Is there a way to start batch mode (2) without right clicking it. I want it to run as a scheduled task ex microsoft scheduler Thanks DerekSee More

HiJust a point of interest I may be using a wrong field but I have written extensive sales reports using Accpac OE generated from RMS.The company I wrote for uses an inclusive price as their master in IC, so be aware that if this is the case the report field in Alchemex "Line Total Excluding" actually is the gross price inclusive of vat and a formula using the "Line Tax " must be deducted to get the net amountI also discovered that the credit note cost field that uses the table OECRDD.EXTICOST…See More

Hii) Does anyone know how to print the filters used in a report on the report ?ii) I have a report that is run out at night unattended, it has parameters on it , anyway of the report not needing to confirm these parameters ie non interactive Thanks guys Derek See More

HiI am writing a financial pack from ACCPAC ERP 500 that contains 200 cost centres. Each cost centres report is 7 pages long but identical in layout and use the same account numbers. The cost centre is accseg1+accseg2+accseg3 and the account number is accseg4. The cost centres then consolidate upwards into sub areas. The sub areas can contain same cost centres and consolidate into areas. These consolidate into companies( different databases) and then into a main consoli. Not sure what would be…See More