• 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…
  • Open Items Report for BP

    Hi, I want to run a report for a specific BP/Customer and I would like this report to show a complete list of all transactions for the customers - open and closed, invoices, CMs, DMs. I want to see 2 columns, one showing original amount and one column…
  • Validate PO Invoice with Webservice

    Does anyone here have any idea how to validate a PO Invoice using a webservice, or other similar method?
  • Import SIH using Web Services

    Hi all, as you can read i'm trying to import an invoice in my Sage X3 V9 PATCH 6 using Web Services, in my specific script(SPESIH) there is an action that i don't want to perform if i'm importing using web services. I wonder if there is a method to…
  • Purchase Invoice: do not allow invoiced quantity greater then receipt quantity

    We have found that when bringing over a PO Receipt into a Purchase Invoice that the user can change the quantity and invoice for more than what the receiver brought into inventory. The user in our system is presented with a warning: "Warning - Maximum…
  • Error in enabling Invoice function - No transaction authorized

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