• Function GESPAY Supplier cash payment Error: Open item being matched

    A/P-A/R accounting>Payments>Payment/Receipt(GESPAY)> SCAS Supplier Cash Payments> For Advance payment entry, every time a user tries to create the entry faces the following error. need urgent help. X3 Application error: Open item being matched.. …
  • Error in returning stock - Line movements are pending, please adjust

    Hi team, I am facing a challenge in returning a stock where as I have deliveries and I was able to create credit notes among the steps in returning the stock but I am facing an error as in below screenshot as soon as I select the delivery number so…
  • No data in GACCTMP

    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…
  • Any Easy way to exclude weekend from date calculation in 4GL?

    Is there any easy way to exclude the weekend from my date calculations in X3? For example, my delivery is suppose to arrive on Monday. It takes 3 business days to get to the customer. If I do Monday - 3, I would get ship date of Friday when I actually…
  • No Applicable Rate when posting purchase invoice

    Hello, I am getting an error message when i try to post my invoice that there is no applicable rate for one of the purchase invoice lines. We create our purchase invoices based on the receipt number. We are on V11, Patch 14 Thanks, Chris
  • Enter backdated shipment for product that has since expired

    We have a scenario as follows Sales Order was done on 18/11/2021 The product to be delivered expires 20/11/2021 Physical delivery to the client was done on 19/11/2021 The delivery was only captured in Sage X3 on 22/11/2021 although we changed…
  • 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…
  • How to Allocate stock/create shortage against intervention

    Hi Guys, V12 PU 25. Wondering if there is a way to manage the following scenario involving service interventions. When creating an intervention typically we need to specify the parts required for the job. We can do this under the consumption…
  • STOCK ACCOUNTING INTERFACE ERROR.

    Hello All, Please i need help I ran Stock Accounting Interface and this error below came up, ACC (CIL) : Tax code mandatory (XSTK Line 22) stat=97 KEY1=HOF2108ISS00000751 KEY2=1000 KEY3=~ KEY4=~ KEY5=~
  • Detail Shortage issue

    Hello All, I have 4 Detail shortage when i checked my stock from product site and i have 6 quantity available. How do i resolve the issue. Please help
  • PERIOD CLOSING ERROR ($VERF_LOT)

    Hello All, Please i need help, i tried to close period and i got this error message below. Kindly find screenshot below. Thanks.
  • Sales return - can't find delivery in Left List

    Trying to process a Customer Return, but the relevant delivery doesn't appear in my left list. Have checked that I have selected the right customer account. Why would the required Sales Delivery not appear?
  • Product Not tied to a Particular site allows transaction created with another site on the line.

    Hello All, Please i notice of recent when a product is not tied to a particular site, The system allows the transaction to flow while another site is assign to that transaction on the line. Which makes it two different site. How can i make it to…
  • Lot Numbers

    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…
  • FIXED ASSETS DATE ERROR INCORRECT.

    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 ) …
  • Job card error when saving on step number 4 ‘Create Transactions’:

    EAM JOB CARD Error occurs when trying to save on step 4 'Create transactions' Please advise '
  • ALL PURCHAE ORDER SHOULD PASS THROUGH PURCHASE RECEIPT (MANDATORY)

    Hello All, Please i need help am having issue,. I want to make all transaction coming from purchase order to go through purchase receipt. Is there a way to make all transaction done using purchase order screen to go through purchase receipt? …
  • How import assembly doc?

    Hi everybody. I need import assembly doc, but now in X3 V12 this object hasn't active import check. I try to active and create import template, but all time system says that first line are not completed, and don't create doc. First, in BBY Object…
  • Field error "Reversal date" Change of fiscal year prohibited

    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…
  • Short Term Rental

    I need to setup a process to manage short term rentals. I have investigated the lease contract option, but it requires Fixed Asset setup and a large amount of transaction overhead. The best option I have found thus far is to use a Loan sales order followed…
  • Postings - Purchase Receipts

    Is there no way to do bulk N/S posting for purchase receipts in X3?
  • Stock Count Sessions with Multiple Worksheets - Journal Entries

    Hello - I have a Stock Count Session that included two Count worksheets, we'll call them A and B. The Journal Entries created for those two count worksheets both reflect a document number of A. I can tell that the JEs are for A and B because of the…
  • How to change average cost lot with code

    Hi everybody. I need found system to update average cost lot without Miscelaneos Receipt /Miscelaneos Issue. For example: I have product A with 100 units of lot LOT1, and cost is 10. This stock I create with an Purchase receipt. Now, i create a…
  • QC Technical sheet changing lot status from A to Q

    Good afternoon, when running a QC technical sheet is it a fixed requirement that while undergoing QC the lot has to change status to Q? for our business we have a testing cycle that while important should restrict our ability to plan and schedule to…
  • Stock location or status not nettable for MRP

    We have a requirement to have some items in stock but not show as available for MRP. I looked for a flag on the location or location type to say not for MRP, but can't seem to find anything. We want MRP to see Quality stock including status R since…