Sage X3

Just released: Sage X3 v12.0 1099 2022. We're thrilled to let you know that the Sage X3 v12.0 1099 for 2022 is now available to download from the Sage Knowledgebase. Head to Knowledgebase article Download Sage X3 Version 12.0 1099 2022 to download…

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…

I need to come up with a way to consume containers (what our product is packaged in) when a work order is closed. I have thought keeping the current BOMs for the "master BOM" (bulk BOM if you will) for each product and then doing a second BOM that puts…

Some of our suppliers send our AP team invoices in advance, such that we have an invoice dated 06/01/2021 on 05/25/2021. Normally our AP team has to wait to enter the invoices until the Doc. Origin Date (BPRDATVCR), or else they receive the error below…

Hi everyone, we have a situation with a customer that as a discrepency between the BPs Credit level total and the accounting balance. The crdit level total (from BPs -> Customer -> Management tab) shows a negative $7,413.54 amount Calculation…

Hello, we have the requirement to allow negative NET pricing on certain lines on Sales Orders, Deliveries and Invoices without using the discount fields. I've been able to enter a negative amount on the GROSS price for a line item, but then Sage makes…

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…

when I run accounting task shows the server is not active, but the batch server is running

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…

I'm wondering if there is a way to link a purchase invoice to a receipt after the invoice has already been entered. Since the receipt is done using the purchase order, can the invoice be entered using the purchase order and then manually or automatically…

Hi, There is any standard procedure to implement TOMS tax scheme? Thank you.

Hi, Can someone explain the meaning of "0" or "2" in the field DUDSTA in GACCDUDATE and HISTODUD tables? Thank you. Regards, Vânia Cardoso

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 can I unvalidate a purchase return. The Gen CR on the grid needs to read "YES"

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?

I am having an issue matching credit memo's for a particular customer. When I go to match invoices the credit and debit column's values match up, the invoices/credit memos turn from red to green. Once I click on the matching button, I get an error…

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…

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…

A customer BP invoice is posted with a wrong date. When attempting to do a accounting cancellation. We get the following error.

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.

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

During year process in actual mode the system is not creating carry forward journals/document .The system only a log without document number as per attached image.

We have a line item that we use on the invoices called "Freight". It currently is hitting the account 410100. What can I do to enable the system to hit a different account when the the line item is used "Freight"

We have a line item that we use on the invoices called "Freight". It currently is hitting the account 410100. What can I do to enable the system to hit a different account when the the line item is used "Freight"

Is there a process guide to set up and process period currency variances for multi ledger/currency journal entries that are using Daily Rate? The scenario is when a non-collective clearing account, or, accrual account, like Payroll Payable, is posted…