• 1) Mass delete BPS Invoices 2) DocLink/DocAlpha

    1) Is there a way to mass delete BPS Invoices? I have 1900 to delete. 2) Duplicate and triplicate Invoices have imported into Sage X3v12 p17 from DocLink/DocAlpha. This is the second or third time it has happened. Does anyone have advice on what might…
  • Opening Balance Formula for SEI

    Good Day I am attempting to create a trial balance that includes opening and closing balances, but I can't seem to locate where those options live in SQL or in X3. Is this something I will have to make a formula for? If so does anyone have any advise…
  • Is it Possible to Import Stock Assignments?

    Here's the background here: We have Sales Order lines tied to a finished good produced by a work order (link is via MFGITM.VCRNUMORI / MFGITM.VCRLINORI) Not all our sales orders and work orders are linked this way. Say it's 50/50 linked and not linked…
  • Stat99 Error on Accounting Interfaces due to Simulated Entry Generation User Parameter

    I think I found a Sage bug. I had two accountants who got vague Stat99 errors when trying to run the Stock Accounting Interface in both V11 and V12. Users with identical functional profiles and roles did not get the same errors and could run the SAI…
  • Vaildate delivery that shipment date is next day

    i tried validation on delivery that shipment date is 24/10/2019 (FYI: now 23/09/2019). then sage give a log error below. the periode is open until end of the year 2019. can delivery validated if the shipment date is next day from current date?
  • Dimensions on Control Accounts

    Hi, Is anyone using dimensions on Control Accounts? Are you experiencing any issues processing transactions, matching, etc. Thanks,
  • Adding a second purchase order sequence number

    I would like to have a second sequence number for non-stock PO's (for items tied to non-managed inventory) as N19000001, N1900002, etc. In sales orders, I know you can create different sequence numbers by sales order type. However, I don't see that…
  • Sage X3 Loan order

    We have a need to separate in the GL the $ for Finished goods inventory versus Loan inventory. Does anyone had a similar requirement? and what was the process to achive it.?
  • Journals on hold when accounting task active also

    Hi All, In my Sage X3 database journals are on hold when the accounting task active. When i post supplier invoice it does not go to GL. Any idea?? This is new database.