Financials

Where is the best place to learn about setting up the AP Approval process/Workflow?  I have looked in University catalog and nothing seems to really fit. Thanks!

Is there a canned or good way of generating turnover reports across branches? 

Hi All, @Naveen B,  I have set up an  Automation Schedule for “Refresh Currency Rates”.  I will only update the previous day rather than the date that it runs.  Also the schedule just stops running ever few days.  Is this a known issue?  Any response appreciated.My settings for the Schedule is as follows:- 

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 

Hi I would like to generate P&L based on item class per below, but keep failing to find the right definition.Does anyone know the definition? Thanks in advance! 

Hi SirWe do a chart in dashboard, however we notice that the below in Black box -SSD is 4% margin. However , from the database , the margin should be negative 6% Is there anyone can advise what is the reason?Herewith the screenshot of dashboard and the chart configure for your reference/   

Is there a way to link an expense receipt for credit card to the vendor record?  Sometimes we pay for vendor bills on credit card, but they also need a 1099, but I can’t find where to link that to the vendor totals for end of year 1099 reporting.  

On a Purchase Order, is there a more efficient way to enter a different Ship-To Address and Ship-To Contact (of our company) than by checking 'Override' and typing in an alternate address/contact?  

Is there a way to change “All Customers” statement settings to (Print Statements)?

A conversion was completed from another software product.  For some reason after validating the entire process we know what the number is and it matches the difference between the balance sheet and income statement to balance it. It belongs in retained earnings and all other balances are matched against the GL ledger from the old program.  I need to make a one sided posting to that account or an adjustment account to sum to that grouping for the amount in question which balances the assets and liabilities and completes the transition.I have been unable to find a methodology

Hi,I’m importing trial balance . the debit and credit amounts exactly tally in the excel. but system keep showing below error. Appreciate your help. Thanks,Dulanjana 

I know there is a customization to publish for add apply retainage for AR Invoices and Memos but what do you need to do for AP Bills? The apply retainage button is not available right now in migration mode and I need this ASAP!

I have created the Order of  Type “IN” with manual numbering.When I am trying to Prepare the Invoice above error is getting. Can anyone help on this ? 

Hi,I have someone entering an expense claim using a specific Expense Item. Normally this item is taxable and has taxes calculated but in his instance, the supplier is not charging tax. How can the person entering their expense claim put the tax amount to zero as the taxes get calculated automatically based on the tax category and configuration. This could be the case on expense claims, or on PO’s or in AP Billls too. When I try to set it to zero I get the following error: 

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)

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 

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. 

Hello thereWhat is the code for creating a date and time stamp which shows on a report when running it?Thanks   

Hello, I want to set up a new branch but unsure where I can specify the data set for the branch.  We use first three character of sub account for department,  as 32A and the new branch is an aggregation of 32A, 32B, 32C.  Can anyone assist us to set this branch correctly?  

Hello,I am wanting to create a pdf form for AP Debit Adjustments. The business case is that when we have a Credit memo request from our Vendors, rather than waiting for the Vendor to create a Credit Memo on their end and send to us, I would like the ability to generate the a Debit Adjustment and print to PDF so I can send to the Vendor to initiate the request. I am told I have to create a form from scratch for this as out of the box there is not form for Debit Adjustments. How would I go about doing this and are there any best practices to help expedite the creating of this, ie copy AP Remit form etc… Thank you

Hi All, @Naveen B , is it possible to change from Diminishing Value to Straight Line Depreciation of an Asset?Case:  Office Equipment has a life of 10years.  First 4 years is Diminishing Value, followed by 6 last years as Straight Line.  Is this possible?  I have tried by running diminishing value first, then changing to SL however an adjustment is added to the start of the SL depreciation so it doesnt work. Regards,Laura 

Hi EveryoneNot sure if anyone know that the new dashboard widget - Link in accumatica 2021R2 can add in the finance report link into dashboard? Which mean we can just click the link and it can direct to show the financial report that we required? 

Is it possible to delete or edit an Expense Claim that has already been released in the system?  Can’t find anything anywhere on this topic??

Hi, A client, at version 2020 R2, wants to eliminate the Email Invoice/Memo Action on the AR Invoices and Memos. I tried to set the Visible value to false on the Form specific option but that did not do anything. In 2021r2, I can do this fairly easily by selecting & setting the action to hidden. Is there anyway to eliminate this action without coding? Thanks,Bill 

How can you restrict access to Cash Books Under banking. I need certain users to access 2 or 3 cash books and only 1 other user to access a separate 2 cash book accounts?