• Period closing problem

    hello guys i have a problem with period closing we changed the currency to 4 decimals to add 0,0004 so i can match correctly after that we try to close the period and i get this error in trace here is what i changed in currency i tried…
  • How to upload a file to mark outstanding transactions?

    Hi there I have a bank reconciliation of 9,000 transactions, of which 750 of them are outstanding. I have already identified the outstanding transactions in an excel workpaper. Do you know if there is any way to upload or mark the 750 outstanding…
  • Open Items Report for BP

    Hi, I want to run a report for a specific BP/Customer and I would like this report to show a complete list of all transactions for the customers - open and closed, invoices, CMs, DMs. I want to see 2 columns, one showing original amount and one column…
  • Importing GAS Error: Record Already Exists, but it doesn't

    Sage X3 ERP v7 Patch 8 I'm trying to figure out how to import Journal Entries to alleviate the time spent by our Accounting Dept. I know the data I'm inputting is accurate because I'm just re-importing data exported from the Production server (excluding…
  • What do you use for automating AP/AR? We are looking for different options that work well with Sage X3 v7

    We are looking for different options that work well with Sage X3 v7 and I thought I'd see what works for you guys.
  • Entering a manual check that is already in g/l

    Hi, I am fairly new to X3 and I entered g/l data for our payroll already. I would like to enter manual p/r checks for the bank rec only so they don't affect any g/l accounts. Is there a way to do this? I was able to do this in Sage Pro. Thank you…
  • Not able to close fiscal period - Error payment not posted

    Hi All, Can anyone suggest me why I am getting below error while closing fiscal period, even journal is created for respective payment (which means it is posted). $VERF_PYH Payment not Posted BNBAC1812OBLI000173 (BNBAC) Kindly let me know…
  • Purchase Return and Customer Return

    Accounting has validated a Purchase return where on the grid the option to generate a credit memo was set to "NO". It needs to be set to "YES" The purchase return also creates customer return that has not been approved. How can we correct…
  • How to UNVALIDATE Purchase Return

    How can I unvalidate a purchase return. The Gen CR on the grid needs to read "YES"
  • 13th Period on Enterprise Management (X3)

    How do you deal with 13th period on X3? Making the last day of the financial year to be the 13 th period is not an option since we have transactions to post on the last day of the financial year. Anyone else who needs this functionality?
  • AUTOMATIC JOURNAL ENTRY POSTING "WIP" ENTRY

    WIP Posting automatically creates a journal entry. The entry is comes in as a temporary status. Is it possible to have the journal entries go to the final status on its on. Or setup something that will do it?
  • Month End Closing

    I am trying to close the month end but I am getting the following error: I ran the SQL and got couple of entries that might be stopping me. I am doing the following: If you have subcontracting order do the following. 1)Purchasing->Subcontract…
  • Need to know what revenue account is being triggered for a product

    Hello People, Good day! Hope you guys are doing well. I came across with an inquiry in my company on how can I determine the code being triggered for a particular product for revenue?. I understand that it could be found on the accounting codes via…
  • IMPORT AND EXPORT

    I am trying to update a journal entry, that has wrong date to the right dates. When I export the information and change the information and re import the file, its giving me an error that the record already exist. I am using the JAS2 Template, I am…
  • Due date being paid . Cancellation not possible

    A customer BP invoice is posted with a wrong date. When attempting to do a accounting cancellation. We get the following error.
  • Linked Account for Inter-site is not defined when trying to POST A Purchase Invoice

    I am running into an issue where the supplier invoice is not posting. When I hit the post button I get the following Linked Account for Inter-site is not defined for site. I have other invoices that were posted.
  • Unposted Items

    Does x3 have a report or a place to find unposted items. Things to look out for (Bills, Invoices, Payments, Journal Entries, etc