• 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…

  • Field error "Document name" when opening an attachment from a Sage X3 transaction

    Good day

    We attach a new attachment to a Sage X3 transaction.

    When someone then open the attachment, the first time, can be downloaded and viewed. When the same attachment is opened for the  second time the error displayed is that the document or directory…

  • Stock receipt entry is not generated correctly


    We use Save X3 V12 & have the issue with stock receipt entry.

    When running stock accounting interface for a purchase receipt, a journal entry is generated but the journal entry lines are not generated correctly. There are 2 cases

    - if valuation…

  • Journal entries created but not posted


    We are using V12, we encountered the issue that entries created but not posted in GL. 

    - batch server is still running

    - Accounting task is active but the number of journal on hold is 22

    How to solve this issue & make 22 journal on hold to be posted…

  • Posting the WIP

    When we posting the WIP on 31/03/2022 creating some issues like these,

    wip posting error

    It has says “Unbalanced Journal Legal”. I tried to run again the WIP after obtain following solution

    1. Changed formula on Automatic Journal > WIP > Line 35 > Amount from…
  • Is there an import template for Batch Journal Entries?

    Client wants to move away from regular journal entries and use Batch Entry exclusively in order to have a review and post capability.  However, I don't see an import template for batch journal entries.

  • Stock journal not having values

    Hi team

    I need some assistance. I am facing a situation where I am having stock journals created but not having values. The process is triggered from a purchase> purchase receipt> and the purchased items were supposed to be received as stock but now,…

  • Account inquiry screen always showing balance of zero

    Our account inquiry screen is not showing the correct balance.

    It is only showing zero balance all the time.

    Any ideas on how to resolve.

  • 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, Sales…

  • Non-AR Cash Receipt

    Hi -

    What is the best way to record a non-AR Cash Receipt?  End-user gets a check from a vendor (or customer) with no open receivable or payable.  Just wants to deposit in the bank, debit cash and credit a misc. revenue account.  Journal entry?

  • Unable to post sales invoice- "No Line to Process" Error

    Unable to post sales invoice- "No Line to Process" Error

    Hi Everyone,

    I am unable to post sales invoice, getting error as "No Line to Process" Error. We have added conversion factor- 1-CASE = 20-Bags

    Can anyone advise me?

    Thanks in…

  • Invoice won't post and errors with "Unbalanced Distribution"

    Our Customer Service team started receiving this error when posting some invoices: "CI2200860 ZSIHI : Unbalanced Distribution 4 (ZSIHI Line 410)" and I'm not having any luck resolving it. I have run GTEST to check the posted amounts and they balance. I…

  • sage x3 v12 mandatory dimension on dimension type CC (PRINC line20) PRINC error

    when we try to do bank direct issue payable posting shows following error, account 51203001 is doing conevrtion currency

    we try to convert EUR to USD for examble via this transaction   

  • Return not corresponding to Gosub on posting sales invoice

    Hi Everyone,

    When we try to post sales invoice we get the errors below

    sagex3 v12

  • Matching error - Acc (CCT): MTC 2

    Hello team,

    The user has raised of getting below error when doing manual matching, kindly assist on what might be the issue and how I can sort him

  • Sage X3 : STKIS Auto Journal not picking up modification


    I have added a modification to STKIS auto journal, line 3 to post to a different account based on customer category instead of my regular COGS account.

    I have introduced the BPCUSTOMER table under conditions of line 3 of STKIS auto journal.


  • Sage X3 Implementation - Resistance to change

    We are a distribution/manufacturing company who implemented Sage X3 about 2 years ago and acquired another company early last year. We are facing quite the pushback from the acquisition from the employees and their resistance to change. Therefore, there…

  • 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 the delivery…

  • SST multiple Tax GL Accounts

    What is the best method to  create Tax postings to multiple GL Accounts when using Sage Sales Tax (Avalera).  Example would be tax for California is posted to account 22101 and tax for Texas is posted to 22102, etc.  SAGE Sales Tax only suggests one TAX…

  • 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…

  • Pre-receipt [GESPPTO]

    How to generate stock quantity by Order pre-receipt function?

  • No Journal Entries on Production Plan (FUNBENCHI)

    We want to start using the Production Plan for non-WO production tracking. The WIP Posting function will NOT post any journal entries for completed records. I run the function wide open with the Entry Type set as "Tracking w/o WO" and nothing happens…

  • error closing work order

    I'm receiving a different error trying to close the work order in my testing environment 'a sub-contract operation is ordered or in progress. closing not possible.'   The PO created from the work order has been received with same quantity as…

  • BPCVAL does not post FRA Legislation BP Customer invoices

    Using V11 Patch18.

    We can individually validate BP Customer Invoices for FRA legislation customers, but when we try and use the BPCVAL function, (validate customer invoices). All we get is a Go Sub error

    Unfortunately, I can't get at the more details…

  • Batch JE Function - reversals?

    Can you create reversing entries in the Batch JE function? If so where? 

    Financials > Journals > Batch Entry