Accounting

Accounting measures and evaluates financial information for a business or an individual household, such as assets, liabilities, revenue, expenses, and more. Accounting professionals are often in charge of payroll, retirement plans, inspecting financial records, allocating resources, and ensuring the balance sheets of the organization are correct in order to properly inform business decisions.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi

I have a point of sales module within the main accounting application , now when printing it is accepting only to print on A4 Paper which is a waste of paper, I have no problem when printing ledgers but a pos receipt must come on a thermal receipt printer and paper size is about 80mm. While discusing about this yesterday someone passed the below code to me to study it and see may be it can sort out the problem. To be honest I did not understand it how it works and where to put either in the report module or a function,kindly can someone help me on this, some may have come up with this before.

(1) It appears like it first opens the report in design mode and that is where I do not understand it!

Sub sSwitchPaperSizeToLegal(rptName As String)
'The purpose of this sub is to set the page size
'for a report to legal
Const SUB_NAME$ = "sSwitchPaperSizeToLegal"
Dim DevString As str_DEVMODE
Dim DM As type_DEVMODE
Dim strDevModeExtra As String
Dim rpt As Report

'Open report in design view.
DoCmd.OpenReport rptName, acDesign 'Open report in Design view.
Set rpt = Reports(rptName)
If Not IsNull(rpt.PrtDevMode) Then
strDevModeExtra = rpt.PrtDevMode ' Get current DEVMODE structure.
DevString.RGB = strDevModeExtra
LSet DM = DevString
DM.lngFields = DM.lngFields Or DM.intPaperSize Or DM.intPaperLength Or DM.intPaperWidth
'DM.intPaperSize = 5 'legal
DM.intPaperWidth = 800 '80mm
DM.intPaperLength = 32760 '3276mm
LSet DevString = DM 'Update property.
0
Become a CompTIA Certified Healthcare IT Tech
LVL 12
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Hello,
I am currently maintaining my catering business on MS Excel;
I maintain the following columns:
1-      Category
2-      Product
3-      Kcal
4-      Element (ingredient)
5-      Measurement (How the ingredient is bought: KG, Pack, Box etc.)
6-      Output (How many end products this element produces)
7-      Cost per element
8-      Total cost
9-      Sale price (per client)
10-      P/L
11-      Orders (by client)
12-      Expenses (Rents, Salaries, and Deliveries etc.)
Are you aware of a simple web based system that can cover this for me?
Not only accounting, I am selling B2B and B2C. I do sandwiches, juices, salads, and parfaits. I want to track the cost of each item and its elements.

I want to sell to each client with different price depending on a criteria I want to maintain.

Be able to follow up with orders placed by clients and print out their invoices and receipts.


Thanks,
0
Having a major issue trying to update Creative Accounting Suite. Update keeps failing when attempting to install Microsoft Visual C++ 2013 redistributable (x86). Following their troubleshooting guides I have uninstalled it, then ran update again and get the same failed notice.
I've downloaded the latest package from Microsoft and put it in the setup folder of the program as suggested, but still no joy.

CSA Error
0
Scribe 7.9.2   GP 10.0

Need assistance setting up Scribe to enter GP payable transactions from a excel worksheet.

I have done the Scribe certification process, I am an authorized consultant but have not used Scribe or GP for about three years

Looking for guidance on step control, have looked on the scribesoft site but dont find any relevant help on transaction batch entry
1
(1) I'm required to deliver the access application system in a supermaket envirnoment, now the number of cashiers will be 20 (Users) accessing the same sales accounting or tables. My application is split into backend & front end of which per user will have their own front end linked to the backend on the server.My fear here is the locking system even if all my forms show the record locks property  - No Locks, any idea how go about this?

(2) I have also experienced some issues of power failure in some clients work place, now because of the same you find in the FE folder sometime their is an extra file generated after power failure any idea how to sort out this? Though my current advice to the clients is to invest in UPSs

Regards

Chris
0
I seem to have gotten what I wanted from earlier question, I have created below a table where I want to store two strings:
Tbllinkstring, see attached table

