Financials

I intend to add custom fields to the Payment Summary section of the AR302000 screen. These two custom fields are intended to appear specifically when the View is set to "Document." However, it seems that despite having implemented the code, the changes are not taking effect. Where might the issue lie?

How can you see what the Project Accountant role actually provides access to?We would like to allow some users to use the ‘Reclassify Bill’ feature in AP, without giving them the ability to post costs to closed Projects.

Hello,I am trying to process application in Acumatica to create invoice. I used Resource Owner Password to generate the tokenHTTPPOST<Acumatica ERP Instance URL>/identity/connect/tokenvar request = new HttpRequestMessage(HttpMethod.Post, configuration["Acumatica:TokenUrl"]);var collection = new List<KeyValuePair<string, string>>{ new("grant_type", "password"), new("client_id", configuration["Acumatica:ClientId"]), new("client_secret", configuration["Acumatica:ClientSecret"]), new("username", configuration["Acumatica:Username"]), new("password", configuration["Acumatica:Password"]), new("scope", configuration["Acumatica:scope"])};var content = new FormUrlEncodedContent(collection);request.Content = content;var response = await client.SendAsync(request);response.EnsureSuccessStatusCode();I am getting error API Login Limitfor the first time call. any help would be appreciated. 

When any user creates PO and status of PO change to open, I want to automate notification email to Finance Workgroup when PO status open. To all member in finance workgroup. Please help me.

I need to display Purchase Order approved and the last person who approved the PO.In a GI or SQL it is simple to return the data for this as an Aggregated value Max on the ApproveDate. The table relationships: EPApproval Table and link it to POOrder using RefNoteID = POOrder.NoteID.How can this be achieved on the Report designer? Where will the Filter be applied?Retha

We created a Purchase Order and tagged it to a Project. A prepayment was then created against the Purchase order and processed completely through check printing. however, the prepayment amount paid to the vendor is not reflecting in the Project Balances or in the Cost Budget.At the moment, the Full PO value is showing as the committed amount in the Cost Budget, which is expected. however, the Prepayment amount itself is not appearing anywhere in the Project balances.I think the Prepayment amount is reflecting to the Project “X”.Could you please confirm, whether any configuration is required, or am I missing any process step to make the prepayment amount reflect correctly in the Project balance or cost budget? 

We have instances where we are issued a credit from a vendor (which is a debit adjustment in Acumatica). We may not use them for future purchases for a long time, so we request a check be issued to us for the outstanding credit. When we receive that check,  can I apply it to the debit adjustment?  

Hello I am reconciling my Monthly tax detail report with my GL account 2045 (Sales Tax Payable) and noticed that  5 Invoices with sales tax are not showing on Sales tax payable GL account. All others are showing up.. Any idea why? The invoices are created from appointments if that helps 

I checked demo sales company assignment map and approval request is the same. but when I active empty company, they are difference. I try with both. but it works only approval. Please guide me  

I try to configure mailing and printing for purchase requisition template for requesting proposal to vendor. But It’s always use default system sending email template. when click request proposal, it also send to other two email that is not the vendor email. This is image when it sent 

Hi all,I’m building a report to track beg inv and end inv. so far so good. Now, I’m looping in sales and margin data. I see that INItemCostHist and INItemSalesHist both have FinPtdSales and FinPtdCOGS. any difference between these two fields? the INItemCostHist matches our sales reports, but want to make sure.thanksJoseph

Hello everyone, Is there any way to use an assign Map to vendor bills object ?I am trying to set restricted user visibility base on who is the bill’s owner.The system set the creator as owner but I need to use more specific rules to assign owner to the bill (for exemple : the manager of the project in the transaction ‘s bill, the PO owner, etc.). There is an approval map but it doesn’t populate le owner field. Thank for your help !C.

Hi everyone, I want to asked, if we want to import trial balance (TB) in Acumatica, specially for Account Accumulated Depreciation, shall we add sign minus (-) in the amount? or we just put positive? please help me to answer this by your experience, thank you.

Hi there,I’m wanting to create journals that hit Inventory ID.For background, we only have non-stock items, and don’t have any stock items as our business doesn’t deal with inventory.However, when I click into Inventory ID to select a stock item, the pop up only shows Stock items, which of course we don’t use/don’t have any. How do I get it to show our Non Stock so I can select that?In contrast, the journals seem to be able to do this, below is a journal with a source document originating from the Receivables module, where the non stock item has been chosen on the invoice document.  Invoice:Thank you. 

Hi everyone,Our business operates with four different branches. Our website allows single-cart checkout, meaning a customer can place an order containing items from multiple branches but only complete one payment at checkout.That payment comes through as a single prepayment, which is posted to our Unearned Revenue account.On the backend, our system then creates the appropriate sales orders for each branch (one sales order per branch). The single prepayment is applied across all of those individual sales orders.Our question is:Is there a way to associate multiple AR accounts with a single prepayment based on the branch of the sales orders tied to that prepayment?Ideally, we would like the portion of the payment applied to each sales order to post to the AR account associated with that branch, rather than everything flowing through a single AR account.Has anyone implemented something like this or found a workaround?Thanks in advance!P.S. we process thousands of sales orders so anything m

