General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,478 Topics
- 4,904 Replies
Our company has an ongoing problem of customers paying twice for invoices that they pre-payed on because the invoice doesn’t show payments applied to that invoice. I have added a subreport to show an invoice’s payments. Now, I need a way to use the payment total on the main report, which I know can’t be passed from the subreport to the main report. I ask about this on StackOverflow before I knew this community existed and someone there suggested a DAC extension, which I’ve never done before. I’ve read through the 2019 R1 Customization guide and have a weak grasp on how DAC Extensions work. The problem is that all of the examples are shown for user entry fields and all of the examples I’ve found on StackOverflow are for user entry fields, too. I need a extension field that is calculated for the report and I haven’t found an example for that, yet. I’m waiting to get approval from the finance department to contact our third-party Acumatica support company, but in hope of getting it done a
I noticed an open credit adjustment in the system and no bill to apply it to. How do I close?This is off topic . . . does anyone know how to create a weekly transaction report in Stripe? I find it tiring to scroll through all the payments/refunds when all I need is the last 7 days. Thanks for your help!
Since the change to the new style approval maps has anyone been successful in implementing the Parent Work Group link from the company tree to have subsequent approvals in a multi step approval move up the company treePreviously I could assign the workgroup in this manner similar to what is done on the rules section when Employee from Document is selected. However, it does not allow me to place the equation for Parent Workgroup in the workgroup field and has no setting for OwnerID of the ParentWG((Approval.ApprovedByID.WorkgroupID.ParentWGID)) is an option but ((Approval.ApprovedByID.WorkgroupID.ParentWGID.OwnerID)) is not and seems to fail to populate the Employee field.Likewise copying this to the workgroup field throws an error that OwnerId can’t be empty and populating both OwnerID and the Workgroup with an equation results in the Workgroup being deleted upon save.
Is there a way to roll up multiple T&M Projects for one customer into one single Pro-Forma or AR Invoice?
We have a business use case that we are trying to figure out. We would like to take multiple T&M projects and roll the invoicing for each one of those into one invoice? I was playing around with the idea of Parent Child Customers with the Child customer associated with he Parent with the Consolidate Balance, Consolidate Statements, and Share credit Policy set. I’m just not seeing any way to roll billing up into one invoice however. Any tips you can provide would be most appreciated. Eric BelshamGaleforce Consulting Partners, LLC.
Hi All, @Irina, @Naveen B , When going into the “Write off Balances and Credits” screen and running this to write off Balances, the client would like an approval prior to the document posting. Is this possible as I cant seem to get anything working? Cheers,Laura
Rookie question on ARM Reporting:I’ve modified a P&L column set to have three columns MTD/PTD/YTD actual values.I can’t figure out the right settings in the Data Source section of the Column Definition.Example of issue: Printing report for January 2021 I ‘should’ get all three columns to be equal.But the result I am getting is shown below. The MTD Data source is set to The PTD Data Source is set to:The YTD Data Source is set to (I think this one is correct) I am looking for help on what the correct Data Source configuration should be for MTD, PTD, and YTD columns.Thank you,Mike Lupro
This formula works for the YTD Column in my Column Set.=IIf(Left(@StartPeriod,2)='01',Left(Report.GetPeriodDescription(@StartPeriod),3)+' '+Right(@StartPeriod,4),Left(Report.GetPeriodDescription('01'+Right(@StartPeriod,4)),3)+' '+Right(@StartPeriod,4)+'-'+Left(Report.GetPeriodDescription(@StartPeriod),3)+' '+Right(@StartPeriod,4))But it does not work for my PTD column set.What would be the correct formula for my PTD column to display Oct 2021 - Nov 2021 when I run the report for the November period.And, while we are at it, what would the correct formula be for the MTD column to display Nov 2021? Mike Lupro
Hello everyone,I am dealing with a peculiar issue with closing the fixed assets financial periods. To give some background, I was reconciling some new assets and I needed to open some old periods for the reconcile+ transactions to be in the right period. When I tried to close the periods again the system gave me an error stating that I had a bunch of unreleased fixed asset transactions. The assets in question are all fully depreciated assets that were brought in at the go-live with the “update gl” checkbox de-selected. Now I am stuck with this module being open all the way back to 10-2020. Has anyone come across this issue before? There are no transactions to release on Release FA Transactions FA503000. Thanks
in segmented keys I would like the system to pickup the BAccountID and fill this in as the 1st part of the subaccount being used So for example I have set subaccount up as such in the CS202000 screenAnd I would like the system to look at the customer or (vendor if applicable) and fill the 1st segment of the subaccount with the BAccount code So if I was entering a AR Invoice I would like the first segment of the subaccount to pickup the current BAccountID and autofill with thatthe only way i can think of doing this is using custom workflows but wanted to check that I’m not missing something
Hi!Does anybody knows if it’s possible to restrict visibility in the Aging Report to specific users that manage a group of customers? For example, the group A of salespersons manage 5 customers only and they only need to view the aging for their specific Customers.I tried first to use Restriction Groups for Customers entities but when the same user runs the Aginig report, the customers that not belong to their restriction group, are displayed anyway.ThankS!!
My customer wants to require that their customer puts a down payment for items they are ordering. The system will allow them to enter the payment when it comes in (as a prepayment). They want to however to send an Invoice for the down payment. I am not seeing a way to do this.I found this article that implies you can do it, but it requires creating a shipment. This is a manufacturer and they cannot create the shipment because they haven’t made the inventory yet.https://www.acumatica.com/blog/technical-tuesday-creating-installment-payments-using-payment-terms/Anybody have any ideas or am I not finding the documentation on how to do this?
Hello everybody,My question is:We pay our employees the professional fees reimbursement by bank transfer (SEPA). And we made it through another software, so we have to book the reimbursement laterly in acumatica, for example on the bank statement, it would appear 3000€ outcoming that we have to affect to 10 employees accounts (512100 Bank account to Sxxxxx employee subledger accounts). It seems that this schema is not available under acumatica, I don’t find how to dispatch a payment and distribute it to 10 different accounts. (as prepayment, sometime the fees bill comes later) For the received payments, check remitment for exemple, I can use the check remit account to aggregate 10 checks and got a unique incoming amount for the bank reconciliation, but I don’t know weather there is a way to do the same with the outcoming payments ? Hope you understand my issue. Thank you in advance for your help.
Our current credit card processor (authorize.net) requires an authorization to be above the dollar amount of the actual capture. We have to authorize before we ship and are using the Acumatica Fedex and UPS carrier plugin to obtain our Freight Charges. What is the best way to get our Sales Order an estimated dollar amount above the actual order total, but only have the actual freight (from the plugin) on the Invoice. We currently have found no solution that doesn’t require manually editing the Invoice. What are other companies workflow like? What is the Acumatica recommended workflow? Thanks!
Is there way to create a TB starting balance update? We have already uploaded a starting TB and need to change a few accounts. From what I see, even when I only populate the Trial Balance screen with my desired GLs once I release and the Journal Transaction is created it includes every GL and assumes the GLs I did not populate I want set to zero and the corresponding journal tran is populated with that assumption. I am unable to delete any of the lines for GL I do not want to touch. Other than just posing a manual journal can this be done through Trial Balance?
Version: 21.106.0024We use “No Rounding” for rounding and “#,##0” as formatting to display whole dollar amount on the report and but need 2 decimal when export to Excel for analysis. This works fine in 20R1 version, but 21R1, only whole number got exported to Excel, seems formatting actually truncated the decimals.
Helloi just add a parameter in my report to select the account range it works fine but i want my filter to suggest the list of the account i writing like this one but its not working this is what the filter looks like i tried to add the branch id like the standard filter but its not working
Is there an easy way to revalue inventory for a specific item/site? Best I have found is inventory adjustments, but then you cannot add inventory to the same receipt because the costing is tied to the receipt. We had a incorrectly costed move due to a incorrect AP entry for a sub component.
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.