A sales invoice is an accounting document that records a business transaction. Sales invoices provide the business with a record of the services they’ve provided to a customer. When you post an invoice or credit note, the value of each invoice line posts to the nominal account specified for the item. But sometimes we get errors while posting sales invoices due to account related.
Sage X3 has a menu termed as accounting codes wherein we need to assign the needed accounts against the different entities e.g. Customer/Supplier/Product etc. If the accounts are not assigned against these entities in the Accounting Setup, in that case, every time the user tries to post a transaction or run the valuation, the user may get the “No Account found” error.
Mostly we found this error while posting the invoices whether it be the Sales invoice or Purchase invoice. Sage X3 has a functionality to solve this error. To solve it, kindly follow the below steps.
While posting the Sales invoice you will get the below error:
Navigate To>> Sales >> Invoice >> Invoices
Navigate To: All >> Setup >> Financial >> Accounting interface >>Automatic Journals
- Select the Entry code i.e. ‘SIHI’ which has mentioned in the above Error log file.
- Then click on the button that is present on the side of the automatic journal screen.
Please refer to the below figure for the same.
After clicking on the Lines button, an Automatic Journal (Lines) screen will open.
Select the line no. i.e. 20 which is mentioned in the above Log file. Please refer to the below figure for the same.
Now in General tab go to in Accounting Codes section and note down the Index no. of the Product and customer as shown in below figure.
Now go to the accounting codes screen and select the account codes that you have defined for the respective product and customer.
For example, In the above transaction, we are using “PURSUPPLIE” accounting code for the product and “AN_NGRU-NA” accounting code for the customer.
(Note: You will get the defined accounting code of that particular product and customer in the Financial tab of product and customer)
As mentioned in the accounting codes section, the product has 2 index no. and the customer has 17 index no., Now go to that particular index no. and enter the account number in legal fields, as shown in the below figure.
For Product:
For Customer:
After saving this record, Navigate To >> Sales >> Invoice >> Invoice
Open the sales invoice screen and post the sales invoice transaction where you are getting errors and you will be able to post the Sales invoice without getting any error, as shown in the below figure.
With the help of this blog, you can solve the Non-existent account code error and you will be able to post the Sales Invoice.
About Us
Greytrix – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.
Greytrix has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3, Sage Intacct, Sage 100, Sage 500, and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, Sage CRM CTI Framework.
Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 – Sage CRM integration listed on Sage Marketplace and Sage CRM – Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.
For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.