Now I want to use DLookup to be pick the string from the table, how do I use the IF and THEN and ELSE from the code below so that it evaluate and use the correct string, do not worry about the rest, I will take care of the rest, see the shaded area in the attached table:

Public Function SqlLinker()
Dim db As Database
Set db = CurrentDb
Dim tdef As TableDef
Dim constr As Variant
constr = "ODBC;DRIVER=SQL Server; " & _
"SERVER=USER\SQLExpress;DATABASE=Accounting;Trusted_Connection=Yes"
For Each tdef In db.TableDefs
If InStr(tdef.Connect, "ODBC") Then
tdef.Connect = constr
tdef.RefreshLink
End If
Next
MsgBox "Re link completed Successfully", vbOKOnly, "CA Premier Accounting Package"
End Function
For me this will be the best solution because before deploying the application I will be required only to change one of the links above in the table called Tbllinkstring to the correct host name, this means that I will still maintain my existing laptop links which allow me to compile and make an ACCDE copy without an error. Once the application is deployed to a new host name again it will simply drop my existing links after evaluating and use the new one. The advantage is that the users will not be required to select the correct link at all, the system will handle that for them.
On the shaded areas I want to …
0
Dear experts

Our company would like to setup open source OT management system that allows us to do following:

1. When employ wants to do OT, Start time must be submitted first and then it will only be reflected to system once administrator approved.
2. Later when employee finish job, he or she can set the end time, and there should be something that allows emplyee to upload service report that contains start and end time signed by our customers.
3. After setting end time, it should show total OT - hours and we should be able to generate monthly OT for each employee.

Plz advise something that is opensource or even if need to pay, it should be something not very expensive.
0
Can we put the Sage data i.e. the Company.000 folder in One Drive or will this cause sync issues
0
Dear,
Is there any open source Accounting package, which is able to create the official Trial balance, Balance sheet, of the companies, while the relevant format is acceptable to Hong Kong government?
0
Hi, I would like to ask about on what is the best way/practice to use 'Wireless 802.1x' authentication. I maybe asking the wrong question but please feel free to correct me.
Two things:
1) I have configured vWLC with Tacacs AuthC, Authz, and Accounting. Im ok with this so far.
2) If ever I am going to authenticate user using 802.1x in a  WLC, what would be the process path looks like? Should it be like:

User -  AP - ISE - AD/NPS  (do we need NPS?)
or
User - AP - AD/NPS (SHould the user directly authenticated via NPS and bypassing ISE?)Topo
0
Big Business Goals? Which KPIs Will Help You
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Hi

Would anyone know were I can find an older version of the accounting software Pastel?

Thanks
0
We are currently running Quickbooks Pro 2018.  We import invoices from a CSV on a given day.  However our accounting person then goes through customer by customer to send an invoice.  

What we are looking to do is two parts.  First we would like to generate a list of invoices for just the customers with invoices that were imported that day.  Lets call it 20 invoices, once we have that list, we would like to click to email them, but also attach that customer's aging report with that invoice(without having to bounce between a million screens).  Currently she is doing this all manually and its a nightmare.   Any help here would be absolutely amazing.
0
I use QuickBook 2016 and store data on server, i always backup my company file with QuickBook backup utility and it work just fine. And my concern is want to know that is it also work 100% if i manually copy or zip whole company folder to external HDD and copy back to anywhere and connect QuickBook to that company folder? (If you can detail me also about PeachTree would be very appreciated).

Thanks in advance.
0
We have an old version of CR (Version 6 or 7?) that came with our accounting software in 1998.  With it we are able to design reports and "compile" them (i.e. create .exe files) for distribution to other users on our network who have a need to generate various accounting-related reports for viewing and/or printing.  So, those client computers are able to run any of the reports, answer input prompts (parameters) that are in the network share but they can't change the structure of the report itself.

We are now researching and planning to upgrade to the latest version (CR 2016?).  SAP pre-sales support is telling us we can no longer distribute the compiled versions for other users on our network.  It's unclear to us if they fully understand what we're doing and whether this "barrier" real and, if so, is a technical barrier or a licensing barrier.

We are hoping to take the old .rpt files and convert them to the latest version.
0
I want to learn about 1 advanced services costco is using. And I am considering becoming a merchant (not of costco).

I signed up for costco membership in person at the costco store giving my united states state id.
I thought costco stored information by recording my state id number.

But when I used my costco membership number to sign up for costco.com online I was asked questions about my credit report.  
Where were you living in 1990?
a b c d choices.

In this example I am the consumer.
But I would like to be the merchant using customer state id.
Do you have examples of websites offering this service?
0
PLEASE READ ENTIRE QUESTION--I am looking for a recommendation from someone who had had FIRST HAND EXPERIENCE with software for an electrical contractor; this electrical contractor works in both the commercial and residential markets and does work on new as well as existing properties. They are looking for a solution that incorporates construction accounting (G/L, A/R, A/P, etc.), a service module for work orders, scheduling, dispatching, as well as T&M billing (mobile tracking included), along with a mobile app that includes invoicing & payments. They also want project and materials management for their bigger commercial projects, and proposal management that can easily be turned into actual jobs.  PLEASE DO NOT SEND ME LINKS TO SITES THAT COMPARE SOFTWARE as I have already done that myself--I have looked at a lot of sites that contrast and compare supposed constructor specific software but when I call and speak to these companies most are general purpose companies and DO NOT have the special and unique features needed in the electrical construction, maintenance and repair business. That is why I am asking for recommendation only from those who have had first-hand experience with actually using and/or implementing software in this very specific industry. They DO NOT want a solution that calls for combining solutions from many different companies, Thank you very much for your time.
0
I signed up for costco membership in person at the costco store giving my united states state id.
I thought costco stored information by recording my state id number.

But when I used my costco membership number to sign up for costco.com online I was asked questions about my credit report.  
Where were you living in 1990?
a b c d choices.

In this example I am the consumer.
But I would like to be the merchant using customer state id.
Do you have examples of websites offering this service?
0
Hey, we have been having a strange problem with our Quickbooks POS ver 13 multi user installation in a club setup (4 machines). Customers have to recharge their accounts before ordering and the big problem we have is discrepancies between current and available balances. However,the sale transactions are posted in real time but the balances take seem time to synchronize(happens  to a random member account irregularly ) and we have changed the LAN routers and cabling and the problem is still persisting. The charge to account is posted after some delays of a few hours. We have integrated the solution to Quickbooks premier for financial exchange. Our company file is 500MB big and the connectivity tool doesn't post any errors. The environment is available for remote access any time. Any pointers?
0
QuickBooks - all versions - DB Mgr issues and MultiUser mode plus simple access to a company file on a Server.

I've read article after article and  they all give the same solutions over and over - which of course are valid.  Open ports on firewall, exclude AV from scanning QB folders, share permissions, etc.
Although QB is a fantastic accounting program for the small business, its data structure and sharing is something else.  We have QB database mgr installed on servers ranging from Microsoft 2008/2012/2016 domain controllers with Microsoft DNS, dedicated QB member servers (No DNS), Windows 7/10 PCs with DB mgr, etc.  All experience the same issues over and over.
The problem:  Either cannot switch to MultiUser mode or cannot access a specific company file.

Our solutions, depending on which platform QB DB Mgr is installed on is basically to perform a "Scan" from the DB Mgr and once its complete, all is good.  Of course on DC's we have to stop DNS (or modify QB to look at other ports that don't conflict) or restart the QB service or just do the scan.  We do find that if we open the QB program on the DB Mgr server and open a company file, there is never an issue but that is not something you can leave because certain functions require QB to be in single user mode to perform.  Even if we disable any firewalls on the DB servers we still get issues.  Many times, on standalone servers, running the Scan to search for company files give a network error.  Most of the time we …
0
C++ 11 Fundamentals
LVL 12
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Hyper-V Storage Recommendation for small enterprise required.

I have a customer that is a 25 seat accounting practice.  Currently they have a server that is 4 years old, dual Xeon CPUs, 72GB of RAM.  Storage is a RAID 6 array of 8 15K 300GB SAS hard disks.  There are 2 years remaining on the warranty.  The server is a Windows 2012 Hyper-V host.  There are 3VMs, a DC, a file server and a RemoteApp server.  The server provides more than adequate compute resources but is running out of storage space.  One of the file server volumes has already been moved to a Synology NAS connected via iSCSI.  Even with that, storage on the server is becoming severely constrained. Storage requirements are only going to grow as the client is moving towards "paperless" operation.

I don't know much about storing VMs outside of the box that they are hosted on, but it seems attractive to move the virtual disks to some sort of network based storage. Easily scalable storage, and when the time comes the ability to replace the Hyper-V host hardware and simply migrate the VMs without disturbing the VHDs.  For a smaller organization like this it seems (from my limited research) that a true SAN is not going to be financially viable.  Is it feasible to use NAS boxes to store VMs or am I going to be better off just recommending replacing the entire server?

DR is handled by a 4TB Datto Siris, so building a multi node cluster really isn't necessary either IMHO.  I know there are some small scale …
0
Hi

Experts C#

Help me how to add a namespace to my existing project in C#. I want to add this new namespace :

namespace autocomplete_controls_csharp

Where do I insert the above name space ,the idea here is that I want to auto complete the combo box on my form instead of using a button to fill it in, those who have experience with MS access will agree with me that once a combo box is set the data is also auto filled in. Below is my simple project:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Accounting
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(@"Data Source=USER\SQLEXPRESS; Initial Catalog=CaPremier; Integrated Security=true; User ID=user\admini");
            con.Open();
            SqlCommand cmdinsert = new SqlCommand("Insert into Customers values('" + txtCustomerID.Text + "', '" + txtCustomer.Text + " ','" + txtAddress.Text + "' )", con);
            cmdinsert.CommandType = CommandType.Text;
            cmdinsert.ExecuteNonQuery();
            con.Close();
            MessageBox.Show("Data Inserted");
        }
    }
}
0
Hi Experts,

My QuickBooks company file is damaged and not opening. Please help me to fix the problem. I have tried QuickBooks file doctor but didn't work.
0
Hi

I have built a simple accounting system in Access  and modelled it around Northwind. I have
modelled the inventory part very much around Northwind. I now need to build a Bill of Materials component.

Does anyone know whether Northwind does this? Any recommendations on how to go about it would be greatly appreciated.

Thanks
0
Artificial Intelligence
The Technological innovations of machine learning and AI will shape the world of accounting into a better and enhanced form.
0
Hi All,

I hope you can all help. Those with a foundation of security would be especially welcome; however opinions always offer some weight, even if from a non IT background.

I have a question regarding IT Security and Non Repudiation.

I have been in a work environment recently where I have performed the following on a whole.

1. When first starting everyone in the company was using one general admin account with "all power" permissions to administer the network.
I implemented a policy to make sure individual admin accounts where created for each IT Person; for accounting purposes.
All 3 personalized admin accounts setup have equal and full administrator permissions on the domain network.

2. When starting all passwords, including admin accounts etc.. where stored in an excel spreadsheet.
I moved this to an encrypted lastpass database; that was moved to a central platform later on for on the road IT staff.
Everyone was given access to the centrally system; however due to myself being occupied with a specific client; left management to another internal IT staff member.

3. The client which I did the above for has kept passwords of all its staff in an excel sheet; which I have advised against; however my reasoning has been ignored for control and I guess what might be a lack of trust of our IT company.


I have recently complained to my Directors(no managers, small company) about illegal activities that were taking place; such as providing unathorised …
0

Accounting

Accounting measures and evaluates financial information for a business or an individual household, such as assets, liabilities, revenue, expenses, and more. Accounting professionals are often in charge of payroll, retirement plans, inspecting financial records, allocating resources, and ensuring the balance sheets of the organization are correct in order to properly inform business decisions.

Top Experts In
Accounting
<
Monthly
>