• Bank Reconciliation add supplier name

    Within the screen BNR0 Bank reconciliation has these reference tables which is OTB GACCENTRY Accounting entries GACCENTRYD Accounting entry lines BANREC Bank Reconciliation Statement BANRECD …
  • several prepayments for a purchase order with one product and quantity of one

    I need to apply an initial prepayment of 30%, a 2nd prepayment of 40% and final prepayment before shipment of 30% but I only have one product, quantity of one and if I apply the first 30% and create an invoice for the second and third payment it cannot…
  • Dimension Codes Not Flowing From Supplier Record to Supplier Invoice

    Common Data >> Bps >> Supplier, Financial Tab, Analytical Dimensions Currently only codes listed in AX1 flow through to the supplier invoice (Supplier BP invoices). How do I change the other dimensions to flow through to the supplier invoice as…
  • How to allow negative NET price on Sales Order/Deliveries/Invoices?

    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…
  • What do you use for automating AP/AR? We are looking for different options that work well with Sage X3 v7

    We are looking for different options that work well with Sage X3 v7 and I thought I'd see what works for you guys.
  • Customer intercompany invoice - A/P-A/R accounting

    Good Morning! I would like to create inter-company invoices from A/P-A/R accounting module with the functions Customer intercompany invoice and Supplier intercompany invoice. I managed to create 2 journals, but the purchase journal that must be generated…
  • Impossible to generate a bank file

    Hello, I'm trying to generate a bank file from Manua Remittance Creation function (GESFRM) however, I get the following message: I've checked the bank account and everything seems ok. Does anyone has an idea? Thank you.
  • 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.
  • Reverse credit card payments that have a status of "In the bank". Accounting Cancellation button is not available.

    We have several credit card receipts which have a status of "In the bank". which do not have credit card authorization under "credit card processing". They payments have been posted & accounting cancellation is not available. How to reverse these payments…
  • A user is unable to print accounting document

    In the All>A/P-A/R accounting>Payments Supplier Cash Payment after entering all of the data, user cannot print the accounting document. as shown below.\\ Need urgent help in this regard
  • Manual AP Checks Accounting Cancellation

    How do you handle manual checks if they are processed within the same bank account as system checks? Here's scenario: Manual checks range is 1000-1500 System Checks 5000-5999; These range is set under checkbook. Sage EM does not allow for two…
  • Entry of purchasing invoice

    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…
  • SEPA Direct Debit receipts

    Hello, I've setup the SEPA Direct Debit receipts and I have one question: - The SEPA DD receipt file that we need to submit to bank, do we need to do customer by customer or is there a way to select of list of customer all at once to get the same…
  • Post AP / AR invoices from Code

    Hi, We need to post invoices from code after having imported the invoice via importsil function. I see that the normal functions use the BISVAL & BICVAL but these scripts are closed source. Thanks Duane
  • Sage ERP X3 Purchase Invoice Automation

    FormerMember
    FormerMember
    Hello, My company has Sage X3 and I will like to automate the invoice capture module. I came across the following link: https://www.sage.com/na/~/media/site/sage-erp-x3/assets/datasheets/Sage-ERP-X3_PurchaseInvoiceAutomation.pdf It seems very interesting…
  • Error while closing the period

    We are using Sage ERP X3 V6. We are working on closing Year End 2016. I was successfully closing periods 1-1-16 through 10-31-16 but November had a surprise for me. We have our software configured to receive and post various API calls for purchase…
  • Sage X3 videos available online

    Just an organized collection of videos found on YouTube. You may find these useful in sales, training, babysitting and support processes… P.S. Many thanks to all authors who did these great videos!!! General * "Sage ERP X3 - Integrated…
  • Payment Post Error

    Hi, I'm facing an issue when trying to post an AR payment. I get the Error: GTE Error in field evaluation evalue(func SUBTFO.FC("PXG")) (screenshot) this happens when the Sign in the payment entry transaction is set to 'Revenue'. If I…