Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

How to pick the current tenant Id for a Database Script?

There are three tenants in our Acumatica Instance. For the purpose of creating a SQL view, we used the below DB Script.create or alter view ardiscountView asselect ROW_NUMBER() OVER(ORDER BY Usrdiscountcoden ASC) row,RefNbr,TranType type,Usrdiscountcoden discount,sum(CuryDiscAmt) amount from artran where Usrdiscountcoden is not nulland CompanyID=2group by RefNbr,TranType,UsrdiscountcodenBut in here we had to hardcode the CompanyID. But we want dynamically pick the CompanyID depending on the current tenant. If you can provide a way to perform this it id highly appreciated.

1 hour ago

alopez21Freshman I

Error: The required configuration data is not entered on the Account Receivable Preferences form.

I am doing a unit test of a customization for the accounts receivable module but I get the following error, I have already done the exercises of the pdf T280_Testing_Business_Logic_2023R2, can you help me?

3 hours ago

HarshitaCaptain II

Import and Export Scenarios

Purchase Receipt Import Scenario with Add PO

Hello community,I have been working on an import scenario of Purchase Receipts, where I am looking to import the lines using Add PO button → Under the Details tab, but the scenario isn’t working. Can anyone let me know what is it that I am missing here?Have attached the XML file of the import scenario. Thanks in advance.

3 hours ago

NaingAungKyawFreshman I

Financials

Purchase Order. Prepayment and Vendor Refund Process

Dear Community, I would like to request your help on clearing amount of “Unbilled Prepayment Total” field under “OTHER” tab of a purchase order. We created a PO with 2 detail lines with same price “14,673,000”. After that we made one Prepayment Bill for first line of the PO. And we paid through Check and Payment Screen.After that, actual Bill came in and the amount was only “13,480,699”. So, we created Refund form for the remaining “1,192,301” and linked with Prepayment.Now, back to the Order and we creat another Prepayment Bill for another line. But when we try to release it, it says “PO Error: The value of the Unbilled Prepayment Total box of the PO00001856 purchase order cannot exceed its unbilled or total amount.” So, I check PO and it has “1,192,301” unbilled prepayment total amount. Now, I cannnot continue creating second Prepayment Bill for second line. Why not Refund amount of the first prepayment does not reconcile in here? Or am I doing incorrectly? Please help.Thank you al

3 hours ago

thoyt76Freshman I

Reports and Generic Inquires

abd28xdFreshman I

Develop Customizations

Trying to access a GraphExtension variable in my javascript function

Hi, I am trying to access a variable in my graph extension from the script on my page, can someone please help me achieve this. Trying to build a URL in graph extension and sending it Javascript to render it in an iframe.This is the code, where i want to access the key field from this GraphExtension in my javascript function #region Selects public PXSelect<SOOrder> AllRecs; #endregion #region Event Handlers #endregion [PXString] [PXUIField(DisplayName="API")] public virtual String vartanaKey {get; set;} public PXAction<SOOrder> VACreateOrder; [PXButton] [PXUIField(DisplayName = "Create Order")] public virtual IEnumerable vaCreateOrder(PXAdapter adapter) { try { usrVAVartanaConfigGraph configGraph = PXGraph.CreateInstance<usrVAVartanaConfigGraph>(); VAVartanaConfig keyRec = configGraph.AllRecs.Select().FirstOrDefault(); vartanaKey = keyRec.UsrVAApiKey;//throw new PXException(vartanaKey.U

10 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

1751 topics
5778 Replies

Distribution

1691 topics
6504 Replies

Manufacturing

595 topics
2231 Replies

Construction

571 topics
1927 Replies

CRM

157 topics
453 Replies

Field Service

278 topics
921 Replies

Retail

451 topics
1990 Replies

Payroll

213 topics
706 Replies

Low Code | No Code Customizations or Integrations

219 topics
798 Replies

Develop Customizations

2374 topics
9629 Replies

Develop Integrations with Web Services | APIs

573 topics
2321 Replies

ISV Solutions

120 topics
490 Replies

