Sage X3

Hello, I enabled the module "Purchasing" for a user, most of the sub-functions are working, however, some functions are running into the error below: I'm trying to enable the Invoice function: These are the user settings, it is a test user…

Hi all, I would like to know what is the best way (step by step) to create a rules/automation on a custom field. I have a field on SIH0 screen, It is a type A field: 1 - When creating the register, the system populates the field with a sequential…

Good day everyone, I am going to be grateful if I get a reply to one of my challenges. I am trying to create two tabs with the table screen type. I am successfully making on the tab save data to the database but the other tab cant save data into the database…

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

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 …

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)

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

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…

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

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?

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.

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…

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:

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

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…

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.

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…

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…

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…

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

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

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

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…