2 locations and same item in both .
Just started using AR 2020 and since we have 2 locations with the same items in both , one for picking and one for backup stock, we need a report with total on hand . The only reports I have found shows the items/itemnr and then what is in Loc1 and what is in Loc2 and I need a total without the split between locations. The field On hand total or Quantity on hand cant be inserted or modified when you do a customreport . Up comes the On handfield only but then also loc 1 and loc 2 and we only want the totals The same applies if we want the total values for an item we have in 2 locations. It sems all reports insists on show per location. When I look at Inventory from Command centre and the Items list I can see the total and here it is called On hand but when you look at the item information the field I want is called Quantity On HandSolved1.3KViews0likes3Comments
Best way to make an offline read only copy of the file for future reference (eg for payroll reporting)
When using the MYOB classic version, we used to make a full copy (not just a backup zip) of the file each year prior to rolling into a new payroll or financial year. This meant we had a complete file for easy reporting. These files were marked read only when we were next asked to confirm them. I am sure I found a way to do this with the new online files too but I can't find any instructions. I think maybe a phone support person talked me through it a few years ago. I have since changed jobs and didn't think to bring my "cheat sheets" with me. I would like to add these files to our company "library" so that if in 2025 I need to access payroll information from 2019/20, I will be able to simply pull up the 2019/20 file and run the reports from there. Our current file has all the payroll data back to 2012 but I can't run an entitlement balance report for 2013/14 year which I now need. I could reverse engineer the report starting from the opening balance of 1/7/2018 but I'd rather not as I imagine it would take several hours, if not days. Thanks in anticipation...Solved1.1KViews0likes2Comments
Employee Headcount Report
We have been asked by our auditors for an Employee Headcount Report as at a particular date (eg. 31 December 2022). Is there a report that will show this easily? The alternative that I have considered is to run a report of Employee Cards and select the Start Date & Termination Dates for everyone in the system and manually work out who was an active employee at the required date, but wanted to know if there is an easier way? There is no employee data that is being requested - it is simply total number of active staff at a particular date and whether they were full time, part time or casual. ThanksSolved422Views0likes1CommentRunning detailed reports
Hello Community, I just wondered if someone can tell me if and how to run a report on gross earnings excluding any O/T, bonuses or super? If someone can direct me how to find the correct report, I can then fiddle around with it and make it work for me. I just always get confused on which report to begin with. Thanks so much, Ashlea153Views0likes1Comment
