Sage X3

Hi. If I have a purchase invoice being created in the AP/AR ledger, and the supplier is set up as 30 days payment terms from invoice date, then I am not getting what I expect to get on the calculated due date. ie if I put in an invoice date of 01/04/24…

I compared my Stock valuation report with the Account balance (INVENTORY ) , and they don't match. How can I find the transactions that caused this discrepancy.

I need to find the calculations or script for the 'Stock by product' function. Is there an SQL script for that, and how can I find it?

Hello, When launching the function (FUNWIPMFC) calculation of the manufacturing cost price WO, I encounter the following error message:"The value of the activity code 'NMM' is not sufficient" I changed the screen dimension without result, for the…

Hi all, Pardon my lack of knowledge on legislation implementation as legislation issue found was an uncommon occurrence. [1] I have a scenario where I need to delete a legislation after a folder validation following an implementation disagreement…

Hi everyone, I'm encountering an issue with exchange rates in Sage X3. Problem Overview: In the account balance inquiry, the amount is $1411.15. In the AP sub-ledger balance, the amount is $1403.26. The difference is $7.89. …

I need to prevent errors due not existent or insufficient stock when doing inter-site transfers, I have tried calling the standard x3 procedure STODISPO from library STKLIB. The error happen when passing the parameters. I've found only information…

After executing the FUNBCN for MRP, it gives me this error for 2 items: <0001 Table : ORDERS [ORD] <0001 Key : 6 SUG103240000669629 ITM000021322 <0001 Record already exists I looked into ORDERS table and there is nothing created with that number.…

Hello, I am trying to calculate one invoicing element off of another and I seem to be running into a road block. I have tried using the "Calculation order" field, but this did not work. The next step would be using the "Action" and "Processing" fields…

What does it mean to have a negative value in the balance field? Thank you !!!

Hello! Anyone knows what is the difference between manual and detailled allocation?

I am running into a problem where we have disposed of assets, and it is still accumulating depreciation a year later. I thought once it is fully disposed, it should no longer accumulate depreciation.

How do you make this start service and end service work that is if I want to spread the cost on an invoice

Does anyone know how to setup the Budget Calculation function correctly. I'd like to create a new year budget (by period or annualized) from the prior year actual ledger account/dimension balances. The function appears to be straight forward, however…

how to create tax rule and define tax determination in sage x3

Hi, We have an automatic damage allowance set up as a sales invoicing element; this element value is set on the customer and is populating on both invoices and credit memos. Is there a way to exclude this invoice element from credit memos only?

I'm struggling to make MRP/MPS provide WOS the way I need them. There are "leftovers" from work orders that the system will count as inventory and either give messages to reduce firmed orders or give wrong WOS. This product is good for that one week,…

I noticed in version 12 that I can't create subcontract suggestions manually in planning workbench(EOS type). Is there a workaround?

If I have an ingredient that changed costs (Std Cost) and it is also a component in many Intermediate BOMs and then those BOM's in many Finished Good BOMs - is there a way to calculate the costs on all the BOM's that are touched by that cost change…

Hello! i have been trying to use the allocation function to allocate stock to WOFs in order to have a prompt update of available stock levels ( presently in my company they always manually update stock late during the month , thus stock levels are never…

Looking for any words of wisdom or experience in driving MPS from a different BOM, than MRP. All on the same site in the Requirements Parameters Settings. Goals: Allow Purchasing to have a ‘pure’ BOM from which to purchase from (BOM 1) Allow Production…

Hi, I need to add overhead costs to the finished product however unsure how to configure. In this case the overhead is based off of quantity and a $ value. Meaning the rate is 2.56/kg so for 550 kg made the total overhead would be $1408. Hoping someone…

hello i need your help when i produced a product another semi finish product produced like in the example: Raw Material: Sheet of steel, 100 cm x 100 cm Semi Finished Product 1: Metal bracket Amount of raw material needed: 50 cm x 50 cm Semi…

Is there a way to have invoice elements allocate to lines on a purchase order based on weight? For example: Lines on PO: Product A 32,000 pounds @0.30 Product B 15,000 pounds @$1.00 Pallet fees $,as an invoice element ( I want this charge…

Hi all, Where we can see how Annual count (179) & Not counted (3) generated from as example below? Thanks in advace!