Simple example:000-000  Default, “Balance Sheet” entries000-001  Operations      “Indirect” (“Overhead”, “G&A”)000-002  Finance000-003  Marketing/Sales000-004  Health & Safety100-000  Hospitality   “Direct” (COGS, Revenue)200-000  Retail300-000  Education400-000  Health/HospitalsWhat is the best way(s) to limit the use of the 000-000 Subaccount to only in conjunction with Balance Sheet Accounts?...the 000-00# Subaccounts on a) on non-job (e.g. “X”) transactions and b) to be paired w/only indirect, overhead Accounts? ...the #00-000 Subaccounts a) on PROJECTS only and b) to be paired w/only direct, COGS, Revenue Accounts? 

We’d like a new window to open automatically when printing an invoice through AR. It currently re-loads the page, and you have to click the back button in order to get back to the invoice. Is this possible? I have tried adding this to the GI Navigation Tab, but that appears to be incorrect. 

Hello all,How can I get a sample for Statistical ledger in Acumatica or how can I create it in Acumatica & analyse the data into this ledger.

Is there a way to make invoice adjustments (what we currently use credit/debit memos for) within the invoice itself? This way we won’t have separate doc numbers for every change we make, and all history for the invoice would be within the original record itself.We wanted to see if there are any such similar requests within the community, and if yes, is this something that is potentially in Acumatica’s pipeline.  

Hello! I am working on my cash flow statement to combine all branches to show ending balance through specified periods. I am not able to determine why not all of my branches are pulling into the rows - below are the setting I have currently… some lines are matching I assume to not having activity in other branches or post periods...any thoughts or ideas are welcome! 

Good day,Questions:Has anyone had an issue with Customer Statement Automation?  Meaning the statement should have been emailed but didn’t.  All the likely areas were reviewed.  Check boxes, AR Statement reference set up.  Customer profile reviewed.   We even had a statement go out but the emailed box was not checked.Does On-Demand update the email box on the Customer Statement History?Last one (promise): When you put two conditions on the Automation, it is an AND condition or OR Condition?  (OK. One more). Statement Date vs Business Date. If payments are made after the Statement Date, does the automaton need to be set to Statement Date or the business date of the prepared statement automation.  For example, if the customer made payments after the statement that show a balance on the statement date, but the balance was Zero at the time the statement is prepared.We ran an automation and accounting say we missed close to 400 statements that should have been emailed based on the set up of

I am currently working on the Dunning Letter functionality in Acumatica.The requirement is to send different email notifications for each Dunning Letter level (for example, Level 1, Level 2, Level 3, etc.).Each Dunning Letter level should have: Its own email template Different email content and tone based on the severity of the overdue status The correct template selected and sent automatically when a Dunning Letter is generated for that specific level Each email should have Outstanding Amount in Dollars I want to understand the best approach to configure or customize Acumatica so that the system sends the appropriate email template corresponding to the Dunning Letter level.

Hello! Is there any way to include the Sales Order info on the installment invoices?I’ve heard feedback from our Accounting Team and many of them express that their customers have a hard time processing the installment invoices since they do not have any detail outside of just the description saying “Multiple Installment Split” and no relevant Sales Order data is present on the form. This further delays payment as there needs to be lots of correspondence and deliberation when it comes to finding which parent invoice the installment invoice is connected to and then further, which Sales Order the parent invoice is connected to. The feedback I've received is that due to the business being an engineer-to-order manufacturing business, most Sales Orders primarily have installment terms. And without any connection to the Sales Orders, it seems to just communicate, “Hey Customer X you owe us Y dollars on this due date” without any backing information from our end as to what the invoice is for

Hi,Quick question about Corporate Credit Card receipts created from Bank Feeds.When we import transactions using Retrieve Bank Feed Transactions (CA507500) with Create Expense Receipts enabled, the receipts are created and automatically matched to the bank transaction.Because of that, fields like Qty, Unit Cost, Tip and Taxes become non-editable for the user unless we Unmatch → Edit → Match again.Is this the expected behavior, or is there a way to prevent the automatic match during import so users can adjust taxes/amount/tips first?Curious how others handle this.Thanks! Example:A corporate card transaction is imported for $61.40. Part of the amount is taxable and part is not. To match the receipt correctly, the expense amount needs to increase while the taxes decrease, but the final claim amount must remain $61.40. Since the receipt is already matched, these fields cannot be adjusted unless the transaction is first unmatched.  

I’ve created a GI to find gross margin on appointments. One issue I’ve run into is that if a purchase order has been returned, the item is still on the appointment with the costs showing but it is marked as “completed” as well as a “free item” to remove the price so it doesn’t bill out. Is this an issue with the steps purchasers are taking, and they should be doing something differently on the appointment? Having theses costs show without a price is greatly affecting margins on some appointments.