• Document deletion not possible - Actual Journal already exists

    Hello, When trying to delete the last line on any document that involves stock (Misc. Receipts, deliveries, intersites, etc), and error occurs, stating that the document already exists (see here for a misc. receipt example). Please note that no matter…
  • SINGLE PRODUCT, SINGLE COMPANY, MULTI SITES PER COMPANY, STOCK ACCOUNT PER SITE

    Good day I have a single product, single company, multiple sites per company, and the requirement is a stock account per site. Let me use purchase request for example: I found an automatic journal for purchase request PQUIS I added additional…
  • Setting up purchase footer

    Good afternoon, Is it possible to setup a purchase footer with account type = Modifier (Purchasing)? If so, how can I setup automatic journals (PIHI2 (Supplier Invoice Increase Line))? Thanks in advance.
  • Index incorrect error on trying to access automatic journal lines

    We encounter the following error when we go to Automatic Journals. It is when we click the Lines button that we get the error. X3 application error @X3.TRT/SUBGAD$adx (528) Error 8 : Index Incorrect FLD(60) How do we resolve?
  • 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.
  • Sage X3 V11 Autoamtic Journal (GLCO) - Post line company as dimension

    FormerMember
    FormerMember
    Good afternoon. With the need of one of my clients on posting inter-company journal entry. During post inter-company journal entry, "inter-company NA10 / NA011" or "Inter-company NA10 " will display on the description field of counterpart of the transaction…
  • How do I set automatic journal line to post to an account depending on 'Cost' field on purchase invoice line?

    Update 9 Patch 9; What 'Identification key' needs to be used when using the 'Cost' accounting code in the setup of an Automatic Journal line? I thought [PID:]FCSCOD would uniquely identify a cost, but it doesn't appear to be working because I'm only…
  • Automatic journal lines works with non active legislation

    Not a first time, it was sawed in v8p4, v9p3 v11p6 - when stock automatic journal lines are posted with inactive legislation. Last time it was one purchase receipt - the line was disabled with deactivating legislation, but anyway it has been posted…
  • user document for setup auto-journals to create different GL entries based on the entry type code for Misc. Issue and Receipt

    Hi, I'm looking for a user document for setting up auto-journals to create different GL entries based on the entry type code for Misc. Issue and Receipt. Hope that someone can share it with me. Thanks.
  • How can I setup a default text in automatic email ?

    Hello Everybody! How can I setup a default text in automatic email that I am sending a report from purchasing order? I have created a workflow rule to do this. I put a default text in : Setup>Workflow Rules>Message. But, It hasn't worked. When I am…
  • func TRTX3FNC.GETLEG([F:STJ]STOFCY)<>"USA")

    Dear all Can someone kindly explain what this line of code does? func TRTX3FNC.GETLEG([F:STJ]STOFCY)<>"USA") It is one of the conditions in Automatic journals lines Thanks Daniel
  • Automatic Journal STKUV - Lines 3 and 4 (Stock increase/Stock increase adjustment)

    Hi Everyone, The Automatic Journal STKUV - No Absorbed Value after update Lines 3 and 4 (Stock increase/Stock increase adjustment) generate journals with zero debit/credit amount. STKUV Automatic journal Line 3 Stock increase Condition: func AFNC…
  • Automatic Journals : How to tell which line is used for which transactionc Journal Lines

    New X3 user here. X3V7. Trying to figure out which Automatic Journal Line is used in what situation. For example, Purchase Receipt uses journal uses STKRE and there are about 20 lines there. When a purchase receipt is posted, what/how is the line# to…
  • journal entry distribution Field, How the '$' symbol will come.

    Hi All, How the distribution "$" will come on journal entry screen. form where these $ will pickuping. please find the attached image for best approach. please help me.
  • Automatic Journals/WIP Costing

    My WIPCO automatic journal has a line that is posting to my suspense account. Where can I go to change that. I have looked at the automatic journal setup and the automatic journal lines - but nowhere do I see where to change the GL account that is being…