• Sage batch posting freezes

    Sage Accpac Version 6.0 SQL 2008R2 on MS Windows Server Server has 8 companies running. One of the Sage accpac companies has issues in posting batches from GL batch list window. Once you reboot server all postings will happen for 1st 5 minutes and…
  • Sage 300 - sql query for recalculating AP Balances - reconciling to GL

    Hi, I am trying to determine why my GL and AP control accounts dont balance. Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer. To this end, I would like to build a query in sql…
  • Update Inventory Worksheet via SDK

    Hi Guys, I am having an issue while updating Inventory Counts in SAGE300. I have created the Macro but it actually does not update the Quantity Counted in I/C Physical Inventory Quantities. Has someone successfully updated /C Physical Inventory…
  • AP Vr posting dated July 2015 (Per 1 Fiscal 2016) errors in GL posting

    Currently closing Per 10 of Fiscal 2015 ending April 30, 2015. Had to enter AP voucher with date July 1 which is Per 1 of next Fiscal year 2016. Have created new 'Active' year 2016 in Common Services, Fiscal Calendar. Created GL batch in AP. in GL…