x Want to participate? Join the group to interact

  • Banking Details Table

    Hello, Could someone please tell me where to find the banking details for a customer - the APVNR table gives the name, REMIT and the address but not banking. I checked the ELVEND and the EFLTLOG files to find the banking details but could not. I have…

  • Payment Batch Import Into Sage 300

    Hi, Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank. Could someone share…

  • old company data lost during creating a new company

    Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, but in sql server all data is avail able. kindly…

  • Where in the AOM can I find flag for "fiscal period" locked or unlocked?

    I have a challenge...can someone familiar with the Sage 300 database tables give me some advice? I would like to query the database to find out if a certain document date correponds with a fiscal period that is currently locked for Accounts Payable…

  • installation 2016 Server 2008

    We were really hoping to stick with a 2008 box for the Accpac install. Did we miss our window of using 2008 by a version or two or are we long done with those versions? We're also looking at the possibility of using server 2016. Is there any chance…

  • 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…

  • Sage 300 2012 Purchase Order has replicated itself and is the wrong jobs

    Thanks in advance, In the middle of December, we created a multiline purchase order that was job costed to roughly 25 identical jobs. Everything seemed fine until we viewed a job report for a completely unrelated job - the purchaser realized that a…

  • Help with New Payroll Code

    Is it possible to have a payroll code that will allow me to enter a 'day rate' i.e. $160.00 per day but also keep track of insurable hours? So on the timecard, I want to enter 5 days work, it will come up with the day rate of $160.00 and multiply it by…

  • FR Report Designer - no network drives shown in the File>>Open area

    Hi all, Strange FR behavior - when opening the FR Report Designer then going to the File>>Open area to select a report to modify, the only contents are the C drive of the workstation. If we close out of FR and launch Excel from the desktop I can see…

*Community Hub is the new name for Sage City