Sales Help

I would need an idea to set up a vacation calendar for our company.

So, we have 3 branches in 3 different cities and 5 different LoBs (marketing, Sales, finance, business, technology)

I am looking for a solution where I can create a calendar for say people in "Technology" visible for everyone in "Technology".

I know I can create an office 365 group and send an invite to it that will show the blocked dates for my vacation. But I don't want that every member should receive every invite or changes notification in his Inbox. But the members should be able to view their vacation in their calendar as well as in "Technology" calendar as well

Any thoughts or ideas?

Thanks in Advance

5 Comments

JavaScript Best Practices

LVL 13

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

LVL 3

Question by

Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc

2019-07-08Solved

Customized Message Boxes

I want the messages on the main form to appear on a much bigger form so that I can easily make them bigger than on the current VBA which has small messages which makes difficult for those old people who are using a point of sales software to read. See a sample pop up form.

I will be opening the pop up form by this method DoCmd.OpenForm “frmMessage” through the save button

Any idea I want to put may a label on the pop up form call lblMessage

Below is my code which should supply the action message

Private Sub CashReceived_BeforeUpdate(Cancel As Integer)
If Me.CashChange > 0 Then
Beep
MsgBox "Please check you have not received enough cash for the quantities you have sold", vbOKOnly, "Internal Audit Manager"
Cancel = True
Exit Sub
ElseIf Me.txtAuditedCash < 0 Then
Beep
Eval ("MsgBox ('Please note too much collected," & _
"give back the change of " & Format (Me.txtAuditedCash, "Currency") & "." & "Do not forget.@Check again.@@',0,' Internal Audit Manager')")
End If
End Sub

Open in new window

2 Comments

I'm looking for an API that can supply some certain sales detail from Ms Access built accounting software to an electronic device which uses Json format to request, send , and receive data through the internet. We want something already made either available for sale as long as it meets our demand, we do want trial and error setuation.

Regards

Chris

3 Comments

How to get live data for a point of sales machine with data in Json format into Ms Access tables ,like below:

(1) tblCustomerInvoice (Primary table)
(2) SalesDetailline (Child table)

Parameters and data type are as below:

Json: char *TaxCode, char *Productcode, char *number, char *date, char *CustomerID, char * amount, char *SpecialCode, char* intKey

Access: text TaxCode, Text Productcode, number Number,date Date, Int CustomerId , double Double , text spcialcode , autonumber Primary key

The only sure way is to use VBA , any idea on how to do the following:

(1) VBA function to get the data and insert into the tblcustomerinvoice and tblsaledetailsline

What we want to archive here is when a person is punching data on a POS machine , then simultaneously the same data must be entered in the above two ( tblcustomerinvoice and tblsaledetailsline) this means that we won't need to recapture the same data again.

Regards

Chris

13 Comments

This may be more a matter of taste rather than a technical question:

I have a web app that I'm going to be selling Membership access to. I'd like to use Shopify as the Merchant Account/Gateway in which I will need to purchase and configure two plugins:

1. A Recurring Subscription plug-in that will allow me to charge Customer's 30 days out from when they subscribed and keep that payment recurring for a given duration
and
2. An "Affiliate" plug-in as I will be paying a Sales Team a portion of the initial cost from the Customers.

I realize this is a big ask and I'm fairly new to Shopify, so please use laymen's terms with your suggestions. The app is written in Node.JS/React so I suspect that integration won't be too difficult for the Devs.

Thanks for your assistance.

3 Comments

Dear Experts,

I am a part of a team that developed an iPhone/Android game. We are in a unique position because the sponsor of the game is willing to pay a lot to get this app marketed by an experienced digital game marketing company.

My issue is, I am not familiar with the gaming industry at all, and not sure how to find such marketing company. The 2 contacts I found through my professional networks did seem qualified, but as soon as we start talking budget, they stop responding. (I was told to start from 20k, but my sponsor is willing go pay quite a bit. He wants this game to be popular.)
Perhaps they are not willing to work with such small team of developers? I am thoroughly stumped to how I can proceed with this problem.
Please advise.

