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…

Is there no way to do bulk N/S posting for purchase receipts in X3?

We are using X3 version 11. I have been invoicing and posting for the same customer without issue until today. Now I am unable to post any new invoices. Seems to be with just this customer though. Error message just says "Unbalanced Journal Legal Rollback…

Hi, We want to post Purchase Invoices from code after it has been saved, we have done a similar customization for the Suppliers and it works perfectly. However, for the Purchase Invoices, it does not execute. Here is the code snippet we use. It…

Good afternoon. With the need of one of my clients on posting inter-company journal entry. During post inter-company journal entry, "inter-company NA10 / NA011" or "Inter-company NA10 " will display on the description field of counterpart of the transaction…

The date ranges configurable in Parameter Values->Common Data->Closing Operation do not seem to be effective in our system (9.0.8). I was able to post purchase invoices and sales invoices outside of the date ranges I defined here. Does anyone use these…

Hi, There is any standard procedure to implement TOMS tax scheme? Thank you.

Accounting has validated a Purchase return where on the grid the option to generate a credit memo was set to "NO". It needs to be set to "YES" The purchase return also creates customer return that has not been approved. How can we correct…

How do we reverse a posted Fixed Asset depreciation charge in Sage X3 fixed asset module.

Hi Guys Has anyone come accross this error when trying to Post a Purchase order The PO is in a Validated State Any help would be appreciated

Hello People, Good day! Hope you guys are doing well. I came across with an inquiry in my company on how can I determine the code being triggered for a particular product for revenue?. I understand that it could be found on the accounting codes via…

Run FUNWIPACC (Costing, WIP, In-process posting) , WIP accounting interface. I am not able to select the work order option. When I go into WIP Posting->Production Site>Entry Type it does not let me select the option Work Order. When I enter…

Hi all! After creating all the assets records for year N, when I start to post the assets issues (of year N), I've got the error that the year N-1 was not closed. When I try to close year N-1, i have several documents awaiting posting. But these documents…

Is is possible to change the check number. The system put a wrong check number.

Hi, Is there a way in X3 to report on two dates, i.e, one for posting date (the date data is entered) and accounting date (the date data belongs to a specific period)? I need this for auditing prior period adjustments to see what entries were made after…

Hi There, Would anyone help me? I am trying to run a simple batch task to generate a log file, but i can't get it to work. It seems to be executing ,but no trace file is generated. This code work fine on the script editor, but doesn't work when i…

Hi I am trying to import a sales order using an import template, in the processing I can run some validations and stop the import by setting OK=0 if the validation fails, however it is my requirement that we just drop the one line of the import that…

Hi , I have a problem , we have updated supplier account category as well as the item category with certain accounts but when i tried with a purchase receipt still the gl entries are getting posted to a suspense account , not quite sure where…

Hi, I've created a purchase order and receipt for 10000 units. Then created a purchase invoice for that receipt for 5000 units only (partial invoice). When I try to post that invoice, I get the error: Error on the adjustment of the prices! (5) Anyone…

We came across and incident where we were printing out checks and then received an error stating that the Entry Batch is full. She went in and posted the checks that she had then tried closing out and re-entering the function but continues to receive…

Hi All, I am getting error (AIN~ ~COR~(C) ~Field CPYCRY : Countries : US Record does not exists) while importing data in Sage X3 for customer with contact tab using web service. If I am not passing Contact tab in XML it works. Anyone know about…

Trial balance report is having some difference for debit balance and credit balance. how it can happen and what is the best way to solve this? version: 9 patch2

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

I am new to Sage X3, we need to book certain expenses directly through bank payment entry debiting more than one GL code, example when we reimburse certain expenses of staff we need to book to various GL code such as school fee, vehicle maintenance reimbursement…

Hi, We have a requirement, Path: FInance> Matching>Automatic Matching 1. i have created customer BP Invoice for "$1000" & Posted having number of (AR00001) 2. I have created un-allocated payment of $1000 & Posted with document numbe r (REC0120152001…