Configuration and Installation

751 topics
2744 Replies

Reports and Generic Inquires

1740 topics
6754 Replies

Import and Export Scenarios

666 topics
2750 Replies

System Health and Performance

132 topics
478 Replies

Community site discussions

227 topics
420 Replies

Community Introductions

95 topics
281 Replies

Everything Else

715 topics
2368 Replies

News & Announcements

Acumatica News & Updates

110 topics
156 Replies

Events & Meet-ups

136 topics
83 Replies

Developer Newsletter

19 topics
0 Replies

43 topics
0 Replies

alopez21Freshman I

Error: The required configuration data is not entered on the Account Receivable Preferences form.

3 hours ago

NaingAungKyawFreshman I

Financials

Purchase Order. Prepayment and Vendor Refund Process

3 hours ago

michaelndungi64Freshman I

Develop Customizations

SyncPostion not working on Grid view

4 hours ago

estebanperalta54Captain II

Distribution

Set item to always dropship

Hi! is it possible to always set certain items to dropship on the sales order line? I’m aware you can flag Mark for PO and select dropship but we have certain items that are always dropship.

6 hours ago

vannakheng66Freshman I

Reports and Generic Inquires

How to navigation to customer screen in report design

8 hours ago

carmelinem89Freshman II

Field Service

How do I get the data from Service Orders Totals Tab?

10 hours ago

abd28xdFreshman I

Develop Customizations

Trying to access a GraphExtension variable in my javascript function

10 hours ago

krausef77Jr Varsity II

Distribution

Expose File Name and potential other File Data in Generic Inquiry for Filtering and Dashboarding

Hi All, We are trying to expose File names and potential other Data to a GI.One usecase is Shipments that are being signed on Delivery through the native Mobile App.I don’t see a Flag indicating it was signed in the DAC Schemas but a signature file is attached.We would be able to utilize this for our Reporting and Analysis if we can expose the File Name. I tried joining PX.SM.UploadFileWithIDSelector and PX.SM.UploadFile via the NoteID field but just got blank results in the Inquiry for the file Data. Any ideas how this can be made happen?

13 hours ago

mnecaiseVarsity I

Reports and Generic Inquires

Report Not Found Error

I have a report that I created a couple months ago that I need to make some changes to. When I click on Edit Report, I get the normal Report Designer pop-up to login. However, as soon as I login I get the error message that the report does not exist. The report runs, so I know it’s there. I just can’t figure out why I’m not able to open it in Report Designer. I haven’t had any issues with opening other reports, so it’s something with this one specifically. Has anyone else run into this or have any suggestions? Thanks!

13 hours ago

rcambierFreshman I

File not instantly downloading when using PXRedirectToFileException

I have a custom page that will allow a user to select several records from a grid and then click a ‘Generate Document’ button that will use a stored proc & several API calls in order to retrieve details from the selected records and generates a document using these details.Each record has the ‘Selected’ property which handles the checkbox selection and lets the ‘Generate Document’ button know which records to pull the details from (using the Reference Number on each selected record).I am using the ‘PXRedirectToFileException’ to download the file after the final API call returns the byte[] array that represents the generated document (and creating a new ‘FileInfo’ object using this byte[] array and a previously declared document name).I don’t run into any errors when executing my code and interacting with the page but when I try to click ‘Generate Document’ there is a slight loading period and then nothing happens UNTIL I click another checkbox on any record and then the file is dow

14 hours ago

New to the community?

Get Started HERE and be sure toIntroduce Yourself

Acumatica User Groups

Educational Resources

Community Library

Blogs

What you may have missed in the Acumatica Community! March, 2024

User leaderboard

Show full leaderboard

Acumatica employee leaderboard

Show full leaderboard

Badge winners

VidhyaHarihas earned the badge Easy talker
ruchikasharma23has earned the badge Integrations and Web Services | APIs expert

Show all badges

Acumatica Community

New to the community?

User leaderboard

Acumatica employee leaderboard

Badge winners

Events Calendar

Latest Articles

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded