Financials

Hi Team, When I tried to configure the AR invoice numbering in the “Numbering Sequence” form, am getting the below error” Start, End Number, Last and Warning Numbers must have the identical length and numbering mask”. Regards,Nithya 

In Acumatica if no tax zone is specified for the customer location, the customer tax zone is the tax zone assigned to the selling branch.You can override the default value.Is this same functionality available with Vendors? In my research I find that the Vendor location specify the tax Zone.  The Tax Zone will be incorrect if you do not specify the Location and use a global Vendor across multiple companies.Retha van Alphen

Hi everyone,Hoping someone can help us.We posted a customer payment to 20 June 2022 in 09-2022 period but should have been 20 July 2022 and 10-2022 period. We have re-done the payment to 20 July 2022 in period 10-2022 however, when we voided the initial incorrect payment (posted in period 09-2022), we accidentally used the wrong period (10-2022). Now the bank reconciliation is out by the same amount.There doesn’t seem to be an option to reverse a void payment unfortunately. Much appreciated,Daniel 

I have setup Row Level Security to GL Account Access and allocated the restriction group to a userThe User should not be able to transact or view the account included in the restriction groupThe result is that the account in the  restriction group is not visible to the user when he view GI/Pivotand the user cannot select the account when capture transactions.I am therefore happy with the resultThe problem however is that the user are able to view the account in the batch file on theJournal Transactions screen GL301000I can restrict the user to not be able to view the detail of the Journal Transaction batch with Access Rights to a role.To implement the Access Rights  by Role is not the ideal solution.Please confirm if I understand the functionality of the Row Level Security to GL Account Access correctly.Should the restriction to the account also apply to the account in that the user will not be able to view transactions captured against the account. 

Hello, Can we changed or is there a way to change the ship via code when the shipment is already released?

I have a scenario where we created 2 separate approval workgroups (reviewer and approver) for AP Invoices and Memos. Once I created this and tested the workflow, I noticed that the document gets automatically approved if the user belongs to reviewer and approver.Ideally, the process should be, after reviewer approve it flows to approver. I am not sure if my configurations are wrong.Anyone having similar issue?

I am prototyping the use of subaccounts for the chart of accounts/general ledger. As I am starting to play with this, I am getting flashbacks of previous experiences attempting to use Inventory subitems with Acumatica, which I considered to be a mess. It seemed like the general consensus when I brought up inventory subitems a couple years ago was that inventory subitems were anachronistic and had been useful when the software was at a less mature stage, but now were not considered best practice and shouldn’t be used for a system setup from scratch (they were still there to enable legacy upgrades, etc).Does anyone have any similar experiences with general ledger subaccounts? I recognize the old “subitem 0”, which was the same as for the inventory subitems. With inventory subitems, if you didn’t want to use a subitem, you couldn’t just have item number 43434. It had to be 43434, subitem 0. Which makes for a lot of extra fields and database entries in the system for no perceivable benefit

Hi everyone,  Can you customize columns and filters on the bills and adjustments page? Or on any pages in the account payables module? In some other ERPs you can but I have not been able to figure it out for Acumatica.  Thanks! 

How does the currency rounding limit work? The format is kind of confusing. Can anyone explain the format for this field and what it does? 

Hi guys, I’m wondering if there’s any training guide for the module “Time and Expense” (mainly about expenses). I couldn’t find it in the openuni course catalog, or in the content library. Could anyone recommend a related course to me? Thanks!

Is there a way to map the fields from the DAC to the fields shown in approval map drop down lists?  For instance, I want to find a field showing the VAT Taxable base currency total in credit memo approvals.  I have found a field called Detail Total, but this is not a field in the DAC.How do I know what Detail Total uses? 

Is there a way in Acumatica to set parameters on how long a sales quote is good for?

HI All,I got this issue when trying to import Trial Balance. Could you please advise what I can do to fix this issue?Thanks for your time,Yên Chi

On the process bank transactions screen I can create AR payments. However, I don’t see a place to put the payment ref number, so I am getting an error when I process. I see that I can globally turn off this requirement in AR, but I don’t want to do that. I would prefer to have a spot to enter it. Am I missing something? 

What are best business practices for paying bills: When should we use a “Quick Check” verses using “Bills and Payments followed by Checks and Payments”?  

Hi, our customer is using Acumatica 2022 R1. Is there any way to create an out of the box approval prior to save the new customers into the system?

From time to time, we finance a customer’s purchase by taking a promissory note. How do we book the promissory note?  How do we book the payments on the promissory note and the interest payments?  How do we show the payment of the related invoice?  Any help would be greatly appreciated. 

Anyone come across this before…When creating a purchase order for a project it updates the commitments as expected, when the PO is receipted in, it updates the actual expense as expected. However when you create the AP bill which has a different amount than the original PO (the vendor has discounted the invoice), the actual amount on the project remains unchanged.Example PO raised for £100 linked to Project1 and Task 1 Commitments on the Cost budget tab and the commitments tab on Project1 are updated with £100 (as expected) The stock is receipted in (the vendor has not sent an invoice at this point), on Project1 on the cost budget tab and on the summary at the top the actual expense is updated with the £100 from the PO (as expected). The vendor now has sent the invoice with a 10% discount and the AP bill is created from the purchase receipt and the discount is added so the AP bill total = £90. When the AP bill is released it does not correct the amount on Project1. Project1 expense = £

Hi everyone,When I was reversing FA in FA module, the following highlight message popup. Where can I find the “unreleased transactions and how can I resolve it? Please advise. Thank you so much for your assistance.  

ERROR:  The TOMYUM2 project cannot be selected because the MAIN warehouse location specified in the line is not linked to this project. Select another project, or change the warehouse location. 

Currently when you check the box to mark a Vendor as a 1099 Vendor, there is no requirement to fill in the Tax Registration ID. It would be good to have the Tax Registration ID become required to be filled in so it is not forgotten when selecting the Vendor as a 1099 Vendor. 

My Client has customers that are setup with Prepay Terms. Some of the Customers sometimes are with Status: Credit Hold. While the customer is set as Credit Hold and Terms are Prepay, users create a Sales Orders. The order changes to Status On Hold until a Prepayment is entered, then they enter a prepayment/payment and SO Status changes to Open. So far, great… Customer is still on a Credit Status so the user goes and changes it to Active. All of the sudden I get a report that I have an issue in InItemPlan where the Hold field is True (t), while all other tables the status is False (f).There is a known issue and says it was fixed in Build 2021 R1 21.102.0070:  My client has 2021 R1- Build 21.106.0024 and I do have the GI that is provided on the the link above. I even created a Widget and Business Event to alert and send out an email when this happens.So far what I gathered after all the testing that was done, we think it has to do with SO Cache not refreshing or reading when customer sta

I am trying to import my initial balances, I have imported a Trial Balance but when I release it, it shows me entirely different numbers in some accounts and will not let me edit anything.  The Journal Transaction that is created is out of balance and there’s nothing that I see that I can do to get my initial balances in the system.This is my import spreadsheet: 

Hi Acumatica Community I need some help please on customer contracts. We have contracts with customers for post go live support every month of 3 hours pre-paid. Then in the for example month of July they only require 2 hours of support. Is there a way to set up Run Billing to in the next month or end of the quarter refund the customer for the support hours they did not use?Overrun hours works perfectly since if they for example used 4 hours in June then in July the extra hour is billed during the billing run. It is just when less support is used that we find Acumatica currently is working on “use it or loose it” set up.  Thanks in advance for the help! 

Has anyone else seen this issue in an upgrade to 22 R1? STAT ledger changed ledger types from statistical (20 R2) to budget (22 R1). This causes an issue where postings can no longer be made on the JT screen due to the ledger change.I’ve opened a high priority case with Acumatica support on this but wanted to see if anyone else has experienced this. I checked our other clients who have moved to 22 R1, and they did not have statistical ledgers setup to verify if others have been affected by this.