7 Comments

Here is some sample data from 3 SQL Server 2014 tables

 CREATE TABLE #Vendor ( 
     ID int NOT NULL,
	 LastName varchar(50),
	 FirstName varchar(50),
	 State1 varchar(50),
	 License1 varchar(50),
	 State2 varchar(50),
	 License2 varchar(50),
	 State3 varchar(50),
	 License3 varchar(50)

        )
 INSERT INTO #Vendor VALUES

 (1, 'Doe','John','CA','45678','TX','178989','CA','99999'),
 (2, 'Smith','John','CA','12ABCD','CA','12ABCD','NY','45678'),
 (3, 'Doe','Jane','CA','09876',Null,Null,Null,Null),
 (3, 'Doe','Jane','CA','09877','CA','45678',Null,Null)



--------------------------------------------------------------------------------



  CREATE TABLE #SalesPerson ( 
     ID int NOT NULL,
	 LastName varchar(50),
	 FirstName varchar(50),
	 State varchar(50),
	 License varchar(50),
	  )

 INSERT INTO #SalesPerson VALUES

 (1, 'Doe','John','CA','45678'),
 (2, 'Smith','John','CA','12ABCD'),
 (3, 'Doe','Jane','CA','09876')


--------------------------------------------------------------------------------



 CREATE TABLE #Master ( 
     ID int NOT NULL,
	 LastName varchar(50),
	 FirstName varchar(50),
	 State1 varchar(50),
	 License1 varchar(50),
	 CALicense1 char(1),
	 NameMatch1 char(1),
	 State2 varchar(50),
	 License2 varchar(50),
	 CALicense2 char(1),
	 NameMatch2 char(1),
	 State3 varchar(50),
	 License3 varchar(50),
	 CALicense3 char(1),
	 NameMatch3 char(1),
	 UniqueCALicenseWithinID char(1),
	 UniqueCALicenseAcrossID char(1)

        )



		 INSERT INTO #Master

Open in new window

…

4 Comments

On our point of sales receipts (Ms Access) form we are using on current event to capture the following automatically:

(1) Date
(2) "Cash receipt"

Now the problem is that when closing the form, its leaving a blank cash receipt which making the serial number having gaps because of the same blank receipts. Is there another event to use other than the current event to archive the same results:

Regards

Chris

5 Comments

Hello:

I am finishing building my custom Sales Order Report that I want to run with my ERP software automatically. The report will be scheduled every morning between 1a - 3a and needs to look at 'yesterday's' orders that was entered in and then e-mail it out to the correct folks.

I have literally spent over a week 'Googleing' around on the web different ways of explaining what I want like 'data parameters crystal report 2016', etc. and I have been A.) unable to find anything that is CR 2008, which has some what a different interface/options than the newer version (CR 2016 SP3) so I am having a hard time finding the information to at least point me in the right direction.

I know a Formula will need to be built then 'Parameter Field' I think but I am not achieving the result I am looking for.

Currently, I have a pop up box that appears and asks for a date, which is working if you manually enter in the dates. However as I previously mentioned I need the date to be set to 'yesterday's' date and not pop up a box so that my report can run automatically.

Thank you all!

3 Comments

LVL 1

Question by

CHI-LTD

2019-04-04Solved

Securing Hosted Apps

Hello

We are to deploy Sales force Cloud to users. From initial testing 2FA looks to work well using the authenticator app, however we are now proposing to block access by corporate IP ranges i.e. our firewall WAN IPs, rather than 2FA. This will mean VPN for remote users will be required not only for SF but other current and future apps.
Unfortunately the subscription/evaluation has expired and SF wont extend the trial, i have to pay a years fee to continue.

We are also looking at SF inbox, marketing cloud, SF inbox and other 3rd party tools to help integrate SF with exchange.

So, if w ego the route of IP blocking can anyone confirm if this can be setup in Sales Cloud globally for Inbox, marketing and sales cloud? I only see option to white-list SF IPs.

Thanks

5 Comments

Fundamentals of JavaScript

LVL 13

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

I have a multi-user Microsoft access application and am getting complaints that users are experiencing "to drop changes and save to clipboard" errors. Is it possible to trap for this or is the only solution to prevent multiple users to access the same "order" simultaneously? This is an order entry system with engineers and sales reps creating and modifying records.

5 Comments

LVL 3

Question by

Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc

2019-03-27Solved

AUTO TAB IN MS ACCESS

I think this could the last part of my journey in the point of sales (POS) ,all I need now is to auto tab to the second LINE since the selection / scanning of product ID automatically populate the entire line with the following:
(1) Quantity sold
(2) Price
(3) Tax
(4) Account code
(5) Date
(6) User ID

I cannot use auto tab property because it require an input mask , the problem here is that the bar codes lengths are not the same with other products that is why an auto tab cannot work. I have tried the code below it is also failing:

Private Sub Userloged_Change()
If (Me.Userloged <> "") Then
Move to second
Me.ProductID.SetFocus
Exit Sub
End If
End Sub

Regards

Chris

9 Comments

I want the Point of sales report to close automatically either after printing or if it failed to print , how do I do it , please do not worry about the the attached action queries they are there to handle the double entry only , below is my VBA code:

Private Sub CmdPos_Click()
DoCmd.SetWarnings False
DoCmd.OpenQuery "QryRevenueAccount"
DoCmd.OpenQuery "QryCostofSales"
DoCmd.OpenQuery "QryStockAccount"
DoCmd.OpenQuery "QryVatAccount"
DoCmd.OpenQuery "QryReceiptsAcc"
DoCmd.Save
DoCmd.OpenReport "rptPosReceipts", acViewPreview, , "ItemSoldID =" & Me.ItemSoldID
DoCmd.PrintOut , , , , 1
DoCmd.Close acReport, "rptPosReceipts"
Me.Refresh
End Sub

See how the above code can be amended.

Regards

Chris

1 Comment

Can Salesforce allow me to create a list of accounts that will quickly allow me to open and append a field value? In other words. I would like to create a list of 500 accounts and input the actual total revenues of that particular company into the field called Total Revenue. We need to do that so we can identify if the representative who handles that account big or small really is QUALIFIED/SKILLED enough to handle them by themselves? Is there an efficient way to go into Salesforce and quickly do that? If not Salesforce needs a way to allow Managers a quick edit tool for salesmen, sales teams and representatives so that corrections can be made quickly and efficiently in the even a new salesman or representative missed some entries or new policy calls for the updating of all or some accounts with new variables for analysis purposes. Opening individually could take forever to do. It would be great to have a list with a column like excel and just go down the list entering the correct value....?
Does Salesforce do anything like that?

1 Comment

Hi

My point of sales receipts is compiled from queries that gather the following:
(1)      Taxes
(2)      Quantity sold & prices
(3)      Other calculations
So in short it is not possible to use the current form to act as a receipt report. These queries are the one providing data for the receipt report, that is why currently to print a receipt report you need to close the current input form and open the parameter query form.
Now I’m wondering if there could a better way of binding the parameter query using the input form so that people do not need to close the current input form but can just invoke the printing of a receipt from the same input form.

I Thought MS Access save data into the table immediately after leaving a control, if yes how can I use the current primary key of the current receipt form as part of the parameter query so that the document printed is the current document showing on the input form screen?
I want to maintain the current form parameter query because sometimes the document may fail to print, then with the current parameter form query available I’m able to preview the document and reprint it.

I know it is possible to attach a macro to either print directly to the printer or preview the document by using the built in macro wizard, but the problem is how to the current document I’m not sure here because this macro wizard will only ask for the report to be printed, this means that I will end will all receipts being printed.

Could it be that there is …

8 Comments

A good buddy and I are helping another friend at a large corporation with an Access database performance issue. My buddy is developing the SQL Web App stuff and I am in charge of all the server maintenance. Its a 70% 30% split between the both of us. Is there a service that will let us be paid individually at these percentages? For example client pays the entire balance and then its split 70/30 between the two of us? Does Upwork (or similar) offer something that could be of help in this scenario? We are being paid via a corporate credit card. Which is nice!

5 Comments

Hi Experts;

I need a clear advice on the Ms Access tables storage size:
Our client with a supermarket has many products on the shelves, now our current Point of sales works as follows:
(1)      For every product line, five line entries are generated as follows (Revenue line, Vat Line, Cost of Sales Line, Stock line and the Cash/Receipt line)
(2)      All the five lines are stored in POS Table details
My question or worry is can this table manage to handle let say 850, 000 product sold per year which is equal (850000 X 5 lines = 4,250,000 lines) if an access table can handle that, then can we continue to use the same POS for the next 5 years? Will it not burst???????
The above line represent data that will be required for accounting purpose, example:
(1)      Revenue Account
(2)      Cost of sales Account
(3)      Vat output Account
(4)      Stock Account
(5)      Cash/Receipts Account
The performance as at now is very good no issues at all.
Regards

Chris

3 Comments

LVL 3

Question by

Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc

2019-03-16Solved

Ms Access Input Box

For the point of sales app I want to use the input box because for Tax purpose because the tax rate keep on changing year in year out , what I want to do is to hard code the txttax control to be only receiving percentages not absolute values , how do I do it? For example I want to be seeing rates like 10% , 16% etc whatever is applicable not values like 10,16 etc.

Private Sub ProductID_AfterUpdate()
Dim s As String
s = InputBox("Tax Value required", "Internal Audit Manager ", "Tax Percentange")
Me.txtTax = s
End Sub

Regards

Chris

4 Comments

Finally my point of sales is complete but with one more help required here:

(1) When a product code is selected , automatically the selling price, quantity sold , taxes and the line total are completed , it also allows to alter the quantity sold just in case the customer has bought more than 1 quantity.

Assistance required

Since the whole line is completed automatically how can I make the cursor move to a new line (add new line) without manually again entering through the whole line?

Regards

Chris

1 Comment

CompTIA Network+

LVL 13

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

We are now required to be scanning the bar codes for the supermarket stock using the point of sales ms access software when selling:

(1) all the stock are stored in the inventory table using the bar codes in place of stock codes
(2) Some stocks can be manufactured within the company some are ordered from outside if there are some pick periods especially monthends

Assistance required:

(1) To avoid wrong bar codes capturing in the software, is it possible the Ms Access 2016 built software can allow the bar codes scanning as a method of imputing the stock /Bar code in the system? There is a text control in a form for imputing bar code which require imputing the bar code manually

(2) Since the cash sale form has a similar text control but in a combobox control form is it possible to be scanning the same bar codes here also, remember the bar codes are stored in the product table hence the reason for the combobox in the cash sale form to easy lookup?

(3) Since the prices are linked to the product codes/ Bar codes such that once the product code/ bar code is selected the price also come automatically, now the question in the text control where we are required to capture the stock sold, is it possible to have the control show a default one (1) quantity sold automatically? or if the customer is buying more than one then the quantity can be over written manually?

Regard

Chris

5 Comments

Hi

Kindly see how you can assist in another cumulative column under commission, I have done it for one column called sales is now showing cumulative with two criteria. How do I add another column called commission as cumulative as well?

SELECT T1.IDLine, T1.Monthend, T1.ProductCode, T1.Qty, T1.Commision, (SELECT Sum(tblLinedetails.QTY) As Total
FROM tblLinedetails
WHERE  (tblLinedetails.Monthend <= T1.Monthend) AND tblLinedetails.ProductCode = T1.ProductCode) AS Total
FROM tblLinedetails AS T1;

Open in new window

Well Dale Fye advised clearly the problem of slowness with ELookups & Dsum , I now totally agree with him that the way forward is to settle on Subqueries.
Regards

Chris

4 Comments

Hi,

We are on Office 365. I built a simple PowerApp that displays our daily sales totals for our Management (8 Users). This App is getting the sales data from my SQL server using an On Premises Gateway. This has worked for almost a year. Recently Microsoft changed the licensing for PowerApps in Office 365 and wants us to upgrade to a Plan 2 license that costs $40 per user per month.

I'm trying to come up with a way to use this app without the On Premises Gateway. Any Suggestions?

Thank you.

5 Comments

I am concerned; I close to buy a Power 9 (IBM SYSTEM) to replace our AS400 (ISERIES).

This sales is through a business partner. We only need the equipment with the last OS and releases and also the last PTF for the that OS, we will transfer the information from the AS400 TO POWER 9.

My business partner says

Agnes,

This system will ship with the IBMi OS installed with the latest RS (re-spin this is a re-spin of the OS with PTF’s) level that is available at order time. This is not the latest PTF levels but it does have PTF’s already installed on the OS. The system will also ship with the latest RS level of the Program Products. If SFNH(ME) wants to install the latest level PTF’s this also would be SFNH's(ME) responsibility, but the OS will come with some already installed.

Is this true? the equipment doesn't comes with the last PTF? so I have to pay to somebody else to apply the rest PTF's? and what about the OS release now is 7.3 have to come with that right?

Please if somebody knows about this could you please guide?

Thank you for your help

2 Comments

Help me to refine the code below , what is required here is that an item must be selected only ONCE from the combo account ANY second selection must be reject . The reasons for that is that the people who will be capturing a sales invoice should not be involved in double entry.

The combo Account ID is populated with only four accounts , that is revenue, discounts, VAT and Excise duty linked as ( 69,73,76 and 92 as Primary Keys), since auto selection appear to be not working ( What I mean if the invoice number is generated then the four accounts in the sub form must be populated 69,73,76 and 92) the only way is to use manual selection such that we need to prevent several selection of one item in the combo Account ID:

Private Sub AccountID_AfterUpdate()
Dim Cancel As Integer
If (Me.AccountID = "69") Then
Beep
MsgBox "Duplicate are not allowed", vbOKOnly + vbExclamation, "Internal Audit Manager"
Cancel = True
Exit Sub
ElseIf (Me.AccountID = "73") Then
Beep
MsgBox "Duplicate are not allowed", vbOKOnly + vbExclamation, "Internal Audit Manager"
Cancel = True
Exit Sub
ElseIf (Me.AccountID = "75") Then
Beep
MsgBox "Duplicate are not allowed", vbOKOnly + vbExclamation, "Internal Audit Manager"
Cancel = True
Exit Sub
ElseIf (Me.AccountID = "76") Then
Beep
MsgBox "Duplicate are not allowed", vbOKOnly + vbExclamation, "Internal Audit Manager"
Cancel = True
Exit Sub
ElseIf (Me.AccountID = "92") Then
Beep
MsgBox "Duplicate are not allowed", vbOKOnly + …

4 Comments

Hi

Background

The management want special general ledger accounts to be attached to the sales invoice automatically so that no manual selection of GL accounts can be allowed to account for the following:

(1) Sales
(2) VAT
(3) Discounts
(4) Excise Duty

Now on the main form I have created un bound controls to summaries the content of ( Sales , VAT, Discounts & Excise Duty) as you can see above , and below are the controls created on the main form to do the required summaries:

(1) txtInvoicesSales
(2) txtInvoicesVat
(3) txtSalesDuties
(4) txtsalesInviiceDiscounts

The mentioned controls above does a good job as you can see from the picture below.

Now I want help to assign both general ledger codes and the value content in the controls above , I have tried the code below it does not work , any help here will be highly appreciated

Private Sub Form_BeforeInsert(Cancel As Integer)
If (Me.Parent!txtInvoiceSales <> "") Then
Me.AccountID = 120 - 15 - 6660 And (Me.Credit = Me.Parent!txtInvoiceSales)
ElseIf (Me.Parent!txtsalesinvoiceDiscounts <> "") Then
Me.AccountID = 110 - 16 - 1004 And (Me.Debit = Me.Parent!txtsalesinvoiceDiscounts)
End If
End Sub

How do I do it?

Regards

Chris

5 Comments

Sales

Related Topics

Sales

Related Topics