Sage X3

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…

I am trying to develop a query that involves aggregating invoice lines such that values for kits are the sum of their components. I can see there is a flag (LINTYP_0) to determine what is a kit and what isn't, however I am having a hard time figuring…

Our Customer Service team started receiving this error when posting some invoices: "CI2200860 ZSIHI : Unbalanced Distribution 4 (ZSIHI Line 410)" and I'm not having any luck resolving it. I have run GTEST to check the posted amounts and they balance.…

Some of our suppliers send our AP team invoices in advance, such that we have an invoice dated 06/01/2021 on 05/25/2021. Normally our AP team has to wait to enter the invoices until the Doc. Origin Date (BPRDATVCR), or else they receive the error below…

Hi Sage Community! Recently we found in our Software an unexpected behaviour related with some articles that are set at Compound Kit. Through our development we manage to do deliveries and invoices that are related to those deliveries, both things…

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

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…

I have the following Graphical query, the two tables are BPCUST AND SINVOICE. How can I set a criteria for it to pull invoices that have a date of 5/01/2018 to 5/30/2018. When I search for this its outputting all the invoices and duplicating…

Hi! i´m trying to edit the SBONFACP crystal report with the parameters values. So i tried to print it in rpt format and later open with the SAP crystal reports. When i tried to open it i have this error: "Unable to find language and/or path in…

Does X3 allow you to put different deliveries from the same customer on one invoices?

I have couple of invoices that are sitting in non financial sites. The invoices do not show up as open item under ACH payment when we try to apply a payment. How can we process these invoices. The site is not suppose to be a financial site, converting…

I am trying to find out what are all the sales invoices, that have not been paid per specific site. I am using the Inquiry under sales->List of invoices. Can I make this search even more specific, for not paid.

The invoice has been posted but the date on the invoice needs to be changed. How do we go about doing that.

We have a line item that we use on the invoices called "Freight". It currently is hitting the account 410100. What can I do to enable the system to hit a different account when the the line item is used "Freight"

X3 v6.5 p28 We receive BP Supplier invoices from various trucking companies that ship our products to distributors. We use dimensions to associate these with a corresponding distributor, but we don't currently have an easy way to connect this transportation…