Sage X3

Hello, I need to create a zero "0" check in accounts payable to clear open credits and debits on a Supplier/Vendor. Can this be done?

I have just started doing A/P after employee left. I have very little notes and no training. Does anyone have a step by step instructions for this process. I am stuck that I am unable to get a REC to 'post'. Thank you, cheryl

We're running into issues when trying to process delivery requests for Open Orders. We will have exactly enough stock of a product in the system that is on a delivery request for an Open Order, the stock will ONLY be allocated to that Open Order, but…

We have a problem with one of our sites where, every now and then, a payment doesn't seem to match properly and we can't figure out why. For the latest case, the symptoms visible in GACCDUDATE were: - Payment: PAYLOC/CUR = 0, TMPCUR/LOC = 0, FLGCLE =…

Good day We have an issue where no transaction is written to the GACCTMP table. Any transaction that we try to post in Sage gives an error and the process stops. When I look at GACCTMP I see no record in this table. I have tested Purchase Invoices…

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…

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…

One of our business partners on their quest to be fully PCI Compliant will no longer be handing off credit card information to us. Instead, they will be providing us a token that is associated to a customer's credit card, and also associated to our merchant…

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…

Hello All, Please i need your help. I tried Creating an Assets from fixed assets Module and at the point of clicking create, an error message popped out. ( @X3.TRT/GLOBIENS$adx (1416) Error 56 : Date Error incorrect ,, ,, src calcdiv.c.495 ) …

Hello, We are using Operating Budgets (Envelopes and Entities have been set up and is working fine) My question is around multi-year budgets Normally if you have say a 3-year budget you need to enter a budgeted amount per year not breaking the…

Hello All, Happy new year. Please i notice on payment screen E.g Bank transfer - if i try to search for a transaction using amount field i get an error message. Please kindly find screen shot below.. Please help. Thank you.

Good Morning, We are getting an error message when we try to set the reversal date to 01/01/2021. (The accounting date is 12/31/2020). This is only happening to some of our journal entries. Would anybody be able to tell me why this error message…

Hi all, On the journal entry function appeared a new option that I never seen before - "Màj date d'exécution" Has anyone seen this? Why it appears and what it does? Thank you.

I am trying to create a Delivery via web services, and have it attached to an existing Order. The order has been allocated, and ready for Delivery creation. I created a simple object web service using the SDH object. I am sending the order # in the header…

Hello, I have to hide a row of a table. I have tried with: CHGFMT [M:YYY]NBLIG(nolign-1) WITH "-K:10", but this action hides the entire table I have tried whit: CHGFMT [M:YYY]FIELD1(nolign-1) WITH "-K:10" : CHGFMT [M:YYY]FIELD2(nolign-1) WITH "…

Below is an error that occurs when we do a costing/WIP/In process posting. Thank you so much for your guidance. Unbalanced Journal Local KEY1=MF1-2101A-2004-00006 KEY2=~ KEY3=~ KEY4=~ KEY5=~ Last WIP : VCRTYP=10 VCRNUM=MF1-2101A-2004-00006 WIPSEQ=12…

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…

I would like to record miscellaneous receipt/income (not inventory) and I can code directly to the sales gl account that I want without having to create an invoice. So in essence code the receipt at time of entry. I set the company up, but when I do…

Hi, We want to post Purchase Invoices from code after it has been saved, we have done a similar customization for the Suppliers and it works perfectly. However, for the Purchase Invoices, it does not execute. Here is the code snippet we use. It…

The manual matching process allows the creation of a journal entry to clear small open items when the MTC parameter and automatic variances are setup. This process is working, where I can manually match a payment and invoice where the variance is under…

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…

When clicking the create button for a Service Request, Why am I seeing "Error registering the consumptions"? When creating a request, I'm not even touching the consumption fields. This happens intermittently. Sometimes I can create the request without…

Does anyone here have any idea how to validate a PO Invoice using a webservice, or other similar method?

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.