• SQL REPORT IN X3

    I am trying to run the following query but its giving me an error. Any suggestion on how it can be fixed.
  • SQL Data Report

    I am trying to pull data from three tables but running into a relation issues. Table1: Customer Table. Table 2: Invoice Table Table 3: Invoice Detail Table On table 1 the customer number column is "BPCNUM_0" On Table 2: The customer number column is …
  • Crystal Report not printing Chinese Name when printing report

    We have a lot of Chinese customers and will prefer products name to appear in their language. How can I make this characters print on reports (Invoices)
  • prevent invoice creating from general journal entry

    Hello, can you suggest a workaround to prevent invoice creation from general journal entry? All invoices should be entered from Sales/Purchasing area only. Thank you
  • Crystal Report

    We have instances where a customer accepts back orders. On the sales order, it will allow you to put all the product, even the ones on back order. However on the invoice, it will only show the products that are available and drop off the back order products…
  • How can i print the Invoice without Download ?

    Hello, Can X3 Print the Invoice/Purchase Order/Sale Order without downloading the document ? Does this feature is available ?? Thank you Moiz
  • INVOICE INQUIRY TABLES

    I am trying to report on the invoice inquiry screen. The fields are exactly what i need. Anyone has an idea what those tables are that are running?
  • Crystal Report Invoice Report field with No data

    I did the following to the YSBONFAC Report. When I print the report, the report does not break. But it does not out put the lot number either. Any recommendation. The lot number is on the delivery.
  • Lot Number From Delivery Onto Invoice

    How can I have the lot number that appear on the delivery, also appear on the invoices. This will help the warehouse pick the product more accurately. Currently on the invoice screen, the LOT number columns shows up but the Lot Number information is not…
  • LOT NUMBER ON THE INVOICE NOT SHOWING UP

    On Delivery, we can see the LOT number, However on the invoice the Lot numbers column comes up blank. How can this be fixed? Delivery: Invoice:
  • How to Hide a Field for A User.

    I am trying to hide certain field that come up on the invoice screen Cost Price and Margin columns on sales orders and invoices. How can I do that
  • Custom delivery address on Invoice (Web service)

    Hello, I have a problem when creating invoices with web service. I need to set a custom delivery address on invoices, but the web service always chose the "default ship-to customer". The reason for this is that we sometimes deliver directly to the…
  • Make A New Field

    How can I make a new field on the invoice? When an invoice is created I want to use this new field with drop down options that the team can use to tag invoices. So when reporting is done they can filter for a specific report.
  • Invoice with unfixed VAT tax rate

    Hi everyone, I am looking for a solution where I want to input a invoice with VAT. However, this vendor would issue invoice with unfixed VAT rate. i.e. sometimes Net amount = GBP 100 and VAT = GBP 12 and sometimes Net amount = GBP 100 but VAT…
  • Free Professional Invoices For Sage X3

    Tired of your current boring Invoice templates and wish you could spruce them up a little bit? Well, now you can. Download these crystal reports and make sure the last impression you leave is a lasting one. Download Now These set of templates have…
  • [REST] Web Services - Query By Date

    Hi there, I'm trying to use POSTMAN to query if an INVOICE exists by date. What DATE format should I use? I'm trying: xx.xx.xx.xxx:xxxx/.../YSINVOICEV eq '2017-05-24', but I get the response: "$message": "X3 engine error: Type incompatibility…
  • Workflows and automated functions

    So, I created a action triggering workflow that triggers on the Posting of a sales invoice... Hit post in GESSIH and this workflow fires every time, does what it is supposed to do, and life is well. When i run FUNCFMINV to post a range of invoices,…
  • How to restrict products by company

    Hi, I need to restrict products by company as the title suggests. I'm able to restrict it by user, so they cant modify / delete the product, but they are still able to invoice those products. Any suggestions? Thanks
  • Sage X3 Purchase Receipt/Invoice Creation

    Hi Do you know can you turn on parameters than when you create a PO receipt that the invoice can be automatically created. Or do you have to create the receipt then the invoice. thanks Stacey
  • Invoice Site mismatch

    Hello all, I had a question about the way X3 is handling our invoice create. X3 allows us to create an invoice to a purchase order outside of the site the PO was originally created. Eg. PO was created in site A Receipt was created in Site A…
  • Managing Invoice Deductions from Payment Level - Sage X3

    Hello Guys, I am currently having some problem allocating my clients deductions. I have proposed for them to manage it at Invoice level making use of the Tax 1, Tax 2, Tax 3 but they refused simply because the date at which the account codes report…
  • Sage X3 V7 - Purchase Orders Not Received But Invoiced

    Hi We have a client who uses Purchase Orders. They are not using inventory as such but we create an item code so they can raise Purchase Orders. They do a Purchase Request, it becomes a PO then they use Invoice Control to enter the Invoice. We don…
  • Component Product Report

    Hi All, I've been using X3 for about 2 months now, so I know a little with a lot to learn. Currently I am trying to run a report/inquiry to determine how much RAW materials we are using. By running the PRODBINV report I get a high level report of…