An Enterprise Resource Planning (ERP) Consultant is either a contract employee or an employee who is part of a company that is hired to do any of the following: implement, upgrade, or support an ERP system.
The main function of the ERP consultant is to help organizations move to ERP software. A successful ERP consultant is able to understand a client's business process, to determine where ERP systems would be most useful.
ERP Consultants' relevant fields of study are information technology, business information systems, or management information systems. You have the option of letting a consultant help out with the full implementation of an ERP project, from matching your business requirements with the right software to managing change within the organization as a result of the software.
You know you have a good consultant when he/she is capable of communicating with users at all levels of the organization.
If you are looking for an ERP Consultant, contact WebSan Solutions Inc. we've got the experience and expertise you need to help lead you in the right direction. We ensure your new integrated ERP system will meet all your management, reporting, financial, and accounting needs, while also helping you to streamline processes and improve your overall business.
My Requirement is to create Cue for “Remaining Amt (LCY)” field in Customer Ledger Entry Table for Invoice with one particular fiscal year (say april 22 – march 23). Since it is the flowfield I used the code as
FieldClass = FlowField;
CalcFormula = Sum(“Detailed Cust. Ledg. Entry”.”Amount (LCY)” where(“Document Type” = filter(Invoice), “Posting Date” = filter(‘-1Y’ .. ‘CD’)));
But if I run the code, the value in the cue doesn’t match with the total sum of Remaining Amt (LCY) field with filter (Invoice and current year).
As in reference If I try to use the code as
Sum(“Detailed Cust. Ledg. Entry”.”Amount (LCY)” WHERE (Cust. Ledger Entry No.=FIELD(Entry No.),Posting Date=FIELD(Date Filter)))
In my VS Code, I get error to use the above filter as Cust. Ledger Entry No.=FIELD(Entry No.). I cannot able to get correct filter to get exact value in the cue. Could you please tell me how to proceed with the filter to get the correct value in the Cues?
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies. However you may visit Cookie Settings to provide a controlled consent.
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
My Requirement is to create Cue for “Remaining Amt (LCY)” field in Customer Ledger Entry Table for Invoice with one particular fiscal year (say april 22 – march 23). Since it is the flowfield I used the code as
FieldClass = FlowField;
CalcFormula = Sum(“Detailed Cust. Ledg. Entry”.”Amount (LCY)” where(“Document Type” = filter(Invoice), “Posting Date” = filter(‘-1Y’ .. ‘CD’)));
But if I run the code, the value in the cue doesn’t match with the total sum of Remaining Amt (LCY) field with filter (Invoice and current year).
As in reference If I try to use the code as
Sum(“Detailed Cust. Ledg. Entry”.”Amount (LCY)” WHERE (Cust. Ledger Entry No.=FIELD(Entry No.),Posting Date=FIELD(Date Filter)))
In my VS Code, I get error to use the above filter as Cust. Ledger Entry No.=FIELD(Entry No.). I cannot able to get correct filter to get exact value in the cue. Could you please tell me how to proceed with the filter to get the correct value in the Cues?