Sage X3

I HAVE A CLIENT MIGRATING FROM ANOTHER SOFTWARE INTO SAGEX3, HOW CAN THE BALANCES BE BRINGING INTO THE X3

What is the standard way of migrating new versioned BOMs? After migration, there is a need to do a BOM validation. Currently, we validate manually. Our customer has thousands of BOMs in the migration. Is there a simple way to batch validate these…

Hi, In the intercompany or inter-establishment process, is it possible to generate the purchase order with one item and the sales order with another item? Example: In company FCY01 the article is XXXXX in company FCY02 the corresponding article is…

When we posting the WIP on 31/03/2022 creating some issues like these, It has says “Unbalanced Journal Legal”. I tried to run again the WIP after obtain following solution Changed formula on Automatic Journal > WIP > Line 35 > Amount from…

Hello, I have added a modification to STKIS auto journal, line 3 to post to a different account based on customer category instead of my regular COGS account. I have introduced the BPCUSTOMER table under conditions of line 3 of STKIS auto journal…

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…

Can you create reversing entries in the Batch JE function? If so where? Financials > Journals > Batch Entry

Hi there I have a bank reconciliation of 9,000 transactions, of which 750 of them are outstanding. I have already identified the outstanding transactions in an excel workpaper. Do you know if there is any way to upload or mark the 750 outstanding…

Hello All, Please i need help I ran Stock Accounting Interface and this error below came up, ACC (CIL) : Tax code mandatory (XSTK Line 22) stat=97 KEY1=HOF2108ISS00000751 KEY2=1000 KEY3=~ KEY4=~ KEY5=~

Here's the background here: We have Sales Order lines tied to a finished good produced by a work order (link is via MFGITM.VCRNUMORI / MFGITM.VCRLINORI) Not all our sales orders and work orders are linked this way. Say it's 50/50 linked and not linked…

I need to come up with a way to consume containers (what our product is packaged in) when a work order is closed. I have thought keeping the current BOMs for the "master BOM" (bulk BOM if you will) for each product and then doing a second BOM that puts…

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…

Is it possible to change the length of the journal line description in both the regular journal and the intercompany journals for both on screen entry and importing? If so, is it difficult? Are there any "gotchas" to look out for? Thank you for…

Hello, We are using Operating Budgets (Envelopes and Entities have been set up and is working fine) My question is around multi-year budgets Normally if you have say a 3-year budget you need to enter a budgeted amount per year not breaking the…

Hello All, Happy new year. Please i notice on payment screen E.g Bank transfer - if i try to search for a transaction using amount field i get an error message. Please kindly find screen shot below.. Please help. Thank you.

Good Morning, We are getting an error message when we try to set the reversal date to 01/01/2021. (The accounting date is 12/31/2020). This is only happening to some of our journal entries. Would anybody be able to tell me why this error message…

I am trying to get an idea of best practices for bank accounts in X3. We are coming from Sage 500 where there is a Cash Management module and implementing Sage X3, where there is not. Our partner believes we should not make our cash account a control…

Below is an error that occurs when we do a costing/WIP/In process posting. Thank you so much for your guidance. Unbalanced Journal Local KEY1=MF1-2101A-2004-00006 KEY2=~ KEY3=~ KEY4=~ KEY5=~ Last WIP : VCRTYP=10 VCRNUM=MF1-2101A-2004-00006 WIPSEQ=12…

I am using Sage X3 v12 raising invoices using the Sales - Invoices function and making use of the intercompany account mapping function so that when we raise sales invoice it automatically raises a purchase invoice. This is working fine except the date…

Client will be using Not managed products for their expenses rather than using BP supplier invoices. They want the purchase tax amounts to allocate back to the expense account that was used. The only way I can think of to do this is to create a tax code…

Hi All, For few transactions, i cannot click 'Print' record from the "Payment/receipt" entry function. Please advise.

Hi All, In my Sage X3 database journals are on hold when the accounting task active. When i post supplier invoice it does not go to GL. Any idea?? This is new database.

Update 9, patch level 8. What's the best way to handle a Complementary Invoice that has been keyed with incorrect value? The complementary invoice is for a stock receipt. The stock has already shipped and is no longer on hand. The complementary…

Hi, We have a situation where if a Credit Memo was done against a Sales Order Invoice... The user says oops... They currently 'reverse' this credit memo by doing an AP Invoice. The issue is that not all the GL accounts are reversed. i.e. Freight, Taxes…

Update 9 Patch 8 Anyone know why WIP inquiry for a Product record includes purchase orders that have been invoiced and closed for back to back orders that have been delivered, invoiced and closed. How do I change this, or what am I misunderstanding…